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 AALA20140222004Fitting · crackedRT HAND WING LE INBD NR 4 SLAT TRACK FITTING CRACKED. INSTALLED DOUBLER IAW EA MD80-57-033517.SDR AALA20140307003Frame · crackedNOSE WW 1 INCH LONG CUT THRU FWD FRAME OF NLG DOOR OPENING, 5 INCHES LT OF CTR. INSTALLED DOUBLER IAW EA MD80-53-033794.SDR AALA20140305001Stop Fitting · crackedAFT CARGO DOOR FWD EDGE TOP STOP FITTING CRACKED. REPLACED FITTING IAW SRM 51-30-05.SDR AALA20140221005Stop Fitting · crackedAFT CARGO DOOR FWD EDGE CTR STOP FITTING CRACKED. REPLACED FITTING IAW SRM 51-30-05.SDR AALA20140221007Stop Fitting · crackedFWD CARGO DOOR STOP AFT LOWER STOP PAD FITTING CRACKED. INSTALLED NEW STOP PAD FITTING IAW SRM 51-30-05.SDR AALA20140226005Rib · crackedNR 4 INBD SLAT TRACK SUPPORT RIB CRACKED. INSTALLED RIB DOUBLER & HAT BUSHING IAW EA MD80-57-033643.SDR AALA20140220008Valve · malfunctionedELP INFLIGHT DFW-SAN CREW REPORTED UNWANTED FUEL TRANSFER IN FLIGHT. EMERGENCY DECLARED FLIGHT DIVERTED ELP LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. PERFORMED CHECK VLV FLUSH PROCEDURE. OPERATED PUMPS & NO TRANSFER NOTED. SYS GND CHECKED NOSDR AALA20140220002Control Module · inoperativeAFT ZONE EMERGENCY SEAT PATH LIGHTING WILL NOT TEST. REPLACED AFT ZONE ESCAPE PATH LIGHTING CONTROL MODULE. OPERATIONS CHECKED NORMAL.SDR AALA20140228005Skin · crackedCRACK INDICATION WAS FOUND ON 1 FASTENER HOLE, ON THE VERTICAL STABILIZER DURING HFEC INSPECTION IAW SB MD80-55A067. REMOVED HOLE & INSTALLED FREEZE PLUG IAW EA MD80-55-033832.SDR AALA20140220003Battery Pack · dischargedEGRESS LIGHTS FAILED AT AB5 1. REPLACED BATTERY PACK, OPERATIONS CHECKED NORMAL.SDR AALA20140215001Battery Pack · dischargedEMERGENCY LIGHT STAYED ON WITH SWITCH OFF. REPLACED BATTERY PACK, OPERATIONS CHECKED NORMAL.SDR AALA20140214019Strut · malfunctionedDFW CREW REPORTED RED NOSE GEAR LIGHT ILLUMINATED AFTER TAKEOFF FOLLOWED BY LOSS OF PRESSURIZATION. AUTO SPOILER DO NOT USE & STALL INDICATION FAILURE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SSDR AALA20140212009Structure · crackedCRACK FOUND AT FASTENER AT STATION 1309 BETWEEN LONGERON 6 & 7 RT. CUT OUT CRACK, INSTALLED DOUBLER & FILLER IAW SRM 53-04-02 FIGURE 2 SHEET 29.SDR AALA20140212001Bracket · crackedUPPER SIDE OF THE GEAR DOOR ACTUATOR, THE GREEN SHELF BRACKET IS CRACKED AT THE AFT INBD RADIUS. INSTALLED DOUBLER & SHIM IAW AARD 53-10-00-38.SDR AALA20140214021Rib · crackedRT HAND WING LE CRACKED IN INBD NR 4 SLAT TRACK FITTING AT AFT UPPER CABLE BRACKET LUG. INSTALLED DOUBLER IAW CARD 57-98-06 & EA MD80-57-033572.SDR AALA20140214018Rib · crackedLT WING NR 4 SLAT TRACK INBD RIB CRACKED. INSTALLED SHIM & DOUBLER IAW EA MD80-57-033566.SDR AALA20140212002Frame · crackedCRACK AT STATION 1418 & LONGERON 2 LT. INSTALLED REPAIR DOUBLER IAW SRM 53-01-00-01.SDR AALA20140210008Regulator · faultySTL INFLIGHT DAY DFW CREW REPORTED CREW O2 BOTTLE EMPTY. FLIGHT DIVERTED STL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ALL THREE O2 REGULATORS. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140208004Slide · unserviceableRT NR 1 DOOR EVACUATION SLIDE FOUND UNPACKED WITH RELEASE PINS PULLED-OUT. REPLACED RT NR 1 DOOR SLIDE, OPERATIONS CHECKED NORMAL.SDR AALA20140207004Battery Pack · dischargedAFT OVERWING EMERGENCY EXIT LIGHTS FAILED TO TEST. REPLACED BATTERY PACK FOR AFT OVERWING EMERGENCY EXIT LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140207003Portable Light · inoperativeLT NR 1 DOOR PORTABLE EMERGENCY LIGHT FAILED TO TEST. REPLACED LIGHT ASSEMBLY, OPERATIONS CHECKED NORMAL.SDR AALA20140203006Valve · inoperativeRDU INFLIGHT EWR-DFW. THE RT HAND ENG FUEL HEAT TEMPERATURE INDICATION. EMERGENCY DECLARED FLIGHT DIVERTED RDU LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT ENG FUEL HEAT VLV. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140203004Engine · failedDFW CREW REPORTED HEARING TWO LOUD BANGS FOLLOWED BY THE RT HAND ENG FAILURE SINGLE ENG TIME 7 TO 8 MINUTES. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT HAND ENG AT DFW ON 02/04/2014. SYS GND CHESDR AALA20140201007Battery Pack · dischargedROW 21 OVERWING EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK & LAMPS IN LIGHT ASSEMBLY. OPERATIONS CHECKED NORMAL.SDR AALA20140130004Cadc · failedDEN INFLIGHT ORD LAS CREW REPORTED CAPTAIN`S & FIRST OFFICER`S MACH AIRSPEED DRIFTED SIGNIFICANTLY. FLIGHT DIVERTED DEN LANDED WITHOUT INCIDENT. REPLACED NR 1 CENTRAL AIR DATA COMPUTER, SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140130003Skin · crackedCRACK FOUND IN SKIN AT STATION 108 BETWEEN LONGERONS 27 & 28 LT. STOP DRILLED CRACK & INSTALLED DOUBLER IAW SRM 51-01-00 FIGURE 2 SHEET 3.SDR AALA20140129004Skin · crackedFUSELAGE SKIN IS CRACKED AT STATION 1309 ABOVE LONGERON 7 RT. INSTALLED REPAIR DOUBLER IAW SRM 53-04-00, FIGURE 32SDR AALA20140129003Cusp Web · corrodedRT CUSP AT STATION 536 OTBD OF SEAT TRACK NR 6 CORRODED. INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20140128005Skin · crackedCRACK FOUND IN FASTENER ROW LT SIDE OF VERTICAL STABILIZER FWD OF INTAKE. INSTALLED DOUBLER IAW SRM 55-01-00 FIGURE 2 SHEET 2.SDR AALA20140128003Cup · crackedGUST LOCK CUP CRACKED INSIDE AFT SERVICE DOOR. REPLACED WITH NEW GUST LOCK CUP IAW AARD 51-00-05-1.SDR AALA20140127010Trim Motor · inoperativeDFW REPEAT ITEM, CREW REPORTED STABILIZER TRIM LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ALTERNATE AUTOPILOT STAB TRIM MOTOR & RECTIFIER. SYS GND CHECKED NORMAL OPERATION CLOSSDR AALA20140127006Casting · crackedRT WING INBD NR 4 SLAT TRACK CASTING CRACKED AT LUG. INSTALLED REPAIR DOUBLER & WASHER IAW EA MD80-57-033310.SDR AALA20140127005Casting · crackedLT WING INBD NR 4 SLAT TRACK CASTING CRACKED AT LUG. INSTALLED REPAIR DOUBLER & WASHER IAW EA MD80-57-033310.SDR AALA20140127003Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED FROM STATIONS 1287 TO 1309 & LBL 0. INSTALLED NEW INTERCOSTAL IAW SRM 51-00-05-1.SDR 2WAA20140127001Generator · shutdownRIGHT GENERATOR WENT OFF LINE DURING CLIMB, ATTEMPTS TO RESET WERE UNSUCCESSFUL, APU GENERATOR CAME ON LINE. INSPECTED RT GENERATOR RESET SWITCH FOR OPS, FOUND NORMAL IAW 30-31-00. TROUBLESHOT TO ELECTRICAL SYSTEM FOUND NORMAL IAW 24-20-01, OPS CHECKED SYSTEMSDR AALA20140126008Trim Motor · inoperativeDFW CREW REPORTED AIRCRAFT LOST PRIMARY STAB TRIM IN FLIGHT. EMERGENCY DECLARED FLIGHT RETURNED DFW. AIRCRAFT REMOVED FROM SERVICE. REPLACED HORIZONTAL STABILIZER PRIMARY TRIM MOTOR. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140126010Seat Track · corrodedSEAT TRACK NR 5 FROM STATIONS 200 TO 246 CORRODED. REPLACED SEAT TRACK SECTION IAW SRM 53-05-00 FIGURE 4F.SDR AALA20140126002Cusp Web · crackedFOUND CRACK IN CUSP SHEET FROM STATIONS 218 TO 237 RT SIDE. REMOVED & INSTALLED NEW SERVICEABLE CUSP SHEET IAW AARD 53-20-00-16.SDR AALA20140124016Membrane · corrodedCORROSION ON BOTTOM OF SUB FLOOR FWD OF FRAME 168 INBD OF CUSP T. REMOVED CORROSION & INSTALLED DOUBLER ON SUB FLOOR.SDR AALA20140124012Seat Track · corrodedSEAT TRACK NR 2 OTBD TRACK FLANGE HAS CORRODED AREA. INSTALLED STRAP REPAIR IAW AARD 53-20-00-13.SDR AALA20140124006Fitting · corrodedOTBD G-1 GALLEY TIE DOWN FITTING CORRODED ON RT SIDE OF STATION 160. INSTALLED NEW SERVICEABLE G-1 TIE DOWN FITTING IAW AARD 51-00-05-1 & IPC 53-40-00-08D BOEING PRINT 9936534 CONF.517.SDR AALA20140124005Seat Track · corrodedSEAT TRACK NR 2 CORRODED FROM STATIONS 1191 TO 1203. INSTALLED SEAT TRACK PLUGS IAW SRM 53-05-00 FIGURE 4A.SDR AALA20140124004Skin · crackedFUSELAGE SKIN IS CRACKED AT STATION 1039 ABOVE LONGERON 7 RT. INSTALLED REPAIR DOUBLER IAW 53-04-00 FIGURE 32.SDR AALA20140124002Membrane · corrodedFWD SUB FLOOR, G2 GALLEY, INBD AFT FLOOR MOUNT HAS CORROSION AT STATION 218. INSTALLED SUBFLOOR DOUBLER IAW AARD 53-20-00-16.SDR AALA20140129008Spar Cap · damaged6 HOLES WERE ELONGATED IN THE LT VERTICAL STABILIZER SPAR CAP AT STATION ZFS 52.267. REPARIRED IAW BOEING DRAWING SG 09550005.SDR AALA20140127009Mount · corrodedNR 2 GALLEY MOUNT AT STATION 218 CORRODED. INSTALLED NEW GALLEY MOUNT FWD SEAT TRACK NR 6 IAW AARD 51-00-05-1.SDR AALA20140123011Mount · corrodedNR 2 GALLEY MOUNT AT STATION 218 & NR 6 SEAT TRACK CORRODED. INSTALLED GALLEY MOUNT FWD END OF NR 6 SEAT TRACK IAW AARD 51-00-05-1.SDR AALA20140122009Membrane · corrodedCORROSION ON SUB FLOOR UNDER G-1 GALLEY DRAIN PAN. REMOVED CORROSION & INSTALLED DOUBLER.SDR AALA20140122005Mount Fitting · corrodedG-1 GALLEY MOUNT CORRODED AT STATION 160 & RBL 44. INSTALLED NEW GALLEY MOUNT FITTING.SDR AALA20140122004Seat Track · corrodedSEAT TRACK NR 3 FROM STATIONS 1166 TO 1309 CORRODED. INSTALLED NEW TRACK NR 3 FROM STATIONS 1166 TO 1309.
Back to Mcdonnell Douglas DC-9-82