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 AALA20090406TUL55Cusp Web · corrodedCORROSION ON LEFT CUSP STATION 1060-1098. INSTALLED DOUBLER PER EA MD80-53-005855 AND AARD 53-20-00-16.SDR AALA20090406TUL54Mount · corrodedFORWARD OUTBOARD G-2 GALLEY MOUNT BRACKET CORRODED AND BLENDED OUT OF LIMITS. INSTALLED NEW G-2 GALLEY MOUNT PER SRM 51-30-00.SDR AALA20090415TUL01Floor Support · crackedCRACK ON FLOORBOARD SUPPORT BRACKET AT STATION 927. INSTALLED NEW FLOORBOARD SUPPORT BRACKET PER SRM 51-01-00.SDR AALA20090409TUL04Bracket · corrodedAFT SERVICE DOOR, FORWARD GIRT BAR FLOOR SUPPORT BRACKET AND SPACERS ARE CORRODED. INSTALLED NEW GIRT BAR SUPPORT BRACKET AND SPACERS PER SRM 51-30-05.SDR AALA20090408TUL02Frame · crackedCANT FRAME 1418 CRACKED AT LONGERON 2R. INSTALLED REPAIR DOUBLER ON FRAME 1418 AND SPLICE ON LONGERON 2R PER SRM 51-30-05 AND AARD 53-30-00-2.SDR AALA2009032600002Switch · inoperativeBNA - INFLIGHT DFW-LGA. CREW REPORTED PRESSURIZATION LOSS. MASKS DID NOT DEPLOY. EMERGENCY DECLARED, LANDED BNA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BOTH SECOND SEGMENT CLIMB PRESSURE SWITCHES. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009032600001Downlock Sensor · defectiveDFW - NOSE LANDING GEAR UNSAFE INDICATION ON DESCENT. EMERGENCY DECLARED, LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED NOSE GEAR DOWN LOCK SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090626TUL04Floor Support · crackedFLOORBOARD SUPPORT CRACKED UNDER NUMBER 4 SEAT TRACK STATION 905. REMOVED AND REPLACED FLOORBOARD SUPPORT PER SRM 51-01-06.SDR AALA20090406TUL57Frame · corrodedCORROSION ON FRAME AT STATION 1309 LONGERON 30. REMOVED CORROSION AND INSTALLED DOUBLER AND FRAME REPAIR PER AARD 53-10-00-14.SDR AALA20090406TUL53Floor Support · crackedFLOORBOARD SUPPORT IS CRACKED AT STATION 972 BELOW NR 5 SEAT TRACK. REPLACED FLOORBOARD SUPPORT PER SRM 51-01-00.SDR AALA20090406TUL52Floor Support · crackedFLOORBOARD SUPPORT IS CRACKED AT STATION 845 BELOW NR 4 SEAT TRACK. INSTALLED NEW FLOORBOARD SUPPORT PER SRM 51-01-00.SDR AALA20090406TUL49Longeron · crackedLONGERON 2L CRACKED AT STATION 160. CUT OUT DAMAGED LONGERON AND INSTALLED LONGERON SPLICE PER SRM 53-02-00.SDR AALA20090406TUL48Cusp Web · crackedCRACKS IN CUSP AT STATION 804 JUST OUTBOARD OF NR 1 SEAT TRACK AT AFT OUTBOARD CORNER OF SEAT TRACK. REMOVED DAMAGED AREA AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL47Shear Tie · corrodedCORROSION ON SHEAR TIE IN AFT CARGO AT STATION 1287. INSTALLED NEW SHEAR TIE WITH DOUBLER STRAPS PER SRM 53-03-00.SDR AALA20090409TUL07Floor Support · crackedFLOORBOARD SUPPORT CRACKED STATION 864. REMOVED AND REPLACED FLOORBOARD SUPPORT PER SRM 51-01-00.SDR AALA20090409TUL06Floor Support · corrodedCORROSION ON FLOORBOARD SUPPORT TEE SECTION STATION 1155 TO 1212 LONGERON 23. REMOVED AND REPLACED FLOORBOARD SUPPORT TEE SECTION PER AARD 51-00-00-012.SDR AALA20090409TUL05Floor Support · crackedFLOORBOARD SUPPORT CRACKED STATION 886. REMOVED AND REPLACED FLOORBOARD SUPPORT PER SRM 51-01-06.SDR AALA2009032600665Strap · brokenLGA - AFT FORWARD FLASHLIGHT RETAINING STRAP BROKEN. INSTALLED SECURITY RETAINING STRAP FOR FLASHLIGHT AT AFT FORWARD.SDR AALA2009032500002Switch · defectiveDFW - LEFT AIR CONDITIONING PACK FAILED. RIGHT PACK WAS ON PLACARD. EMERGENCY DECLARED, LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLOW CONTROL VALVE AND LEFT TURBINE INLET AND OUTLET OVERTEMP SWITCHES. SYSTEM GROUND CHECK NORMALSDR AALA2009032500001Pump · inoperativeDFW - CREW REPORTED CENTER FUEL TANK BOOST INOPERATIVE. RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CENTER TANK PUMPS. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090406TUL59Frame · corrodedCORROSION ON FRAME LOWER FLANGE AT STATION 1271 LONGERON 29L- LONGERON 30. INSTALLED J-ANGLE DOUBLER PER AARD 53-10-00-14 REPAIR 1.SDR AALA20090406TUL58Intercostal · crackedCRACK ON INTERCOSTAL ON FORWARD SIDE OF FLOORBEAM STATION 1041. INSTALLED REPAIR DOUBLER PER SRM 53-01 FIGURE 2 SHEET 4.SDR AALA20090406TUL51Beam · corrodedCORROSION ON UPPER AND LOWER LEG OF MID CARGO DOOR BEAM, STATION 636-693. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA20090406TUL50Bracket · corrodedCORROSION IN LOWER CORNER BRACKET AT STATION 1156 OUTBOARD OF LOWER DOOR BEAM FORWARD END, IN AFT CARGO. INSTALLED NEW BRACKET PER SRM 51-30-5 AND AARD 51-00-00-012.SDR AALA20090331TUL32Plate · crackedRIGHT AFT OVERWING EXIT CUTOUT FORWARD GUIDE RECESS PLATE IS CRACKED. INSTALLED DOUBLER PER SRM 53-05-00 FIGURE 32.SDR AALA20090326TUL01Engine · making metalNUMBER ONE ENGINE FILTER BYPASS LIGHT ILLUMINATED. OIL PRESSURE N2 HAD NO INDICATION. ENGINE SHUTDOWN. INSPECTION FOUND METAL IN OIL FILTER.SDR AALA2009032500655Placard · damagedDFW - RIGHT AFT OVERWING EXIT MARKER DECAL DAMAGED. REPLACED RIGHT AFT OVERWING EXIT DECAL.SDR AALA2009032500654Guard · damagedDFW - EMERGENCY LIGHT GUARD AT SEAT 27D DAMAGED. REPLACED EMERGENCY LIGHT GUARD AT SEAT 27D.SDR AALA2009032500653Battery Pack · not seatedLGA - AFT STAIRWAY OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPOSITIONED BATTERY PACK.SDR AALA2009032500652Battery Pack · not seatedLGA - AFT CEILING EMERGENCY LIGHTS FROM AFT GALLEY TO AFT LAVATORY INOPERATIVE. REPOSITIONED BATTERY PACKS.SDR AALA20090406TUL46Cusp Web · corrodedCORROSION ON SUBFLOOR UNDER FORWARD GIRT BAR BRACKET OF AFT SERVICE DOOR AT STATION 1140. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL44Beam · corrodedCORROSION ON AFT CARGO DOOR BEAM VERTICAL AND HORIZONTAL LEGS STATION 1158-1209. INSTALLED REPAIR ON DOOR BEAM PER AARD 53-10-00-3.SDR AALA20090406TUL43Pan · crackedWINDOW PAN CRACKED IN UPPER AFT CORNER AT STATION 1041 RIGHT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20090331TUL53Frame · crackedSTATION 1510 CANT FRAME CRACKED ABOVE LEFT UPPER TAIL CONE LATCH. INSTALLED REPAIR DOUBLER PER EA MD80-53-005820.SDR AALA2009032400645Battery Pack · dischargedLGA - CEILING EMERGENCY LIGHTS FOR ROWS 18 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT ROWS 18 TO 21.SDR WX0A070282Battery · 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 AALA20090406TUL45Cusp Web · corrodedCORROSION ON RIGHT CUSP STATION 1193-1212. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL42Cusp Web · crackedCRACK IN CUSP FROM LIGHTENING HOLE TO LIGHTENING HOLE RIGHT SIDE STATION 1300. INSTALLED DOUBLER PER EA MD80-53-005822 AND AARD 53-20-00-16.SDR AALA20090406TUL41Cusp Web · corrodedRIGHT CUSP HAS CORROSION BETWEEN STATION 1212 AND 1231. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20090406TUL40Cusp Web · damagedTORN CUSP SHEET AT STATION 160 LEFT SIDE AT AIRSTAIR ROD. INSTALLED DOUBLER ON CUSP MEMBRANE PER EA MD80-53-005776.SDR AALA20090406TUL33Web · corrodedSUBFLOOR CORRODED BETWEEN NR 5 AND NR 6 SEAT TRACK STATION 200-218. INSTALLED SUBFLOOR DOUBLER PER SRM 51-10-3, 53-01 FIGURE 1, AND 51-30-1.SDR AALA20090406TUL30Frame · crackedFRAME 1418 CRACKED ON UPPER FLANGE BETWEEN LONGERON 1R AND 2R. INSTALLED DOUBLER PER EA MD80-53-005777.SDR AALA20090406TUL29Stop Fitting · crackedAFT CARGO DOOR UPPER FORWARD STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174 DATED 03/23/09.SDR AALA20090401TUL05Longeron · crackedLONGERON 1L CRACKED AT STATION 200. REPLACED LONGERON PER SRM 53-02-00 FIGURE 8.SDR AALA20090401TUL04Longeron · crackedLONGERON 1L CRACKED AT STATION 160. REPLACED LONGERON PER SRM 53-02-00 FIGURE 8.SDR AALA20090331TUL54Cusp Web · corrodedHEAVY CORROSION ON SUB FLOOR DOUBLER JUST INBOARD OF FORWARD SERVICE DOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090331TUL52Stiffener · crackedAFT PRESSURE BULKHEAD, 1 INCH CRACK AT TOP OF STIFFENER LOCATED ABOVE CENTER OF VAULT DOOR OPENING ON FORWARD SIDE OF AFT PRESSURE BULKHEAD. INSTALLED NEW STIFFENER PER SRM 51-01-00.SDR AALA20090324TUL02Stiffener · crackedFORWARD END OF RIGHT FOD PANEL ABOVE RIGHT MAIN LANDING GEAR, INBOARD END VERTICAL STIFFENER CRACKED. INSTALLED NEW VERTICAL STIFFENER PER SRM 51-10-01.SDR AALA20090324TUL01Attach Fitting · crackedINBOARD LEFT FLAP ACTUATOR ATTACH FITTING CRACKED AT LOWER WEB. INSTALLED DOUBLERS ON FLAP MECHANISM SUPPORT FITTING PER AARD 57-10-00-2.SDR AALA2009032300636Battery Pack · dischargedPHL - EMERGENCY LIGHTS DID NOT PASS TEST. REPLACED BATTERY PACK.
Back to Mcdonnell Douglas DC-9-82