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 AALA20050520Charger · inoperativeDFW - COCKPIT AND FORWARD GALLEY CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY FOR COCKPIT AND FORWARD GALLEY CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050521Charger · inoperativeDFW - CEILING EMERGENCY LIGHTS ABOVE AFT STAIR DOOR INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY FOR CEILING EMERGENCY LIGHTS ABOVE AFT STAIR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050513Brake · overheatedPIT - ABORTED TAKEOFF DUE TO RIGHT HAND COMPRESSOR STALL. UPON ABORT BRAKES OVERHEATED AND TIRE LOST PRESSURE. REPLACED TIRES AND BRAKES. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASAA0580453Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE SKIN IS DENTED. COLD-WORKED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580452Skin · canningOKC - DURING C-CHECK, FOUND FUSELAGE SKIN IS `OIL CANNED`. REMOVED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580451Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE SKIN DENTED. COLD-WORKED DENT. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580450Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE SKIN DENTED. COLD WORKED DENT. INSTALLED REPAIR DOUBLER. (M)SDR ASA0580449Web · corrodedOKC - DURING C-CHECK, FOUND AFT CARGO BAY THRESHOLD WEB CORRODED. REPLACED WEB. (M)SDR ASAA0580448Clip · corrodedOKC - DURING C-CHECK, FOUND CARGO TRACK-TO-FRAME TIE DOWN CLIP CORRODED. REPLACED CLIP. (M)SDR ASAA0580447Support · corrodedOKC - DURING C-CHECK, FOUND SUPPORT STRAP CORRODED. REPLACED STRAP. (M)SDR ASAA0580446Floor Support · corrodedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL SUPPORT CORRODED. REPLACED SUPPORT. (M)SDR ASAA0580445Floor Support · corrodedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL SUPPORT CORRODED. REPLACED SUPPORT. (M)SDR ASAA0580444Floor Support · corrodedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL SUPPORT FITTING CORRODED AND CRACKED. REPLACED SUPPORT FITTING. (M)SDR ASAA0580443Floor Support · corrodedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL SUPPORT CORRODED. REPLACED SUPPORT. (M)SDR ASAA0580463Support Beam · corrodedOKC - DURING C-CHECK, FOUND AFT CARGO BAY DOOR SUPPORT BEAM CORRODED. REPLACED BEAM. (M)SDR ASAA0580462Skin · damagedOKC - FOUND DURING C-CHECK, LEFT WING OUTBOARD FLAP T/E OUTER SECTION DAMAGED, DENTED. BOND REPAIRED. (M)SDR ASAA0580461Attach Angle · corrodedOKC - DURING C-CHECK, FOUND AFT CARGO BAY FRAME ATTACH ANGLE CORRODED. REPLACED ATTACH ANGLE. (M)SDR ASAA0580460Spacer · corrodedOKC - DURING C-CHECK, MID CARGO BAY DOOR SILL JAMB BEAM DOUBLER, SPACER, CORRODED. REPLACED SPACER. (M)SDR ASAA0580459Vane · gougedOKC - DURING C-CHECK, FOUND LEFT INBOARD FLAP VANE GOUGED. REMOVED DAMAGED AREA. INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR ASAA0580458Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE SKIN IS DENTED. REMOVED DAMAGED AREA. INSTALLED REPAIR DOUBLER AND STRAPS. (M)SDR ASAA0580457Skin · dentedOKC - FOUND DURING C-CHECK, FUSELAGE SKIN IS DENTED. COLD-WORKED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580456Skin · dentedOKC - FOUND DURING C-CHECK, FUSELAGE SKIN IS DENTED. COLD-WORKED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580455Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE SKIN IS DENTED. COLD-WORKED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580454Skin · dentedOKC - FOUND FUSELAGE SKIN IS DENTED. RECON TOURED DAMAGED AREA. INSTALLED REPAIR DOUBLER. (M)SDR AALA20050510Wire · brokenDTW - EMERGENCY LIGHTS ON SEAT 21DEF INOPERATIVE. REPAIRED BROKEN WIRE UNDER SEAT FOR EMERGENCY LIGHTS ON SEAT 21DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050509Battery Pack · inoperativeDTW - EMERGENCY LIGHTS AT FORWARD OVERHEAD GALLEY AND IN COACH INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD OVERHEAD GALLEY AND IN COACH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASAA0580429Intercostal · corrodedOKC - DURING C-CHECK, FOUND INTERCOSTAL CORRODED. REPLACED INTERCOSTAL. (M)SDR ASAA0580442Longeron · corrodedOKC - DURING C-CHECK, FOUND LONGERON CORRODED. REPLACED DAMAGED SECTION. (M)SDR ASAA0580441Angle · corrodedOKC - FOUND DURING C-CHECK, T-ANGLE CHORD ON SUPPORT BEAM CORRODED. REPLAED T-ANGLE. (M)SDR ASAA0580440Intercostal · corrodedOKC - DURING C-CHECK, INTERCOSTAL CORRODED. REPLACED INTERCOSTAL. (M)SDR ASAA0580439Frame · corrodedOKC - DURING C-CHECK, FOUND FRAME CORRODED. REPLACED DAMAGED FRAME SECTION. (M)SDR ASAA0580438Shear Tie · corrodedOKC - DURING C-CHECK, FOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE. (M)SDR ASAA0580437Longeron · corrodedOKC - DURING C-CHECK, FOUND LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR CHANNEL. (M)SDR ASAA0580436Intercostal · corrodedOKC - DURING C-CHECK, FOUND INTERCOSTAL CORRODED. REPLACED INTERCOSTAL. (M)SDR ASAA0580435Longeron · corrodedOKC - FOUND DURING C-CHECK, LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR CHANNEL. (M)SDR ASAA0580434Longeron · corrodedOKC - DURING C-CHECK INSPECTION, FOUND LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR CHANNEL. (M)SDR ASAA0580433Longeron · corrodedOKC - DURING C-CHECK, FOUND LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR FILLER STRAP AND SHIM. (M)SDR ASAA0580432Longeron · corrodedOKC - DURING C-CHECK, FOUND LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR CHANNEL. (M)SDR ASAA0580431Longeron · corrodedOKC - DURING C-CHECK, FOUND LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR CHANNEL. (M)SDR ASAA0580430Intercostal · corrodedOKC - DURING C-CHECK, FOUND INTERCOSTAL CORRODED. REPLACED INTERCOSTAL. (M)SDR AALA20050507Battery Pack · inoperativeSAT - AFT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ON OVERHEAD BIN AFT SECTION FOR AFT OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050506Battery Pack · inoperativeBOS - EMERGENCY LIGHT AT FORWARD LEFT NUMBER 1 DOOR AND AISLE WAY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD LEFT NUMBER 1 DOOR AND AISLE WAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050504Strut · lack of lubeORD - INFLIGHT AFTER TAKEOFF NOSE WHEEL WOULD NOT RETRACT. PERFORMED FULL NOSE STRUT SERVICE AND LUBED NOSE GEAR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050522Schrader Valve · inoperativeDFW - NOSE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. FOUND NOSE LANDING GEAR STRUT FLAT. REPLACED SCHRADER VALVE AND SEALS AND RESERVICED STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050502Connector · looseDFW - EMERGENCY LIGHT AT SEAT 12D INOPERATIVE. RESECURED CONNECTOR UNDER SEAT FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050501Light · inoperativeLGA - EMERGENCY DOOR EXIT LIGHT AT RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050500Engine · shutdownDFW - INFLIGHT LEFT ENGINE FAILED DURING DESCENT. N1 AND N2 CONTINUED TO WINDMILL. EXHAUST GAS TEMPERATURE OVER 800 DEGREES. TIME ON SINGLE ENGINE APPROXIMATELY 10 MINUTES. LANDED WITHOUT INCIDENT. REPLACED LEFT ENGINE. SYSTEM GROUND CHECKED NORMAL OPERASDR AALA20050496Battery Pack · inoperativeDTW - EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK AND CHARGER ASSEMBLY FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050495Valve · inoperativeDFW - INFLIGHT NOSE LANDING GEAR DID NOT RETRACT AFTER TAKEOFF. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED LANDING GEAR CONTROL VALVE AND ACCOMPLISHED NOSE GEAR STRUT REPACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050497Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT CABIN SEAT INOPERATIVE. REPLACED MID AND AFT AND FORWARD BATTERY PACKS FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82