SELECT DISTINCT inventory.typenum, partusemaster.part FROM inventory JOIN partusemaster ON inventory.typenum = partusemaster.typenum WHERE `status` = 'A' AND quantity > 0 AND productcode = 24153 ORDER BY part    Air Bag (Safety)  Air Cleaner    Air Conditioner Condenser  Air Conditioning Changeover    Air Drier  Air Tank    Alternator  Axle Beam (Front)    Battery Box  Brackets, Misc.    Brake Parts, Misc. Rear  Bumper Assembly, Front    Cab  Camshaft    Catwalk  Charge Air Cooler (ATAAC)    Complete Vehicle  Crankshaft    Cutoff  Cylinder Block    Cylinder Head  Door Assembly, Front    ECM  Engine Assembly    Engine Mounts  Exhaust Pipe    Fan Clutch  Fender    Fender Extension  Fifth Wheel    Flywheel  Frame    Front Cover  Fuel Pump (Tank)    Fuel Tank  Harmonic Balancer    Headache Rack  Heater Core    Hood  Muffler    Oil Pan  PTO    Radiator  Rears (Front)    Rears (Rear)  Sleeper    Sleeper Fairing  Spindle / Knuckle, Front    Starter Motor  Steering Column    Steering Gear / Rack  Sun Visor (External)    Suspension  Tag Axle    Tires  Tool Box    Transfer Case Assembly  Transmission Assembly    Turbocharger / Supercharger  Water Pump    Wet Kit  Wheel    Wire Harness, Transmission