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 AALA20141016002Skin · crackedFUSELAGE SKIN CRACKED, CANTED FRAME STATION 1474, RT SIDE 15 INCHES DOWN FROM GUTTER. DAMAGE CUT OUT & INSTALLED EXTERNAL DOUBLER IAW SRM 53-01-00-001.SDR AALA20141026004Web · crackedWEB IS CRACKED AT STATION 207 & INTERCOSTAL 11 LT. INSTALLED DOUBLER IAW AARD 53-10-00-11.SDR AALA20141026003Mount · corrodedG2 GALLEY MOUNT UNDER SUBFLOOR CORRODED. REPLACED MOUNT IAW AARD 51-00-05-1.SDR AALA20141026002Membrane · corrodedCORROSION ON SUBFLOOR MEMBRANE. CUT OUT CORROSIONS & INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20141026001Fitting · corrodedCORROSION ON INBD G1 MOUNT AT STATION 160 & RBL 12. REPLACED MOUNT & FITTING IAW SRMS 51-30-02 & 51-30-05.SDR AALA20141023004Mount · corrodedOUTBOARD G1 GALLEY MOUNT CORRODED. REPLACED CORRODED MOUNT.SDR AALA20141023003Fitting · corrodedCORROSION ON NR 1 GALLEY CTR TIE DOWN FITTING AT STATION 160 & RBL 45. REMOVED CORRODED FITTING & INSTALLED NEW FITTING.SDR AALA20141023002Membrane · corrodedSUBFLOOR BULGED & CRACKED FROM STATIONS 160 TO 180 AT RBL 48. INSTALLED NEW SUBFLOOR SECTION & STIFFENER IAW 53-20-00-16.SDR AALA20141015002Skin · damagedGOUGE AT STATION 200 AT LT LONGERON 200. INSTALLED DOUBLER IAW SRM 53-04-02-001 FIGURE 2.SDR AALA20141015001Terminal · dirtyEMERGENCY LIGHT ABOVE THE AFT CABIN VAULT DOOR WOULD NOT EXTINGUISH. CLEANED BATTERY PACK TERMINALS & OPERATIONS CHECKED NORMAL.SDR AALA20141013003Longeron · crackedCRACK IN LONGERON 25 LT AT STATION 160. SPLICED IN LONGERON REPAIR IAW SRM 53-02-00-001.SDR AALA20141013002Longeron · crackedCRACK IN LONGERON 24 LT AT STATION 200. SPLICED IN LONGERON REPAIR IAW SRM 53-02-00-001.SDR AALA20141013001Longeron · crackedCRACK IN LONGERON 23 LT AT STATION 200. SPLICED IN LONGERON REPAIR IAW SRM 53-02-00-001.SDR AALA20141013006Bracket · crackedMID CARGO DOOR STOP PAD CRACKED ON FWD SIDE. REMOVED & INSTALLED SERVICEABLE BRACKET.SDR AALA20141013005Bracket · crackedCARGO DOOR STOP PAD BRACKET CRACKED. REMOVED & INSTALLED SERVICEABLE BRACKET.SDR AALA20141013004Battery Pack · dischargedOVERWING EMER EXIT CABIN LIGHTS ON BOTH LT & RT FWD ESCAPE DOORS INOPERATIVE. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20141024004Mount · corrodedG2 GALLEY INBD TIE DOWN MOUNT CORRODED. REMOVED CORRODED MOUNT & INSTALLED NEW SERVICEABLE MOUNT IAW 51-00-05-1 & DWG 9936535.SDR AALA20141023008Floor Support · crackedFLOOR SUPPORT CRACKED BELOW NR 4 SEAT TRACK & ABOVE CTR FUEL TANK AT STATION 826. INSTALLED NEW SERVICEABLE SUPPORT STATION 826.SDR AALA20141023007Floor Support · crackedFLOOR SUPPORT CRACKED BELOW NR 4 SEAT TRACK & ABOVE CTR FUEL TANK AT STATION 864. INSTALLED NEW SERVICEABLE SUPPORT AT STATION 864.SDR AALA20141022008Mount · corrodedG2 GALLEY MOUNT AT FWD END OF NR 6 SEAT TRACK CORRODED. INSTALLED NEW G2 GALLEY MOUNT IAW AARD 51-00-05-1.SDR AALA20141010002Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1437 OTBD OF LONGERON 2 RT. INSTALLED NEW SHEAR TIE IAW DWG 9911840, AARD 51-00-05-1 & SRM 53-05-00-001 FIGURE 99.SDR AALA20141010001Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1437 & LONGERON 2 LT. REPLACED CLIP IAW DWG 9911840, SRM 53-05-00-001 FIGURE 99 & AARD 51-00-05-1 REPAIR 1.SDR AALA20141009009Bushing · wornOUT OF ROUND HOLE AT THE VERTICAL 503 BAND LABELED 21. INSTALLED PLUG IAW SRM 55-03-00.SDR AALA20141009008Bushing · wornOUT OF ROUND HOLE AT THE VERTICAL 503 BAND LABELED 22. INSTALLED PLUG IAW SRM 55-03-00.SDR AALA20141009007Bushing · wornOUT OF ROUND HOLE AT THE VERTICAL 503 BAND LABELED 38. INSTALLED PLUG IAW SRM 55-03-00.SDR AALA20141009006Bushing · wornOUT OF ROUND HOLE AT THE VERTICAL 503 BAND LABELED 24. INSTALLED PLUG IAW SRM 55-03-00.SDR AALA20141010004Battery Pack · dischargedFORWARD CABIN OVERHEAD EMER LIGHTS FOUND DIM. REPLACED BATTERY PACK FOR FWD CABIN OVERHEAD EMER LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20141010003Battery Pack · dischargedFOUND EMER LIGHTS IN AFT TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK IN RT AFT LAVATORY CEILING. OPERATIONS CHECKED NORMAL.SDR AALA20141007011Structure · crackedSTATION 1437 CRACK AFT OF FASTENER BETWEEN LONGERON 3 & 4 RT. INSTALLED DOUBLER SRM 53-04-00-001 FIGURE 27 & EA MD80-53-036885.SDR AALA20141007006Shear Tie · crackedCRACKED SHEAR TIE AT FRAME 1437 LONGERON 2 TO 3 LT. INSTALLED NEW SHEAR TIE IAW AARD 51-00-05-1.SDR AALA20141009005Tire · separatedDAMAGE TO RT INBD FLAP MIDDLE DUE TO TIRE SEPARATION. DRILLED & INSTALLED DOUBLER ON RT INBD FLAP MIDDLE IAW SRM 57-01-00-001.SDR AALA20141005004Door Seal · obstructedAIRCRAFT SLOW TO PRESSURIZE. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. REMOVED DEBRIS FROM AFT CARGO DOOR SEAL DEPRESSOR AREA & PRESS CHECKED OK. REPLACED LT TEMPERATURE CONTROLLER. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20141005003Former · 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 AALA20141005002Former · 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 AALA20141004002Skin · crackedFUSELAGE SKIN CRACKED AT STATION 1309 & LONGERON 7 LT. INSTALLED DOUBLER IAW SRM 53-04-00 FIGURE 32.SDR AALA20141003008Shear Tie · crackedCRACKED SHEAR TIE AT STATION 1450 & LONGERON 2 LT. REPLACED SHEAR TIE.SDR AALA20141003006Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF 1450 FRAME LT SIDE INBD OF LONGERON 3 LT. INSTALLED NEW SERVICEABLE SHEAR TIE AT STATION 1450 INBD OF LONGERON 3 LT IAW SRM 51-30-05.SDR AALA20141003004Skin · damagedTWO HOLES WERE FOUND DISTRESSED AT ZFS 52.267. ACCOMPLISHED REPAIRED IAW SRM 55-03-00.SDR AALA20140930011Cusp Web · damagedFASTENER PULLING THROUGH CUSP & TEE ANGLE AT STATION 1250 LT. INSTALLED FREEZE PLUG IN TEE ANGLE, FILLER & STRAP ON CUSP IAW EA MD80-53-036772.SDR AALA20140930009Angle · damagedCUSP T ANGLE LOWER FLANGE OTBD FASTENER HOLE MATERIAL PUSHED DOWN & GOUGED ON LOWER SIDE AT STATION 1249 LT SIDE. INSTALLED REPAIR ON CUSP T & CUSP FILLER, WASHER & DOUBLER IAW EA MD80-53-036772.SDR AALA20140930008Doubler · corrodedSTATION 1250 LT SIDE HAS CORROSION ON THE CUSP DOUBLER. REPLACED CUSP DOUBLER IAW 53-20-00-16.SDR AALA20140930003Mount · corrodedGALLEY MOUNT NR 2 CORRODED AT END OF SEAT TRACK NR 6. INSTALLED NEW GALLEY MOUNT IAW 51-00-05-1 & DWG 5930547.SDR AALA20140929014Tire · separatedNUMBER 1 TIRE TREAD SEPARATED & CAUSED DAMAGE TO THE LT INBD FLAP & POSSIBLE ENG INGESTION. EMER DECLARED FLIGHT REMOVED ACFT FROM SERVICE. REPLACED LT INBD FLAP MPN 5930479513 & LT ENG N1 BLADES. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20141003020Shear Tie · crackedSHEAR TIE AT STATION 1437 BETWEEN LONGERONS 2 & 4 RT IS CRACKED AT ATTACH HOLE. INSTALLED NEW SHEAR TIE IAW DWG 9911840 & SRM 53-05-00-001.SDR AALA20140929015Gasket · leakingTAIL COMPARTMENT HIGH TEMP INDICATION DURING CLIMB OUT. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED RT GND AIR CONDITIONING CHECK VLV GASKET THAT WAS LEAKING. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140929012Structure · crackedCRACK AT STATION 200 & LONGERON 24 LT. ACCOMPLISHED SPLICE REPAIR IAW SRM 53-02-00-001.SDR AALA20140929010Cusp Web · corrodedLEFT CUSP CORRODED FROM STATION 811 TO 845. INSTALLED NEW CUSP SHEET IAW SRM 53-14-03-001 & DWG 9910151.SDR AALA20140929007Seat Track · corrodedSEAT TRACK NR 1 CORRODED FROM STATIONS 1174 TO 1309. INSTALLED NEW NR 1 SEAT TRACK IAW AMM 53-40-01.SDR AALA20140929005Mount · corrodedGALLEY MOUNT CORRODED AT STATION 218 & RBL 12. INSTALLED NEW GALLEY MOUNT IAW 51-00-00-012.SDR AALA20140929003Mount · corrodedGALLEY MOUNT CORRODED AT STATION 160 & RBL 51. INSTALLED NEW GALLEY MOUNT IAW SRM 51-30-05.
Back to Mcdonnell Douglas DC-9-82