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 AALA20090826LGA03Battery Pack · failedEMERGENCY LIGHT BATTERY PACK AT BIN 20 FAILED TEST. REMOVED AND REPLACED LOWER BATTERY AT BIN 20. OPS NORMAL.SDR AALA20090826LGA02Charger · failedEMERGENCY LIGHT CHARGER FAILED TEST AT OVERHEAD BIN 20. REMOVED AND REPLACED CHARGER AT BIN 20. OPS NORMAL.SDR AALA20090826LGA01Battery · looseEMERGENCY LIGHTS OVER THE TWO REAR OVERWING EXIT ARE INOPERATIVE. RESEATED BATTERY AND OPS IS NORMAL.SDR AALA20090825BNA01Charger · failedBNA - INFLIGHT DCA-DFW. BATTERY CHARGER ILLUMINATED INFLIGHT. EMERGENCY DECLARED, LANDED AT BNA WITHOUT INCIDENT. REMOVED AND REPLACED BATTERY CHARGER BREAKER AND BOTH BATTERIES IN ACCORDANCE WITH MD80 AMM 24-30-01-4 AND 30-02-2. OPS CHECK GOOD OK FOR SERVSDR AALA20090825TUL38Seat Track · corrodedSEAT TRACK NUMBER 2 STATION 1198-1201 OUT OF LIMITS DUE TO CORROSION. REPLACED SEAT TRACK UNDER SRM 53-05 FIG 4F.SDR AALA20090825TUL37Support Angle · damagedCUSP SUPPORT ANGLE BRACKET AT STATION 824 DAMAGED DURING REMOVAL. REPAIRED UNDER EA MD80 53-007229.SDR AALA20090825TUL36Casting · crackedGROUND SPOILER ACTUATOR MOUNT CASTING IS CRACKED. REPLACED CASTING UNDER SRM 51-01-00.SDR AALA20090825TUL34Fitting · corrodedAFT CARGO DOORWAY FORWARD INBOARD CORNER FITTING IS CORRODED BEYOND LIMITS. REPLACED FITTING UNDER AARD 51-00-00-012.SDR AALA20090825TUL33Cap · crackedCAP IS CRACKED AT VERTICAL FLANGE STATION 846 BELOW NUMBER 5 SEAT TRACK. REPAIRED UNDER EA MD80 57-007195.SDR AALA20090825TUL13Beam · corrodedAFT CARGO DOOR BEAM HAS CORROSION STATION 1155-1211. REPAIRED UNDER AARD 53-10-00-3.SDR AALA20090824LGA01Module · malfunctionedFAILED SECTION 7 WORK CARD 5403 - SEAT MOUNTED ESCAPE PATH LIGHTING - DUAL FEED CHECK. REPLACED FLOOR PATH LIGHTING CONTROL MODULE AND 4 BATTERY PACKS.SDR AALA20090823DFW01Pump · faultyDFW - ON CLIMBOUT CENTER TANK FUEL WOULD NOT TRANSFER. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND AFT CTR BOOST PUMP CIRCUIT BREAKER POPPED. WITH LEFT AND RIGHT FUEL PUMPS OFF, CTR FUEL WOULD TRANSFER. REPLACED CENTER AFT BOOST PUMP UNDER AMM 28-20SDR AALA20090823LGA03Shield · missingFORWARD UPPER FLASHLIGHT SAFETY SHIELD MISSING. REPLACED SAFETY SHIELD FOR FORWARD UPPER FLASHLIGHT.SDR AALA20090823LGA02Strap · missingAFT RIGHT LAVATORY OUTSIDE FORWARD EMERGENCY FLASHLIGHT MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT RIGHT LAVATORY OUTSIDE FORWARD.SDR AALA20090823LGA01Strap · missingEMERGENCY FLASHLIGHT AT AFT RIGHT LAVATORY MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT RIGHT LAVATORY.SDR AALA20090825TUL41Cusp Web · crackedCUSP AT STATION 815 IS CRACKED. REPAIRED UNDER AARD 53-20-00-16.SDR AALA20090825TUL39Cusp Web · corrodedRIGHT CUSP AT STATION 469 CORROSION IS OUT OF LIMITS. REPAIRED UNDER AARD 53-20-00-16.SDR AALA20090825TUL17Cusp Web · corrodedSTATION 1193 LEFT CUSP LOWER SIDE HAS AREA OF CORROSION. INSTALLED CUSP SHEET STA 1179-1200 UNDER SRM 53-20-00-16.SDR AALA20090825TUL08Stiffener · crackedCRACK AT TOP OF VERTICAL STIFFENER TOP CENTER OF AFT BULKHEAD. STOP DRILLED CRACK AND INSTALLED DOUBLER UNDER AARD 53-10-00-15.SDR AALA20090825TUL02Strap · corrodedCORROSION ON STRAP STATION 1212. REPLACED STRAP UNDER EA 53007201 AND SRM 53-01-00.SDR AALA20090822LGA02Battery · not seatedEMERGENCY LIGHT IN TAIL COMPARTMENT INOPERATIVE. RESEATED BATTERIES IN AFT LAVATORY. OPS CHECK GOOD PER MM.SDR AALA20090822LGA01Light · inoperativeEMERGENCY EXIT LIGHT FLOOR LEVEL BY FORWARD LAVATORY INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT FORWARD GALLEY EXTERIOR OPPOSITE LAVATORY. OPS CHECK GOOD.SDR AALA20090821LGA03Light · inoperativeEMERGENCY LIGHT ASSEMBLY BY LEFT NUMBER 1 DOOR IS NOT WORKING. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY BY LEFT NUMBER 1 DOOR. OPS CHECK GOOD.SDR AALA20090821LGA02Light · missingMISSING 22D SEAT MOUNTED ESCAPE PATH LIGHT BULBS. REPLACED LAMP AT 22D SEAT MOUNTED ESCAPE PATH LIGHT, OPS CHECK GOOD.SDR AALA20090821LGA01Lens · missingMISSING 22D SEAT MOUNTED ESCAPE PATH LIGHT LENS. INSTALLED 22D SEAT MOUNTED ESCAPE PATH LIGHT LENS AS REQUIRED.SDR AALA20090825TUL16Doubler · corrodedCORROSION ON CUTOUT FOR RADIO ANTENNA STATION 605 LONGERON 30. INSTALLED NEW ANTENNA DOUBLER UNDER SRM 51-30-2 AND 51-30-05.SDR AALA20090825TUL15Beam · corrodedCORROSION ON LOWER CARGO DOOR BEAM, STATION 640-688. INSTALLED DOOR JAMB DOUBLER UNDER AARD 53-10-00-3.SDR AALA20090825TUL14Membrane · corrodedCORROSION ON SUBFLOOR AT RIGHT STATION 218 UNDERNEATH GALLEY MOUNT FITTING, OUT OF LIMITS. INSTALLED REPAIR DOUBLER UNDER AARD 53-20-00-16.SDR AALA20090825TUL11Cap · crackedSTATION 826 RIGHT UPPER SKIN CAP CRACKED AT FORWARD END OF INTERCOSTAL BELOW NUMBER 5 SEAT TRACK. STOP DRILLED CRACK AND INSTALLED REPAIR ANGLE UNDER EA MD80 57-007195 DATED 8/20/09.SDR AALA20090825TUL09Cusp Web · corrodedCUSP LEFT STATION CORRODED OUT OF LIMITS. INSTALLED REPAIR DOUBLER UNDER AARD 53-20-00-16.SDR AALA20090825TUL07Cusp Web · crackedCUSP IS CRACKED BETWEEN LIGHTENING HOLES RIGHT STATION 220-222. REPLACED CUSP UNDER AARD 53-20-00-16.SDR AALA20090825TUL06Cusp Web · corrodedCORROSION ON CUSP BELOW AFT SERVICE DOOR FORWARD GIRT BAR FITTING. INSTALLED DOUBLER UNDER AARD 53-20-00-16.SDR AALA20090825TUL05Cusp Web · corrodedLEFT CUSP STATION 527 CORROSION. INSTALLED REPAIR UNDER AARD 53-20-00-16.SDR AALA20090825TUL04Structure · damagedTEMPORARY DOUBLER INSTALLED ON FUSELAGE STAION 522. INSTALLED PERMANENT REPAIR UNDER SRM 53-04 FIG 12B.SDR AALA20090825TUL40Pressure Panel · crackedRIGHT WHEEL WELL UPPER PRESSURE DECK IS CRACKED AT FUEL SHROUD SUPPORT AT STATION 997. REPAIRED UNDER SRM 53-01-00 FIG 2.SDR AALA20090825TUL26Cusp Web · corrodedLEFT CUSP CORRODED OUT OF LIMITS AT STATION 670. INSTALLED REPAIR DOUBLER UNDER AARD 53-20-00-16.SDR AALA20090825TUL25Seat Track · damagedSEAT TRACK GOUGED AT STATION 1100 ON SEAT TRACK NUMBER 4. INSTALLED SEAT TRACK PLUG AT STATION 1100 ON SEAT TRACK NUMBER 4 UNDER AARD 53-20-00-10.SDR AALA20090825TUL24Pan · corrodedCORROSION ON FORWARD CARGO LOWER DOOR PAN. INSTALLED NEW FORWARD CARGO LOWER DOOR PAN UNDER SRM 53-05-00.SDR AALA20090825TUL23Floorbeam · damagedFLOORBEAM AT STATION 1098 UNDER SEAT TRACK NUMBER 4 IS DAMAGED. INSTALLED DOUBLER ON FLOORBEAM AT STATION 1098 UNDER EA MD80-53-007159.SDR AALA20090819TUL13Cusp Web · damagedELONGATED HOLE IN RIGHT CUSP AT STATION 245. INSTALLED DOUBLER UNDER SRM 53-14-02.SDR AALA20090921TUL15Battery Pack · dischargedEMERGENCY AISLE LIGHTING WEAK. REPLACED BATTERY PACK.SDR AALA20090818BNA01Regulator Valve · inoperativeBNA - INFLIGHT DCA-DFW. ICE PROTECT PRESSURE ABNORMAL LIGHT ILLUMINATED. EMERGENCY DECLARED, LANDED BNI WITHOUT INCIDENT. REPLACED PRESSURE REGULATING VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090819TUL16Longeron · crackedLONGERON L4 CRACKED INBOARD AND OUTBOARD SIDES AT STATION 200. INSTALLED NEW LONGERON FROM STATION 170 TO 229 UNDER SRM 53-02-00.SDR AALA20090819TUL15Pan · crackedFORWARD LOWER WINDOW PAN TAB CRACKED RIGHT SIDE AT STATION 826. INSTALLED REPAIR ANGLE UNDER AARD 53-10-00-25.SDR AALA20090819TUL07Bracket · corrodedAFT SERVICE DOOR AFT GIRT BAR BRACKET HAS CORROSION. REPLACED GIRT BAR BRACKET UNDER SRM 51-01.SDR AALA20090819TUL06Web · corrodedCORROSION ON SUBFLOOR AT FORWARD END OF NUMBER 6 SEAT TRACK. INSTALLED DOUBLER UNDER AARD 53-20-00-25.SDR AALA20090819TUL05Pan · crackedWINDOW PAN CRACKED AT STATION 1041. INSTALLED REPAIR ANGLE UNDER AARD 53-10-00-25.SDR AALA20090819TUL04Pan · crackedWINDOW PAN CRACKED AT STATION 1098. INSTALLED REPAIR ANGLE UNDER AARD 53-10-00-25.SDR AALA20090819TUL03Intercostal · crackedCARGO CEILING INTERCOSTAL CRACKED. INSTALLED NEW INTERCOSTAL AT STATION 1041 UNDER SRM 51-30-05.SDR AALA20090819TUL01Pan · crackedWINDOW PAN CRACKED AT STATION 826. INSTALLED REPAIR ANGLE UNDER AARD 53-10-00-25.
Back to Mcdonnell Douglas DC-9-82