Catalog of spare parts for maintenance

Catalog of spare parts for maintenance

Catalog of spare parts for maintenance. Data format: MySQL. The date of relevance is 2024. Car brands: 131, models: 5398, modifications: 23081, spare parts: 66929, technical fluids: 57837, parts cross-references: 369735

The catalog contains the following information about cars: make, model, modification name, engine code, body, fuel, engine power l/s, start of production, end of production, engine capacity, number of cylinders, valves, total valves, engine type.

There is also information about technical fluids and their filling volumes.

For each spare part in the catalog, its name in Russian, brand, article, cross-references and the quantity required for maintenance are indicated.

Spare parts for cars produced in the period from August 1958 to September 2023.

List of brands: ABARTH, ACURA, ALFA ROMEO, ASTON MARTIN, AUDI, AVATR, BAIC, BENTLEY, BMW, BMW MOTORRAD, BOGDAN, BRILLIANCE, BUICK, BYD, CADILLAC, CHANGAN (CHANA), CHERY, CHEVROLET, CHRYSLER, CITROEN, DACIA, DAEWOO, DAIHATSU, DATSUN, DAYUN, DODGE, DONGFENG, DS, EVOLVE, EXEED, FAW, FERRARI, FIAT, FORD, FORD ASIA / OZEANIA, FORD USA, FORTHING, FOTON, GAC, GAZ, GEELY, GENESIS, GEO, GMC, GREAT WALL, HAFEI, HAIMA (FAW), HAVAL, HAWTAI, HONDA, HONGQI, HUMMER, HYUNDAI, INFINITI, IRAN KHODRO (IKCO), ISUZU, IVECO, JAC, JAECOO, JAGUAR, JEEP, JETOUR, JETTA, KAIYI, KAMAZ, KIA, LADA, LAMBORGHINI, LANCIA, LAND ROVER, LDV, LEXUS, LI, LIFAN, LINCOLN, LIVAN, LUXGEN, LYNK&CO, MASERATI, MAYBACH, MAZDA, MERCEDES-BENZ, MERCURY, MG, MINI, MITSUBISHI, MITSUBISHI (BBDC), MOSKVICH, NISSAN, OLDSMOBILE, OMODA, OPEL, PEUGEOT, PLYMOUTH, POLESTAR, PONTIAC, PORSCHE, PROTON, RAVON, RENAULT, RENAULT (DONGFENG), RENAULT TRUCKS, ROLLS-ROYCE, ROVER, SAAB, SAMSUNG, SATURN, SCION, SEAT, SKODA, SKYWELL, SMART, SOLLERS, SOUEAST, SSANGYONG, SUBARU, SUZUKI, SWM MOTORS, TAGAZ, TANK, TATA, TESLA, TOYOTA, UAZ, VGV, VOLVO, VOYAH, VW, ZAZ, ZEEKR, ZOTYE.

Types of spare parts: rear shock absorber, front shock absorber, brake drum, rear stabilizer bushings, front stabilizer bushings, rear brake pad sensor, front brake pad sensor, clutch disc, rear brake disc, front brake disc, ignition coil, rear brake pads, front brake pads, drive belt kit, clutch basket, tie rod tip, water pump, fuel pump, timing tensioner, rear shock absorber support, front shock absorber support, ball bearing, rear shock absorber bump, front shock absorber bump, release bearing, rear hub bearing, front hub bearing, high-voltage wires, rear suspension spring, front suspension spring, inner tire anther, outer tire anther, timing belt, drive belt, timing repair kit, timing belt roller, drive belt roller, spark plug, pallet drain plug, rear stabilizer struts, front stabilizer struts, clutch kit, thermostat, steering rod, air filter, oil filter, interior filter, fuel filter, timing chain, inner joint, outer joint, driver's wiper blade, rear wiper blade, passenger wiper blade, wiper blades kit.

Catalog structure:

TObrands.id - vehicle brand ID, TObrands.name - brand name, TOmodels.makeId - vehicle brand ID, TOmodels.modelId - vehicle model ID, TOmodels.modelName - model name, TOmodels.yearFrom - the beginning of the release, TOmodels.yearTo - end of release, TOmodifications.brand - manufacturer, TOmodifications.constructionType - body, TOmodifications.EndDate - end of production, TOmodifications.EngineCapacity - engine displacement, TOmodifications.engineCode - engine code, TOmodifications.fuel - fuel, Modifications.fullName - full name of the modification, Modifications.horsePower - engine power, hp, TOmodifications.id - modification ID, TOmodifications.makeId - vehicle brand identifier, TOmodifications.model - model, TOmodifications.modelId - model identifier ts, TOmodifications.motorType - engine type, TOmodifications.name - name, Modifications.numberOfCylinders - number of cylinders, TOmodifications.StartDate - start of production, TOmodifications.valves - valves, Modifications.valvesTotal - total valves, TOparts.comment - comments and explanations, TOparts.itemName - the name of the spare part, TOparts.makeId - the identifier of the vehicle brand, TOparts.ManufacturerID - the identifier of the manufacturer of the spare part, TOparts.ManufacturerName - name of the manufacturer of the spare part, TOparts.modelId - vehicle model identifier, TOparts.modificationId - identifier vehicle modifications, TOparts.partNumber - part number, TOparts.quantity - required quantity

Демо на ZAPCHASTI-TO.RU