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 WX0A070483Cusp Web · corrodedDURING BOW 1C/2C/3C/S1/S2/S4/S5/2A, FOUND CORROSION IN CEILING MEMBRANE ON FWD SIDE OF CABIN FLOORBEAM STA 148, APPROX 10 INCHES RIGHT OF AIRCRAFT CENTER LINE. ADDRESSED AS REQUIRED.SDR WX0A070482Cusp Web · corrodedDURING BOW 1C/2C/3C/S1/S2/S4/S5/2A, FOUND CORROSION ON RT CUSP STA 886 TO 905. ADDRESSED AS REQUIRED.SDR WX0A070481Cusp Web · corrodedDURING BOW 1C/2C/3C/S1/S2/S4/S5/2A, FOUND CORROSION ON CUSP STA 845 TO 864 RT. ADDRESSED AS REQUIRED.SDR AALA20091110LGA04Battery Pack · dischargedEMERGENCY LIGHT AT AFT GALLEY OVERHEAD INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091110LGA03Battery Pack · dischargedEMERGENCY LIGHTS AT TAIL CONE COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091110LGA02Battery Pack · weakEMERGENCY LIGHT BATTERY PACK FOR OVERWING DOOR ARE WEAK. REPLACED BATTERY PACK.SDR AALA20091110LGA01Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK AT FORWARD CABIN WEAK. REPLACED BATTERY PACK.SDR AALA20091108DFW01Duct · blownCREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED DURING CLIMB AT FLIGHT LEVEL 270. LANDED DFW WITHOUT INCIDENT. FOUND RIGHT AIR CONDITIONING SUPPLY DUCT BLOWN. REPLACED THE DUCT ASSEMBLY.SDR AALA20091109LGA01Battery Pack · dischargedEMERGENCY LIGHTS AT SEAT ROWS 3 TO 19 INOPERATIVE. REPLACED BATTERY PACK. OPS CHECK GOOD.SDR AALA20091107DFW03Proximity Sensor · failedCREW REPORTED RIGHT MAIN LANDING GEAR HAD RED INDICATION ON APPROACH. LANDED DFW WITHOUT INCIDENT. REPLACED RIGHT MAIN LANDING GEAR DOWN AND LOCKED PROXIMITY SENSOR.SDR AALA20091108PHX01Battery Pack · dischargedEMERGENCY EXIT LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091107TUL01Drain Pan · crackedGALLEY 1 DRAIN PAN FOUND CRACKED. SUPPORT DOUBLER FOUND CORRODED OUT OF LIMITS. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16 AND REPLACED G1 GALLEY DRAIN PAN PER SRM 51-30.SDR AALA20091107TUL03Tire · damagedINFLIGHT DFW TO MEX. CREW REPORTED SEVERE YAW AT ROTATION. FELT LIKE NOSE GEAR PROBLEM. ALSO CAPTAINS SLIDING WINDOW POSSIBLE CRACK. EMERGENCY DECLARED AND LANDED SAT WITHOUT INCIDENT. NO DEFECTS NOTED WITH LANDING GEAR. REPLACED BOTH NOSE LANDING GEAR TISDR WX0A070457Battery Pack · inoperativeDURING 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 BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20091105MCO01Csd · overheatedCREW REPORTED LEFT CONSTANT SPEED DRIVE GENERATOR OVERHEAT. RIGHT GENERATOR ON MEL. RETURNED TO MCO AND LANDED WITHOUT INCIDENT. REPLACED LEFT CONSTANT SPEED DRIVE GENERATOR.SDR AALA20091104TUL09Attach Angle · brokenLEFT ANTI FLOAT GEAR TAB CONTROL ROD FAIRING UPPER ATTACH ANGLE BROKEN. INSTALLED DOUBLER PER ENGINEERING AUTHORIZATION MD80-55-007984.SDR AALA20091104LGA01Battery Pack · dischargedEMERGENCY LIGHT AT SEAT ROWS 20 TO 32 INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091103TUL14Cusp Web · crackedCRACK IN CUSP MEMBRANE AT STATION 1176 LEFT AND SIDE. INSTALLED NEW CUSP SHEET AT LEFT STATION 1174 TO 1250 PER AARD 53-20-00-16.SDR AALA20091103TUL07Intercostal · crackedINTERCOSTAL CRACKED BETWEEN FLOORBEAMS AT STATION 1289 TO1309. INSTALLED NEW INTERCOSTAL PER SRM 53-01.SDR AALA20091103TUL06Shear Tie · crackedSTATION 1380 FRAME SHEAR-TIE CRACKED BETWEEN LONGERON 13 RT AND LONGERON 14 RT. INSTALLED SHEAR-TIE DOUBLER PER ENGINEERING AUTHORIZATION MD80-53-007956.SDR AALA20091103TUL05Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20091103TUL04Floor Support · crackedFLOORBOARD SUPPORT CRACKED AT STATION 180 LEFT BUTTLINE 15 TO LEFT BUTTLINE 35. INSTALLED NEW SUPPORT PER SRM 51-30-01.SDR AALA20091103TUL01Stiffener · crackedCENTER ANGLE ABOVE VAULT DOOR IS CRACKED AT UPPER FASTENER. COMPLETED STIFFENER INSTALLATION PER SRM CH 51-01-00.SDR AALA20091202TUL10Lens · brokenEMERGENCY LIGHT AT SEAT 4E HAS BROKEN LENS. REPLACED LENS AT SEAT 4E.SDR AALA20091103LGA01Light · inoperativeEMERGENCY LIGHT AT SEAT 7D INOPERATIVE. REPLACED LAMP AT SEAT 7D.SDR AALA20091102TUL11Cusp Web · damagedDAMAGE TO LEFT CUSP AT STATION 1250 TO 1309. INSTALLED NEW CUSP PER AARD 53-20-00-16.SDR AALA20091102TUL07Cusp Web · crackedCRACK IN CUSP AT STATION 1189 LEFT SIDE. REMOVED CRACK AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20091102TUL01Pan · corrodedFORWARD GALLEY FLOOR PAN CORRODED AT STATION 170-200 UNDER PHENOLIC H-CHANNEL AT FORWARD SERVICE DOOR. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20091101TUL02Skin · damagedFUSELAGE HAS A GOUGE ON LEFT SIDE APPROXIMATELY 8 INCHES FORWARD OF PRODUCTION SPLICE STATION 221 JUST BELOW NUMBER 4 LONGERON. INSTALLED DOUBLER AT STATION 216 TO 226 BETWEEN LONGERON 4 AND 6 LEFT SIDE OF AIRCRAFT PER SRM 53-04-00 FIG 12B.SDR AALA20091101LGA03Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS ARE DIM. REPLACED BATTERY PACK.SDR AALA20091101LGA02Battery Pack · not seatedEMERGENCY LIGHT AT OVERWING EXIT SIGN ABOVE WINDOWS INOPERATIVE. RESEATED BATTERY PACK AND LEFT CHARGING. RE-CHECKED BATTERY PACK AND FOUND OPS NORMAL.SDR AALA20091101LGA01Battery Pack · dischargedDURING EGRESS LIGHT TEST FOUND OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 23 THROUGH 27 INOPERATIVE. BATTERY PACK AT SEAT ROW 23 RESEATED AND LEFT CHARGING. RE-CHECKED LIGHT OPERATION AND OPS CHECKS NORMAL.SDR AALA20091031DFW01Actuator · leakingON APPROACH RIGHT HYDRAULIC SYSTEM FAILED. LEFT MAIN LANDING GEAR DOOR DAMAGED ON LANDING. REVERSER UNLOCK LIGHT REMAINED ILLUMINATED. FLUID RETURNED TO 6 AFTER SHUTDOWN AND FLAPS RETRACTED. AIRCRAFT OUT OF SERVICE. REPLACED LEFT MAIN LANDING GEAR DOOR. SDR AALA20091030TUL06Cusp Web · crackedFLOOR PAN CRACKED IN RADIUS STATION 219 OUTBOARD SIDE OF SEAT TRACK 2. INSTALLED NEW CUSP SHEET LEFT STATION 218 TO 237 AND INSTALLED DOUBLER STATION 223 FOR WIRE BUNDLE ACCESS PER AARD 53-20-00-16.SDR AALA20091030TUL05Cusp Web · corrodedCORROSION ON UNDERSIDE OF CUSP SHEET OUTBOARD HOLES FORWARD OF STATION 541, LEFT HAND SIDE OF CABIN. INSTALLED DOUBLER AS PER AARD 53-20-00-16.SDR AALA20091030TUL03Casting · crackedRIGHT GROUND SPOILER ACTUATOR CASTING CRACKED AT OUTBOARD FORWARD LEG. SPOILER CASTING REPLACED PER SRM 51-30.SDR AALA20091030TUL02Fitting · crackedVAULT DOOR HAS A CRACKED ANGLE JUST BELOW THE LOWER LATCH PIN LINK. REMOVED CRACKED FITTING AND INSTALLED NEW PER ESO 80186.SDR AALA20091030MEX01Bearing · damagedON FINAL APPROACH RIGHT ENGINE OIL QUANTITY FELL TO ZERO. OIL TEMP AT RED LINE, PRESSURE NORMAL. CREW SHUT NUMBER TWO ENGINE DOWN. LANDED WITHOUT INCIDENT. FOUND COMBUSTION CHAMBER FUEL DRAIN LEAKING OIL. SUSPECT ENGINE BEARING NR 4 DAMAGED. DOWNLOADED FSDR AALA20091030TUL04Frame · crackedRIGHT 1497 CANTON FRAME CRACKED AT LONGERON 15 RIGHT. REPAIRED DOUBLER INSTALLED PER ENGINEERING AUTHORIZATION MD80-53-007945 DATED 10/29/2009.SDR AALA20091029TUL07Pan · crackedHANDLE PAN ON FORWARD ENTRY DOOR CRACKED. INSTALLED NEW HANDLE PAN PER ESO 80172.SDR AALA20091029TUL05Cusp Web · damagedFOUND AT .375 INCH HOLE IN CUSP AT RIGHT STATION 334. INSTALLED DOUBLER.SDR AALA20091029TUL04Cusp Web · corrodedLEFT HAND CUSP HAS CORROSION AT STATION 1250 TO 1309. CUSP SHEET REMOVED AND NEW SHEET INSTALLED.SDR AALA20091029TUL03Skate Angle · crackedFUSELAGE TO VERTICAL STABILIZER LEFT SKATE ANGLE IS CRACKED BETWEEN FASTENER HOLES. INSTALLED DOUBLER.SDR AALA20091029TUL01Stiffener · crackedVERTICAL STIFFENER CRACKED AT TOP FASTENER HOLE ABOVE VAULT DOOR. REMOVED AND INSTALLED NEW STIFFENER.SDR AALA20091028TUL02Structure · crackedFOUND .3125 INCH CRACK AT LEFT STRUT DOOR AFT HINGE CUTOUT. INSTALLED DOUBLER REPAIR PER 53-05-00.SDR AALA20091028TUL01Slat · damagedRIGHT WING NUMBER 2 SLAT RUBSTRIP LOOSE ON DE-ICE TUBE ACCESS. BLENDED SMOOTH WORN AREA, ALODINED AREA AND FILLED AREAS WITH DEVCON F. RE-ATTACHED RUB STRIP PER ESO 80559 DATED 10/28/09.SDR AALA20091103TUL10Tee Fitting · gougedTOOLING MARKS AND GOUGES STATION 1338 T-CHORD LEFT AND RIGHT SIDES. INSTALLED NEW T-CHORD PER ENGINEERING AUTHORIZATION MD80-53-007388 DATED 27 OCT 09.SDR WX0A070456Seat Track · corrodedDURING BOW 1C/2C/S1/S2/S4, SEAT TRACK NR 2 HAS CORROSION STA 1150-1200, NEW SEAT TRACK INSTALLED PER SRM 53-05. ADDRESSED AS REQUIRED.SDR WX0A070455Cusp Web · corrodedDURING BOW 1C/2C/S1/S2/S4, LT CUSP HAS AREAS OF CORROSION. ADDRESSED AS REQUIRED.SDR WX0A070454Seat Track · corrodedDURING BOW 1C/2C/S1/S2/S4, NR 2 SEAT TRACK HAS AREAS OF CORROSION. ADDRESSED AS REQUIRED.
Back to Mcdonnell Douglas DC-9-82