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 AALA20140621001Web · crackedFORWARD PAX DOOR UPPER WEB IS CRACKED AT STATION 206. INSTALLED DOUBLER & FILLER IAW AARD 53-10-00-11.SDR AALA20140627033Rib · crackedRIGHT WING LE RIB AT NR 4 SLAT TRACK INBD RIB CRACKED. REPAIRED RT WING NR 4 SLAT TRACK INBD SUPPORT RIB IAW EA MD80-57-035287.SDR AALA20140625007Support Fitting · crackedLEFT GND SPOILER ACTUATOR SUPPORT FITTING CRACKED. REPLACED FITTING.SDR AALA20140610024Rib · crackedNUMBER 4 SLAT TRACK LEADING INBD SUPPORT RIB CRACKED. ACCOMPLISHED REPAIR IAW EA MD80-57-035265.SDR AALA20140610023Rib · crackedNUMBER 4 SLAT TRACK LEADING INBD SUPPORT RIB CRACKED. ACCOMPLISHED REPAIR IAW EA MD80-57-035265.SDR AALA20140609010Slide · unsecureWHILE OPENING THE RT NR 1 DOOR THE SLIDE PACK FELL OUT & FELL TO THE RAMP & INFLATED. REPLACED RT NR 1 DOOR SLIDE.SDR AALA20140609008Support · crackedVERTICAL SUPPORT STRUT ON LT SIDE OF BULKHEAD STATION 218 IS CRACKED AT LOWER END BETWEEN LONGERONS 23 & 24 LT. INSTALLED DOUBLER IAW AARD 53-10-00 FIGURE 15.SDR AALA20140609006Longeron · crackedSTATION 200 AT LONGERON 24 CRACKED. SPLICED IN NEW LONGERON SECTION IAW SRM 53-02-00.SDR AALA20140609005Longeron · crackedLONGERON 25 AT STATION 160 CRACKED. INSTALLED NEW LONGERON & SPLICE DOUBLERS IAW SRM 53-02-00.SDR AALA20140609003Longeron · crackedLONGERON 23 AT STATION 200 CRACKED. INSTALLED NEW LONGERON & SPLICE DOUBLERS IAW SRM 53-02-00.SDR AALA20140609002Longeron · crackedLONGERON 24 AT STATION 200 CRACKED. INSTALLED NEW LONGERON & SPLICE DOUBLERS IAW SRM 53-02-00.SDR AALA20140607003Connector · leakingCREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE INDICATION. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND RT PACK LEAKING FROM SLIP CONNECTOR & DUCT OVERHEAT SWITCH INOPERATIVE. REPLACED SEALS IN SLIP CONNECTOR &SDR AALA20140607001Battery Pack · dischargedONE SECTION OF CABIN EMER LIGHTS INOPERATIVE. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20140606028Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMED IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER IAW WORK CARD 57-98-05 & EA MD80-57-035192.SDR AALA20140606027Former · crackedLEFT HAND WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 INBD FORMER DOUBLER IAW WORK CARD 57-98-05 & EA MD80-57-035192.SDR AALA20140606021Battery · dischargedEMERGENCY CEILING LIGHTS ABOVE SEATS 12 TO 16 ARE INOPERATIVE. REPLACED BATTERY B5-102. OPERATIONS CHECKED NORMAL.SDR AALA20140605006Stop Fitting · crackedMID CARGO DOOR AFT STOP CRACKED. R & R AFT STOP IAW AARD 51-00-05-1.SDR AALA20140605001Skin · crackedFOUND CRACK IN SKIN AT STATION 1510. INSTALLED DOUBLER IAW SRM 53-01-00-001.SDR AALA20140604014Longeron · crackedCRACK IN LONGERON 25 AT STATION 160. INSTALLED NEW LONGERON & SPLICES IAW SRM 53-02-00 & AARD 53-00-00 ITEM 5.SDR AALA20140603025Regulator · defectivePHX CREW REPORTED OBSERVERS O2 BOTTLE COMPLETELY EMPTY. FLIGHT RETURNED PHX LANDED WITHOUT INCIDENT. REPLACED OBSERVERS O2 REGULATOR & O2 BOTTLE. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20140603002Sensor · faultyORD CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED. EMER DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED AFT TEMPERATURE SENSOR. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20140603004Skin · crackedCRACKS IN SKIN AT FWD SERVICE DOOR CUT OUT, FWD UPPER CORNER. INSTALLED DOUBLER TRIPLER IAW DWG SR09530172.SDR AALA20140602023Stop Fitting · crackedFORWARD CARGO DOOR STOP CRACKED. REPLACED FWD CARGO DOOR STOP IAW AARD 51-00-05-1.SDR AALA20140602002Angle · corrodedCUSP T ANGLE FROM STATIONS 170 TO 180 CORRODED. REMOVED & INSTALLED NEW CUSP T ANGLE.SDR AALA20140531010Doubler · corrodedCORROSION ON DOUBLER ON DIAPHRAGM BY FWD SERVICE DOOR FROM STATIONS 200 TO 218. INSTALLED CUSP DOUBLER FROM STATIONS 200 TO 218, OTBD SEAT TRACK NR 5 IAW AARD 53-20-00-16.SDR AALA20140531009Structure · corrodedHEAVY CORROSION UNDER GALLEY NR 1 DRAIN PAN. INSTALLED DOUBLER UNDER GALLEY NR 1 DRAIN PAN IAW AARD 53-20-00-16.SDR AALA20140531008Cusp Web · crackedRIGHT CUSP CRACKED FROM STATIONS 200 TO 224 UNDER SEAT TRACK NR 6. INSTALLED NEW CUSP SHEET FROM STATIONS 218 TO 237 IAW SRM 51-30-05, SRM 51-30-02 & DWG 9930538.SDR AALA20140531004Structure · damagedFASTENER HOLES AT STATIONS 190 TO 195 AT RBL DAMAGED. INSTALLED SUBFLOOR DOUBLER FROM STATIONS 160 TO 200 IAW AARD 53-20-00-16.SDR AALA20140602025Structure · cracked2 CRACKS IN FASTENER HOLES AT STATION 1474 & LONGERON 19 LT. INSTALLED DOUBLER IAW SRM 53-01-00-001.SDR AALA20140602021Longeron · crackedAFT ACCY, LT HAND SIDE LONGERON 2 CRACKED AT AFT END AFT OF 1418 FRAME. REPLACED SECTION OF LONGERON & INSTALLED LONGERON SPLICE IAW SRM 53-20-00 FIGURE 18.SDR AALA20140530010Pan · wornAFT CARGO DOOR OUTER PAN WORN AT NR 4 BEAM FWD STOP PAD. INSTALLED DOUBLER IAW AARD 52-30-00-1.SDR AALA20140530002Portable Light · inoperativeLEFT NR 1 PORTABLE LIGHT INOPERATIVE. R & R LT NR 1 PORTABLE LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140530001Mount · corrodedGALLEY MOUNT IN FWD END OF NR 6 SEAT TRACK CORRODED. REPLACED NEW GALLEY MOUNT IN FWD END OF NR 6 SEAT TRACK IAW AARD 51-00-05-1.SDR AALA20140529015Seat Track · corrodedCABIN SEAT TRACK NR 6 FROM STATIONS 36 TO 367 CORRODED. REPLACED CABIN SEAT TRACK NR 6 FROM STATIONS 36 TO 367 IAW SRM 53-05-00-001 FIGURE 4F.SDR AALA20140529007Altimeter · failedDFW CREW REPORTED CAPTAINS ALTIMETER FAILED ACCOMPANIED BY A BUZZING NOISE IN THE COCKPIT. NOISE GOT LOUDER AS AIRSPEED INCREASED DURING CLIMBOUT. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED CAPTAINS ALTIMETER. SYS GNDSDR AALA20140529001Intercostal · crackedINTERCOSTAL ON CABIN FLOOR ON CTR LINE FRAME 1287 TO 1309 CRACKED. R & R INTERCOSTAL.SDR AALA20140528009Seat Track · corrodedSEAT TRACK NR 4 FROM STATIONS 1031 TO 1309 CORRODED. INSTALL NEW SEAT TRACK IAW AARD 51-00-05-1 & AARD 51-00-05.SDR AALA20140528008Seat Track · corrodedSEAT TRACK NR 1 FROM STATIONS 1174 TO 1309 CORRODED. INSTALLED NEW SERVICEABLE SEAT TRACK IAW AMM 53-40-01-2.SDR AALA20140528005Stop Fitting · crackedMID CARGO STOP PAD, FWD UPPER CORNER CRACKED. R & R FITTING IAW AARD 51-00-05-1.SDR AALA20140528004Stop Fitting · crackedMID CARGO FWD DOOR STOP FITTING CRACKED. R & R STOP FITTING IAW AARD 51-00-05-1.SDR AALA20140527020Stop Fitting · crackedFORWARD CARGO STOP PAD FITTING CRACKED. R & R FITTING IAW AARD 51-00-05-1.SDR AALA20140527013Rib · crackedRIGHT NR 4 LE SLAT RIB INBD CASTING CRACKED. REPLACED CASTING IAW AARD 51-00-05-1.SDR AALA20140612006Longeron · crackedCRACK IN 1 FASTENER AT LONGERON 22 LT & STATION 188. INSTALL DOUBLER IAW DWG SR09530219.SDR AALA20140526010Membrane · crackedCRACK IN THE CUSP MEMBRANE AT STATION 164, 2 INCHES RT OF ACFT CENTERLINE APPROXIMATELY 1/2 INCH LONG IN THE INBD & OTBD DIRECTION. INSTALLED DOUBLER IAW EA MD80-53-026939.SDR AALA20140527035Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 INBD FORMER DOUBLER IAW WORK CARD 57-98-03 & EA MD80-57-034944.SDR AALA20140523008Pan · crackedRIGHT AFT OVERWING EXIT DOOR CRACKED AT NR 1 STOP FITTING. INSTALLED DOUBLER IAW SRM 52-05-00-01.SDR AALA20140523007Pan · crackedRIGHT AFT OVERWING EXIT DOOR CRACKED AT THE NR 12 STOP FITTING. INSTALLED DOUBLER IAW SRM 52-05-00-01.SDR AALA20140523006Mount · corrodedGALLEY MOUNT CORROSION FWD END OF SEAT TRACK NR 1 & STATION 1174. INSTALLED NEW GALLEY MOUNT TO SEAT TRACK IAW AARD 51-00-05-1 & DWG 5930566.SDR AALA20140523005Fitting · corrodedRIGHT FRAME FOOT AT STATION 200 CORRODED. INSTALLED NEW FRAME FOOT IAW SRM 51-30-05 & SRM 51-30-01.SDR AALA20140522022Pressure Switch · faultyDFW CREW REPORTED ON DESCENT LT OIL STAINER CLOGGING ANNUNCIATOR CAME ON. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED LT ENG OIL FILTER DIFFERENTIAL PRESS SWITCH. SYS GND CHECKED NORMAL, OPERATION CLOSED.
Back to Mcdonnell Douglas DC-9-82