Skip to content

American Year Make Model

Year-Make-Model car database

Download free SAMPLES (Ford and BMW):

Year-Make-Model.xlsx for general use
Year-Make-Model.csv for programming
Year-Make-Model.sql for web developers

Buy complete database (all makes) + FREE updates for one year:

Database coverage

Complete for World War II – present. New and used cars, light trucks, SUVs and vans, basically all vehicles that can be driven with car standard driving license, sold in North America. I added notes regarding cars specific to Canada and not sold in United States, but I do not know which cars sold in United States were sold or not in Canada.

Database also include 234 vintage cars MY 1917-1942, if there is a name connection with post-war models, example Chrysler Imperial (since 1926) and Chevrolet Suburban (since 1933), but it is not and will never be complete for pre-war period.

Database contains year, make (BMW), model (3-Series), platform code / generation number and car class. For additional details like body style or trim (320i sedan, 330d touring, etc), see instead Year-Make-Model-Trim-Specs (1990-present).

Last release: May 2023, including 326 “2024 models”, see changelog & update history.

Makes included

Domestic makes: AMC (including Eagle), Bricklin, Buick, Cadillac, Checker, Chevrolet, Chrysler (including Imperial), DeSoto, Dodge (including RAM), Edsel, Fisker (including Karma), Ford, Freightliner, Geo (including Chevrolet), GMC, Hudson, Hummer, International Harvester, Jeep, Lincoln, Mercury, Merkur, Nash, Oldsmobile, Packard, Plymouth, Pontiac (including Asüna), Rivian, Saturn, Studebaker, Tesla.

Imported makes: AC, Acura, Alfa Romeo, Alvis, Aston Martin, Audi, Austin, Austin-Healey, Bentley, BMW, Bristol, Bugatti, Citroën, Daewoo, Daihatsu, Daimler, DeLorean, De Tomaso, Ferrari, Fiat, Hillman, Honda, Hyundai (including Genesis), Infiniti, Iso, Isuzu, Jaguar, Jensen, Kia, Lada, Lamborghini, Lancia, Land Rover, Lexus, Lotus, Maserati, Maybach, Mazda, McLaren, Mercedes, MG, Mini, Mitsubishi, Morgan, Morris, Nash-Healey, Nissan, NSU, Opel, Panther, Peugeot, Polestar, Porsche, Renault, Riley, Rolls-Royce, Rover, Saab, Scion, smart, Spyker, Subaru, Sunbeam, Suzuki, Tatra, Toyota, Triumph, VinFast, Volkswagen, Volvo, Zastava.

Source of data

Mainly Wikipedia, which is pretty accurate for cars produced in USA and for cars imported from Japan, but not for cars imported from Europe, so to get higher accuracy I also verified with the highly-reliable Edmunds (unfortunately 1990-present only), eBay Motors (unreliable, may model years that actually do not exist), Nada Guides (some missing models and messed up names, for example missing Suzuki after 1997 and incompleteness of Porsche 1998-2010, but best source of data for 1940-1990), and CarListDB.com (one of my competitors in data providing that was closed in 2015).

There is some confusion at cars imported before 1990 regarding the model years each model was available for sale, in case of contradictory info I added notes in Excel table “possible non-existent model year, existent on CarListDB, non-existent on NadaGuides” so you have guarantee that you get a car and truck database with NO missing models.

Updating procedure

See the below video how I do the main yearly update: in April 2021 I added in advance all “2022 Models” that may be launched during 2021, by duplicating “2021 models” and changing model year to 2022, unless there was an announcement on Wikipedia that 2021 is the last year for that model (I manually checked each car model on Wikipedia). I may have added in database models that will never launch, I do minor updates and corrections at random times of year.

This procedure save my time from checking each manufacturer website every month, save your hassle of requesting updates every month, and guarantee NO missing cars!

22 comments

  1. Well explained, I guess this is the perfect write up I was looking for. Since I am very much interested in different cars, make and model so would definitely visit the website again for more info. Having said that in short we are also in the auto business and paying cash for car brisbane

Leave a comment

Your email address will not be published. Required fields are marked *