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 AALA20101113TUL02Attach Fitting · damagedFLOORBEAM ATTACH FITTING (CASTING) AT STATION 294 LEFT UNDER NUMBER 1 SEAT FLOORBEAM ATTACH FITTING (CASTING) AT STATION 294 LEFT UNDER NUMBER 1 SEAT TRACK HAS DAMAGE ON UPPER AFT SIDE FLANGE. INSTALLED FLOORBEAM FITTING AT STATION 294 LEFT SRM 51-30-05 AND ESDR AALA20101113TUL08Pan · crackedWINDOW PAN UPPER AFT CORNER IS CRACKED AT STATION 1022. INSTALLED REPAIR DOUBLER AT LEFT SIDE STATION 1022 PER AARD 53-10-00-25.SDR AALA20101113TUL07Pan · crackedCRACK AT AFT TOP CORNER OF LEFT WINDOW FRAME, STATION 1022. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101113TUL06Pan · crackedWINDOW PAN UPPER AFT CORNER IS CRACKED AT STATION 1079. INSTALLED DOUBLER AT RIGHT WINDOW PAN STATION 1079 PER AARD 53-10-00-25.SDR AALA20101113TUL05Pan · crackedCRACK IN WINDOW PAN AT RIGHT LOWER FORWARD CORNER STATION 946. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101113TUL04Pan · crackedCRACK IN WINDOW PAN AT RIGHT UPPER FORWARD CORNER STATION 946. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20101113TUL01Cusp Web · corrodedLEFT CUSP STATIONS 636 TO 655 HAS CORROSION THAT IS OUT OF LIMITS. CUT OUT DAMAGE PER AARD 53-20-00-16 AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101112TUL10Fitting · corrodedNUMBER 1 GALLEY TIE DOWN FITTING CORRODED. REPLACED TIE DOWN FITTING PER 51-30-05.SDR AALA20101112AFW01Strut · flatDFW - CAPTAIN RECEIVED UNSAFE NOSE GEAR INDICATION AND NOSE LANDING GEAR WOULD NOT RETRACT. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. THE NOSE GEAR WAS FLAT ON ARRIVAL. AIRCRAFT REMOVED FROM SERVICE. REPACKED NOSE STRUT ASSEMBLY. LEAK CHECK AND GEAR SWSDR AALA20101113LGA01Battery Pack · dischargedCEILING BATTERY PACK INOPERATIVE. REPLACED BATTERY PACK AT CEILING.SDR AALA20101112TUL14Cusp Web · damagedHOLE IN LEFT CUSP STATION 294. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101112TUL13Cusp Web · corrodedCORROSION ON LEFT CUSP AT NUMBER 1 SEAT TRACK, STATIONS 1174 TO 1178. INSTALLED NEW CUSP SHEET, LEFT SIDE, BETWEEN NUMBER 1 AND NUMBER 2 SEAT TRACKS, STATIONS 1174 TO 1250 PER AARD 53-20-00-16 AND AARD 51-10-00-5.SDR AALA20101112TUL12Cusp Web · corrodedCORROSION ON LEFT CUSP UNDER AFT SERVICE DOOR, FORWARD GIRT BAR BRACKET, STATION 1140. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101112TUL03Intercostal · crackedAFT CARGO - INTERCOSTAL CRACKED, BELOW CABIN FLOOR ON CENTER LINE, STATION 1271 TO 1287. REPLACED INTERCOSTAL PER AARD 51-10-00-5.SDR AALA20101112TUL02Intercostal · crackedAFT CARGO - INTERCOSTAL CRACKED, BELOW CABIN FLOOR ON CENTER LINE, STATION 1287 TO 1309. REPLACED INTERCOSTAL PER AARD 51-10-00-5.SDR AALA20101112TUL01Cusp Web · corrodedCORROSION ON THE LEFT CUSP UNDER THE AFT SERVICE DOOR AFT GIRT BAR SUPPORT BRACKET AT STATION 1168. LEFT CUSP UNDER AFT SERVICE DOOR AFT GIRT BAR SUPPORT BRACKET AT STATION 1168 WAS REPAIRED WITH DOUBLER PER AARD 53-20-00-16.SDR EE4Y1112490Spar Cap · crackedDURING STRUCTURAL INSPECTION COOPESA REPORTED LT WING REAR SPAR LOWER CAP AFT FLANGE WITH CORROSION AND CRACKED AT STA XRS 172.SDR AALA20101111TUL18Fitting · corrodedLOWER FITTING AT STATION 1155 OUTBOARD OF DOOR BEAM CORRODED. REPLACED FITTING PER SRM 51-01-00.SDR AALA20101111TUL17Stop Fitting · crackedAFT VAULT DOOR JAMB, DOOR STOP CRACKED, LEFT SIDE MIDDLE STOP. REMOVED CRACKED FITTING, DRILLED UP NEW FITTING AND INSTALLED PER AARD 51-10-00-3.SDR AALA20101111TUL13Membrane · puncturedSUBFLOOR HAS PUNCTURE AT STATION 198 FORWARD OF NUMBER 3 SEAT TRACK. REMOVED DAMAGE INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20101111TUL11Support Angle · corrodedLOWER SUPPORT ANGLE AT STATION 1155 OUTBOARD OF DOOR BEAM IS CORRODED. BLENDED AND REMOVED CORROSION PER SRM 51-10-03. CORROSION OUT OF LIMITS PER SRM 53-01-00. REMOVED DAMAGED ANGLE AND INSTALLED A NEW ONE PER AARD 51-10-00-5. TREATED AND PRIMED PER SRM 5SDR AALA20101111TUL10Bracket · corrodedAFT CARGO HAS CORROSION ON VERTICAL CORNER BRACKET IN DOOR OPENING AT STATION 1155 NEXT TO LOWER BEAM. BLENDED AND REMOVED CORROSION PER SRM 51-10-03 FOUND TO BE OUT OF LIMITS PER SRM 53-01-00. REMOVED DAMAGED CLIP AND REPLACED WITH A NEW ONE PER AARD 51-10-SDR AALA20101111ORD01Probe · inoperativeORD - INFLIGHT DFW-MSP. CAPTAIN REPORTED RUDDER LIMITER LIGHT ILLUMINATED DURING CRUISE. FLIGHT DIVERTED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RUDDER LIMITER HEATER PROBE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101110TUL11Pan · damagedSTATION 946 LOWER FORWARD WINDOW PAN CRACKED LEFT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101111TUL01Intercostal · crackedAFT CARGO DOOR FORWARD LOWER SUPPORT STRAP INTERCOSTAL IS CRACKED. DWMS NR1440044, MRT 028756, INSTALLED NEW SUPPORT STRAP INTERCOSTAL PER ESO 80174.SDR AALA20101110TUL15Tie Down · corrodedCORROSION ON NUMBER 2 GALLEY TIE DOWN FITTING AT STATION 218 INBOARD OF NUMBER 4 SEAT TRACK. (MKD) INSTALLED NEW SERVICEABLE G-2 GALLEY TIE DOWN SUPPORT FITTING AT STATION 218 PER AARD 51-10-00-5.SDR AALA20101110TUL14Tie Down · corrodedCORROSION ON NUMBER 2 GALLEY TIE DOWN FITTING AT STATION 208 INBOARD OF NUMBER 4 SEAT TRACK. (MKD) INSTALLED NEW SERVICEABLE G-2 GALLEY TIE DOWN SUPPORT FITTING AT STATION 208 PER AARD 51-10-00-5.SDR AALA20101110TUL12Skate Angle · crackedFUSELAGE, LEFT SIDE, TOP AFT END OF PYLON, CRACK IN SKATE ANGLE DOUBLER THROUGH FASTENER. INSTALLED DOUBLER PER AARD 54-20-00-1.SDR AALA20101110TUL10Pan · damagedSTATION 946 UPPER FORWARD WINDOW PAN CRACKED LEFT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101110TUL09Pan · damagedSTATION 1060 LOWER FORWARD WINDOW PAN CRACKED LEFT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101110TUL08Pan · damagedSTATION 1098 UPPER AFT WINDOW PAN CRACKED LEFT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101109TUL09Skin · dentedOUTER SKIN ON AFT CARGO DOOR (AAID BBDPZCR) HAS DENT APPROXIMATELY 10 INCHES FROM AFT EDGE BETWEEN NUMBER 3 AND 4 BEAMS. BLENDED AREA OF DENT TO REMOVE SHARP EDGES. DYE CHECKED DENTED AREA AND FOUND NO CRACK INDICATIONS. FABRICATED AND INSTALLED INTERNAL RSDR AALA20101109TUL03Skin · dentedDENT IN FUSELAGE SKIN 1 INCH BY 1.5 INCH BY .063 AT STATION 210 STRINGER 15 LEFT WITHIN SRM 53-04-00 LIMITS. INSTALLED DOUBLER PER AARD 53-30-00-9 AND SRM 53-04-00 FIGURE 12B.SDR AALA20101110TUL07Cusp Web · crackedCUSP SHEET CRACKED AT RIGHT HAND STATIONS 218 TO 223 UNDER SEAT TRACK NUMBER 6. INSTALLED SERVICEABLE CUSP SHEET FROM STATIONS 218 TO 237 RIGHT PER AARD 51-10-00-5.SDR AALA20101108TUL08Cusp Web · corrodedSTATION 460 RIGHT CUSP HAS CORROSION. DOUBLER INSTALLED PER AARD 53-20-00-16.SDR AALA20101108TUL07Cusp Web · corrodedSTATIONS 512 TO 513 LEFT CUSP HAS CORROSION. DOUBLER INSTALLED PER AARD 53-20-00-16.SDR AALA20101108TUL04Frame · crackedCANT FRAME 1474 IS CRACKED AT RIVETS AT LONGERON 18 RIGHT AREA AFT ACCESSORY COMPARTMENT. COMPLETED INSTALLATION OF DOUBLER PER EA MD-80-53-013941.SDR AALA20101108TUL02Cusp Web · corrodedFORWARD CARGO - BOTTOM SURFACE OF RIGHT CUSP IS CORRODED STATIONS 503 TO 513. INSTALLED NEW DOUBLER AT RIGHT STATIONS 503 TO 522 CUSP PER AARD 53-20-00-16.SDR AALA20101108TUL01Seat Track · corrodedFIRST OFFICERS OUTBOARD SEAT TRACK IS CORRODED. INSTALLED FIRST OFFICERS OUTBOARD AFT SEAT TRACK PER AARD 51-10-00-5.SDR AALA20101108LGA01Light · inoperativeEMERGENCY LIGHT AT SEAT 28D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 28D. OPS CHECK NORMAL.SDR AALA20101107TUL04Cusp Web · corrodedLEFT CUSP STATIONS 488 TO 500 CORROSION OUT OF LIMITS. CUT OUT CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101107DFW16Compressor · stalledDFW - CREW REPORTED LEFT ENGINE COMPRESSOR STALLED (SINGLE ENGINE TIME 10 MINUTES). EMERGENCY DECLARED RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. LEFT ENGINE CHANGED ON 11/09/2010 AT DFW. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101107TUL03Cusp Web · damagedCABIN HAS CORROSION IN SUB FLOOR WEBBING OUTBOARD OF AFT SERVICE DOOR AFT GIRT BAR SUPPORT BRACKET. INSTALLED CUSP SPLICE REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20101107TUL02Intercostal · crackedINTERCOSTAL CRACKED JUST RIGHT OF CENTER STATIONS 1287 TO 1309 BETWEEN CABIN FLOORBEAMS. INSTALLED NEW INTERCOSTAL AT STATIONS 1287 TO 1309 PER SRM 51-30-05.SDR AALA20101107TUL01Cusp Web · corrodedFORWARD CARGO - BOTTOM SURFACE OF RIGHT CUSP IS CORRODED STATIONS 503 TO 513. INSTALLED NEW DOUBLER REPAIR AT RIGHT STATIONS 503 TO 522 CUSP PER AARD 53-20-00-16.SDR AALA20101107LGA01Battery · not seatedDURING ROUTINE EMERGENCY LIGHT TEST FOUND AFT ACCESSORY COMPARTMENT EMERGENCY OVERHEAD LIGHTS INOPERATIVE. RESEATED BATTERIES IN EMERGENCY LIGHT BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20101106TUL04Membrane · corrodedCORROSION ON UPPER SURFACE OF SUBFLOOR, STATIONS 160 TO 162, RIGHT BUTTLINES 10 TO 12. CUT OUT CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101106TUL03Cusp Web · corrodedCORROSION ON LEFT CUSP STATIONS 989 TO 992. ROUTED OUT CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20101106TUL02Beam · corrodedDOOR BEAM HAS CORROSION STATIONS 1155 TO 1211. INSTALLED DOUBLERS ON AFT CARGO DOOR BEAM PER AARD 53-10-00-3 AND EA MD80-013913.SDR AALA20101106TUL01Bracket · corrodedAFT CARGO DOOR JAM, STATION 1155, LOWER CORNER BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM 51-30-01.
Back to Mcdonnell Douglas DC-9-82