SELECT DISTINCT inventory.typenum, partusemaster.part FROM inventory JOIN partusemaster ON inventory.typenum = partusemaster.typenum WHERE `status` = 'A' AND quantity > 0 ORDER BY part
| |
Accelerator Parts |
Air Bag (Safety) |
| |
Air Bag Detector |
Air Cleaner |
| |
Air Compressor |
Air Conditioner Compressor |
| |
Air Conditioner Compressor Clutch |
Air Conditioner Condenser |
| |
Air Conditioner Evaporator |
Air Conditioner Evaporator Housing |
| |
Air Conditioner Hoses |
Air Conditioner Wiring Harness |
| |
Air Conditioning Changeover |
Air Conditioning Selector |
| |
Air Drier |
Air Flow Meter |
| |
Air Injection Pump |
Air Spring |
| |
Air Tank |
Alternator |
| |
Anti Lock Brake Parts |
Automatic Transmission Pan |
| |
Automatic Transmission Parts, Misc. |
Auxillary Power Unit |
| |
Axle Assembly Housing |
Axle Assembly, Rear |
| |
Axle Assy, Fr (4WD) |
Axle Beam (Front) |
| |
Axle Housing |
Axle Parts, Misc. |
| |
Axle Shaft |
Back Glass |
| |
Backing Plate, Front |
Backing Plate, Rear |
| |
Backup Lamp |
Battery |
| |
Battery Box |
Bell Housing |
| |
Belt Tensioner |
Blower Motor (HVAC) |
| |
Body Parts, Misc. |
Body Wiring Harness |
| |
Boot Cover |
Box / Bed |
| |
Brackets, Misc. |
Brake Master Cylinder |
| |
Brake Parts, Misc. Front |
Brake Parts, Misc. Rear |
| |
Brake Proportioning Valve |
Brake Shoes |
| |
Brakes, Front |
Brakes, Rear |
| |
Bumper Assembly, Front |
Bumper Assembly, Rear |
| |
Bumper Bracket, Front |
Bumper End Cap |
| |
Bumper Guard, Front |
Bumper Reinforcement, Front |
| |
Cab |
Caliper |
| |
Camshaft |
Camshaft Housing |
| |
Carburetor |
Carrier Case |
| |
Catalytic Converter |
Catwalk |
| |
Charge Air Cooler (ATAAC) |
Clock |
| |
Clock Spring |
Clutch Disc |
| |
Clutch Housing |
Clutch Master Cylinder |
| |
Clutch Slave Cylinder |
Coil |
| |
Coil Spring |
Column Shift Lever |
| |
Column Switch |
Complete Interior |
| |
Complete Vehicle |
Connecting Rod |
| |
Console |
Convertible Top Lift |
| |
Cooling Assy. (Rad., Cond., ATAAC) |
Cowl |
| |
Cowl Vent Panel |
Crank / Cam Angle Sensor |
| |
Crankshaft |
Crossmember |
| |
Cutoff |
Cutoff Assembly |
| |
Cylinder Block |
Cylinder Head |
| |
Dash / Console Switch |
Dash Assembly |
| |
Dash Pad |
Dash Panel |
| |
Dash Wiring Harness |
Differential Assembly (Front, Rear) |
| |
Differential Assembly (Rear, Rear) |
Differential Case |
| |
Differential Flange |
Differential Parts, Misc. |
| |
Differential Side Gears |
Distributor |
| |
Door Assembly, Front |
Door Assembly, Rear or Back |
| |
Door Glass, Front |
Door Glass, Rear |
| |
Door Handle |
Door Hinge, Front |
| |
Door Hinge, Rear |
Door Moulding, Front |
| |
Door Panel (Trim) |
Door Vent Glass, Front |
| |
Door Vent Glass, Rear |
Door Vent Window Regulator, Front |
| |
Door Window Crank, Front |
Door Window Crank, Rear |
| |
Door Window Regulator, Front |
Door Window Regulator, Rear |
| |
Drag Link |
Drive Shaft, Front |
| |
Drive Shaft, Rear |
ECM |
| |
ECM (Brake & ABS) |
ECM (Transmission) |
| |
EGR Maintenance Reminder |
Electric Door Motor |
| |
Electrical Parts, Misc. |
Electronic Chassis Control Modules |
| |
Electronic Parts, Misc. |
Emergency Brake Parts |
| |
Engine Assembly |
Engine Mounts |
| |
Engine Oil Cooler |
Engine Parts, Misc. |
| |
Engine Wiring Harness |
Equipment (Mounted) |
| |
Equipment (Whole Vehicle) |
Exhaust Assembly |
| |
Exhaust Cross Pipe |
Exhaust Manifold |
| |
Exhaust Pipe |
Exhaust Pipe |
| |
Fan Blade |
Fan Clutch |
| |
Fender |
Fender Extension |
| |
Fender Moulding |
Fifth Wheel |
| |
Filter / Water Separator |
Flex Plate |
| |
Floor Pan |
Floor Shift Assembly |
| |
Flywheel |
Flywheel Housing |
| |
Frame |
Frame Horn |
| |
Frame Rail |
Frame, Front |
| |
Front Cover |
Front End Assembly |
| |
Front Lamp (Turn Signal) |
Fuel Cap |
| |
Fuel Gauge |
Fuel Injector |
| |
Fuel Pump (Injection) |
Fuel Pump (Tank) |
| |
Fuel Tank |
Fuel Tank Sending Unit |
| |
Fuel Tank Strap/Hanger |
Fuse Box |
| |
Gauges (all) |
Gear Kit |
| |
Generator Set |
Glove Box |
| |
Grille |
Harmonic Balancer |
| |
Hatchback Strut |
Headache Rack |
| |
Header Panel Assembly |
Headlamp Assembly |
| |
Headlamp Door / Cover |
Headliner |
| |
Heater Assembly |
Heater Core |
| |
Heater Housing |
Heater or Air Conditioner Parts, Misc. |
| |
High Mounted Stop Lamp |
Hood |
| |
Hood Hinge |
Hood Hinge |
| |
Horn |
Hub |
| |
Hub Cap |
Idler Arm |
| |
Ignition Switch |
Independent Rear Suspension Assembly |
| |
Inner Fender |
Inner Fender Liner |
| |
Instrument Cluster |
Instrument Cluster Bezel |
| |
Intake Manifold |
Intercooler |
| |
Interior Mirror |
Interior Parts, Misc. |
| |
Interior Sun Visor |
Interior Trim Panel |
| |
Jack |
Jake/Engine Brake |
| |
Knee |
Knuckle Support |
| |
Lamp Wiring Harness |
Latches and Locks |
| |
Leaf Spring, Front |
Leaf Spring, Rear |
| |
Lid Pulldown |
Locking Hubs |
| |
Lower Control Arm, Front |
Luggage Rack |
| |
Manual Transmission Parts, Misc. |
Mirror (Side View) |
| |
Miscellaneous Parts |
Muffler |
| |
Muffler Shield |
Oil Pan |
| |
Oil Pump |
Overdrive Unit |
| |
Pickup Box Floor Pan |
Pickup Box Front Panel |
| |
Pickup Cab (Shell) |
Piston |
| |
Pitman Arm |
Power Brake Booster |
| |
Power Steering Assembly |
Power Steering Control Valve |
| |
Power Steering Cooler |
Power Steering Pressure Cylinder |
| |
Power Steering Pressure Hose |
Power Steering Pump |
| |
Power Window Motor |
Pressure Plate |
| |
PTO |
Quarter Extension |
| |
Quarter Glass |
Quarter Panel Assembly |
| |
Quarter Repair Panel |
Radiator |
| |
Radiator Core Support |
Radiator or Condenser Fan Motor |
| |
Radiator Overflow Bottle |
Radiator Shroud |
| |
Radio |
Radio Antenna |
| |
Radio Speaker, Rear |
Radius Arm |
| |
Rear Clip |
Rear Top Section |
| |
Rears (Front) |
Rears (Matched Set) |
| |
Rears (Rear) |
Rebuilders |
| |
Refrigerant |
Relay, Electrical |
| |
Retainer |
Ring Gear and Pinion |
| |
Rocker Arm |
Roll Bar |
| |
Roof Assembly |
Roof Glass |
| |
Running Board |
Seat Belt |
| |
Seat Track, Front |
Seat, Front |
| |
Seat, Rear |
Shock Absorber |
| |
Side Fairing |
Skirt |
| |
Sleeper |
Sleeper Fairing |
| |
Solvent or Lubricant |
Special Glass |
| |
Speedometer Head Cluster |
Spindle / Knuckle, Front |
| |
Spoiler / Aero Wing |
Spring Hanger |
| |
Stabilizer Bar |
Starter Motor |
| |
Starter Solenoid |
Steering Column |
| |
Steering Gear / Rack |
Steering or Suspension Parts, Misc. |
| |
Steering Wheel |
Strut |
| |
Stub Axle, Rear |
Sun Visor (External) |
| |
Suspension |
Suspension Trunion Arm |
| |
Tachometer |
Tag Axle |
| |
Tail Finish Panel |
Tail Lamp |
| |
Tail Pipe |
Tailgate |
| |
Temperature Control |
Third Seat, (Station Wagon or Van) |
| |
Throttle Body Assembly |
Tie Rod |
| |
Timing Gears |
Tire and Rim |
| |
Tires |
Tool Box |
| |
Tools |
Torque Converter |
| |
Torsion Bar |
Trailer |
| |
Trailer Hitch |
Transaxle Housing |
| |
Transfer Case Adapter |
Transfer Case Assembly |
| |
Transfer Case Motor |
Transmission Assembly |
| |
Transmission Crossmember / Mounts |
Transmission Oil Cooler |
| |
Trim Pad, Misc |
Trunk Lid Moulding |
| |
Turbocharger / Supercharger |
Universal Slip Yoke |
| |
Upper Control Arm, Front |
Vacuum Pump |
| |
Valance, Front |
Valve Cover |
| |
Water Pump |
Wet Kit |
| |
Wet Kit Control |
Wet Kit Tank |
| |
Wheel |
Wheel Bearing, Front |
| |
Wheel Cover |
Windshield Frame |
| |
Windshield Glass |
Windshield Washer Motor |
| |
Windshield Washer Reservoir |
Windshield Wiper Arm |
| |
Wiper Motor, Rear |
Wiper Motor, Windshield |
| |
Wiper Transmission |
Wire Harness, Transmission |
|
