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 AALA20071662Battery Pack · corrodedLGA - EMERGENCY LIGHTS AT TAIL CONE INOPERATIVE. CLEANED CORROSION ON BATTERY PACK FOR EMERGENCY LIGHTS AT TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071661Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROW 25DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROW 25DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071660Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071655Lens · missingTPA - EMERGENCY LIGHT AT SEAT 9D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071654Bulb · inoperativeTPA - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071653Bulb · inoperativeTPA - EMERGENCY LIGHT AT SEAT 8D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071656Lens · missingTPA - EMERGENCY LIGHT AT SEAT 8D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071648Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR 070165Structure · crackedHORIZONTAL STABILIZER LEFT SIDE CRACKED AT REAR UPPER INBOARD SIDE BETWEEN UPPER AND LOWER BOLTS AT STATION XH8.50. HORIZONTAL STABILIZER SENT TO VENDOR FOR REPAIR. REPAIRED IAW ESO 80559 AND BOEING DRAWING 5R09550027. HORIZONTAL STABILIZER OK FOR CONTINUEDSDR AALA20071642Blades · damagedSJC INFLIGHT T2426/29AUG - BIRD STRIKE ON NUMBER TWO ENGINE DURING CLIMB. CREW REPORTED ODOR AFTER BIRD STRIKE. RETURNED TO SJC AND LANDED WITHOUT INCIDENT. AIRCRAFT TAKEN OUT OF SERVICE. FOUND TWO FAN BLADES WITH MINOR DAMAGE. BLENDED BLADES. SYSTEM GRSDR 070164Skin · gougedAFT CARGO DOOR HAS A GOUGE BELOW DOOR HANDLE. ORIGINAL SKIN THICKNESS .050". REMOVED .011", OUT OF LIMITS PER SRM 53-04 FIG 38. AREA MEASURES 2.7" BY 1.7" BY .011". FABRICATED INTERNAL REPAIR DOUBLER 2024 T3, .032". CARGO DOOR OK FOR CONTINUED SERVICE.SDR AALA20071633Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD MAIN ENTRY DOOR TO SEAT ROW 3 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD MAIN ENTRY DOOR TO SEAT ROW 3. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071632Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 6 TO 10 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 6 TO 10. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071631Battery Pack · inoperativeLGA - EMERGENCY LIGHTS IN COCKPIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071630Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT LAVATORY CEILING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT LAVATORY CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071628Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT TAIL CONE INOPERATIVE. REPLACED BATTERY PACK AT AFT LAVATORY OVERHEAD FOR EMERGENCY LIGHTS AT TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071619Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD GALLEY OVERHEAD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD GALLEY OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071610Valve · inoperativeSAT INFLIGHT T304/23AUG - LANDING GEAR WOULD NOT RETRACT. RETURNED TO SAT AND LANDED WITHOUT INCIDENT. FOUND GEAR DOOR BYPASS LEVER OPEN. REPAIRED VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071599Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 29DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 29DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071597Engine · making metalBNA INFLIGHT T1531/21AUG - NUMBER ONE ENGINE OIL CLOG LIGHT ILLUMINATED DURING CLIMB. REDUCED NUMBER ONE ENGINE TO IDLE AND RETURNED TO BNA AND LANDED WITHOUT INCIDENT. FOUND METAL IN OIL FILTERS. REPLACED NUMBER ONE ENGINE ON 22 AUG AT BNA. SYSTEM GROUNDSDR 070163Skin · gougedAFT CARGO PIT DOOR HAS GOUGE ON 3RD STRINGER FROM BOTTOM OF DOOR. ORIGINAL SKIN THICKNESS .050". REMOVED .015" OUT OF LIMITS PER SRM 53-04 FIG 38. AREA MEASURES 2" BY 1" BY .015. FABRICATED INTERNAL REPAIR DOUBLER 2024 T3 .032". DOOR SKIN OK FOR CONTINUEDSDR AALA20071593Terminal · dirtySFO - EMERGENCY LIGHTS AT LEFT AND RIGHT FORWARD OVERWING EXIT INOPERATIVE. CLEANED BATTERY TERMINALS FOR EMERGENCY LIGHTS AT LEFT AND RIGHT FORWARD OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071589Lamp · inoperativeATL - EMERGENCY LIGHT AT COCKPIT OVERHEAD PANEL INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT COCKPIT OVERHEAD PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071585Terminal · dirtySFO - EMERGENCY LIGHT AT RIGHT OVERWING EXIT INOPERATIVE. CLEANED BATTERY PACK TERMINAL AT 21D FOR EMERGENCY LIGHT RIGHT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071584Terminal · dirtySFO - EMERGENCY LIGHT AT LEFT OVERWING EXIT INOPERATIVE. CLEANED BATTERY PACK TERMINAL AT SEAT 21D FOR EMERGENCY LIGHT AT LEFT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071574Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 13 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071573Battery Pack · inoperativeLGA - EMERGENCY LIGHT PASSENGER ENTRY DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT PASSENGER ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071548Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT AFT STAIRS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT STAIRS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071547Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT LEFT AND RIGHT OVERWING FORWARD EMERGENCY EXIT INOPERATIVE. REPLACED BATTERY PACK B5103 FOR EMERGENCY LIGHT AT LEFT AND RIGHT FORWARD OVERWING EMERGENCY EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071549Bulb · inoperativeSFO - EMERGENCY LIGHT AT FORWARD OVERHEAD TAIL COMPARTMENT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD OVERHEAD TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071543Hook And Loop · inoperativeMSP - EMERGENCY DOOR SLIDE AT LEFT NUMBER TWO DOOR GIRT BAR HOOK AND LOOP INOPERATIVE. REPLACED EMERGENCY DOOR SLIDE AT LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071535Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY CEILING FOR EMERGENCY LIGHT AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071545Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT SEAT ROW INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT AFT SEAT ROW. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071527Valve · inoperativeORD INFLIGHT T1189/13AUG CREW REPORTED UNABLE TO MAINTAIN CABIN PRESSURE. DESCENDED BELOW 10000 FEET. LANDED ORD WITHOUT INCIDENT. REPLACED RIGHT HAND FLOW CONTROL VALVE AND LEFT AIR CYCLE MACHINE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071530Slide · damagedMSP - EMERGENCY SLIDE GIRT BAR VELCRO INOPERATIVE AND MANUAL DEPLOY HANDLE RING CORRODED AT RIGHT NUMBER ONE DOOR. REPLACED EMERGENCY SLIDE AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071505Circuit Breaker · trippedDFW INFLIGHT T2334/12AUG - CREW REPORTED UNABLE TO GET FUEL FLOW FROM CENTER TANK. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND CENTER TANK FUEL PUMP CIRCUIT BREAKER POPPED. RESET CENTER TANK FUEL PUMP CIRCUIT BREAKER. SYSTEM GROUND CHECKED NORMAL OPSDR AALA20071514Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 28D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071513Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT ROW 20D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 20D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071517Bulb · inoperativeDFW - EMERGENCY EXIT SIGN LIGHT AT FORWARD LEFT OVERWING INOPERATIVE. REPLACED FORWARD LAMP FOR EMERGENCY EXIT SIGN LIGHT AT FORWARD LEFT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071518Battery Pack · inoperativeDFW - EMERGENCY LIGHT AT EXTERIOR OVERWING INOPERATIVE. REPLACED BATTERY PACK B5 49 FOR EMERGENCY LIGHT AT EXTERIOR OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071512Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT ROW 18D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071516Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 19D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071511Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT ROW 16D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071510Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT ROW 8D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071515Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 24D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 24D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071496Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT FORWARD CABIN CEILING FLIGHT DECK, FORWARD ENTRY AND GALLEY INOPERATIVE. REPLACED BATTERY PACK B5 23 FOR EMERGENCY LIGHTS AT FORWARD CABIN CEILING FLIGHT DECK, FORWARD ENTRY AND GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071494Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT ROW 18D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071495Light · inoperativeDFW - PORTABLE EMERGENCY LIGHT AT FORWARD CABIN IS INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071500Bulb · inoperativeDFW - EMERGENCY LIGHT AT OVERHEAD SEAT ROW 13AB IS INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROW 13AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071499Bulb · inoperativeDFW - EMERGENCY LIGHT AT OVERHEAD SEAT ROW 12AB IS INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROW 12AB. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82