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 AALA20150205005Link · missingEMERGENCY DECLARED & LANDING UNEVENTFUL. RT MLG DOOR DID NOT LATCH CLOSED ON LANDING. FOUND DOOR UP LATCH ROLLER & ARM MISSING. REPLACED LINK ASSEMBLY. SYS CHECKED NORMAL.SDR AALA20150204012Engine · malfunctionedDURING CLIMB RT ENG OIL PRESSURE INCREASED TO 60 PSI, OIL QTY DROPPED TO ZERO & ENG SHUTDOWN. RETURNED & EMERGENCY DECLARED. LANDING UNEVENTFUL. R & R RT ENG POWER PLANT ENGINEERING REPORTS INTRUSION OF HOT AIR INTO THE NUMBER 4 & 5 BEARING COMPARTMENT WHICSDR AALA20150204009Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. STOP DRILLED CRACK & INSTALLED RT WING NR 4 SLAT INBD FORMER DOUBLER IAW WORK CARD 57-98-04.SDR AALA20150201001Pan · corrodedCORROSION ON FWD CARGO DOOR PAN LOWER SECTION BETWEEN FS 370 & 427 AT STRINGER 26 RT. R & R SECTION OF PAN IAW EA 53-038391 & SRM 53-05-00 FIG 44.SDR AALA20150129005Rib · crackedLEFT WING, NR 4 SLAT TRACK INBD SUPPORT RIB IS CRACKED. INSTALLED REPAIR DOUBLER IAW EA 57-038352 DATED 1/28/15.SDR AALA20150127009Former · 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 AALA20150127008Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. STOP DRILLED CRACK & INSTALLED LT WING NR 4 SLAT INBD FORMER DOUBLER IAW WORK CARD 57-98-03.SDR AALA20150127007Stop Fitting · crackedFORWARD CARGO DOOR, FWD STOP PAD FITTING, SECOND FROM TOP IS CRACKED. R & R FITTING IAW AARD 51-00-05-1, DWG 5910141 & DWG CDK2345.SDR AALA20150124003Skin · damagedRIGHT ELEVATOR STATIC WICK SHOWS EVIDENCE OF LIGHTNING STRIKE DAMAGE TO UPPER AFT OTBD SKIN. REPAIRED AREA IAW FEA.SDR AALA20150123007Casting · crackedLEFT WING GND SPOILER FITTING FWD INBD LUG IS CRACKED. R & R CASTING IAW SRM 51-01-00-001.SDR AALA20150123005Stop Fitting · crackedFORWARD CARGO DOOR FWD, 2ND FROM BOTTOM, STOP IS CRACKED. R & R STOP IAW AARD 51-00-05-1, DWG 5910141 & DWG CDK2345.SDR AALA20150123004Stop Fitting · crackedFORWARD CARGO DOOR FWD UPPER STOP IS CRACKED. R & R STOP IAW AARD 51-00-05-1, DWG 5910141 & DWG CDK2345.SDR AALA20150128004Rib · crackedNUMBER 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED. ACCOMPLISHED DOUBLER & FILLER REPAIR IAW EA 57-038347 DATED 01/28/2015.SDR AALA20150119005Angle · corrodedRIGHT CUSP T ANGLE CORRODED BETWEEN FS 180 & 227. R & R ANGLE IAW SRM 53-30-05, SRM 53-05-00, SRM 51-10-03, SRM 51-30-05 & AMM 20-10-15.SDR AALA20150119003Seat Track · corrodedCABIN SEAT TRACK NR 5 HAS CORROSION FROM FS 210 TO 256 ON OTBD FLANGE. REPAIRED SEAT TRACK IAW SRM 53-05-00-4F.SDR AALA20150118005Stiffener · crackedCRACK IN STATION 1338 BULKHEAD STIFFENER UPPER END FWD SIDE ABOVE VAULT DOOR JAMB CTR AREA. R & R STIFFENER IAW SRM 51-30-05 & 51-60-00 5 B.SDR AALA20150118004Mount Fitting · corrodedNUMBER 2 GALLEY MOUNT AT FWD END OF NR 6 SEAT TRACK IS CORRODED. R & R GALLEY MOUNT IAW AARD 51-00-05-1 & DWG 5930547.SDR AALA20150118003Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED FROM FS 215 TO 285. R & R SEAT TRACK SECTION IAW SRM 53-05-00-001 FIG 4F.SDR AALA20150117004Former · 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 AALA20150116029Beam · crackedFORWARD ENTRY DOOR BEAM, NR 8 BEAM IS CRACKED AT FWD END. R & R BEAM IAW AARD 51-00-05 REPAIR 1 EA COMP-52-038127 DATE 01/14/2015 & DWG 5910081.SDR AALA20150116015Nose Bullet · detachedAIR INTERRUPT, RETURNED & EMER DECLARED. LANDING UNEVENTFUL & ACFT WAS OVERWEIGHT. DURING TAKEOFF THE NR 1 ENG EXPERIENCED COMPRESSOR STALLS. UPON INSPECTION FOUND NOSE BULLET LIBERATED FROM ENG & RESTING IN INLET. REPLACED INLET BULLET IAW AMM 71-10-00. SDR AALA20150116014Diaphragm · damagedSEVERAL RIVETS PULLED THROUGH DIAPHRAGM SHEET ON RT OF ELECTRONICS BAY BETWEEN FS 195 & 200 ABOVE PNEUMATIC DUCT. INSTALLED DOUBLER REPAIR IAW AARD 53-20-00-16.SDR AALA20150116018Unlock Cylinder · malfunctionedFAIL 26 ON BOTH FMA FLIGHT GUIDANCE PANEL WAS DEAD, ALL FOUR WINDOWS. BREAKER C17 DFGC SW A WAS POPPED. ACFT MADE AN EMER LANDING WITH GROSS 132900, IT WAS A SMOOTH LANDING.SDR AALA20150116005Power Supply · inoperativeSECTION OF OVERHEAD EMER LIGHTS INOPERATIVE IN AFT CABIN. REPLACED EMER LIGHT POWER SUPPLY B5 - 28.SDR AALA20150116004Portable Light · inoperativePORTABLE EMER LIGHT FAILS FUNCTIONAL TEST. REPLACED PORTABLE EMER LIGHT.SDR AALA20150115017Cusp Web · corrodedCORROSION ON RT DIAPHRAGM DOUBLER CUSP SHEET BETWEEN STATIONS 200 & 218. INSTALLED CUSP SHEET BETWEEN STATIONS 200 & 218 IAW AARD 53-20-00-16.SDR AALA20150115016Cusp Web · corrodedCORROSION ON RT CUSP BETWEEN STATIONS 218 - 235 OUT OF LIMITS. REPLACED CUSP SHEET IAW AARD 51-00-05-01 & DWG 9930538.SDR AALA20150115009Web · crackedSUBFLOOR CRACKED AT FS 218, 3 INCHES OTBD OF NR 4 SEAT TRACK. INSTALLED REPAIR DOUBLERS IAW AARD 53-20-00-16.SDR AALA20150115007Longeron · corrodedLONGERON 29 LT IS CORRODED AT FS 1287. SPLICE REPAIR INSTALLED IAW SRM 53-02-00-001 FIG 18.SDR AALA20150114006Cusp Web · corrodedRIGHT CUSP SHEET CORRODED BETWEEN FS 788 & 807. REMOVED & INSTALLED NEW CUSP SHEET IAW AARD 51-00-05-1.SDR AALA20150114011Cusp Web · crackedLEFT CUSP CRACKED AT FS 241. INSTALLED CUSP DOUBLER IAW AARM 63-20-00-16.SDR AALA20150113009Cusp Web · crackedCRACK IN CUSP UNDER HORSESHOE COLLAR AT FRAME STATION 845 LT SIDE. INSTALLED CUSP DOUBLER IAW AARD 53-20-00-16.SDR AALA20150112026Servo · failedEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING DESCENT EXPERIENCED ALTERNATE TRIM MALFUNCTION. WHEN NR 2 AUTOPILOT WAS DISCONNECTED THE PITCH UP STOPPED. R & R DUPLEX ELEVATOR SERVO DRIVE IAW AMM 22-12-01 & NR 2 DFGC IAW AMM 22-01-01. SDR AALA20150112014Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER & HAT BUSHING IAW WC 57-98-06.SDR AALA20150111004Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED, INSTALLED RT WING NR 4 INBD FORMER DOUBLER & HAT BUSHING IAW WC 57-98-06.SDR AALA20150109021Channel · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT Z CHANNEL IS CORRODED BETWEEN FS 1155 & 1136 AT LONGERON 25 RT. R & R CHANNEL IAW IPC 25-52-00-03L & SRM 51-30-01.SDR AALA20150109022Stiffener · crackedRIGHT UPPER WING STIFFENER ANGLE CRACKED IN VENT TANK ACCESS 1440C BETWEEN XW 486 & XW 536. R & R STIFFENER ON RT UPPER WING VENT TANK ACCESS 1440C BETWEEN XW 486 & XW 536.SDR AALA20150109020Doubler · crackedTAIL VERTICAL STABILIZER HAS CRACKED DOUBLER ON RT FUSELAGE TO VERTICAL STABILIZER SKATE ANGLE AT CANT FRAME 1463. R & R ANGLE DOUBLER IAW AARD 51-00-05-01.SDR AALA20150109002Battery Pack · dischargedEMERGENCY LIGHTS CONTROLLED BY BATTERY PACK B5-107 INOPERATIVE. R & R BATTERY PACK B5-107 IAW AMM 33-53-00. SYS CHECKED NORMAL.SDR AALA20150109013Former · crackedRIGHT WING LE WING NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER & HAT BUSHING IAW WC 57-98-06.SDR AALA20150109012Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 SLAT INBD FORMER DOUBLER & HAT BUSHING IAW WC 57-98-05.SDR AALA20150109011Cargo Track · corrodedRIGHT FWD TIE DOWN TRACK IN AFT CARGO CORRODED BETWEEN STATIONS 1136 & 1155 ABOVE, LONGERON 27R. INSTALLED NEW TIE DOWN TRACK IAW SRM 51-30-01.SDR AALA20150108013Bracket · crackedSTATION 180 FLOORBEAM INTERCOSTAL ANGLE CRACKED 11 INCHES LT OF CTR LINE. INSTALLED NEW BRACKET IAW SRM 53-14-01-001 & DWG 9923484.SDR AALA20150108007Cargo Track · corrodedAFT CARGO RT TIE DOWN TRACK HAS CORROSION IN SEVERAL AREAS BETWEEN STATION 1212 TO 1231. R & R TIE DOWN TRACK IAW SRM 51-30-01.SDR AALA20150108006Skin · dentedDENTS AT STATION 339 ABOVE & BELOW L 24L. INSTALLED DOUBLER IAW SRM 53-04-02 FIG 2 SHEET 2.SDR AALA20150108005Skin · dentedDENT AT STATION 324 BETWEEN L 24L & L 25L. INSTALLED DOUBLER IAW SRM 53-04-02 FIG 2 SHEET 2.SDR AALA20150108001Fitting · crackedRIGHT WING, INBD FLIGHT SPOILER PANEL CTR FITTING CRACKED AT INBD RADIUS. INSTALLED NEW SPOILER PANEL IAW AMM 27-61-01-201.SDR AALA20150119010Pan · crackedCABIN SIDEWALL LOWER AFT TAB CRACKED ON WINDOW PAN BETWEEN RT OVERWING EXITS. REPAIRED IAW 53-10-00-25.SDR AALA20150119009Pan · crackedCABIN SIDEWALL TOP FWD TAB CRACKED ON WINDOW PAN BETWEEN RT OVERWING EXITS. INSTALLED REPAIR ANGLE IAW AARD 53-10-00-25.SDR AALA20150115020Support · crackedCRACK IN VERTICAL SUPPORT AT FS 927. REMOVED CRACKED VERTICAL SUPPORT & INSTALLED SERVICEABLE VERTICAL SUPPORT IAW AARD 51-00-05-1.
Back to Mcdonnell Douglas DC-9-82