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 AALA20150115015Stiffener · crackedCRACKED STIFFENER ABOVE AFT BULKHEAD DOOR STATION 1338. REMOVED DAMAGED STIFFENER & INSTALLED NEW STIFFENER IAW SRM 51-30-05, SRM 51-60-00 5 B & AMM 20-15-2.SDR AALA20150113006Cusp Web · damagedDAMAGE TO AFT LOWER RT CUSP AT FS 237. INSTALLED REPAIR DOUBLER IAW AARD 53-20-00-16.SDR AALA20150105010Skin · puncturedRIGHT WING INBD FLAP LOWER SKIN PUNCTURED AT INBD END. REPAIRED SKIN IAW SRM 57-03-00 FIG 8.SDR AALA20150106014Seat Track · corrodedSEAT TRACK NR 6, FROM FS 403 TO 406, IS CORRODED OUT OF LIMITS IAW SRM 53-05-00 FIGURE 4B-1. ACCOMPLISHED SEAT TRACK PLUG REPAIR IAW AARD 53-20-00-10 & SRM 53-05 FIGURE 4A.SDR AALA20150106013Seat Track · corrodedSEAT TRACK NR 6, FROM FS 362 TO 367, IS CORRODED OUT OF LIMITS IAW SRM 53-05-00 FIGURE 4B-1. ACCOMPLISHED SEAT TRACK PLUG REPAIR IAW AARD 53-20-00-10 & SRM 53-05 FIGURE 4A.SDR AALA20150106012Seat Track · corrodedSEAT TRACK NR 6, FROM FS 322 TO 326, IS CORRODED OUT OF LIMITS IAW SRM 53-05-00 FIGURE 4B-1. ACCOMPLISHED SEAT TRACK PLUG REPAIR IAW AARD 53-20-00-10 & SRM 53-05 FIGURE 4A.SDR AALA20150106011Seat Track · corrodedSEAT TRACK NR 6, FROM FS 304 TO 306, IS CORRODED OUT OF LIMITS IAW SRM 53-05-00 FIGURE 4B-1. ACCOMPLISHED SEAT TRACK PLUG REPAIR IAW AARD 53-20-00-10 & SRM 53-05 FIGURE 4A.SDR AALA20150105001Control Box · faultedEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH WITH LG SELECTED DOWN LT OTBD ANTI-SKID LIGHT ILLUMINATED. AFTER GO AROUND LIGHT ILLUMINATED AGAIN. QRH PROCEDURE FOLLOWED. FLAPS 40 LANDING. PERFORMED ANTI-SKID SYS TROUBLESHOOTSDR AALA20150104010Stiffener · crackedVERTICAL STIFFENER AT FS 218 BETWEEN LONGERONS 24 LT & 23 LT IS CRACKED. REPAIRED STRUT IAW AARD 53-10-00-15.SDR AALA20150104009Longeron · crackedLONGERON 25 LT IS CRACKED AT FS 160. REPAIRED LONGERON IAW SRM 53-02-00.SDR AALA20150104008Frame Splice · gougedFUSELAGE FRAME SPLICE AT STATION 200 & LONGERON 23 LT HAS GOUGE. R & R SPLICE IAW AARD 51-00-05-1, DWG 9911518 & SRM 51-30-05.SDR AALA20150104007Longeron · crackedLONGERON 24 LT IS CRACKED BETWEEN FS 160 & 200. REPAIRED LONGERON IAW SRM 53-02-00 FIG 18.SDR AALA20141231003Bayonet · damagedACFT WOULD NOT PRESSURIZE. NO EMERGENCY DECLARED, RETURNED TO DEPARTURE. FOUND THE L2 DOOR BAYONET & BAYONET RECEIVER ON FRAME BENT & DAMAGED PREVENTING THE DOOR FROM SECURING PROPERLY. REMOVED AND REPLACED BAYONET RECEIVER AND RIGGED IAW AMM 52-40-00.SDR AALA20141230010Skin · damagedSEVERE LIGHTNING STRIKE STATIC BURNS ON FS SKIN AT STATION 345 BETWEEN LONGERON 26R & 27R IS OUT OF LIMITS. REMOVED DAMAGE & INSTALLED REPAIR DOUBLE IAW SRM 53-04-03.SDR AALA20141230005Power Supply · inoperativeEMERGENCY LIGHTS IN AFT OF CABIN WONT TEST. REPLACED POWER SUPPLY B5-27.SDR AALA20141224010Wire · damagedTAIL COMPARTMENT EMER LIGHT, OVERHEAD CATWALK AREA INOPERATIVE. RE-TERMINATED WIRE.SDR AALA20141224006Frame · crackedCRACK IN CANTED FRAME 1463 LONGERON 18L, STOP DRILLED & INSTALLED DOUBLER IAW SRM 53-01-00-001 FIGURE 2 SHEET 4.SDR AALA20141224002Line · failedDURING CLIMB OUT CREW NOTED THAT THE CTR FUEL TANK WAS NOT FEEDING. FOLLOWED QRH PROCEDURES & DISCOVERED THAT TURNING OFF EITHER RT OR LT MAIN TANK BOOST PUMPS, & CTR PUMP SWITCHES ON, THAT LOW PRESSURE LIGHT CAME ON TURNED OFF CTR PUMPS IAW PROCEDURE. DIVERSDR AALA20141224005Warning System · activatedCENTER TANK LOW PRESS CAME DURING CLIMB OUT. TROUBLESHOOTING THE CTR TANK FUEL SYS.SDR AALA20141223014Shear Tie · crackedSHEAR TIE CRACKED IN RADIUS, FWD SIDE OF STATION 1380 ABOVE LONGERON 14 RT. INSTALLED DOUBLER REPAIR IAW AARD 53-10-00-20.
SDR 2WAA20141222001Socket · damagedDURING DESCENT, AFT ROW 20 ELECTRICAL ODOR. INSPECTED AREA FOUND LAMP HOLDER DAMAGED. R & R HOLDER IAW AMM 33-21-03. OPS CHECKED NORMAL IAW AMM 33-21-03, NO DEFECTS NOTED.SDR AALA20141219002Switch · dirtyEMERGENCY DECLARED & LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING CRUISE LT ENG REVERSE UNLOCK LIGHT ILLUMINATED. ACCOMPLISHED QRH PROCEDURE & LIGHT REMAINED ON. LIGHT EXTINGUISHED ABOUT 20 MINUTES LATER WHILE ON DECENT. NO OTHER INDICATIONS. CLEANED LSDR AALA20141213004Pressure Switch · defectiveAIR INTERRUPT, DIVERTED & EMER DECLARED & LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING CRUISE, LT ENG OIL FILTER BYPASS LIGHT ILLUMINATED. R & R LT ENG OIL FILTER DIFFERENTIAL PRESS SWITCH ASSEMBLY IAW AMM 79-35-01-201. PERFORMED OPERATION & LEAK CHECK.SDR AALA20141212002Battery Pack · dischargedAFT EMER PATH LIGHTS FAILED TEST ON MCM 5403. R & R AFT BATTERY PACK FOR EMER PATH LIGHTS. SYS CHECKED NORMAL.SDR AALA20141211015Fuel Control · defectiveRIGHT ENG WOULD NOT MAKE TAKEOFF POWER, ABORTED TAKEOFF. R & R RT ENG FUEL CONTROL IAW MCM 73-91-99, MCM 71-91-17 & MCM 71-91-73. PERFORMED ENG RUN & LEAK CHECK. SYS CHECKED NORMAL.SDR AALA20141210016Casting · crackedLEFT GND SPOILER ACTUATOR CASTING IS CRACKED AT INBD FWD AREA. R & R CASTING IAW SRM 51-01-00-001 4B.SDR AALA20141211001Light · missingSEAT 22D EMER LIGHT ASSEMBLY IS MISSING. INSTALLED NEW LIGHT ASSEMBLY IAW AMM 33-60-98-401 & PERFORMED CHECK IAW AMM 33-60-98-501. SYS CHECKED NORMAL.SDR AALA20141208020Battery Pack · dischargedOVERHEAD EMER LIGHTS AT SEAT ROW 9 DO NOT GO OUT WHEN POWER IS REMOVED. R & R EMER BATTERY PACK B5-101 IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20141207010Engine · failedAIR INTERRUPT, RETURNED & EMERGENCY DECLARED. LANDING UNEVENTFUL. DURING CLIMBING THRU 25000 HEARD A VIOLENT BANG & ACFT SHOOK, NR 1 ENGINE FAILED. DURING INSPECTION ENGINE WAS FOUND TO HAVE TURBINE BLADE DISTRESS. R & R NR 1 ENGINE.SDR AALA20141205003Battery Pack · dischargedEMERGENCY LIGHTS CAME ON AT SHUTDOWN & BATTERY OFF. R & R B5-104. SYS CHECKED NORMAL.SDR AALA20141205001Battery Pack · dischargedFORWARD EMER LIGHTS INOPERATIVE BETWEEN ROW 5 & 23. R & R BATTERY PACK IAW AMM 33-53-00. SYS CHECKS NORMAL.SDR AALA20141204008Longeron · crackedCRACK ON LONGERON 25 LT BETWEEN FUSELAGE STATIONS 160 & 200. REPAIRED LONGERON IAW SRM 53-02-00 FIG 18 SHEET 1.SDR AALA20141204004Seal · cutRETURNED, EMER DECLARED, LANDING UNEVENTFUL & ACFT WAS OVERWEIGHT. NLG WOULD NOT RETRACT AFTER TAKEOFF. FOUND NLG STRUT FLAT. INSPECTION OF NLG FOUND THE SHRADER VLV SEAL CUT. PERFORMED NLG STRUT REPACK IAW AMM 32-21-02. PERFORMED GEAR SWING. SYS CHECKED SDR AALA20141203002Position Switch · defectiveDURING TAKEOFF RECEIVED SLAT AUTO FAIL MSG. ABORTED TAKEOFF AT 90. R & R FLAP SLAT HANDLE POSITION SWITCHES & TRANSMITTER IAW MM 27-80-07. ACCOMPLISHED ALL REQUIRED CHECKS. SYS CHECKED NORMAL.SDR AALA20141130001Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-06.SDR AALA20141129007Battery Pack · dischargedEMERGENCY EXIT LIGHTS ABOVE RT & LT FWD HATCH DOORS INOPERATIVE. R & R BATTERY PACK. SYS CHECKED NORMAL.SDR AALA20141129006Power Supply · inoperativeMID CABIN OVERHEAD EMER LIGHTS FAIL OPERATIONAL TEST. R & R MID CABIN POWER SUPPLY. SYS CHECKED NORMAL.SDR AALA20141129005Portable Light · inoperativePORTABLE EMER LIGHT FAILS OPERATIONAL TEST. R & R PORTABLE EMER LIGHT. SYS CHECKED NORMAL.SDR AALA20141202011Casting · crackedFORWARD CARGO DOOR TOP FWD DOOR STOP CASTING IS CRACKED. R & R CASTING IAW SRM 51-30-05.SDR AALA20141124006Oil Filter · cloggedEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH RT ENG OIL STRAINER CLOG LIGHT ILLUMINATED. REDUCED POWER IAW QRH & LANDED. R & R OIL FILTER IAW AMM 71-91-12. NO DEFECTS NOTED. PERFORMED LEAK CHECK, SYS CHECKED GOOD.SDR AALA20141124004Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 SLAT INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-05.SDR AALA20141124003Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER & HAT BUSHING IAW WORK CARD 57-98-06.SDR AALA20141124001Frame · crackedCANT FRAME AT FS 1510 IS CRACKED AT FIRST TAIL CONE GUIDE PIN BELOW RT UPPER LATCH. REPAIRED FRAME IAW SRM 53-01-00-001.SDR AALA20141123011Switching Unit · defectiveAIR INTERRUPT, RETURNED & EMER DECLARED. LANDING UNEVENTFUL, NOT OVERWEIGHT. DURING CLIMB THE NLG RED LIGHT REMAINED LIT WITH AUTO SPOILER DO NOT USE & STALL INDICATION FAILURE LIGHTS. NLG STRUT BOTTOMED. PERFORMED NOSE GEAR STRUT SERVICE IAW 32-21-02. RESDR AALA20141123010B-Nut · looseEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING DESCENT RT HYD SYS QTY INDICATED LOW & DECREASING. PERFORMED QRH & LANDED WITH RT HYD ENG & AUXILIARY PUMPS OFF. FOUND B NUT LEAKING AT LG MANIFOLD. TORQUED NUT IAW SP 20-30-02. PERFORMEDSDR AALA20141124002Unknown · malfunctionedEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CRUISE CABIN ALTITUDE WARNING ALERTED. RT PACK BECAME UNCONTROLLABLE, OPERATED PRESSURIZATION SYS IAW AMM 21-32-00. SYS CHECKED NORMAL.SDR AALA20141121001Battery Pack · dischargedAFT EMER PATH LIGHTING FAILED CHECK. R & R AFT BATTERY PACK.SDR AALA20141123007Battery Pack · dischargedEMERGENCY CEILING LIGHTS INOPERATIVE FROM ROW 23 TO 26. REPLACED BATTERY PACK AT ROW 25. OPERATIONS CHECKED GOOD IAW MM 33-53-00.SDR AALA20141123006Battery Pack · dischargedTAIL CONE EMER LIGHT IS INOPERATIVE. REPLACED BATTERY PACK AFT LT LAVATORY. OPERATIONS CHECKED GOOD IAW MM 33-53-00-501.SDR AALA20141123005Light · inoperativeEMERGENCY CEILING LIGHT ROW 30. LT SIDE IS INOPERATIVE, RELAMPED EMER CEILING LIGHT ROW 30. OPERATIONS CHECKED GOOD IAW MM 33-53-00-501.
Back to Mcdonnell Douglas DC-9-82