Mcdonnell Douglas DC-9-82
Service difficulty reports · 23,866
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DC982' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DC982' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA200800696Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 8 TO 13 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 8 TO 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800687Bracket · crackedLGA - EMERGENCY FLASHLIGHT AT AFT RIGHT FORWARD BY LAVATORY HAS CRACKED BRACKET. REPLACED BRACKET FOR EMERGENCY FLASHLIGHT AT AFT RIGHT FORWARD BY LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800686Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD SEAT ROWS 7 TO 11 INOPERATIVE. REPLACED BATTERY PACK AT ROW 9DEF FOR EMERGENCY LIGHT AT SEAT ROWS 7 TO 11. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800690Battery Pack · inoperativeDFW - EMERGENCY LIGHT AT OVERHEAD SEAT ROWS 28 TO 30 INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 29 FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROWS 28 TO 30. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800689Lens · missingDFW - EMERGENCY LIGHT AT OVERHEAD SEAT 29D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD SEAT 29D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800688Strap · brokenLGA - EMERGENCY FLASHLIGHT AT AFT SERVICE DOOR HAS BROKEN STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800683Battery Pack · looseLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 29 TO AFT GALLEY INOPERATIVE. RESECURED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 29 TO AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800675Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800662Gasket · blownPBI INFLIGHT T862/17MAR - CREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE INDICATION. RETURNED TO PBI AND LANDED WITHOUT INCIDENT. FOUND THE LEFT HAND PACK HIGH THERMOSTAT GASKET BLOWN. REPLACED THERMOSTAT, GASKET AND RIGHT PACK TEMPERATURE CONTROL VALVE. SDR AALA200800645Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS SECTION INOPERATIVE. REPLACED BATTERY PACK B5 23 FOR EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS SECTION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800647Lens · missingDFW - EMERGENCY LIGHT AT SEAT 7D LENS MISSING. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800638Lamp · inoperativeLGA - EMERGENCY LIGHT IN TAIL CONE COMPARTMENT BY WATER SEPARATORS INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT IN TAIL CONE COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800642Lamp · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD FLIGHT ATTENDANT SEAT BY VENTRAL DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD FLIGHT ATTENDANT SEAT BY VENTRAL DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800639Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD FIRST CLASS LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD FIRST CLASS LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800610Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERWING RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING RIGHT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800599Battery Pack · dischargedLGA - EMERGENCY LIGHT AT RIGHT OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT RIGHT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800530Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT OVERHEAD AFT CABIN INOPERATIVE. REPLACED BATTERY PACK B5 27 FOR EMERGENCY LIGHTS AT OVERHEAD AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800532Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 26D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 26D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800531Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 15D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800533Shroud · brokenDFW EMERGENCY LIGHT AT SEAT 28D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA080041Wire · brokenFORWARD SECTION OF EMERGENCY LIGHTING BY GALLEY TWO IS INOPERATIVE. REPAIRED BROKEN WIRE.SDR YYFA200800002Hydraulic Line · leakingDURING CRUISE RIGHT HYDRAULIC PRESSURE LOW AND RUDDER CONTROL MANUAL DUE TO RIGHT HAND HYDRAULIC SYSTEM LEAK.SDR AALA200800518Lens · missingMSP EMERGENCY LIGHT AT SEAT 12D HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800517Lamp · missingMSP - EMERGENCY LIGHT AT SEAT 12D HAS MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800477Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT SEAT ROWS 20DEF TO 32DEF INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD 20DEF FOR EMERGENCY LIGHTS AT SEAT ROWS 20DEF TO 32DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800478Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT SEAT ROWS 8DEF TO 19DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 8DEF TO 19DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800468Pump · inoperativeLGA INFLIGHT T333/02MAR - AFT CENTER FUEL BOOST PUMPS POPPED CIRCUIT BREAKERS. RETURNED TO LGA AND LANDED WITHOUT INCIDENT. REPLACED AFT CENTER FUEL TANK BOOST PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800461Controller · inoperativeDFW INFLIGHT T2459/01MAR - LEFT AIR CONDITIONING PACK TEMPERATURE HIGH INDICATION AND PNEUMATIC PRESSURE MAXED OUT. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE FOR EVALUATION. REPLACED TEMPERATURE SENSOR AND CONTROLLER. FOUNDSDR AALA200800459Shroud · missingDFW - EMERGENCY LIGHT AT SEAT 12D HAS SHROUD MISSING. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800458Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800457Battery Pack · looseLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 7 TO 16 INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 7 TO 16. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800456Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800455Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASMF200802009Indicator · out of adjustCAPTAIN REPORTED THAT THE RUDDER WAS TRIMMED 3 DEGREES TO THE LT DURING ALL FLIGHT. MAINTENANCE PERSONNEL REPLACED AND ADJUSTED THE RUDDER TRIM CONTROL POSITION INDICATOR IAW MM 27-20-00, TESTED CORRECT.SDR AALA200800433Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 20 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 20 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800441Lamp · inoperativeEWR - EMERGENCY LIGHT AT OVERHEAD COCKPIT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800440Battery Pack · inoperativeEWR - EMERGENCY LIGHTS AT OVERHEAD COCKPIT INOPERATIVE. REPLACED BATTERY PACK B5 23 FOR EMERGENCY LIGHTS AT OVERHEAD COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800429Lamp · inoperativeLGA - EMERGENCY LIGHT AT SEAT 18D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800428Lamp · inoperativeLGA - EMERGENCY LIGHT AT SEAT 11D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800427Lens · missingMSP - EMERGENCY LIGHT AT SEAT ROW 13 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800426Lamp · missingMSP - EMERGENCY LIGHT AT SEAT ROW 13 MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800425Lens · missingMSP - EMERGENCY LIGHT AT SEAT ROW 10 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 10. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800421Battery Pack · inoperativeLGA EMERGENCY LIGHT AT OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800424Lamp · missingMSP - EMERGENCY LIGHT AT SEAT ROW 10 MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 10. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800430Strap · brokenLGA - EMERGENCY FLASHLIGHT AT FORWARD JUMPSEAT HAS BROKEN SAFETY STRAP. REPLACED SAFETY STRAP FOR EMERGENCY FLASHLIGHT AT FORWARD JUMPSEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800392Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 10D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800391Battery · inoperativeSFO - EMERGENCY FLASHLIGHT AT AFT CABIN INOPERATIVE. REPLACED BATTERY FOR EMERGENCY FLASHLIGHT AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800387Battery Pack · inoperativeLGA EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 20 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 20 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800390Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD AISLE BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD AISLE BETWEEN AFT LAVATORIES. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800386Strap · missingLGA - EMERGENCY FLASHLIGHT AT AFT CABIN MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82