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 AALA20140122001Mount Fitting · corrodedFWD SUBFLOOR, G2 GALLEY, INBD AFT FLOOR MOUNT HAS CORROSION AT STATION 218. INSTALLED G-2 GALLEY MOUNT FITTING IAW AARD 51-00-05-1.SDR AALA20140121008Cusp Web · corrodedCORROSION ON CUSP SHEET UNDER AFT GIRT BAR FITTING ATTACH BRACKET AT THE AFT SERVICE DOOR. REMOVED CORROSION & INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20140121007Stiffener · crackedSTIFFENER IS CRACKED AT CEILING ON OTBD SIDE OF BULKHEAD AT STATION 1338 BETWEEN LONGERONS 3 & 4 RT. INSTALLED NEW STIFFENER IAW AARD 51-00-05-1.SDR AALA20140121006Cusp Web · corrodedRT CUSP AT STATION 536 OTBD OF SEAT TRACK NR 6 CORRODED. REMOVED CORROSION & INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20140121004Bracket · crackedDOOR JAMB INNER SKIN BRACKET CRACKED. INSTALLED REPAIR DOUBLER OVER BRACKET.SDR 2WAA20140118004Bolt · missingMAIN WHEEL ASSY TIE BOLT MISSING, FOUND DURING WALKING AROUND PREFLIGHT. R & R MAIN WHEEL ASSY IAW 32-40-01.SDR AALA20140118002Control Valve · malfunctionedDFW CREW REPORTED NLG UNSAFE LIGHT ILLUMINATED. RECYCLED GEAR & LIGHT WENT OUT. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NGL STEERING & CONTROL VLV. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140118001Cusp Web · crackedLT CUSP CRACKED AT STATION 223. REPLACED CUSP IAW AARD 53-20-00-16.SDR AALA20140117023Casting · crackedRT WING NR 4 SLAT TRACK CASTING CRACKED INBD SIDE. INSTALLED REPAIR FITTING IAW EA MD80-57-033206.SDR AALA20140117018Governor · malfunctionedDFW CREW REPORTED DURING CLIMB OUT RT ENG HAD UNCOMMANDED SHUTDOWN WITH NO WARNINGS PRIOR TO SHUT DOWN. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FUEL FLOW GOVERNOR & FUEL PUMP. SYSTEM GND CHECKESDR AALA20140122008Seat Track · corrodedCORROSION ON NR 6 SEAT TRACK AT STATION 323. INSTALLED SEAT TRACK PLUG IAW SRM 53-05-00-4A.SDR AALA20140122007Seat Track · corrodedNR 6 SEAT TRACK CORRODED STATION 286. INSTALLED SEAT TRACK PLUG IAW SRM 53-05-00-4A.SDR AALA20140116013Skin · damagedLIGHTNING STRIKE DAMAGE AT STATION 447.75 & LONGERON 22 RT. INSTALLED DOUBLER IAW SRM 53-04-02.SDR AALA20140116012Skin · damagedLIGHTNING STRIKE DAMAGE AT STATION 331 APPROXIMATELY 2 INCHES ABOVE STRINGER 22 RT. INSTALLED DOUBLER IAW SRM 53-04-02 FIGURE 2.SDR AALA20140116009Pan · crackedRT HAND WINDOW RING PAN CRACKED AT STATION 1098. ACCOMPLISHED NESTED ANGLE REPAIR IAW AARD 53-10-00-25.SDR AALA20140116008Pan · crackedLT HAND WINDOW RING PAN CRACKED AT STATION 946. ACCOMPLISHED NESTED ANGLE REPAIR IAW AARD 53-10-00-25.SDR AALA20140116006Pan · crackedLT HAND WING PAN CRACKED AT STATION 845. ACCOMPLISHED NESTED ANGLE REPAIR IAW AARD 53-10-00-25.SDR AALA20140116005Pan · crackedRT HAND WING PAN CRACKED AT STATION 1041. ACCOMPLISHED NESTED ANGLE REPAIR IAW AARD 53-10-00-25.SDR AALA20140116004Pan · crackedRT HAND WING PAN CRACKED AT STATION 1022. ACCOMPLISHED NESTED ANGLE REPAIR IAW AARD 53-10-00-25.SDR AALA20140116001Pan · crackedRT HAND WINDOW PAN CRACKED AFT OF FRAME 598 LOWER TAB. INSTALLED WINDOW RING DOUBLER IAW AARD 53-10-00-25.SDR AALA20140117016Ring · crackedWINDOW RING UPPER TAB CRACKED AT STATION 1098. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140117015Ring · crackedWINDOW RING UPPER TAB CRACKED AT STATION 1079. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140117014Ring · crackedWINDOW RING UPPER TAB CRACKED AT STATION 1060. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140117013Ring · crackedWINDOW RING UPPER TAB CRACKED AT STATION 1041. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140115002Ring · crackedWINDOW RING UPPER & LOWER TABS CRACKED AT STATION 1022. INSTALLED DOUBLERS IAW AARD 53-10-00-25.SDR AALA20140115001Pan · crackedLT HAND WINDOW PAN CRACKED AT STATION 1060. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140117004Track · corrodedCORROSION ON LT HAND TIE DOWN TRACK STATIONS 1060 TO 1212. REPLACED TRACK IAW AARD 51-00-05-1.SDR AALA20140114007Skin · crackedFUSELAGE SKIN CRACKED AT STATION 1380 BETWEEN LONGERONS 13 & 14 RT. DYE CHECKED CRACK & STOP DRILLED. INSTALLED DOUBLER IAW SRM 53-01-00 & AARD 53-30-00-02.SDR AALA20140111007Controller · inoperativeIAD INFLIGHT DFW-DCA. CREW REPORTED ANTI SKID FAULT INDICATION DURING APPROACH. FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI SKID CONTROL. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140110011Fuel Line · defectiveBNA INFLIGHT ORD-RSW. CREW REPORTED CTR TANK FUEL WOULD NOT FEED DURING CRUISE. FLIGHT DIVERTED BNA LANDED WITHOUT INCIDENT. PLACARDED CTR FUEL TANK BOOST PUMPS INOPERATIVE IAW MEL 28-18 & FLIGHT CONTINUED TO DESTINATION. REPLACED THE FEED PLUMBING IN THE SDR AALA20140110001Power Supply · inoperativeAFT SECTION OF EMERGENCY SEAT LIGHTING INOPERATIVE. REPLACED AFT SEAT LIGHTING POWER SUPPLY & BATTERY. OPERATIONS CHECKED NORMAL.SDR AALA20140108002Casting · crackedFWD CARGO DOOR TWO STOP CASTINGS CRACKED AFT UPPER & FWD UPPER. INSTALLED TWO NEW CASTINGS IAW SRM 51-30-05.SDR AALA20140107007Linkage · out of adjustORD CREW REPORTED LOUD AIR NOISE WAS COMING FROM NLG AREA ALONG WITH RED UNSAFE INDICATION. FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. ADJUSTED NOSE LINKAGE TO GET TARGETS IN RANGE. SYSTEM GND CHECKED NORMAL OPERATION CLOSESDR AALA20140107004Casting · crackedAFT CARGO DOOR FWD LOWER DOOR STOP CASTING CRACKED. INSTALLED NEW CASTING IAW SRM 51-30-05.SDR AALA20140204006Stringer · crackedCRACK IN RT HAND WING LOWER STRINGER 1 LT, 4TH FASTENER OTBD OF STATION XRS 164.000. ACCOMPLISHED SPLICE REPAIR IAW EA MD80-57-033487 & DRAWING SR09570100.SDR AALA20140127007Membrane · corrodedSUBFLOOR CORRODED FROM STATIONS 200 TO 218 RT HAND SIDE. CUT OUT CORRODED SECTION OF SUBFLOOR & INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20140127004Floor Support · corrodedFLOOR BOARD SUPPORT CORRODED FROM STATIONS 160 TO 168 & RBL 10. INSTALLED FLOOR BOARD SUPPORT IAW AARD 51-00-05-1.SDR AALA20140109003Rib · crackedLT HAND WING LE RIB CRACKED JUST INBD OF NR 4 SLAT TRACK. INSTALLED DOUBLER & SHIM IAW MD80-57-033080.SDR AALA20131224009Compressor · stalledSTL CREW REPORTED LT ENG COMPRESSOR STALLED & LOSS OF THRUST. PULLED THE THROTTLE TO IDLE & SHUT IT DOWN, SINGLE ENGINE TIME 17 MINUTES. EMERGENCY DECLARED FLIGHT RETURNED STL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT ENG AT STL OSDR AALA20131223003Web · damagedRT NLG WW WEB DAMAGED FROM CONTACT WITH STEERING ACT. INSTALLED REPAIR DOUBLER IAW SRM 53-05-00 FIGURE 36 & EA MD80-53-033037.SDR AALA20131223002Battery Pack · dischargedCABIN EMERGENCY EGRESS LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR CABIN EMERGENCY EGRESS LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20131220004Compressor · stalledMSP CREW REPORTED ON CLIMB OUT THE LT ENG ENCOUNTERED MULTIPLE COMPRESSOR STALLS. EMERGENCY DECLARED FLIGHT RETURNED MSP LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT ENG AT MSP ON 12/21/2013. SYSTEM GND CHECKED NORMAL OPERATION OPENSDR AALA20131218007Fitting · wornRT HAND WING NR 12 SLAT TRACK KNUCKLE WORN. INSTALLED NEW SERVICEABLE KNUCKLE AT RT HAND NR 12 SLAT TRACK.SDR AALA20131218006Fitting · wornRT HAND NR 4 SLAT OTBD END KNUCKLE WORN. INSTALLED NEW SERVICEABLE RT HAND NR 4 SLAT OTBD END KNUCKLE.SDR AALA20131217009Reservoir · defectiveDFW CREW REPORTED RT HYDRAULIC FAILURE. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT SYSTEM RESERVOIR. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131217006Former · crackedLT HAND LE NR 4 SLAT TRACK INBD FORMER CRACKED. ACCOMPLISHED DOUBLER REPAIR IAW EA MD80-57-032663.SDR AALA20131217001Former · crackedRT HAND LE SLAT, NR 4 SLAT TRACK INBD FORMER CRACKED. INSTALLED REPAIR DOUBLER IAW EA MD80-57-032663.SDR AALA20131216009Rib · wornLT HAND NR 15 SLAT TRACK OTBD RIB CASTING WORN OUT. INSTALLED NEW SERVICEABLE RIB CASTING.SDR AALA20131216003Flap · crackedFOUND 4 INCH CRACK ON RT HAND TE FLAP APPROXIMATELY 18 INCHES OTBD OF FLAP CANTILEVER. ACCOMPLISHED INTERIM REPAIR TO RT HAND TE IAW FEA AUTH 16095.SDR AALA20131215004Battery Pack · dischargedEMERGENCY EXIT LIGHTS DO NOT ILLUMINATE WITH THE EMERGENCY EXIT LIGHT PLACED TO ON POSITION. REPLACED COCKPIT OVERHEAD EMERGENCY EXIT BATTERY PACK, OPERATIONS CHECKED NORMAL.
Back to Mcdonnell Douglas DC-9-82