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 AALA200810417Bracket · crackedNUMBER 3 SEAT TRACK LOWER SUPPORT BRACKET CRACKED AT STATION 864. REMOVED AND REPLACED WITH SERVICEABLE BRACKET.SDR AALA200802572ACsd · failedMSY INFLIGHT DFW TO TPA. CREW REPORTED RIGHT HAND CONSTANT SPEED DRIVE LOW PRESSURE INDICATION. APU WOULD NOT START. DIVERTED TO MSY AND LANDED WITHOUT INCIDENT. REPLACED CONSTANT SPEED DRIVE. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200810424Cusp Web · corrodedCORROSION ON CUSP STATION 560 TO 579, LEFT SIDE. REPAIRED PER AARD 53-20-00SDR AALA200810423Stiffener · crackedSTIFFENER CRACKED ABOVE VAULT DOOR JAMB O TOP FORWARD SIDE STATION 1338. REPAIRED PER AARD 53-10-00-15.SDR AALA200810422Cusp Web · corrodedCORROSION ON CUSP STATION 579 TO 598 LEFT SIDE. REPAIRED PER AARD 53-20-00-16.SDR AALA200820421Cusp Web · corrodedCORROSION ON CUSP STATION 1022, LEFT SIDE. REPAIRED PER SRM 53-20-00-16.SDR AALA200810433Intercostal · crackedCENTER WING, INTERCOSTAL LOWER SUPPORT ANGLE CRACKED STATION 825. REPAIRED PER ESO 80559 DATED 11-21-08.SDR AALA200810447Bracket · corrodedCORROSION ON TOP OF GIRT BAR BRACKET, AFT SERVICE DOOR, FORWARD BRACKET. REPLACED GIRT BAR BRACKET.SDR AALA200810432Seat Track · corrodedCORROSION ON NUMBER 1 SEAT TRACK STATION 470. INSTALLED REPAIR PLUG AARD 53-20-00-10.SDR AALA200810425Attach Angle · crackedFORWARD CARGO, RIGHT SIDE STATION 237 INTERCOSTAL ATTACH ANGLE AT FRAME BELOW TIE DOWN TRACK IS CRACKED. REMOVED AND REPLACED WITH SERVICEABLE ANGLE PER SRM 51-01-00.SDR AALA200810438Seat Track · corrodedNR 3 SEAT TRACK HAS CORROSION OUT OF LIMITS. REMOVED CORROSION, ROUTED AND INSTALLED SEAT TRACK PLUG.SDR AALA200810437Seat Track · corrodedNR 6 SEAT TRACK CORROSION OUT OF LIMITS STATION 855 TO STATION 857. REMOVED CORROSION ROUTED AND INSTALLED SEAT TRACK PLUG.SDR AALA200810436Seat Track · corrodedNR 6 SEAT TRACK CORROSION OUT OF LIMITS STATION 933 TO STATION 936. REPAIRED DAMAGE BY INSTALLING PLUG PER AARD 53-20-00-10.SDR AALA200810435Cusp Web · corrodedCORROSION ON CUSP FROM STATION 1164 TO STATION 1178. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810434Cusp Web · corrodedCORROSION TOP LEFT CUSP FROM STATION 1136 TO STATION 1174. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810100Angle · crackedSUPPORT ANGLE IN STRUCTURAL RIB CRACKED OUTBOARD OF ANTI FLOAT TAB PUSH ROD CRANK IN RIGHT ELEVATOR. REPLACED CRACKED RIB AND CLIP.SDR AALA200802534AStrap · brokenLGA - EMERGENCY FLASHLIGHT AT FORWARD CABIN UPPER POSITION HAS BROKEN SAFETY STRAP. REPLACED SAFETY STRAP AT FLASHLIGHT AT FORWARD CABIN UPPER POSITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810431Window Frame · crackedWINDOW FRAME, CRACK IN FRAME AFT TOP CORNER RIGHT SIDE STATION 1060. REPAIRED PER AARD 53-10-00-25.SDR AALA200810430Window Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP CORNER RIGHT SIDE STATION 927. REPAIRED PER AARD 53-10-00-25.SDR AALA200810429Window Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP AFT CORNER RIGHT SIDE STATION 1079. REPAIRED PER AARD 53-10-00-25.SDR AALA200810428Window Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP CORNER RIGHT SIDE STATION 886. REPAIRED PER AARD 53-10-00-25.SDR AALA200810427Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP CORNER LEFT SIDE STATION 1098. REPAIRED PER AARD 53-10-00-25.SDR AALA200810426Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP CORNER LEFT SIDE STATION 1060. REPAIRED PER AARD 53-10-00-25.SDR AALA200810193Casting · crackedGROUND SPOILER ACTUATOR CASTING CRACKED FORWARD INBD CORNER, LEFT GROUND SPOILER. INSTALLED REPAIR DOUBLER PER AARD 57-20-00-15.SDR AALA200810182Frame · crackedCANT FRAME CRACKED AT LOWER TAILCONE ALIGNMENT PIN, STATION 1510, LEFT. REPAIRED PER ESO80559 DATED 11-17-08.SDR AALA200810032Diaphragm · corrodedCORROSION ON DIAPHRAGM UNDER G-1 GALLEY DRAIN PAN. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA208810181Skin · cracked2 CRACKS IN SKIN AT STATION 1380 RT BETWEEN LONGERON 13R AND 14R. INSTALLED DOUBLER PER SRM 53-01-00.SDR AALA200810180Frame · crackedFRAME AT STATION 1418 CRACKED AT LONGERON 2L. REPAIRED PER ESO80559 DATED 11-14-08.SDR AALA200810188Angle · corrodedCORROSION ON HORIZONTAL LEG OF AFT CARGO DOOR BEAM AT STATION 1174 TO 1211. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA200810176Frame · chafedAFT ACCESSORY AREA, FRAME 1361 HAS HOLE FROM BRAIDED LINE CHAFING AT LONGERON 19L. INSTALLED SPLICE REPAIR PER SRM 53-03-00.SDR AALA200802524APlacard · missingDFW - EMERGENCY LIGHT PLACARD IN FRONT OF SEAT 21A MISSING. REPLACED PLACARD IN FRONT OF SEAT 21A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802523AShroud · missingDFW - EMERGENCY LIGHT SHROUD MISSING AT SEAT 31D. REPLACED SHROUD FOR SEAT 31D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802519ARegulator · failedSTL - INFLIGHT DTW TO DFW - CREW REPORTED LOSS OF CREW OXYGEN. LANDED STL WITHOUT INCIDENT. REPLACED PRESSURE REGULATOR FOR CAPTAINS OXYGEN AND REPLACED OXYGEN BOTTLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810187Pan · corrodedCORROSION ON FORWARD CARGO LOWER DOOR PAN. INSTALLED NEW LOWER SECTION OF THRESHOLD PAN, FOR FORWARD CARGO, PER SRM 53-05-00.SDR AALA200810177Battery Pack · weakCABIN EMERGENCY BATTERY PACK BS-104 AT STATION 902R ARMING VOLTAGE WEAK. REPLACED BATTERY PACK WITH SERVICEABLE PACK.SDR AALA200810197Battery Pack · weakEMERGENCY LIGHT BATTERY PACK WEAK AT STATION 160L. INSTALLED NEW BATTERY PACK.SDR AALA200810196Battery Pack · weakMID CABIN EMERGENCY LIGHT BATTERY PACK WEAK AT STATION 500R. INSTALLED NEW BATTERY PACK.SDR AALA200810195Battery Pack · weakMID CABIN BATTERY PACK INOP RIGHT SIDE STATION 671. REPLACED WEAK BATTERY PACK .SDR AALA200810194Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK BS-107 STATION 1190R INOP. REPLACED DEFECTIVE BATTERY PACK WITH SERVICEABLE PACK.SDR AALA200810179Frame · crackedFRAME AT STATION 1418 AT 2R FORWARD SIDE CRACKED. REPAIRED PER ESO80559 DATED 11-11-08SDR AALA200810178Frame · crackedFRAME AT STATION 1418 AT LONGERON 2R AFT SIDE CRACKED. REPAIRED FRAME PER ESO80559 DATED 11-11-08.SDR AALA200810235Intercostal · corrodedCORROSION ON OUTFLOW VALVE SUPPORT STRUCTURE AT STATION 1275 NEAR LONGERON 21 LEFT. REMOVED AND REPLACED INTERCOSTAL FROM STATION 1271-1287 PER SRM 51-30-05.SDR AALA200810232Mount Fitting · corrodedGALLEY MOUNT FITTING CORRODED STATION 218 OUTBOARD OF NR 5 SEAT TRACK. INSTALLED NEW GALLEY MOUNT FITTING.SDR AALA200810231Longeron · corrodedLONGERON 30 CORRODED AT STATION 446-465. INSTALLED LONGERON "U" CHANNEL SPLICE IN LONGERON 30 PER SRM 53-02-00.SDR AALA200810002Cusp Web · crackedLEFT CUSP CRACKED AT LIGHTING HOLES. CUSP AREA REPAIRED PER AARD 53-20-00-16.SDR AALA200810234Cargo Track · corrodedRIGHT CARGO TIE DOWN TRACK CORRODED STATION 1231-1271. REPLACED TIE DOWN TRACK FORM STATION 1212 TO 1322.SDR AALA200810230Cusp Web · corrodedCORROSION ON RIGHT CUSP MEMBRANE STATION 560-579. INSTALLED NEW CUSP MEMBRANE STATION 503-598.SDR AALA200810200Stringer · corrodedLONGERON 29 LEFT CORRODED FROM STATION 484 TO 494. INSTALLED LONGERON REPAIR PER ESO 80559 DATED 11/04/2008.SDR AALA200810199Stringer · corrodedLONGERON 30 CORRODED FROM STATION 465-494. INSTALLED LONGERON REPAIR AT STATION 465-494 PER ESO 80559 DATED 11/04/2008.SDR AALA200810198Frame · crackedFRAME AT STA 1418 L-2L TO L-2R HAS CRACKS. INSTALLED DOUBLER AND RADIUS BLOCK PER AARD 53-10-00-17.
Back to Mcdonnell Douglas DC-9-82