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 AALA20140707005Rib · crackedCRACK IN THE LT WING NR 4 SLAT TRACK INBD SUPPORT RIB. INSTALLED REPAIR FITTING.SDR AALA20140707004Rib · crackedCRACK IN RT WING NR 4 SLAT TRACK INBD SUPPORT RIB. INSTALLED REPAIR FITTING & HAT BUSHING.SDR AALA20140701006Stop Fitting · crackedFORWARD CARGO DOOR, FWD LOWER DOOR STOP CASTING IS CRACKED. INSTALLED NEW STOP PAD FITTING.SDR AALA20140630015Support · crackedLEFT FWD WING SPAR PULLEY BRACKET SUPPORT CASTING CRACKED INBD OF NR 8 SLAT TRACK FROM STATIONS XHS 240 TO 253. REMOVED & INSTALLED NEW SERVICEABLE SUPPORT IAW AARD 51-00-05-1 & EA MD80-57-035547.SDR AALA20140627034Dome Nut · missingANTENNA ATTACHMENT DOME NUT ON CROWN SKIN MISSING BETWEEN STATIONS 1022 & 1041. INSTALLED ANTENNA ATTACHMENT DOME NUT IAW EA MD80-53-035371 & SRM 53-05-00 PARAGRAPH 141.SDR AALA20140626013Angle · crackedLEFT WW UPPER OTBD UPPER SLANT PANEL ANGLE CORRODED. REMOVED & INSTALLED NEW SERVICEABLE ANGLE IAW AARD 51-00-05-1.SDR AALA20140626012Support Rib · crackedLEFT WING NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED. INSTALLED DOUBLER IAW CARD 57-98-04.SDR AALA20140621004Battery Pack · dischargedFORWARD EMER LIGHTS INOPERATIVE. R & R BATTERY PACK B5-23. OPERATIONS CHECKED NORMAL.SDR AALA20140621003Portable Light · inoperativeLEFT NR 1 DOOR FWD PORTABLE EMER LIGHT INOPERATIVE. R & R LT NR 1 DOOR FWD PORTABLE EMER LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140620002Intercostal · crackedCRACKED INTERCOSTAL, AFT CARGO CEILING AREA FROM STATIONS 1287 TO 1309. REMOVED & INSTALLED NEW INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA20140620001Intercostal · crackedCRACKED INTERCOSTAL, AFT CARGO CEILING FROM STATIONS 1271 TO 1287. REMOVED & INSTALLED NEW INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA20140619014Doubler · wornWEAR ON EXISTING DOUBLER AT FWD SIDE OF LT FRAME STATION 1380 JUST AFT OF LT TEMPERATURE CONTROL VLV. R & R DOUBLER IAW AARD 53-10-00-28.SDR AALA20140619013Pan · crackedMID CARGO DOOR OUTER PAN HAS CRACK AT NR 5 BEAM AFT RADIUS BLOCK. INSTALLED DOUBLER IAW SRM 52-03-00-001 & EA MD80-52-035385.SDR AALA20140619008Structure · crackedLEFT HAND STRUT DOOR AFT HINGE CUT OUT CRACKED. INSTALLED DOUBLER IAW SRM 53-05-00 FIGURE 62.SDR AALA20140619007Bracket · crackedRIGHT WW GREEN SHELF BRACKET AT THE UPPER END OF THE GEAR DOOR ACTUATOR IS CRACKED AT THE AFT INBD SIDE. INSTALLED DOUBLER IAW AARD 53-10-00-38.SDR AALA20140619006Structure · crackedRIGHT HAND STRUT DOOR AFT HINGE CUT OUT CRACKED. INSTALLED DOUBLER IAW SRM 53-05-00 FIGURE 62.SDR AALA20140619002Charger · defectiveBATTERY CHARGER LIGHT ILLUMINATED DURING CRUISE. EMER DECLARED FLIGHT LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED MAIN SHIP BATTERIES, CHARGER, RELAY R2-56 MPN ZCDZLX021 & CHARGER CB B1-146. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140619005Battery Pack · dischargedOVERHEAD EMER LIGHTS FROM ROWS 18 TO 22 FAILED TEST. REPLACED BATTERY PACK FOR OVERHEAD EMER LIGHTS FROM ROWS 18 TO 22. OPERATIONS CHECKED NORMAL.SDR AALA20140618015Support Rib · crackedRIGHT NR 4 WING SLAT TRACK LE INBD SUPPORT RIB CRACKED AT PULLEY BRACKET ATTACH BOSS. INSTALLED REPAIR DOUBLER IAW PATTERN CARD 57-98-06 & EA MD80-57-035315.SDR AALA20140618014Support Rib · crackedLEFT WING NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED AT PULLEY BRACKET SUPPORT BOSS. INSTALLED REPAIR DOUBLER IAW PATTERN CARD 57-98-05 & EA MD80-57-035315.SDR AALA20140618013Pan · wornAFT SERVICE DOOR INNER HANDLE HOUSING HAS WORN AREA. REPLACED AFT SERVICE DOOR HANDLE HOUSING IAW 51-00-05-REPAIR 1.SDR AALA20140618003Frame · crackedCRACK ON RT CANT FRAME AT STATION 1474 & LONGERON 18 RT. REMOVED CRACKED SECTION OF FRAME & INSTALLED REPAIR ANGLE IAW SRM 51-70-05-001.SDR AALA20140617014Pan · wornMID CARGO DOOR OUTER PAN WORN AT LOWER FWD STOP PAD. INSTALLED DOUBLER IAW AARD 52-30-00-1 FIGURE 2.SDR AALA20140617013Pan · crackedRIGHT AFT OVERWING EXIT DOOR PAN IS CRACKED AT NR 12 STOP PAD. REPAIRED WITH AN INTERNAL DOUBLER IAW SRM 52-05-00-001 FIGURE 51 SHEET 3.SDR AALA20140617007Door Frame · crackedLEFT AFT OVERWING EXIT DOOR CRACKED UNDER THE NR 12 STOP PAD. REPAIRED WITH INTERNAL DOUBLER IAW SRM 52-05-00-001 FIGURE 51 SHEET 3.SDR AALA20140617006Door Frame · crackedLEFT AFT OVERWING EXIT DOOR FRAME CRACKED UNDER NR 1 STOP PAD. REPAIRED WITH INTERNAL DOUBLER REPAIR IAW SRM 52-05-00-001 FIGURE 51 SHEET 3.SDR AALA20140617005Seat Track · corrodedSEAT TRACK NR 6 FROM STATIONS 281 TO 283 CORRODED. INSTALLED SEAT TRACK PLUG IAW AARD 53-20-00-10.SDR AALA20140617004Diaphragm · corrodedSUB FLOOR IS CRACKED AT VENTURI HOLE UNDER G1 DRAIN PAN BETWEEN STATIONS 148 TO 160. INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20140617003Stop Fitting · crackedMID CARGO DOOR FWD SIDE STOP FITTING CRACKED. REPLACED STOP FITTING IAW AARD 51-00-05-1.SDR AALA20140617001Skin · damagedVERTICAL STABILIZER LE SKIN BELOW THE ZFS 52.267 SPLICE HAS A NR OF HOLES DAMAGED IN THE SKIN & THE LT SPAR CAP. INSTALLED PLUG BUSHING IAW SRM 55-03-00 FIGURE 30 & INSTALLED EXTERNAL DOUBLER IAW SRM 55-03-00 & EA MD80-55-035355.SDR AALA20140616032Mount · corrodedG2 GALLEY MOUNT CORRODED AT STATION 210 & RBL 12. INSTALLED G-2 GALLEY MOUNT IAW AARD 51-00-05 & DWG 9936535 & CONFIGURATION 537.SDR AALA20140616018Mount · corrodedG2 GALLEY MOUNT CORRODED AT STATION 218 & RBL 12. INSTALLED NEW GALLEY MOUNT IAW AARD 51-00-05-1 & DWG 9936535.SDR AALA20140616003Diaphragm · corrodedCORROSION IN SUB FLOOR AROUND G2 GALLEY MOUNT HOLE AT STATION 218 & RBL 12. INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20140615004Frame · gougedFRAME AT STATION 636 & LONGERON 7 LT GOUGED. ACCOMPLISHED NESTED ANGLE REPAIR IAW SRM 51-70-05-001.SDR AALA20140616001Portable Light · intermittentPORTABLE EMER LIGHT COMES ON INTERMITTENTLY DURING TEST. REPLACED ASSEMBLY B5-29. OPERATIONS CHECKED NORMAL.SDR AALA20140615001Battery Pack · dischargedONE STRING OF EMER LIGHTS FROM STATIONS 218 TO 225 INOPERATIVE. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20140614006Filter · cloggedLEFT ENG OIL BYPASS LIGHT ILLUMINATED. EMER DECLARED FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND CARBON IN FILTER, REPLACED ENG OIL FILTER. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140614005Switch · inoperativeCREW REPORTED DIRTY SOCK SMELL & SOON AFTER LOSS OF BOTH AIR CONDITIONING PACKS. ANNUNCIATOR LIGHT PRESSURIZATION FLOW ALSO ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED BOTH SINGLE SECOND SESDR AALA20140614003Sense Line · disconnectedCREW REPORTED BOTH AIR CONDITIONING PACKS INOPERATIVE. RT PACK WAS PLACARDED PRIOR TO DEPARTURE. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. FOUND LT PACK PRESS SENSING LINE LOOSE & DISCONNECTED DURING TROUBLESHOOTING IAW AMM 21-20-00-101. RE-SDR AALA20140614001Fitting · corrodedCORROSION IN FITTING BELOW SUBFLOOR AT G2 MOUNT AT STATION 218 & RBL 12. INSTALLED NEW FITTING IAW AARD 51-00-05 & AARD 52-20-00.SDR AALA20140614002Skin · bentAFT CARGO DOOR LOWER EDGE OF OUTER SKIN BENT TO RIVET ROW. BUILT & INSTALLED DOUBLER IAW ESO 80174 PAGE 601 F.SDR AALA20140613008Coffeemaker · malfunctionedCREW REPORTED ELEC ODOR IN CABIN. CREW DONNED O2 MASKS FOR LANDING. EMER DECLARED FLIGHT LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED FWD GALLEY NR 2 COFFEE MAKER THAT WAS CAUSING ODOR. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140613006Cusp Web · crackedLEFT CUSP CRACKED FROM STATIONS 740 TO 741. INSTALLED CUSP DOUBLER IAW AARD 53-20-00-16.SDR AALA20140613005Stiffener · crackedVERTICAL STIFFENER CRACKED AT UPPER END, ABOVE VAULT DOOR ON CTR LINE. INSTALLED NEW SERVICEABLE STIFFENER IAW AARD 51-00-05-1 & SRM 51-30-05.SDR AALA20140613004Seat Track · corrodedNUMBER 4 SEAT TRACK FROM STATIONS 1256 TO 1260 CORRODED. INSTALLED SEAT TRACK SPLICE IAW SRM 53-05-00 AT STATION 1222 & SEAT TRACK 4 FROM STATIONS 1222 TO 1309 IAW SRM 53-05-00-001 FIGURE 4F.SDR AALA20140612003Pan · crackedWINDOW RING PAN FROM STATIONS 1174 TO 1175 CRACKED. ACCOMPLISHED NESTED REPAIR ANGLE IAW AARD 53-10-00-25.SDR AALA20140612002Cusp Web · crackedLEFT CUSP CRACKED AT STATION 845 AT SEAT TRACK NR 1. INSTALLED NEW LT CUSP SHEET FROM STATIONS 807 TO 845 IAW SRM 51-00-05-1, SRM 53-14-03-001 FIGURE 10 & DWG 9910151.SDR AALA20140611010Frame · crackedFRAME STATIONS FROM 1446 TO 1451 CRACKED. INSTALLED DOUBLER IAW SRM 51-70-5.SDR AALA20140611008Periseal · leakingTAIL COMPARTMENT TEMPERATURE HIGH ILLUMINATED. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED PERI-SEALS ON RT AIR CONDITIONER DUCT & TIGHTENED LOOSE CLAMP ON BOTTOM OF LT HEAT EXCHANGER. SYS GND CHECKED NORMALSDR AALA20140621002Door Frame · crackedFORWARD ENTRY DOOR FRAME WEB, REPAIR DOUBLER CRACKED AT STATION 208 & LONGERON 15 LT. INSTALLED DOUBLER & FILLER IAW AARD 53-10-00-11.
Back to Mcdonnell Douglas DC-9-82