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 AALA20100403DFW02Guard · damagedEMERGENCY LIGHT AT SEAT 19 HAS DAMAGED GUARDS. REPLACED GUARDS FOR EMERGENCY LIGHT AT SEAT 19.SDR AALA20100401TUL03Stop Fitting · cracked3 STOP PAD FITTINGS CRACKED ON AFT CARGO DOOR. REPLACED FITTINGS.SDR AALA20100401TUL05Seat Track · corrodedCORROSION BLEND OUT BEYOND LIMITS ON SEAT TRACK 6 STATIONS 216 TO 218. INSTALLED PLUG PER SRM 53-05-00 AND AARD 53-20-00-10.SDR AALA20100401TUL02Seat Track · corrodedCORROSION BEYOND LIMITS ON NUMBER 1 SEAT TRACK STATION 1210. CUT OUT CORRODED AREA AND INSTALLED SEAT TRACK PLUG PER SRM 53-05-00.SDR AALA20100401TUL01Support Fitting · crackedVERTICAL SUPPORT CRACKED. INSTALLED NEW SUPPORT BELOW NUMBER 3 SEAT TRACK PER SRM 51-30-05.SDR AALA20100401TUL06Membrane · puncturedSUBFLOOR PUNCTURED AT STATION 163 LEFT BUTTLINE 3. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100331TUL01Tab · damagedLEFT ELEVATOR CONTROL TAB HAS STATIC DISCHARGE BURN ON TRAILING EDGE. HOT BONDED METAL DOUBLER TO BURN AREA PER SRM 51-70-02.SDR AALA20100331TUL07Support Angle · corrodedRIGHT MAIN LANDING GEAR WHEEL WELL FRETTING CORROSION ON SUPPORT ANGLE ABOVE ACCUMULATOR. INSTALLED CHORD ANGLE PER SRM 51-30-1.SDR AALA20100331TUL04Pan · crackedRIGHT WINDOW PAN CRACKED AT LOWER FORWARD FASTENER AT STATION 1041 ABOVE STRINGER 15 RIGHT. REPAIRED PER AARD 53-10-00-25.SDR AALA20100331TUL03Seat Track · corrodedCORROSION OUT OF LIMITS SEAT TRACK NUMBER 3 AT STATIONS 541 TO 547. REMOVED CORROSION AND INSTALLED SEAT TRACK REPAIR PLUG PER AARD 53-20-0-10.SDR AALA20100330TUL12Rib · crackedNUMBER 15 WING LEADING EDGE SLAT RIB IS CRACKED. REMOVED 2ND FROM OUTBOARD ATTACH FITTING (NUMBER 15). LOCATED, DRILLED, AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20100330TUL11Rib · crackedNUMBER 14 WING LEADING EDGE SLAT RIB IS CRACKED. REMOVED 2ND FROM OUTBOARD ATTACH FITTING (NUMBER 14). LOCATED, DRILLED, AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20100330TUL09Pan · crackedCRACK IN LEFT WINDOW PAN UPPER FORWARD TANG STATION 788 AFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL08Pan · crackedWINDOW RING PAN CRACKED AT TOP AFT FASTENER AT STATION 1193 BELOW LONGERON 11 RIGHT. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL07Pan · crackedCRACK AT LEFT WINDOW UPPER FORWARD TANG STATION 845 AFT SIDE. INSTALLED DOUBLER AARD 53-10-00-25.SDR AALA20100330TUL06Pan · crackedWINDOW RING PAN CRACKED AT LOWER FORWARD FASTENER AT STATION 1155 ABOVE LONGERON 15 RIGHT. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL05Pan · crackedCRACK AT LEFT WINDOW PAN UPPER FORWARD TANG STATION 946 AFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL04Pan · crackedCRACK AT RIGHT WINDOW PAN UPPER FORWARD CORNER AFT OF STATION 807. CUT OUT CRACK AND INSTALLED NEW REPAIR ANGLE PER AARD 53-10-00-25 AT STATION 807 WINDOW PAN UPPER FORWARD CORNER.SDR AALA20100330TUL02Fitting · crackedLOWER AFT T-CLIP IS CRACKED. REMOVED AND REPLACED LOWER AFT T-CLIP ON FORWARD CARGO DOOR PER ESO 80174.SDR AALA20100330TUL01Fitting · wornRIGHT WING SLAT NUMBER 4 KNUCKLE FITTING WORN AT OUTBOARD END. REMOVED WORN ATTACH FITTING. LOCATED, DRILLED, AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20100330DFW06Control Valve · inoperativeDFW - CREW REPORTED LANDING GEAR UNSAFE INDICATION. EMERGENCY EXTENSION WAS USED AND GEAR EXTENDED NORMALLY. EMERGENCY DECLARED LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LANDING GEAR HANDLE WAS JAMMED. REPLACED LANDING GEAR CONTROLSDR AALA20100329TUL10Pan · crackedCRACK AT LEFT WINDOW PAN UPPER AFT TANG STATION 1022 FORWARD SIDE. TRIMMED OUT CRACK AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100329TUL09Fitting · crackedCRACK AT LEFT WINDOW PAN LOWER FORWARD CLIP STATION 1022 AFT SIDE. TRIMMED OUT CRACK AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100329TUL08Pan · crackedRIGHT WINDOW RING PAN CRACKED AT STATION 1061 ABOVE STRINGER 15 RIGHT. REPAIRED PER AARD 53-10-00-25.SDR AALA20100329TUL07Pan · crackedLEFT WINDOW PAN UPPER AFT CLIP CRACKED AT STATION 1022. REPAIRED PER AARD 53-10-00-25.SDR AALA20100329TUL06Pan · crackedLEFT WINDOW RING PAN LOWER FORWARD CLIP CRACKED AT STATION 1022. REPAIRED PER AARD 53-10-00-25.SDR AALA20100329TUL04Pan · crackedRIGHT WINDOW RING PAN CRACKED AT STATION 1059 BELOW STRINGER 11 RIGHT. REPAIRED PER AARD 53-10-00-25.SDR AALA20100328DFW01Compressor · stalledDFW - CREW REPORTED AFTER CLIMB THE RIGHT ENGINE COMPRESSOR STALLED. CREW SHUT DOWN ENGINE (SINGLE ENGINE TIME 15 MINUTES) EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED THE RIGHT ENGINE AND ISOLATORSSDR AALA20100328ORD01Engine · making metalORD - CREW REPORTED OIL STRAINER CLOG LIGHT, HIGH OIL TEMPERATURE, AND VIBRATIONS DURING FLIGHT. RIGHT ENGINE WAS SHUTDOWN (SINGLE ENGINE TIME 13 MINUTES). EMERGENCY DECLARED LANDED ORD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. METALLIC PARTICLES WESDR AALA20100329LGA02Battery Pack · dischargedEMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS. OPS CHECKED NORMAL.SDR AALA20100329LGA01Battery Pack · dischargedEMERGENCY LIGHT ON ROW 8 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT ON ROW 8. OPS CHECKED NORMAL.SDR AALA20100326TUL07Fitting · corrodedRIGHT TRAPEZOID ANGLE FITTING IS CORRODED. REMOVED AND REPLACED ANGLE FITTING PER SRM 51-30-01.SDR AALA20100326TUL06Fitting · corrodedLEFT TRAPEZOID ANGLE FITTING CORRODED. REMOVED AND REPLACED ANGLE FITTING PER SRM 51-31-01.SDR AALA20100326TUL03Frame · wornFRAME 1418 HAS WORN AREA. REMOVED DAMAGE, INSTALLED DOUBLER REPAIR PER AARD 53-10-00-14.SDR WX0A070544Battery Pack · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE LIGHT BATTERY PACK AND MADE ALL REQUSDR AALA20100325TUL07Skin · scratched4 FOOT LONG SCRATCH AFT OF FORWARD CARGO DOOR. INSTALLED DOUBLER PER EA MD80 53-009803.SDR AALA20100325TUL11Structure · puncturedHOLE PUNCTURE IN RIGHT FUSELAGE STATION 1497 LONGERON 10 RIGHT. REMOVED DAMAGE INSTALLED DOUBLER REPAIR PER SRM 53-30-00-2.SDR AALA20100325TUL01Shear Tie · crackedSHEAR TIE CRACKED STATION 1380. INSTALLED DOUBLER PER AARD 53-10-00-20/EA MD-80-53-009727.SDR AALA20100324TUL09Structure · dentedDENT IN LEFT FUSELAGE STATION 237 LONGERON 20 LEFT. INSTALLED INTERNAL DOUBLER REPAIR PER SRM 53-04-04 AND DWG SG09530001.SDR AALA20100324TUL08Tab · damagedRIGHT ELEVATOR CONTROL TAB OUTBOARD AFT END DAMAGED. INSTALLED HOT BOND DOUBLER PER SRM 51-70-02.SDR AALA20100324TUL05Shear Tie · crackedCRACK IN SHEAR TIE RIGHT SIDE OF FRAME STATION 1380, 3 INCHES ABOVE AND AFT OF CUTOUT OF PYLON. REPAIR DOUBLER WAS INSTALLED PER EA NUMBER MD80-53-009723 DATED 3/19/2010.SDR AALA20100323TUL11Skin · scratchedSCRATCH FOUND APPROXIMATELY 2 FEET BELOW RIGHT FORWARD FUSELAGE STATIONS 118 TO 119. INSTALLED DOUBLER PER SRM 53-04-02.SDR AALA20100323TUL12Longeron · crackedCABIN FORWARD ENTRY STRINGER 4 LEFT CRACKED AT STATION 200 AT LOWER FASTENER. INSTALLED LONGERON 4 LEFT FROM STATION 165 LEFT TO STATION 226 LEFT PER SRM 53-02-00 FIG 18 AND AARD 51-60-00-01.SDR AALA20100323TUL05Pan · corrodedCORROSION AT FORWARD CARGO DOOR LOWER THRESHOLD PAN. REMOVED CORROSION AND INSTALLED DOUBLER PER EA-MD80-53-009771.SDR AALA20100322TUL02Skin · gougedGOUGE ON SKIN AT STATION 225 LONGERON 18 LEFT APPROXIMATELY 4 INCHES LONG. INSTALLED PERMANENT REPAIR INTERNAL DOUBLER PER SRM 53-04-02 AND DWG NUMBER SG09530001.SDR AALA20100322TUL01Skin · gougedDENT WITH GOUGE AT STATION 118 LONGERON 24 RIGHT. INSTALLED INTERNAL DOUBLER PER SRM 53-04-02 AND BOEING DWG NUMBER SG09530001.SDR AALA20100322TUL13Frame · corrodedAFT CARGO HAS CORROSION ON FRAME 1271 BETWEEN LONGERON 29 LEFT TO 29 RIGHT. INSTALLED FILLER AND REPAIR DOUBLER PER SRM 51-30-5.SDR AALA20100322TUL10Cusp Web · corrodedCUSP SHEET RIGHT SIDE FROM STATIONS 218 TO 237 HAS CORROSION AND IS CRACKED AT CENTER LIGHTENING HOLE. REMOVED AND REPLACED CUSP SHEET PER AARD 53-20-00-16.SDR AALA20100322TUL09Membrane · corrodedCABIN FLOOR PAN IS CORRODED STATIONS 200 TO 205 FORWARD OF NUMBER 6 SEAT TRACK. FABRICATED AND INSTALLED SUBFLOOR DIAPHRAGM REPAIR PER AARD 53-20-00-16.SDR AALA20100322TUL07Cusp Web · corrodedLEFT CUSP CORRODED UNDER AFT GIRT BAR SUPPORT BRACKET. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82