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. Hi, i have and auto parts directory webpage. We are interested in a auto parts catalog like your with the years, make and model. We also need a database like yours but that also have images of the parts. Will you suggest one or your database have images. Need help…. Oh my website Is made speifically for latin america.

    Thanks,
    We are looking forward for a prompt answer.

  2. Hi
    I am looking for Dodge Caliber SRT 4 full body kits with costs and shipping costs to South Africa.
    Kind regards
    Molefe RSA

  3. Hi, I am interested in acquiring a database for Mexico only with Year Make and Model, do you have one at disposal? If so how much would it cost?

    1. None of my current databases are specifically made for Mexico, but I can help you doing web scraping from an existing Mexican website and create a custom database for you.

    1. Drivetrain is included in bigger database https://www.teoalida.com/cardatabase/year-make-model-trim-specs/ and if you need a custom package with ONLY Year, Make, Model, Drivetrain, I can do this at smaller price than full database.

      Sorry for late reply, for some reasons all emails notification of new comments landed my SPAM folder, only today I took a look in SPAM folder to clean it. Next time use live chat in lower-left corner of screen if you want a FAST reply from me.

    1. In case you didn’t noticed the menu bar, there is a separate page for Australia: https://www.teoalida.com/cardatabase/australia/ but checking pages viewed by the IP you left comment, you already saw Australia page so why do you post comment to ask for Australia datbase in this page about American database instead of purchasing Australia database directly?

      Sorry for late reply, for some reasons all emails notification of new comments landed my SPAM folder, only today I took a look in SPAM folder to clean it. Next time use live chat in lower-left corner of screen if you want a FAST reply from me.

  4. Wonderful article and enhanced by a video which is a most attractive way for readers to understand and also helps the business to keep the track of records in the database. Excellently projected ideas in your website more interesting ones to read. You can just hover your link to Ezy cash for cars for more inquiries about selling your unwanted cars for cash.

Leave a comment

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