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 AALA20071281Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD FORWARD MAIN ENTRY DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD FORWARD MAIN ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071280Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 23 HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 23. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071279Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 21 HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071278Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT ROW 12 HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 12. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071276Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071271Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD GALLEY CEILING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD GALLEY CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071270Wire Harness · brokenLGA - EMERGENCY LIGHTS AT AFT CATWALK INOPERATIVE. REPAIRED OVERHEAD BROKEN WIRE AT CONNECTOR FOR EMERGENCY LIGHTS AT AFT CATWALK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071265Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 20 TO 32 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 20 TO 32. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071264Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 1 TO 19 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 1 TO 19. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071263Fire Loop · faultyDFW INFLIGHT T2368/07JUL - DURING CLIMB CREW REPORTED APU FIRE WARNING INDICATION. BOTH FIRE BOTTLES WERE DISCHARGED AND AIRCRAFT RETURNED TO DFW AND LANDED WITHOUT INCIDENT. INSPECTION FOUND NO FIRE. WARNING WAS STILL ON FOR LOOP NUMBER ONE. REPLACED LEFSDR AALA20071256Battery Pack · inoperativeLGA - EMERGENCY EXIT LIGHTS AT RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHTS AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071233Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY LIGHTS AT SEATS 6B TO 7B INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT SEATS 6B TO 7B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071240Smoke Detector · inoperativeLIT - PHL TO DFW - AFT CARGO FIRE WARNING LIGHT ILLUMINATED. EMERGENCY DECLARED AND LANDED LIT WITHOUT INCIDENT. AIRCRAFT INSPECTED AND CONFIRMED NO FIRE. REPLACED CARGO COMPARTMENT SMOKE DETECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071224Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 12D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071223Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 9D HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071222Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT CEILING TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK AT B5 28 FOR EMERGENCY LIGHTS AT CEILING TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071221Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT MID CABIN CEILING INOPERATIVE. REPLACED BATTERY PACK B5 104 FOR EMERGENCY LIGHTS AT MID CABIN CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071220Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT FORWARD CABIN CEILING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071219Lens · crackedDFW - EMERGENCY LIGHT AT LEFT AFT OVERWING EMERGENCY EXIT SIGN COVER IS CRACKED. REPLACED COVER FOR EMERGENCY LIGHT AT LEFT AFT OVERWING EMERGENCY EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071226Battery Pack · inoperativeLGA - AFT OVERHEAD EMERGENCY LIGHTS AT RIGHT LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR AFT OVERHEAD EMERGENCY LIGHT AT RIGHT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071225Battery Pack · corrodedLGA - EMERGENCY LIGHTS AT BOTH OVERWING EXIT SIGNS IN AFT CABIN INOPERATIVE. CLEANED CORROSION ON BATTERY PACK FOR EMERGENCY LIGHTS AT OVERWING EXIT SIGNS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071216Battery Pack · inoperativeLGA EMERGENCY LIGHTS AT SEAT ROWS 28 TO AFT OF CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 28 TO AFT OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071215Oil System · leakingDFW - INFLIGHT T848/29JUN - CREW REPORTED SMOKE IN CABIN. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND AUXILIARY POWER UNIT (APU) LEAKING OIL. REPLACED APU ON 01 JUL 2007 AT DFW. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071204Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT SEAT ROWS 17 TO 21 INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 20 FOR EMERGENCY LIGHTS AT SEAT ROWS 17 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071202Battery 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 AALA20071201Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROW 26 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROW 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071200Battery Pack · dislodgedLGA - EMERGENCY LIGHTS AT OVERHEAD TAIL CATWALK INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHTS A OVERHEAD TAIL CATWALK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071199Battery Pack · inoperativeLGA - EMERGENCY LIGHTS IN CEILING FROM SEAT ROWS 23 TO 27 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CEILING FROM SET ROWS 23 TO 27. SYSTEM ROUND CHECKED NORMAL OPERATION.SDR AALA20071208Battery Pack · inoperativeDFW - OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 18 TO 21 INOPERATIVE. REPLACED BATTERY PACK B5 104 FOR EMERGENCY LIGHTS AT SEAT ROWS 18 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071190Wire Harness · damagedSFO - EMERGENCY LIGHT AT SEAT 23 INOPERATIVE. REPAIRED HARNESS FOR EMERGENCY LIGHT AT SEAT ROW 23. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071189Battery Pack · inoperativeSFO - EMERGENCY LIGHT AT AFT AIR STAIRS INOPERATIVE. REPLACED BATTERY PACK AT AFT SERVICE DOOR FOR EMERGENCY LIGHT AT AFT AIR STAIRS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071188Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT SEAT ROWS 21D TO 32D INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 21D TO 32D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071182Battery Pack · inoperativeLGA - EMERGENCY CEILING LIGHTS AT TAIL COMPARTMENT AFT LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY CEILING LIGHTS AT TAIL COMPARTMENT AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071159Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD ENTRY DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071154Bleed Valve · inoperativeDFW INFLIGHT T1365/25JUN AT FLIGHT LEVEL 320 WITH ENGINE AND AIRFOIL ANTI-ICE ON RIGHT ENGINE COMPRESSOR STALLED WHEN POWER WAS REDUCED TO ONE THIRD ENGINE PRESSURE RATIO FOR DESCENT. NO LIMITS EXCEEDED. LANDED DFW WITHOUT INCIDENT. REPLACED PRESSURE RATISDR AALA20071135Strap · missingLGA - EMERGENCY FLASHLIGHT AT AFT FLIGHT ATTENDANT SEAT HAS MISSING STRAPS. REPLACED STRAPS FOR EMERGENCY FLASHLIGHT AT AFT FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071136Strap · missingLGA - EMERGENCY FLASHLIGHT AT LEFT SERVICE DOOR MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT LEFT SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071133Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD AFT FLIGHT ATTENDANT JUMP SEAT INOPERATIVE. RESECURED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD AFT FLIGHT ATTENDANT JUMP SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071122Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY EXIT LIGHTS AT SEAT ROWS 20 TO 34 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY EXIT LIGHTS AT SEAT ROWS 20 TO 34. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071121Module · inoperativeLGA - OVERHEAD EMERGENCY EXIT LIGHTS AT SEAT ROWS 20 TO 34 INOPERATIVE. REPLACED MODULE FOR OVERHEAD EMERGENCY EXIT LIGHTS AT SEAT ROWS 20 TO 34 . SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071119Engine · power lossDFW INFLIGHT T1412/17JUN - DURING CLIMB HEARD THUMP AND FELT VIBRATION THROUGHOUT AIRCRAFT. RIGHT ENGINE ROLLED BACK TO IDLE. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND METAL DEBRIS IN TAIL CONE. REPLACED RIGHT ENGINE ON 18JUN2007 AT DFW. SYSTEM SDR AALA20071115Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071118Battery Pack · inoperativeLGA - OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROWS 3 TO 8 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY EXIT LIGHT AT SEAT ROWS 3 TO 8. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071106Strap · brokenLGA - EMERGENCY FLASHLIGHT AT AFT CABIN HAS BROKEN STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071100Lens · missingTPA - EMERGENCY EXIT LIGHT AFT OF FORWARD GALLEY MISSING LENS. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT LOWER AFT OF FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071104Csd · low pressureDFW INFLIGHT T1436/14JUN - RIGHT ENGINE CONSTANT SPEED DRIVE LOW OIL PRESSURE LIGHT ILLUMINATED. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED RIGHT CONSTANT SPEED DRIVE AND RIGHT GENERATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071094Light · damagedJFK - EMERGENCY EXIT LIGHT AFT OF FORWARD GALLEY DAMAGED. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AFT OF FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071089Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERWING EXIT INOPERATIVE. RESECURED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071091Bulb · burned outLGA - EMERGENCY EXIT LIGHT AT TAIL CAT WALK INOPERATIVE. RELAMPED EMERGENCY EXIT LIGHT AT TAIL CAT WALK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071090Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82