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 AALA20110128TUL06Shutoff Valve · leakingMCI - CREW REPORTED RIGHT HYDRAULIC SYSTEM QUANTITY LOSS DURING FLIGHT. ALTERNATE GEAR EXTENSION USED FOR LANDING. EMERGENCY DECLARED FLIGHT LANDED MCI WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT RUDDER SHUT-OFF VALVE THAT WAS LEAKING. SDR AALA20110125TUL01Beam · damagedAFT CARGO: CORROSION ON DOOR BEAM AND UNDER DOOR BEAM DOUBLER FROM STATION 1160 TO STATION 1212. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3 AND EA MD80-53-014964.SDR AALA20110124DFW04Unknown · smokeDFW - CREW REPORTED SMOKE THAT WAS WHITE AND ACRID IN CABIN AND COCKPIT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE.SDR AALA20110125LGA03Wire · disconnectedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 27D INOP. WIRE PULLED OUT OF CONNECTOR BELOW SEAT 27F. REPLACED PIN & SECURED CONNECTOR. OPS CHECK NORMAL.SDR AALA20110125LGA02Light · inoperativeCEILING EMERGENCY LIGHTS FROM ROWS 28 TO ROW 30 INOPERATIVE. REPLACED AND SECURED LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20110125LGA01Battery · dischargedCEILING EMERGENCY LIGHTS FROM ROW 7 TO ROW 21 INOPERATIVE. REPLACED BATTERY AT ROW 20. OPS CHECK NORMAL.SDR AALA20110124DFW05Strut · lowDFW - CREW REPORTED NOSE LANDING GEAR FAILED TO RETRACT AFTER TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. GEAR HANDLE WAS LOWERED AND NORMAL THREE GREEN WITH LANDING. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE GEAR SHORT SEALSDR EE4Y20110034Door · delaminatedLT WING T/E BUTE DOOR P/N: 5919572-512 DELAMINATED. DELAMINATED BUTE DOOR WAS REPAIRED BY LOCAL DER.SDR AALA20110123TUL01Bearing · crackedELP CREW REPORTED ON APPROACH NO DOWN AND LOCKED INDICATION WHEN GEAR SELECTED DOWN. RECYCLED GEAR, STILL NO DOWN AND LOCKED INDICATION. USED ALTERNATE GEAR DOWN AND ALL THREE GEAR INDICATED DOWN AND LOCKED. EMERGENCY DECLARED FLIGHT LANDED ELP WITHOUT INCISDR AALA20110124LGA03Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROW 23 TO ROW 30 INOPERATIVE. RE-SEATED BATTERIES IN BATT PACK AT ROW 24DEF. OPS CHECK NORMAL.SDR AALA20110124LGA02Battery · not seatedFORWARD CABIN AND FLIGHT DECK EMERGENCY LIGHTS INOPERATIVE. RE-SEATED BATTERIES IN BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110124LGA01Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110122TUL01Membrane · corrodedCORROSION FOUND BELOW T-FITTING AT STATION 218 RIGHT OUT OF LIMITS. FABRICATED AND INSTALLED SUBFLOOR DOUBLER AT STATIONS 210 TO 218 RIGHT PER AARD 53-20-00-16.SDR AALA20110126TUL10Battery Pack · dischargedAFT CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT RIGHT AFT LAVATORY.SDR AALA20110126TUL09Battery Pack · dischargedTAIL CONE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR TAIL CONE EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110126TUL08Battery Pack · dischargedCABIN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT STATION 700. OPS CHECK NORMAL.SDR AALA20110126TUL07Battery Pack · dischargedOVERWING ESCAPE DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110126TUL06Battery Pack · dischargedCABIN CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT STATION 500. OPS CHECK NORMAL.SDR AALA20110126TUL05Battery Pack · dischargedROW 13 TO 17 EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT FORWARD COACH CABIN STATION 400. OPS CHECK NORMAL.SDR AALA20110126TUL04Battery Pack · dischargedFORWARD ENTRY COCKPIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD ENTRY COCKPIT EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110122AUS01Light · inoperativeEMERGENCY LIGHT AT SEAT 23D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23D.SDR AALA20110121TUL04Frame · corrodedCARGO AFT CORROSION ON FRAME 1322 FORWARD SIDE LONGERONS 28 LEFT TO 28 RIGHT. INSTALLED NEW FRAME SECTION STATION 1322 PER AARD 51-10-00-5 AND SRM 51-30-05. INSTALLED FRAME SPLICES AT LONGERONS 25 RIGHT AND 25 LEFT PER SRM 53-03-00 FIGURE 2A SHEET 1.SDR AALA20110120LGA01Connector · disconnectedLEFT AFT CATWALK SIDEWALL EMERGENCY EGRESS LIGHTS INOPERATIVE. RECONNECTED AND SECURED CONNECTOR. OPS CHECK NORMAL.SDR AALA20110120TUL04Fitting · corrodedCARGO AFT CORROSION ON FITTING AT AFT END OF LONGERON 29 RIGHT STATIONS 1330 TO 1336. INSTALLED NEW FITTING PER EA MD80-51-014815 DATED 1-19-2011 AND AARD 51-10-00-5.SDR AALA20110120TUL03Longeron · corrodedLONGERON 29 RIGHT CORRODED AT STATION 1336. INSTALLED LONGERON SECTION AND SPLICE PER AARD 51-10-00-5 AND SRM 53-02-00.SDR EE4Y20110038Spar · damagedTHE FRONT SPARS ENGINES 1 AND 2, ENGINE MOUNTING HOLES WITH LIGHT NOTCHES.SDR AALA20110119TUL11Fitting · crackedRIGHT WING GROUND SPOILER ACTUATOR CASTING CRACKED IN RADIUS ABOVE FOWARD ACTUATOR ATTACH BOLT ON INBOARD SIDE. INSTALLED NEW SPOILER FITTING (CASTING) PER SRM 51-30-2 AND 51-30-05 AND AARD 51-10-00-5.SDR AALA20110119TUL07Pan · corrodedCORROSION ON LOWER LEG OF FOWARD CARGO DOOR PAN STATIONS 389 TO 408. INSTALLED STRAP PER EA MD80-53-014923.SDR AALA20110119TUL02Skin · crackedSTATION 1474 CRACK IN FUSELAGE SKIN, RIGHT SIDE, AFT OF ELEVATOR ACCUMULATOR ACCESS DOOR. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-30-00-02 AND SRM 53-01-00.SDR EE4Y20110032Skin · dentedFUSELAGE SKIN DENTED FROM STA Y197.25 TO STA Y200, BTWN LONG 15R AND LONG 16R. DENTED SKIN WAS REPAIRED.SDR AALA20110117DFW02Switch · faultyDFW - CREW REPORTED DURING DESCENT RIGHT HYDRAULIC PRESSURE LOW LIGHT ILLUMINATED WHEN SELECTING PUMP TO HIGH. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. INITIAL INSPECTION AT GATE SHOWED NO FLUID LOSS, QUANTITY OK. AIRCRAFT REMOVED FROM SERVICESDR AALA20110118TUL01Seat Track · corrodedSEAT TRACK NUMBER 2 CORROSION OUT OF LIMITS FROM STATIOBS 1201 TO 1205. REMOVED SECTION OF SEAT TRACK FROM STATIONS 1145 TO 1309 AND SPLICED IN NEW SECTION OF TRACK PER SRM 53-05-00, 51-30-05 AND 51-30-01.SDR AALA20110117TUL07Static Port · defectiveLEFT ALTERNATE STATIC PORT FAILED THE PORT TO SKIN MISMATCH REF AMM 34-11-01-2 1. INSTALLED ALTERNATE STATIC PORT AND CONNECTED PIPING TO PORT PER AMM 34-11-01.SDR AALA20110117LGA02Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 24D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 24D. OPS CHECK NORMAL.SDR AALA20110117LGA01Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 18 TO 21 INOPERATIVE. RE-SEATED BATTERY PACK FOR CEILING EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20110119AUS01Slide · damagedFORWARD GALLEY SERVICE DOOR SLIDE DAMAGED. REMOVED AND REPLACED SLIDE WITH SERVICEABLE SLIDE. OPS CHECK NORMAL.SDR AALA20110116LGA05Wire · brokenSEAT MOUNTED EMERGENCY LIGHTS AT ROW SEAT 27D INOPERATIVE. REPAIRED BROKEN WIRE AT SEAT ASSEMBLY ROW 27D. OPS CHECK NORMAL.SDR AALA20110116LGA04Battery Pack · not seatedAFT ACCESSORY COMPARTMENT OVERHEAD CATWALK EMERGENCY LIGHT INOPERATIVE. RE-SEATED TAIL COMPARTMENT EMERGENCY BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110116LGA03Battery Pack · not seatedLEFT AFT AND RIGHT AFT OVERWING EMERGENCY EXIT DOOR SIGNS INOPERATIVE. RE-SEATED FORWARD CABIN EMERGENCY LIGHT BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110116LGA02Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 18 TO 21 INOPERATIVE. RE-SEATED MID CABIN EMERGENCY LIGHT BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110116LGA01Connector · dirtyFIRST CLASS EMERGENCY OVERHEAD LIGHT ACROSS FROM FIRST CLASS LAVATORY INOPERATIVE. CLEANED CONNECTOR ON FIRST CLASS EMERGENCY AISLE OVERHEAD LIGHT. OPS CHECK NORMAL.SDR AALA20110114STL01Acm · seizedSTL - INFLIGHT ORD-DFW. CREW REPORTED CABIN PRESSURIZATION PROBLEMS AND FLOW LIGHT ILLUMINATED, 500 TO 600 FPM CLIMB IN CABIN. FOLLOWED QRH PROCEDURE AND CABIN CONTINUED TO CLIMB. EMERGENCY DECLARED FLIGHT DIVERTED STL LANDED WITHOUT INCIDENT. AIRCRAFT REMSDR AALA20110114TUL07Longeron · crackedLONGERON 2 RIGHT CRACKED AFT OF FRAME STATION 1418. INSTALLED LONGERON SPLICE AND FILLER PER EA MD80-53-014831 DATED 01/14/11.SDR AALA20110114TUL04Frame · crackedAFT SIDE OF FRAME STATION 1418 CRACKED AT LONGERON 2 RIGHT. INSTALLED DOUBLER PER EA MD80-53-014820.SDR AALA20110113DFW02Apu · malfunctionedDFW - CREW REPORTED AUXILIARY POWER UNIT FAILED ON TAKEOFF WITH LEFT GENERATOR ON PLACARD. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. SHUTDOWN AND RESTARTED APU, RAN APU FOR 20 MINUTES NO FAULTS NOTED. RESDR AALA20110113TUL04Cusp Web · corrodedCORROSION ON RIGHT CUSP, STATIONS 214 TO 218. REMOVED CORRODED SECTION OF CUSP AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20110113LGA02Light · inoperativeCEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT, OPS CHECK NORMAL.SDR AALA20110113LGA01Power Supply · inoperativeTAIL COMPARTMENT EMERGENCY LIGHT ABOVE CATWALK INOPERATIVE. ADJUSTED POWER SUPPLY AND OPS CHECK NORMAL.SDR AALA20110112TUL12Vane · wornRIGHT WING FLAP VANE - WORN SPOTS IN LEADING EDGE OF NUMBER 3 FLAP VANE NEAR INBOARD END OF VANE. INSTALLED DOUBLER WITH HOT BOND PER SRM 51-70-02.SDR AALA20110112TUL11Cusp Web · corrodedLEFT CUSP CORROSION OUT OF LIMITS AT STATION 666. INSTALLED CUSP DOUBLER WET AT STATION 666 LEFT SIDE AS PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82