select * from advertise where manufacturer like 'C%' and adv_type='Parts' and del_status='N' and adv_status='A' and advertise_id < 372 GROUP BY manufacturer ORDER BY `manufacturer`, `part_number` ASC olddieselparts
Old Diesel Parts

Search for Parts

 
For part number examples click on the alphabetical list and it will just show the examples
View By:   A| B| C| D| E| F| G| H| I| J| K| L| M| N| O| P| Q| R| S| T| U| V| W| X| Y| Z


Examples
Manufacturer Part Number Description
Caterpillar
4N0425 Weight
7S6681 Element
CIPA
AC 1811 Delivery valve
CKBL 97 JB 2088 Injector
KS 1005 Rubber bellows
PC605 Element
Cummins C D C
101981 Sprocket
143849 Spring
3006355 Shaft
3015224 Injector
3017996 Governor weight