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 AALA20072175Engine · bird ingestionORD INFLIGHT T405/09NOV - AIRCRAFT EXPERIENCED NUMBER ONE ENGINE STALLS AT APPROXIMATELY 2000 FEET DURING CLIMB. ENGINE STALLS STOPPED WHEN NUMBER ONE ENGINE AT IDLE. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. FOUND EVIDENCE OF BIRD STRIKE. REPLACED ENGISDR FX7A200700006Apu · shutdownAPU SHUT DOWN AT TOP OF DESCENT.SDR AALA20072143Light · brokenDFW - EMERGENCY EXIT SIGN LIGHT AT FORWARD GALLEY AISLE WALL AT FLOOR IS BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY EXIT SIGN LIGHT AT FORWARD GALLEY AISLE WALL AT FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072148Battery Pack · inoperativeDFW - EMERGENCY EXIT ARROW SIGN LIGHT AT AFT LEFT SERVICE DOOR INOPERATIVE. REPLACED BATTERY PACK AB54 FOR EMERGENCY EXIT ARROW SIGN LIGHT AT AFT LEFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072147Light · inoperativeDFW - SEAT MOUNTED EMERGENCY LIGHT AT FORWARD SEAT 21D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT FORWARD SEAT 21D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072150Light · brokenDFW - EMERGENCY EXIT SIGN LIGHT AT AFT STAIR DOOR BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY EXIT SIGN LIGHT AT AFT STAIR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072142Lens · brokenDFW - EMERGENCY LIGHT AT RIGHT FORWARD OVERWING EXIT SIGN HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT RIGHT FORWARD OVERWING EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072149Flashlight · inoperativeDFW - EMERGENCY FLASHLIGHT AT FORWARD CABIN INOPERATIVE. REPLACED EMERGENCY FLASHLIGHT AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072144Light · brokenDFW - EMERGENCY EXIT SIGN LIGHT FORWARD OF FORWARD SERVICE DOOR BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY EXIT SIGN LIGHT FORWARD OF FORWARD SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072146Light · inoperativeDFW - SEAT MOUNTED EMERGENCY LIGHT AT AFT SEAT 18D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT AFT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072145Light · brokenDFW - SEAT MOUNTED EMERGENCY LIGHT AT AFT SEAT 7D BROKEN. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT AFT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072120Battery Pack · inoperativeLGA - EMERGENCY OVERWING EXIT LIGHT AT SEAT ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY OVERWING EXIT LIGHT AT SEAT ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072108Apu · leakingORD INFLIGHT T1502/01NOV - WHITE SMOKE REPORTED IN CABIN WITH OIL ODOR. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED AUXILLIARY POWER UNIT (APU) DUE TO INGESTION OF OIL FROM LEAK. ACCOMPLISHED PNEUMATIC DUCT BURNOUT. SYSTEM GROUND CHECKED NORMAL OSDR AALA20072078Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK AT STATION 1338 FOR EMERGENCY LIGHTS AT OVERHEAD TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072080Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072079Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD SEAT ROW 20DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 20DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070264Skin · crackedWAVE IN FUSELAGE SKIN AFT OF LEFT NOSE GEAR DOOR HAS A CRACK IN SKIN EMINATING FROM THE RIVET HOLE AT 12 O'CLOCK. FABRICATED AND INSTALLED DOUBLER.SDR AALA20072058Inlet · contaminatedPHX INFLIGHT T1770/28OCT - FLIGHT ATTENDANTS REPORTED BLUE SMOKE OR HAZE IN CABIN AND ODOR NOTED IN COCKPIT. RETURNED TO PHX AND LANDED WITHOUT INCIDENT. FOUND OIL IN APU INLET. ACCOMPLISHED PACK BURN OUT AND REPLACED BOTH COALESCER BAGS. SYSTEM GROUND CSDR AALA20072063Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 10D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070263Wire · brokenFLOOR TRACK EMERGENCY LIGHT INOPERATIVE FROM ROW 27 AFT. FOUND SPLICE BROKEN REPLACED SPLICE.SDR AALA20072041Strap · missingLGA - EMERGENCY FLASHLIGHT AT RIGHT AFT LAVATORY HAS MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT RIGHT AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072040Battery Pack · inoperativeBOS - EMERGENCY LIGHTS AT AFT OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 21DEF FOR EMERGENCY LIGHT AT AFT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072114Wire · pinchedTUL - EMERGENCY LIGHTS IN FORWARD CABIN INOPERATIVE. REPLACED PINCHED WIRE AT FORWARD ESCAPE PATH LIGHTING PANEL FOR EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072035Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072036Strap · brokenLGA - FORWARD LOWER EMERGENCY FLASHLIGHT HAS BROKEN STRAP. REPLACED STRAP FOR FORWARD LOWER EMERGENCY FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072034Screw · missingDFW - EXTERNAL EMERGENCY EXIT LIGHT AT RIGHT HAS TWO SCREWS MISSING. REPLACED SCREWS FOR EXTERNAL EMERGENCY EXIT LIGHT AT RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072033Lamp · inoperativeDFW - EXTERNAL EMERGENCY LIGHT AT RIGHT OVERWING INOPERATIVE. REPLACED LAMP FOR EXTERNAL EMERGENCY LIGHT AT RIGHT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072032Battery Pack · inoperativeDFW - EXTERNAL EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EXTERNAL EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR 070173Longeron · corrodedFOUND LONGERON AT STA 1155 CORRODED. REMOVED AND REPLACED LONGERON P/N 5936037-501 AT STATION 1155 L-29R IAW SRM 51-30-05 AND 51-30-02.SDR 070174Frame · corrodedFRAME AT STA 1155 CORRODED. REMOVED AND REPLACED FRAME P/N 5AA9936073-9 AT STATION 1155 L27R AND 28R IAW SRM 51-30-05 AND 51-30-02.SDR AALA20072030Lamp · missingLGA - EMERGENCY LIGHT AT SEAT ROW 28D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072028Shroud · missingLGA - EMERGENCY LIGHT AT SEAT ROW 28D MISSING SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072024Slide · failedMSY - AFT GALLEY SERVICE DOOR SLIDE DISLODGED BY AIRCRAFT CLEANERS. DID NOT DEPLOY. REPLACED AFT GALLEY SERVICE DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072029Lens · missingLGA - EMERGENCY LIGHT AT SEAT ROW 28D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 28D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072027Battery · inoperativeLGA - FORWARD LOWER EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED BATTERY FOR FORWARD LOWER EMERGENCY FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072015Valve · leakingDFW INFLIGHT T417/23OCT - ON SLAT EXTENSION RIGHT HYDRAULIC LOW PRESSURE LIGHT ILLUMINATED. LOST RIGHT HYDRAULIC QUANTITY. MANUALLY EXTENDED GEAR. LANDED DFW WITHOUT INCIDENT. FOUND RESIDUE FROM RIGHT SPOILER SHUTOFF VALVE. REPLACED RIGHT SPOILER SHUTOFFSDR AALA20072007Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072006Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072005Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072003Connector · inoperativeDFW INFLIGHT T1306/21OCT - LEFT ENGINE FIRE LOOP ILLUMINATED FOLLOWED BY FIRE INDICATION. SHUT ENGINE DOWN. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. SINGLE ENGINE TIME 5 MINUTES. FOUND 2 CONNECTORS BAD ON LOWER SUPPORT DETECTOR. REPLACED NEW CONNECTOSDR AALA20071991Battery 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 AALA20071990Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 6 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 6. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071981Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 18 TO 20 INOPERATIVE. REPLACED RESET BATTERY PACK AT SEAT ROW 20 FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 18 TO 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071980Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071973Sensor · inoperativeDFW INFLIGHT T852/17OCT - NOSE GEAR WARNING DURING LANDING. PERFORMED GO AROUND AND ALL INDICATIONS NORMAL. LANDED DFW WITHOUT INCIDENT. REPLACED NOSE GEAR LOCK SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071972Flashlight · unsecureLGA - EMERGENCY FLASHLIGHT AT AFT DOOR HAS DAMAGED STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070259Smoke Detector · faultyLEFT REAR LAV SMOKE ALARM SOUNDED. REMOVED AND REPLACED AFT LEFT LAVATORY SMOKE DETECTOR.SDR AALA20071936Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 8 INOPERATIVE. REPLACED BATTERY PACK AT OVERHEAD BIN FOR EMERGENCY LIGHT AT SEAT ROW 8. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070250Battery Pack · inoperativeCEILING EMERGENCY LIGHTS AT ROWS 17-21 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK.SDR 070172Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE POWER SUPPLY BATTERY PACK. A SATISF
Back to Mcdonnell Douglas DC-9-82