Database
1985-2021 US Auto Parts Catalog Database
521,648 Car Parts & 139.85G Part Images by 217 Brands, 59 Makes, 17,299 Models, 63,076 Vehicles
Description: With 521,648 parts by 37 years, 59 makes, 17,299 models, 41,064 sub-models or trims, 63,076 engines, and 217 manufacturers, this is the latest (1985 to 2021) and highly comprehensive United States auto parts database for your auto parts software, app, or website. Parts are also categorized by 8 tier 1 categories, further by 158 tier 2 categories, and eventually by 5,698 tier 3 categories, which all come with a large cover image each.
Other than general part fields, the part_attributes (99.4%) field carry further details of 642 unique part attributes: warranty (94.8%), location (62.0%), product fit (51.8%), series (49.5%), recommended use (45.9%), notes (35.2%), replaces OE number (28.7%), material (25.8%), type (20.9%), interchange part number (20.7%), color finish (19.5%), returns policy (19.4%), design (9.3%), components (8.7%), etc.. This data set also comes with 520,830 auto part images (139.85G) that are of high resolutions with no watermarks, averaging about 246KB per JPEG image, ready for your part store and inventory management. There are 16 tables in this database.
Data Samples
By Table / Parts (Desktop) / JSON / XML / Excel / CSV (Download)
By Table / Vehicles (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
https://songer.datasn.com/data/api/v1/u_2926417bef71d25521f5/auto_parts_united_states/ (By Table)
Media Files
category_1_image -- Bytes: 220.58K / Files: 8
category_2_image -- Bytes: 36.74M / Files: 145
category_3_image -- Bytes: 603.09M / Files: 5,183
part_image -- Bytes: 139.85G / Files: 520,830
Data Samples (JSON, CSV, XML, Excel):
https://songer.datasn.com/data/api/v1/u_2926417bef71d25521f5/auto_parts_united_states/by_table/
Database Statistics
- Size: 10.66 GB
- Tables: 12
- Records: 521,648
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Images Statistics
- Images: 0.14T
- Dimensions: 1200 x 1200 on average
- Image formats: JPEG
- Images count: 520,830
- Reference field: {part_image.path} by {part_image.part_id} to {part.id}
Database Structure
| Table | Records | Fields |
|---|---|---|
| brand | 217 |
|
| category_1 | 8 |
|
| category_2 | 158 |
|
| category_3 | 5,698 |
|
| engine | 63,076 |
|
| make | 1,608 |
|
| model | 17,299 |
|
| part | 521,648 |
|
| submodel | 41,064 |
|
| vehicle | 63,076 |
|
| vehicle_x_part | 84,796,836 |
|
| year | 37 |
|
Database Attachments
Images: This database is attached with 520,830 images. See them under the Attachments tab.
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
make
- Acura - 615,762
- Audi - 2,986,932
- BMW - 2,256,679
- Buick - 1,139,086
- Cadillac - 1,460,251
- Chevrolet - 8,556,303
- Chrysler - 1,074,784
- Daewoo - 38,616
- Daihatsu - 14,928
- Dodge - 3,557,803
- Eagle - 82,639
- Fiat - 295,758
- Ford - 8,881,222
- Freightliner - 4,703,587
- Geo - 56,630
- GMC - 5,769,303
- Hino - 404,004
- Honda - 2,108,435
- Hummer - 59,386
- Hyundai - 2,050,462
- Infiniti - 704,391
- International - 2,632,750
- Isuzu - 577,718
- Jaguar - 760,007
- Jeep - 1,959,320
- Kenworth - 1,424,372
- Kia - 1,738,609
- Land Rover - 614,247
- Lexus - 990,952
- Lincoln - 777,982
- Mack - 827,657
- Mazda - 1,736,058
- Mercedes Benz - 2,184,737
- Mercury - 499,970
- Mini - 381,374
- Mitsubishi - 1,235,909
- Mitsubishi Fuso - 269,979
- Nissan - 2,808,917
- Oldsmobile - 412,339
- Peterbilt - 1,497,827
- Plymouth - 246,522
- Pontiac - 731,090
- Porsche - 964,111
- Ram - 1,753,115
- Saab - 206,371
- Saleen - 5,247
- Saturn - 272,846
- Scion - 99,290
- Shelby - 2,077
- Smart - 116,447
- SRT - 8,196
- Sterling - 4,500
- Subaru - 1,476,255
- Suzuki - 561,706
- Tesla - 80,389
- Toyota - 3,718,554
- UD - 196,101
- Volkswagen - 2,460,504
- Volvo - 1,745,830
year
- 2021
- 2020
- 2019
- 2018
- 2017
- 2016
- 2015
- 2014
- 2013
- 2012
- 2011
- 2010
- 2009
- 2008
- 2007
- 2006
- 2005
- 2004
- 2003
- 2002
- 2001
- 2000
- 1999
- 1998
- 1997
- 1996
- 1995
- 1994
- 1993
- 1992
- 1991
- 1990
- 1989
- 1988
- 1987
- 1986
- 1985
brand
- Hengst - 486
- Replacement - 82,563
- Flowmaster - 617
- Energy Suspension - 1,145
- Husky Liners - 1,567
- Curt - 2,724
- Weathertech - 15,192
- MBRP - 646
- Rancho - 488
- KC Hilites - 164
- Prothane - 374
- Battery Doctor - 16
- B&M - 114
- Funnel King - 8
- Air Lift - 297
- Eastern - 1,432
- Kool Vue - 7,027
- Newark Auto Products - 7,282
- Precision Parts - 805
- Spectre - 345
- Dynomax - 375
- JC Whitney - 874
- TrueDrive - 19,641
- DriveWire - 1,623
- SureStop - 3,544
- Powerstop - 23,183
- GPD - 13,347
- Moog - 10,830
- KYB - 4,025
- DriveMotive - 1,356
- Schrader - 124
- K&N - 1,864
- Centric - 23,841
- Walker Products - 4,804
- 4-Seasons - 5,291
- AC Delco - 19,543
- Standard - 12,672
- Mevotech - 11,221
- Philips - 38
- Hastings - 621
- Beck Arnley - 4,765
- aFe - 3,094
- VDO - 1,426
- Magnaflow - 4,466
- Bilstein - 1,822
- Quality-Built - 3,729
- A1 Cardone - 22,079
- Denso - 3,184
- Stant - 574
- Monroe - 5,980
- Ventshade - 2,350
- Rhino-Rack - 454
- Purolator - 703
- Valeo - 1,036
- Westin - 2,875
- DSS - 1,292
- Dorman - 25,596
- AEM Air - 452
- Airaid - 388
- Access - 944
- Extang - 959
- Bosch - 3,440
- NTK - 221
- Fram - 870
- Hitachi - 93
- Delphi - 2,790
- Truxedo - 497
- EGR - 320
- Borla - 570
- Dayco - 4,152
- Mahle - 498
- Timken - 2,738
- Gates - 8,689
- ReplaceXL - 8,088
- CSF - 977
- Strong Arm - 1,317
- Motorcraft - 9,418
- NGK - 309
- BAK Industries - 555
- Felpro - 5,798
- GenuineXL - 3,972
- Pro Parts - 205
- EBC - 13
- Hellwig - 145
- Davico - 1,124
- GMB - 1,010
- Febi - 942
- Crown - 5,805
- Evan Fischer - 435
- Aries - 1,188
- Titan Fuel Tanks - 43
- Liland - 581
- Dee Zee - 511
- DNJ - 8,733
- Luverne - 858
- Edelmann - 997
- Switch Pros - 12
- Arnott - 378
- AISIN - 256
- Mann-Filter - 286
- Bestop - 651
- Bushwacker - 568
- DEA - 1,920
- Catco - 980
- Go Rhino - 967
- Seat Designs - 26,745
- Item Auto - 789
- Baum Tools - 31
- Cloyes - 364
- Anzo - 1,228
- Hayden - 26
- Airtex - 1,401
- Accel - 177
- Bostech - 716
- Belltech - 958
- Pacer - 6
- Painless - 204
- Hurst - 98
- Proform - 91
- RT Off-Road - 375
- Transdapt - 139
- Teraflex - 488
- Walker - 3,551
- Autometer - 2,921
- Holley - 678
- MSD - 399
- SPAL - 3
- OEMTOOLS - 965
- FEY - 55
- Flowtech - 222
- Sachs - 22
- Wade Auto - 45
- StyleLine - 14
- Skyjacker - 967
- PIAA - 1
- Mr Gasket - 6
- Performance Tool - 2
- Plasticolor - 3
- Mile Marker - 61
- Corsa - 670
- Hypertech - 663
- Dashtop - 931
- Lisle - 104
- Great Neck - 25
- Edge Products - 156
- Smittybilt - 2
- Tuff Stuff Overland - 38
- APEX - 3,183
- Superchips - 50
- Fox - 321
- PPE Diesel - 9
- Yukon Gear & Axle - 1,905
- Key Parts - 1,762
- N-Dure - 25
- Diablo Sport - 1
- AutoWheels - 163
- 4WD Pros - 1
- Kooks - 285
- Pacesetter - 30
- Haynes - 145
- Eastern Exhaust - 464
- Bosal - 1,968
- Perfection Clutch - 752
- StopTech - 12
- JW Speaker - 22
- Centerforce - 322
- Chilton - 86
- Putco - 8
- Rugged Ridge - 1
- Lemfoerder - 85
- Automotive Lighting - 73
- Rain-X - 52
- Daystar - 3
- JP Group Dansk - 86
- Aceon - 159
- Fairchild Industries - 375
- Coverlay - 3,353
- JL - 8
- Scott Drake Legendary Wheels - 3
- Griffin Thermal Products - 4
- Kee Auto Top - 553
- Bolton Premiere - 16
- Accu Form - 222
- Alliance - 138
- Nolathane - 615
- Whiteline - 354
- FER - 10
- LN Engineering - 6
- SuperSprings - 153
- Drake Automotive - 2
- Metro Moulded - 23
- FCS - 2
- Odyssey Battery - 47
- Champion - 6
- Eibach - 2
- FPD - 7
- Warn - 4
- Ansa - 8
- SL - 1
- Raybestos - 3,163
- Liqui Moly - 5
- Recochem - 12
- DJM Suspension - 1
- Premium Guard Filters - 3
- Tub O Towels - 4
- Hooker - 1
- MTS - 3
- C&M Hydraulics - 2
- Pro Comp - 7
- Bracketron - 2
- POD - 1
- USA Standard Gear - 9
- Pierburg - 4
- Zumbrota Drivetrain - 6
- Rekon Off Road - 1
- Fidanza - 1
- Hella - 1
category_1
- Auto Body Parts & Mirrors - 50,206
- Headlights & Lighting - 21,442
- Engine & Drivetrain - 188,010
- Brakes, Suspension & Steering - 143,562
- Interior Accessories - 55,935
- Exterior Accessories - 60,595
- Wheels - 296
- Tools & Garage - 1,602
category_2
- Air Filters & Intake Systems - 13,660
- Air Suspension Components - 774
- Auto Body Styling & Accessories - 253
- Axles, Driveshaft & 4WD - 12,318
- Ball Joints & Components - 4,322
- Brake Discs, Pads & Calipers - 51,685
- Brake Drums, Shoes & Components - 2,453
- Brake Hoses, Lines & Components - 6,050
- Brake Master Cylinders, Boosters & Components - 5,629
- Bulbs - 441
- Bumpers & Components - 24,893
- Cams, Timing & Valvetrain - 17,025
- Car Covers - 4
- Cargo Accessories, Liners & Mats - 4,131
- Carpet & Vinyl Floor Kits - 7,241
- Catalytic Converters & Components - 8,811
- Clutches, Flywheels & Components - 3,309
- Coil Springs & Components - 1,223
- Consoles & Organizers - 156
- Control Arms, Thrust Arms & Components - 16,194
- Convertible Tops, Soft Tops & Components - 784
- Corner Lights & Components - 1,056
- Cranks, Pistons, Oil & Components - 14,558
- Dash & Dash Accessories - 3,390
- Decals & Graphics - 4
- Deflectors, Bras & Shields - 1,520
- Door Handles, Locks & Accessories - 10,275
- Door Panels & Accessories - 515
- Door Sheet Metal - 209
- Electronic Control Modules, Ignition & Distributors - 7,916
- Emblems - 112
- Emission & Components - 1,346
- Engine & Transmission Assemblies - 1
- Engine & Transmission Mounts - 3,136
- Exhaust, Headers, Manifolds Mufflers & Components - 11,466
- Fender Flares, Vents & Accessories - 1,305
- Fenders & Components - 5,870
- Floor Mats & Liners - 7,818
- Fog Lights, Driving Lights, Components & Accessories - 2,920
- Fuel Systems & Components - 11,607
- Fuel Tanks & Components - 1,468
- Garage Accessories - 217
- Gas Caps, Fuel Doors & Components - 327
- Gauges, Meters & Monitors - 2,654
- Grille Guards & Bull Bars - 827
- Grilles & Components - 4,021
- Header Panels - 210
- Headlights, Components & Accessories - 9,830
- Headliners & Deck Covers - 19
- Heating, Air Conditioning & Components - 26,049
- Hitches, Winches & Trailers - 2,872
- Home and Garden - 2
- Hoods & Components - 3,560
- Horns & Components - 1
- Intercoolers, Superchargers, Turbos & Components - 701
- Interior Lighting & Components - 26
- Inverter Coolers & Components - 1
- Jacks, Lifts & Stands - 29
- Leaf Springs & Components - 602
- License Plate Components & Accessories - 763
- Lift Supports & Components - 2,662
- Liftgate & Hatch Components - 80
- Lighting Accessories & Components - 123
- Lowering, Leveling & Lifting Kits - 1,236
- Lug Nuts & Bolts - 234
- Mirrors & Components - 8,688
- Mobile Electronics - 671
- Nerf Bars, Running Boards & Steps - 3,134
- OE Replica Wheels - 346
- Off-Road Lighting - 268
- Other Auto Body Accessories - 699
- Other Auto Body Replacement - 6,533
- Other Gaskets & Seals - 294
- Other Interior - 79
- Outdoor & Camping Gear - 23
- Oxygen Sensors & Components - 6,018
- Parking Brake, ABS & Other Components - 6,047
- Pedals & Accessories - 83
- Pet Accessories - 34
- PM Review - 14
- Power Programmers, Tuners, Chips & Monitors - 940
- Power Steering Pumps & Components - 4,017
- Quarter Panels & Components - 216
- Radiator Support & Components - 2,228
- Radiators, Fans, Cooling Systems & Components - 19,954
- Repair Manuals, Videos & Software - 231
- Rocker Panels & Accessories - 625
- Roof Racks & Cargo Carriers - 458
- Rust Repair & Patch Panels - 524
- Seals & Weatherstripping - 549
- Seats, Seat Covers & Accessories - 27,089
- Shifter Accessories - 77
- Shocks, Struts & Components - 18,820
- Spare Tire Accessories - 97
- Spark Plugs, Wires & Components - 3,390
- Speed Sensors - 454
- Starters, Alternators, Batteries & Components - 6,723
- Steering Systems & Components - 1,263
- Steering Wheels & Accessories - 277
- Sun Visors, Shields & Accessories - 1,666
- Sunroof Components - 55
- Suspension Links, Rods, Bars & Components - 1,691
- Suspension System Components - 1,647
- Sway Bars & Components - 7,938
- Switches, Relays, Wiring & Components - 7,511
- Tail Lights, Back Up Lights & Accessories - 5,870
- Tailgates & Components - 1,021
- Third Brake Lights & Components - 192
- Tie Rods, Steering Racks, Gearboxes & Components - 10,641
- Tire Pressure Monitoring Systems & Components - 496
- Tires - 2
- Tonneau Covers & Accessories - 3,179
- Tools - 1,125
- Transmissions & Shifters - 2,660
- Truck Bed & Tailgate Accessories - 783
- Trunks & Components - 142
- Turn Signals, Side Markers & Other Lights - 3,298
- Wheel Covers, Caps & Simulators - 92
- Wheel Hubs, Bearings, and Components - 8,368
- Window Visors - 4,058
- Windows & Components - 9,716
- Windshield, Wipers, Washers, Accessories & Components - 3,740
Miscellaneous
Notes:
- All part images are original and large JPEG images with no watermarks.
- All data fields are populated 92% or more.
Defects:
- There are no defects regarding this parts database that we know of .
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.