Happy Monday guys. I'm in the process of trying to figure out the production total of our cars. To my knowledge Mazda hasn't released this information so there is only rough estimates. So far I've mapped out what I think is all possible VIN combinations, so all that's left is to run through the sequence. But in the interest of saving time if anyone's interested then just list the details of your car and I'll add it to the list. So far I've mapped out close to 200 of them and counting, I'll drop what info I'm collecting below and appreciate any help. And if there's any questions let me know.
Requested Info:
Model Year
Vin Number
Original Color
Tech/Non-Tech
State the vehicle is in
Rough Mileage
If vehicle has any previous Accidents or if the vehicle is totaled, Salvaged, Scrapped, or parted out.
Update:
attached is a screenshot of what I have so far just to give an idea of what I want to do and show I'm serious. As it stands though I'm still going VIN by VIN looking for speeds so it'll take way longer than if everyone helps out, but I've added another 50-60 since the initial post I'm open to any feedback or to make any changes if people want to see it.
Update:
Just cracked 400, so I'm guessing that's somewhere between 2% - 5% of the total cars based off of my estimation and the article posted states. Looks like there was anywhere from 130-200,00 Mazda 3's produced each year. If 5,000 per year is the magic number than that means the Speed3 makes up anywhere from 2.5% to 3.75% of the production numbers each year. Also idk if it's been documented but based off what I've found so far Color popularity goes as follows :
Black = 33%
Silver = 26%
Red = 21%
Blue = 5%
White = 15%
Update:
Been a little busy with school so haven't updated as much as I wanted too, however I've made major progress and am almost at 1K VINs. Now some of these don't have color or Carfax info because I'm going to do that all at once. Question for everyone is, is there interest in the list being posted as it is now, or waiting until there is a more sizeable representation of the total population i.e. 50% complete or so? As always any feedback is appreciated, and feel free to post your vehicle info.
Update:
Back again for an update, I've been busier this summer than anticipated so haven't got to work on this as much as i wanted to. But i cleaned some things up and added the status info to vehicles i already had VINs for. I'm attaching a link to the spreadsheet view-able by browser. As far as the spreadsheet goes, the red cars are completely totaled and not roadworthy, the yellow ones have "Unclean" titles which can be anything from an accident to a salvage or rebuilt title. This will probably change later but i didn't want to over complicate things. If the damage column has N/A it means no accident, and if there is no data in a column it means i haven't had a chance to add it to the spreadsheet yet. If anyone has any feedback, questions or suggestions let me know, as always feel free to send me your info. This can be done by PM if you don't want your VIN tied to your username. Thanks for checking back in.
Update:
Overdo but I'm still working on this, Gen 1s have been added in feel free to add your info.
Spreadsheet Link: https://docs.google.com/spreadsheet...AeAs8gxFFkvwmnZEb7d6lvKgRVMlZ41VOYNX_/pubhtml
Requested Info:
Model Year
Vin Number
Original Color
Tech/Non-Tech
State the vehicle is in
Rough Mileage
If vehicle has any previous Accidents or if the vehicle is totaled, Salvaged, Scrapped, or parted out.
Update:
attached is a screenshot of what I have so far just to give an idea of what I want to do and show I'm serious. As it stands though I'm still going VIN by VIN looking for speeds so it'll take way longer than if everyone helps out, but I've added another 50-60 since the initial post I'm open to any feedback or to make any changes if people want to see it.
Update:
Just cracked 400, so I'm guessing that's somewhere between 2% - 5% of the total cars based off of my estimation and the article posted states. Looks like there was anywhere from 130-200,00 Mazda 3's produced each year. If 5,000 per year is the magic number than that means the Speed3 makes up anywhere from 2.5% to 3.75% of the production numbers each year. Also idk if it's been documented but based off what I've found so far Color popularity goes as follows :
Black = 33%
Silver = 26%
Red = 21%
Blue = 5%
White = 15%
Update:
Been a little busy with school so haven't updated as much as I wanted too, however I've made major progress and am almost at 1K VINs. Now some of these don't have color or Carfax info because I'm going to do that all at once. Question for everyone is, is there interest in the list being posted as it is now, or waiting until there is a more sizeable representation of the total population i.e. 50% complete or so? As always any feedback is appreciated, and feel free to post your vehicle info.
Update:
Back again for an update, I've been busier this summer than anticipated so haven't got to work on this as much as i wanted to. But i cleaned some things up and added the status info to vehicles i already had VINs for. I'm attaching a link to the spreadsheet view-able by browser. As far as the spreadsheet goes, the red cars are completely totaled and not roadworthy, the yellow ones have "Unclean" titles which can be anything from an accident to a salvage or rebuilt title. This will probably change later but i didn't want to over complicate things. If the damage column has N/A it means no accident, and if there is no data in a column it means i haven't had a chance to add it to the spreadsheet yet. If anyone has any feedback, questions or suggestions let me know, as always feel free to send me your info. This can be done by PM if you don't want your VIN tied to your username. Thanks for checking back in.
Update:
Overdo but I'm still working on this, Gen 1s have been added in feel free to add your info.
Spreadsheet Link: https://docs.google.com/spreadsheet...AeAs8gxFFkvwmnZEb7d6lvKgRVMlZ41VOYNX_/pubhtml
Attachments
Last edited:
