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 AALA20072392Seal · inoperativeMSP INFLIGHT T1085/06DEC - NOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO MSP AND LANDED WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR SHOCK STRUT SEALS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072390Seal · brokenLGA - EMERGENCY FLASHLIGHT SECURITY SEAL AT LEFT NUMBER ONE DOOR BROKEN. REPLACED SECURITY SEAL FOR EMERGENCY FLASHLIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072389Battery 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 AALA20072388Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072391Pseu · inoperativeDFW INFLIGHT T2422/06DEC - CREW REPORTED MAIN LANDING GEAR INDICATION ON APPROACH TO DFW. TOWER CONFIRMED GEAR DOWN. LANDED DFW WITHOUT INCIDENT. REPLACED PROXIMITY SWITCH ELECTRONIC UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072384Battery Pack · inoperativeLGA - EMERGENCY LIGHT AT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072385Strut · inoperativeORD INFLIGHT T755/05DEC - NOSE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. ACCOMPLISHED NOSE STRUT REPACK AND REPLACED SCHRADER VALVE AND SERVICED WITH DRY NITROGEN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072383Connector · looseLGA - EMERGENCY LIGHTS AT SEAT ROWS 16AB TO 25AB INOPERATIVE. RESEATED CONNECTOR PLUG AT SEAT ROW 16AB FOR EMERGENCY LIGHTS AT SEAT ROWS 16AB TO 25AB. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072381Start Valve · inoperativeDFW INFLIGHT T732/04DEC - NUMBER TWO ENGINE START VALVE OPEN LIGHT ILLUMINATED. CAPTAIN SHUT DOWN NUMBER TWO ENGINE. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. SINGLE ENGINE TIME 20 MINUTES. REPLACED STARTER AND START VALVE. SYSTEM GROUND CHECKED NORMASDR AALA20072369Battery 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 AALA20072367Flashlight · inoperativeLGA - EMERGENCY FLASHLIGHT AT FORWARD ENTRY DOOR INOPERATIVE. REPLACED EMERGENCY FLASHLIGHT AT FORWARD ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072365Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072362Blades · failedDFW INFLIGHT T1382/02DEC - DURING CLIMB CREW HEARD A LOUD BANG ON LEFT SIDE OF AIRCRAFT AND NUMBER ONE ENGINE PRESSURE RATIO ROLLED BACK. REDUCED NUMBER ONE ENGINE TO IDLE. ALL INDICATIONS NORMAL AT IDLE POWER. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. SDR AALA20072361Wire · chafedPHX INFLIGHT T1658/02DEC PSP-DFW - DURING CLIMB AIRCRAFT EXPERIENCED AN UNCOMMANDED RUDDER INPUT. LANDED PHX WITHOUT INCIDENT. FOUND CHAFED WIRE FOR RIGHT POSITION SENSOR IN AFT TAIL COMPARTMENT. REPAIRED WIRE FOR RIGHT DUEL SERVO RUDDER POSITION SENSOR IN SDR AALA20072358Hose · leakingRIC INFLIGHT 1180/01DEC - RIGHT LOW HYDRAULIC PRESSURE LIGHT ILLUMINATED. RIGHT HYDRAULIC QUANTITY AND PRESSURE ZERO. LANDED RIC WITHOUT INCIDENT. FOUND HYDRAULIC PRESSURE LINE ON RIGHT WHEEL LOOSE. TIGHTENED RIGHT HYDRAULIC PRESSURE LINE AND REPLACED HYDRSDR AALA20072350Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT COCKPIT FORWARD ENTRY INOPERATIVE. REPLACED BATTERY PACK AT B5 23 FOR EMERGENCY LIGHTS AT COCKPIT FORWARD ENTRY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072348Battery Pack · dislodgedLGA - EMERGENCY LIGHTS AT LEFT NUMBER TWO DOOR AND SEAT ROW 28A INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT NUMBER TWO DOOR AND SEAT ROW 28A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072349Battery Pack · dislodgedLGA - EMERGENCY LIGHTS AT SEAT ROWS 30AC TO 32A INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 30AC TO 32A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072337Placard · tornLGA - EMERGENCY EXIT PLACARD AT AFT LEFT TAIL CONE TORN. REPLACED EMERGENCY EXIT PLACARD AT AFT LEFT TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072329Battery Pack · dislodgedLGA - EMERGENCY LIGHT AT OVERHEAD SEAT 28A INOPERATIVE. RESET BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT 28A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072328Battery · dislodgedLGA - EMERGENCY LIGHT AT OVERHEAD SEAT 11A INOPERATIVE. SECURED BATTERIES IN CHARGER B5 101 FOR EMERGENCY LIGHT AT OVERHEAD SEAT 11A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072327Battery · dislodgedLGA - EMERGENCY LIGHT AT OVERHEAD SEAT 9ABC INOPERATIVE. SECURED BATTERIES IN CHARGER B5 107 FOR EMERGENCY LIGHT AT OVERHEAD SEAT 9ABC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072325Terminal · brokenLGA - EMERGENCY LIGHTS AT TAIL CONE INOPERATIVE. REPAIRED BROKEN TERMINAL FOR EMERGENCY LIGHTS AT TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072324Battery · dislodgedLGA - EMERGENCY LIGHTS AT OVERHEAD COCKPIT INOPERATIVE. SECURED BATTERIES AT BATTERY CHARGER B5 23 FOR EMERGENCY LIGHTS AT OVERHEAD COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072330Battery Pack · dislodgedLGA - EMERGENCY LIGHT AT OVERHEAD SEAT ROW 30AC INOPERATIVE. RESEATED BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROW 30AC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072326Battery · dislodgedLGA - EMERGENCY LIGHT AT OVERHEAD SEAT 7A INOPERATIVE. SECURED BATTERIES IN CHARGER FOR EMERGENCY LIGHT AT OVERHEAD SEAT 7A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072321Slide · damagedMSP - EMERGENCY SLIDE AT LEFT NUMBER TWO DOOR HANDLE VELCRO MISSING. REPLACED SLIDE AT LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072314Battery · dislodgedLGA - EMERGENCY LIGHTS AT TAIL COMPARTMENT INOPERATIVE. RESET BATTERIES IN BATTERY PACK FOR EMERGENCY LIGHTS AT TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072313Contact · dirtyLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 28 TO 30 INOPERATIVE. CLEANED CONTACTS ON BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 28 TO 30. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072299Battery Pack · inoperativeLGA - EMERGENCY LIGHTS IN FIRST CLASS CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072277Lens · missingLGA - EMERGENCY LIGHT AT SEAT 13D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072276Lamp · missingLGA - EMERGENCY LIGHT AT SEAT 13D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072267Slide · damagedRDU - EMERGENCY EVACUATION SLIDE AT LEFT NUMBER ONE DOOR HAD INFLATION CABLE PULLED FROM PINS. REPLACED EMERGENCY EVACUATION SLIDE AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072265Fan · fodORD INFLIGHT - NUMBER ONE ENGINE LOST POWER DURING CLIMB. CREW HEARD LOUD POPS. PULLED THROTTLE TO IDLE AND LEFT NUMBER ONE ENGINE AT IDLE FOR LANDING. NUMBER ONE ENGINE PARAMETERS WERE NORMAL. LANDED ORD WITHOUT INCIDENT. REPLACED NUMBER ONE ENGINE AND ISDR AALA20072243Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT SEAT ROWS 28 TO 32 INOPERATIVE. REPLACED BATTERY PACK AND REPAIRED WIRING BETWEEN SEAT ROWS 27 AND 28 FOR INOPERATIVE EMERGENCY LIGHTS AT SEAT ROWS 28 TO 32. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072224Light · inoperativeBOS - EMERGENCY LIGHT AT SEAT 6E INOPERATIVE. REPAIRED EMERGENCY LIGHT AT SEAT 6E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA070294Smoke Detector · inoperativeRIGHT LAVATORY SMOKE DETECTOR BRIEFLY SOUNDS WITH RED LIGHT THEN TESTS NORMAL AGAIN, NO FIRE. REMOVED AND REPLACED RIGHT LAVATORY SMOKE DETECTOR.SDR AALA20072207Battery Pack · looseLGA - EMERGENCY LIGHT AT OVERHEAD SEAT ROW 8 INOPERATIVE. SECURED LOOSE BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROW 8. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072206Battery Pack · looseLGA - EMERGENCY LIGHT AT OVERHEAD FORWARD GALLEY INOPERATIVE. SECURED LOOSE BATTERY PACK FOR EMERGENCY LIGHT AT OVERHEAD FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072204Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT 13D HAD DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072203Lens · missingDFW - EMERGENCY LIGHT AT SEAT 11D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072202Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 11D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072201Connector · defectiveDFW - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. REPLACED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072200Connector · defectiveDFW - EMERGENCY LIGHT AT SEAT 8D INOPERATIVE. REPLACED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072198Compressor · stalledLAX INFLIGHT T458/13NOV - AIRCRAFT RETURNED TO LAX DUE TO NUMBER ONE ENGINE COMPRESSOR STALLS. NUMBER ONE ENGINE REDUCED TO IDLE. OIL TEMPERATURE WAS IN YELLOW BAND. LANDED LAX WITHOUT INCIDENT. REPLACED NUMBER ONE ENGINE ON 13 NOV AT LAX. REPLACED LEFT ESDR AALA20072193Guard · damagedDFW - EMERGENCY LIGHT AT SEAT 17D LENS GUARD DAMAGED. REPLACED LENS GUARD FOR EMERGENCY LIGHT AT SEAT 17D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072190Engine · making metalIAD INFLIGHT T731/12NOV LGA TO DFW. NUMBER TWO ENGINE LOST OIL PRESSURE. NUMBER TWO ENGINE OIL INDICATION ILLUMINATED. REDUCED POWER AND OIL TEMPERATURE DROPPED. SHUT DOWN NUMBER TWO ENGINE. LANDED IAD WITHOUT INCIDENT. SINGLE ENGINE TIME 12 TO 15 MINUTESDR ASMF200711003Blade · damagedDURING TRANSIT CHECK, FIVE BLADES WERE DETECTED DAMAGED DUE TO A FOD IN LT ENGINE. (4) BLADES WERE DETECTED WITH NICKS ON BLADES LEADING EDGE AND WERE REWORKED IAW MM 72-33-21 BEING WITHIN LIMITS. ONE BLADE WAS DETECTED WITH DENT WITH DEPTH OF 0.135 INCHES ANDSDR AALA20072184Cable · damagedMCI INFLIGHT T2406 - LANDING GEAR WOULD NOT RETRACT. RETRACT HANDLE WOULD NOT RETURN TO RETRACT POSITION. RETURNED TO MCI AND LANDED WITHOUT INCIDENT. REPLACED DAMAGED ANTI-MAGNETIC CABLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072187Indicator · faultyORD INFLIGHT T2045/11NOV - RED NOSE GEAR UNSAFE LIGHT ILLUMINATED DURING CLIMB. CYCLED GEAR AND RED NOSE GEAR LIGHT REMAINED ILLUMINATED WITH GEAR DOWN. SECONDARY GEAR INDICATOR WAS NORMAL. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED INDICATOR D1
Back to Mcdonnell Douglas DC-9-82