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 AALA20071498Bulb · inoperativeDFW - EMERGENCY LIGHT AT RIGHT EXTERIOR OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT RIGHT EXTERIOR OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071501Hook And Loop · failedDFW - EMERGENCY SLIDE AT AFT SERVICE DOOR HANDLE HOOK AND LOOP INOPERATIVE. REPLACED EMERGENCY SLIDE AT AFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071497Wire Harness · brokenDFW - EMERGENCY LIGHT AT SEAT 8D IS INOPERATIVE. REPAIRED WIRE FROM SIDEWALL AREA TO SEAT FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071472Pump · inoperativeSTL INFLIGHT T616/08AUG DFW TO DTW - FORWARD CENTER FUEL BOOST PUMP CIRCUIT BREAKER POPPED. FUEL STOPPED FEEDING FROM CENTER TANK. LANDED STL WITHOUT INCIDENT. REPLACED CENTER FUEL TANK FORWARD FUEL BOOST PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071433Battery Pack · inoperativeBOS - EMERGENCY LIGHTS AT RIGHT AND LEFT AFT AUXILIARY DOORS INOPERATIVE. REPLACED BATTERY PACK AT BIN 20DEF FOR EMERGENCY LIGHT AT SEAT ROW 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071427Battery Pack · inoperativeLGA - SEAT MOUNTED EMERGENCY LIGHT AT POSITION AB53 INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHT AT POSITION AB53. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071410Hook And Loop · inoperativeMSP - LEFT NUMBER ONE DOOR SLIDE HOOK AND LOOP STRIP INOPERATIVE. REPLACED LEFT NR 1 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071401Lanyard · frayedMSP - FORWARD GALLEY DOOR SLIDE LANYARD CABLE IS FRAYED. REPLACED LANYARD FOR FORWARD GALLEY DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071396Duct · leakingTAIL COMPARTMENT OVERHEAT INDICATION ON CLIMB OUT. LEFT AIR CONDITIONING PACK WAS TURNED OFF AND LIGHT EXTINGUISHED AFTER ONE MINUTE. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED DUCT. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20071409Battery · inoperativeORD - EMERGENCY FLASHLIGHT AT FIRST CLASS INOPERATIVE. REPLACED BATTERY FOR EMERGENCY FLASHLIGHT AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071412Light · brokenDFW - EMERGENCY LIGHT AT FORWARD GALLEY WALL BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FORWARD GALLEY WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071411Light · brokenDFW - EMERGENCY LIGHT MARKER AT RIGHT AFT EXIT BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT MARKER AT RIGHT AFT EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071395Line · inoperativeEWR INFLIGHT T558 - LEFT HYDRAULIC PRESSURE INDICATION AS THEY ENTERED HOLDING. LEFT PRESSURE READ ZERO POUNDS PER SQUARE INCH. LANDED EWR WITHOUT INCIDENT. FOUND EXCESSIVE AIR IN LEFT AND RIGHT HYDRAULIC SYSTEMS. PERFORMED EXCESSIVE AIR CHECK AND BLED AIRSDR AALA20071386Boot · looseLBB INFLIGHT T389/31JUL DFW TO ABQ - DURING FLIGHT CREW RECEIVED TAIL COMPARTMENT HIGH INDICATION. LANDED LBB WITHOUT INCIDENT. SECURED BOOT AT RIGHT TEMPERATURE CONTROL VALVE INLET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071385Connector · inoperativeSTL - EMERGENCY LIGHT AT FORWARD RIGHT VENTRAL STAIRWAY INOPERATIVE. REPLACED CONNECTOR FOR EMERGENCY LIGHT AT FORWARD RIGHT VENTRAL STAIRWAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071384Hook And Loop · inoperativeORD - L2 DOOR SLIDE GIRT BAR HOOK AND LOOP STRIP IS DIRTY AND WILL NOT HOLD. REPLACED LEFT NUMBER TWO DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071380Cover · inoperativeORD - LEFT NUMBER ONE DOOR SLIDE MANUAL INFLATION HANDLE VELCRO DOES NOT HOLD. REPLACED SLIDE ASSEMBLY FOR LEFT NUMBER ONE DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071377Cover · inoperativeORD - LEFT NUMBER TWO DOOR SLIDE MANUAL INFLATION HANDLE COVER DOES NOT HOLD. REPLACED LEFT NUMBER TWO DOOR SLIDE ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR FX7A200700005Csd · overheatedLEFT CSD TEMP INCREASED TOWARDS RED MARK. LEFT CSD PRESS LOW LIGHT AND MASTER CAUTION LIGHT ILLUMINATED. APU FAILED TO START CAUSING AIR TURN-BACK.SDR AALA20071369Battery Pack · dislodgedLGA - EMERGENCY LIGHT AT OVERHEAD CATWALK INOPERATIVE. RESET BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD CATWALK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071368Lamp · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 7 INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 7. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071364Strut · inoperativeAUS INFLIGHT T1560/27JUL - NOSE LANDING GEAR DID NOT RETRACT WHEN HANDLE WAS SELECTED UP. RETURNED TO AUS AND LANDED WITHOUT INCIDENT. DEFLATED STRUT COMPLETELY AND ACCOMPLISHED FULL OIL AND AIR SERVICE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASMF200707017Engine · vibrationCAPTAIN REPORTED THAT DURING TAKE OFF AND INITIAL CLIMB, LT ENGINE WITH STRONG VIBRATION. MAINTENANCE PERFORMED AN ENGINE RUN CONFIRMING VIBRATION OUT OF LIMITS, THE ENGINE WAS REPLACED IAW MPCM 71-00-02 AND OPERATIONAL TEST WAS PERFORMED IAW MPCM 71-00-01, SDR AALA20071353Duct · leakingLAS INFLIGHT T2274/25JUL - LEFT ENGINE FIRE WARNING ILLUMINATED. REDUCED NUMBER ONE ENGINE TO IDLE AND WARNING INDICATION WENT OUT. LANDED LAS WITHOUT INCIDENT. REPLACED NUMBER ONE ENGINE ON 26 JUL AT LAS DUE TO AIR DUCT LEAK AT 13TH STAGE MANIFOLD. SYSTESDR AALA20071352Battery Pack · inoperativeLGA - EMERGENCY LIGHTS FROM SEAT ROWS 20 TO AFT OF CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM SEAT ROWS 20 TO AFT OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071345Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS GALLEY OVERHEAD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS GALLEY OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071344Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT TAILCONE INOPERATIVE. REPLACED BATTERY PACK AT LEFT AFT LAVATORY OVERHEAD FOR EMERGENCY LIGHTS AT TAILCONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071338Coalescer Bag · disconnectedTUL INFLIGHT T2528/21JUL - DURING CLIMB FLIGHT ATTENDANT REPORTED ODOR AND SMOKE IN CABIN. RETURNED TO TUL AND LANDED WITHOUT INCIDENT. FOUND RIGHT COALESCER BAG OFF AND STUCK TO BOTTOM OF DUCT. REPLACED BOTH COALESCER BAGS. SYSTEM GROUND CHECKED NORMAL OPSDR AALA20071334Door · damagedDFW INFLIGHT T2055/19JUL - UNABLE TO EXTINGUISH RED NOSE GEAR LIGHT ON GEAR RETRACTION. CREW REPORTED LOUD AIR NOISE COMING FROM NOSE GEAR AREA. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPAIRED NOSE GEAR DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071326Battery Pack · looseLGA - EMERGENCY EXIT LIGHTS FROM SEAT ROWS 9B TO 11B INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY EXIT LIGHTS FROM SEAT ROWS 9B TO 11B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071325Battery Pack · inoperativeLGA - EMERGENCY EXIT LIGHTS AT SEAT ROWS 21A AND 21F INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHTS AT SEAT ROWS 21A AND 21F. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071313Bulb · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 4EF INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 4EF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071320Battery Pack · inoperativeLGA - EMERGENCY LIGHTS FROM SEAT ROWS 22 TO 26 INOPERATIVE. REPLACED BATTERY PACK AT ROW 25 OVERHEAD BIN FOR EMERGENCY LIGHTS FROM SEAT ROWS 22 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071317Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 19, 20, 21 AND 28 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 19, 20, 21, AND 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071316Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD CAT WALK INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CAT WALK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071312Duct · blownSAN INFLIGHT T237/16JUL - REPEATER DURING CLIMB TAIL COMPARTMENT TEMPERATURE WARNING LIGHT ILLUMINATED. LIGHT EXTINGUISHED AFTER NUMBER ONE ENGINE TO IDLE AND LEFT PACK TURNED OFF. RETURNED TO SAN AND LANDED WITHOUT INCIDENT. FOUND BLOWN DUCT. REPLACED DUCSDR AALA20071292Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 9D HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071291Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 8D HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071293Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 15D HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071290Lens · crackedDFW - EMERGENCY LIGHT AT LEFT FORWARD EXIT SIGN HAS CRACKED LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LEFT FORWARD EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071289Bulb · burned outDFW - EMERGENCY SLIDE FLOOD LIGHT AT MIDDLE POSITION TAIL COMPARTMENT INOPERATIVE. RELAMPED EMERGENCY SLIDE FLOOD LIGHT AT MIDDLE POSITION TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071288Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 18D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071287Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 8D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071296Lens · missingDFW - EMERGENCY LIGHT AT SEAT ROW 10D HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071298Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 14DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 14DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071297Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071295Shroud · missingDFW - EMERGENCY LIGHT AT SEAT ROW 10D HAS MISSING SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071294Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 17D HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 17D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071283Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT AFT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT AFT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071282Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD CENTER AISLE FOR EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82