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 AALA200800237Strut · inoperativeORD INFLIGHT T2481/02FEB - NOSE GEAR UNSAFE LIGHT ILLUMINATED AFTER NOSE GEAR RETRACTION. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. ACCOMPLISHED NOSE GEAR SHOCK STRUT SEAL REPLACEMENT AND REPLACED TURNING TUBE CYLINDER AND LOWER BEARING ASSEMBLY. SYSTEM SDR AALA200800236Strut · inoperativeORD INFLIGHT T1545/02FEB - NOSE GEAR UNSAFE LIGHT ILLUMINATED AFTER NOSE GEAR RETRACTION. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPACKED NOSE STRUT ASSEMBLY AND REPLACED LOWER TURNING TUBE BEARING ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800235Strut · inoperativeORD INFLIGHT T1145/02FEB - NOSE GEAR UNSAFE LIGHT ILLUMINATED AFTER NOSE GEAR RETRACTION. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPACKED NOSE STRUT ASSEMBLY AND REPLACED METERING PIN SEALS AND LOWER TURNING TUBE BEARING. SYSTEM GROUND CHECKED NORMAL SDR AALA200800222Battery Pack · inoperativeLGA - EMERGENCY LIGHT BATTERY PACK AT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800223Battery Pack · inoperativeLGA - EMERGENCY LIGHT BATTERY PACK AT SEAT ROW 8 WEAK. REPLACED BATTERY PACK AT SEAT ROW 8 CEILING FOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800199Lamp · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD SEAT 16D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800191Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA080016Support · corrodedCORROSION AROUND BOLT HOLE ALONG ENTIRE LENGTH OF AFT CARGO DOOR THRESHOLD PLATE SUPPORT STRUCTURE. FABRICATED AND INSTALLED SPACERS.SDR AALA200800188Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800187Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800182Actuator · brokenSTL INFLIGHT T1295/27JAN - AFTER LANDING GEAR RETRACTION CREW REPORT MODERATE VIBRATION. RETURNED TO STL AND LANDED WITHOUT INCIDENT. FOUND RIGHT NOSE GEAR DOOR ACTUATOR ATTACH FORK BROKEN AND FOLLOW UP ROD END BRACKET. REPLACED RIGHT FORWARD DOOR, DOOR LINSDR AALA200800173Schrader Valve · inoperativeRSW INFLIGHT T1093/26JAN - CREW REPORTED NOSE GEAR RED LIGHT AFTER RETRACTION. RETURNED TO RSW AND LANDED WITHOUT INCIDENT. ACCOMPLISHED NOSE LANDING GEAR STRUT REPACK AND REPLACED SCHRADER VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800174Strut · inoperativeSTL INFLIGHT T1605/26JAN - NOSE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO STL AND LANDED WITHOUT INCIDENT. ACCOMPLISHED STRUT REPACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800166Slide · failedSAN - EMERGENCY ESCAPE SLIDE AT R1 DOOR UNSUCCESSFULLY DEPLOYED. SLIDE WAS HANGING FROM GIRT BAR AT DOOR FRAME. REPLACED RIGHT NUMBER ONE DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA080017Generator · faultyCAPTAIN HAD FLICKERING ELECTRICAL COMPONENTS AND ON THE FIRST OFFICER'S SIDE LOST AP. REMOVED AND REPLACED AC GENERATOR.SDR AALA200800162Seal · inoperativeTUS INFLIGHT T1418/24JAN - NOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO TUS AND LANDED WITHOUT INCIDENT. ACCOMPLISHED NOSE GEAR SHOCK STRUT SEAL REPLACEMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800165Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 20 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 20 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800164Battery Pack · inoperativeLGA EMERGENCY LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK AT FOWARD SEAT ROW 20 FOR EMERGENCY LIGHTS AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800163Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROW 13 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROW 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800137A/C Pack · smokeMSP INFLIGHT T1037/23JAN - VERY LIGHT SMOKE STARTED TO FLOW THROUGH CABIN. SHUT DOWN RIGHT AIR CONDITIONING PACK AND SMOKE DISSIPATED. CONTINUED TO MSP AND LANDED WITHOUT INCIDENT. ACCOMPLISHED PACK BURN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA080014Skin · corrodedAFT LAVATORY SERVICE PANEL, BOX AND FUSELAGE SKIN SEPARATED AND CORROSION LEVEL 1 FOUND IN BETWEEN AT FORWARD LOWER CORNER. CUT OUT DAMAGE AND FABRICATED AND INSTALLED DOUBLER.SDR AALA200800089Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 26 TO 29 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 26 TO 29. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800090Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 14 TO 17 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 14 TO 17. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA080011Cusp Web · corrodedAFT CARGO COMPARTMENT HAS CORROSION ON BOTTOM OF CUSP MEMBRANE AT DOME NUT JUST AFT OF FRAME STATION 1174L. FABRICATED AND INSTALLED DOUBLER.SDR AALA200800083Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 22 TO 24 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 22 TO 24. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800084Flashlight · inoperativeLGA - EMERGENCY FLASHLIGHT IN FIRST CLASS INOPERATIVE. REPLACED EMERGENCY FLASHLIGHT IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800065Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERWING EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800063Strut · inoperativeSTL INFLIGHT T1186/14JAN - NOSE GEAR FAILED TO RETRACT AFTER TAKEOFF. RETURNED TO STL AND LANDED WITHOUT INCIDENT. REPACKED NOSE LANDING GEAR STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800058Flashlight · inoperativeLGA - EMERGENCY FLASHLIGHT AT AFT GALLEY CHARGE LIGHT INOPERATIVE. REPLACED EMERGENCY FLASHLIGHT AT AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800057Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 25DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 25DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800056Wire · damagedBOS - EMERGENCY LIGHT AT SEAT ROWS 20 TO AFT CABIN. REPAIRED WIRE FOR EMERGENCY LIGHT AT SEAT ROWS 20 TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800051Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT SEAT ROWS 28 TO AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 28 TO AFT OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA080008Proximity Sensor · defectiveTHE NOSE LANDING GEAR UNSAFE LIGHT ILLUMINATED. REMOVED AND REPLACED PROXIMITY SENSOR.SDR AALA200800046Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD SEAT ROWS 14 TO 19 INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 14DEF FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROWS 14 TO 19. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800044Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT FORWARD GALLEY CEILING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT A FORWARD GALLEY CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800043Battery · looseLGA - EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS CABIN INOPERATIVE. SECURED BATTERIES FOR EMERGENCY LIGHTS AT OVERHEAD FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800034Lens · missingLGA - EMERGENCY LIGHT AT OVERHEAD AFT LAVATORY MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800032Flashlight · inoperativeDFW - EMERGENCY FLASHLIGHT AT FIRST CLASS FLIGHT ATTENDANT STATION INOPERATIVE. REPLACED FLASHLIGHT AT FIRST CLASS FLIGHT ATTENDANT STATION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800027Battery 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 AALA200800029Strap · brokenLGA - EMERGENCY FLASHLIGHT AT AFT RIGHT AFT POSITION HAS BROKEN STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT RIGHT AFT POSITION.SDR AALA200800028Strap · missingLGA - EMERGENCY FLASHLIGHT AT AFT RIGHT FORWARD POSITION MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT RIGHT FORWARD POSITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800026Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT MID TO AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT MID TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800023Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT FIRST CLASS ENTRY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FIRST CLASS ENTRY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072569Strut · dischargedORD INFLIGHT T1447/21DEC - AFTER TAKEOFF, NOSE LANDING GEAR WOULD NOT RETRACT. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. FOUND STRUT FLAT. PERFORMED STRUT REPACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072564Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT AFT LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072563Battery 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 AALA20072562Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072561Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 13 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072560Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 25DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT ROW 25DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072559Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82