One payment, lifetime updates. Come back once in a while to stay updated of new versions of this database.

1942 - 2015 Car Auto Parts Database by Make, Model, Trim, Engine, Year & Brand w/ Images

Database Description:

This auto parts data set (4th edition) is comprised of a 15.8 GB database (MySQL or CSV) of over 1.7 million vehicle car parts of 68 makes from year 1942 to 2015, in 12 highly structural data tables, and a package of 1,702,044 JPEG part image files of a total download size of 30.4 GB. You can search or browse parts by:

1. Make (68) + Year (74) => Model (22,603) => Trim / Submodel (43,921) => Engine (74,205) => Part (1,708,530)
2. Brand (765) => Part (1,708,530)

Each part has a part number (100%), manufacturer number (100%), list price (100%), text description (100%), fits (97.5%), JSON specifications (100%) with more than 700 different properties / attributes, such as Product Fit (90.5%), Warranty (82.9%), Notes (47.4%), Fit Note (43.9%), Color / Finish, Material, Series, Design, Position, and Recommended Use.

Each part has a thumbnail picture in the part images package with a total of over 1.7 million part image photos referenced by part.id. Car parts data records in the database are organized by car makes, years, models, sub-models / trims, engines and part brands.

Parts included: Accessory, Air Intake, Body Electrical, Body Mechanical & Trim, Brake, Car Care, Climate Control, Clutch, Cooling System, Driveshaft & Axle, Engine Electrical & Mechanical, Exhaust, Fuel Delivery, Interior Styling, Steering, Suspension, Tires & Wheels, and Transmission.

Category tables, namely `category`, `category_sub`, and `category_sub_sub` are NOT associated with the other tables for now.

Database Meta:

  • Size: 15.8 GB + 30.4 GB
  • Images / Multi-media: 1,702,044 JPEG image files, 30.4 GB. File name: ab/cd/{part.id}.jpg (abcd = last 4 digits of file name, e.g. 888abcd.jpg)
  • Last updated: Jan. 3rd, 2015
  • Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
  • Tables: 12

Buy Now & Download: $489.95 (USD)


phpMyAdmin Screenshots:

MySQL Database: 1942 - 2015 Car Auto Parts Database by Make, Model, Trim, Engine, Year & Brand w/ Images for Sale

Table Details (Data Structure / Schema):

  • brand
    Records:765

    Brands of auto parts

    Data fields

    1. id: int(10) unsigned
    2. title: varchar(255)
    3. slug: varchar(255)
    4. initial: char(1)
  • category
    Records:8

    Top categories

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. slug: varchar(255)
  • category_sub
    Records:158

    Secondary categories

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. category_id: int(11)
  • category_sub_sub
    Records:1,540

    Tertiary categories

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. category_sub_id: int(11)
  • engine
    Records:74,205

    Different engines of automobiles

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. submodel_id: int(11)
    4. make: varchar(255)
    5. year: char(4)
    6. model: varchar(255)
    7. submodel: varchar(255)
    8. num_parts: int(10) unsigned
  • engine2part
    Records:117,229,740

    Association table of auto engines and auto parts

    Data fields

    1. id: int(11)
    2. part_id: int(11)
    3. engine_id: int(11)
  • make
    Records:68

    Automobile makes

    Data fields

    1. id: int(10) unsigned
    2. title: varchar(255)
    3. num_parts: int(10) unsigned
  • make2year
    Records:2,978

    Association table of auto makes and auto years

    Data fields

    1. id: int(11)
    2. make: varchar(255)
    3. year: char(4)
  • model
    Records:22,603

    Different models of automobile makes

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. make2year_id: int(11)
    4. make: varchar(255)
    5. year: char(4)
  • part
    Records:1,708,530

    Primary table containing all the automobile parts

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. part_number: varchar(255)
    4. manufacturer_number: varchar(255)
    5. list_price: varchar(255)
    6. universal_part: tinyint(1)
    7. brand_title: varchar(255)
    8. brand_id: int(10) unsigned
    9. description: mediumtext
    10. fits: text
    11. specifications_json: text
    12. Quantity_Sold: varchar(255)
    13. Product_Fit: varchar(255)
    14. Warranty: varchar(255)
    15. Color_Finish: varchar(255)
    16. Material: varchar(255)
    17. Location: varchar(255)
    18. Series: varchar(255)
    19. Notes: text
    20. Seat_Type: varchar(255)
    21. Fit_Note: text
    22. Design: varchar(255)
    23. Position: varchar(255)
    24. Type: varchar(255)
    25. Row: varchar(255)
    26. Recommended_Use: varchar(255)
    27. Vehicle_Body_Type: varchar(255)
    28. Construction: varchar(255)
    29. Kit_Type: varchar(255)
  • submodel
    Records:43,921

    Sub-models or trims of auto models

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. model_id: int(11)
    4. make: varchar(255)
    5. year: char(4)
    6. model: varchar(255)
  • year
    Records:74

    Year of automobile production

    Data fields

    1. id: int(11)
    2. title: char(4)
    3. num_parts: int(10) unsigned

Buy Now & Download: $489.95 (USD)



Download link will be automatically sent to your PayPal email. Please check the spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive the download link 10 minutes after payment. We will manually send the download details as soon as we see your message. Our delivery / support staff work in the time zone of GMT+8.

Instant automatic download upon payment success, just press return button on PayPal website after finishing payment.

Prospective Applications / Implementations:

  • New & used auto parts online shopping store / affiliate site
  • Aftermarket automobile / automotive related website / wholesale manufacturer
  • Automobile repair service site
  • Automobile information site / community enhancement
  • Auto body parts directory lookup and reference

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the URL we sent to you, you can download updated versions free.