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 AALA20100507TUL11Mount · corrodedG2 GALLEY MOUNT FORWARD END OF NUMBER 6 SEAT TRACK CORRODED. INSTALLED NEW G2 GALLEY MOUNT ON FORWARD END OF NUMBER 6 SEAT TRACK AS PER SRM 51-30-02.SDR AALA20100507TUL09Pan · crackedLEFT STATION 1079 UPPER AFT WINDOW PAN EAR IS CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100507TUL08Pan · crackedLEFT STATION 1060 UPPER AFT PAN EAR IS CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100507TUL07Pan · crackedLEFT STATION 1022 UPPER AFT WINDOW PAN EAR IS CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100507TUL06Pan · crackedLEFT STATION 1022 LOWER FORWARD WINDOW PAN EAR IS CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100507DFW01Regulator · faultyDFW - CREW REPORTED ON CLIMB THE CABIN RATE OF PRESSURE CONTINUED TO RISE BEYOND NORMAL. THE FLOW LIGHT CAME ON AND THE OUTFLOW VALVE FULLY CLOSED AND THEN THE CABIN RATE OF CLIMB RETURNED TO NORMAL. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMSDR AALA20100506TUL08Casting · crackedGROUND SPOILER ACTUATOR CASTING ON THE LEFT WING CRACKED AT BOTH FORWARD LUGS. INSTALLED NEW GROUND SPOILER CASTING PER SRM 51-01-00 AND RE-INSTALLED SPOILER PANEL PER MM 27-62-01-2.SDR AALA20100506TUL01Rib · crackedNUMBER 5 BRACKET CRACKED IN RADIUS. REMOVED AND REPLACED RIB ASSEMBLY PER ESO 27-80-1.SDR AALA20100505EWR01Engine · seizedEWR - INFLIGHT LGA-ORD. LEFT ENGINE FAILED ON TAKEOFF (SINGLE ENGINE TIME 5 MINUTES). EMERGENCY DECLARED FLIGHT DIVERTED EWR LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE ON 05/06/2010 AT EWR. SYSTEM GROUND CHECK NORMAL OPERSDR AALA20100505TUL04Cusp Web · crackedCABIN CUSP CRACKED RIGHT SIDE STATION 1212. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20100505TUL12Cusp Web · damagedDAMAGE TO CUSP SHEET AT STATION 295 TO 312. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100505TUL06Beam · corrodedLIGHT CORROSION AROUND RIVNUT HOLES ON DOOR BEAM STATIONS 636 TO 655. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA20100505TUL05Structure · corrodedCORROSION ON TOP OF RIGHT OUTBOARD EDGE OF FORWARD SUBFLOOR STATIONS 200 TO 218. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16 PARAGRAPH 6.SDR AALA20100505TUL03Battery Pack · weakFORWARD EMERGENCY PATH MARKING LIGHT BATTERY AB5-1 IS WEAK. REPLACED BATTERY PACK FOR FORWARD EMERGENCY PATH MARKING LIGHT. OPS CHECKED NORMAL.SDR AALA20100505TUL01Battery Pack · weakAFT EMERGENCY PATH MARKING LIGHT BATTERY PACK IS WEAK. INSTALLED SERVICEABLE BATTERY PACK. OPS CHECKED NORMAL.SDR AALA20100504TUL12Fitting · damagedAFT TIE DOWN RIGHT SIDE DAMAGED IN AFT CARGO. INSTALLED SERVICEABLE TIE DOWN PER SRM 51-30-00.SDR AALA20100504TUL09Beam · corrodedCORROSION ON DOOR CUTOUT BEAM STATIONS 1174 TO 1193. INSTALLED BEAM DOUBLER PER AARD 53-10-00-03.SDR AALA20100504TUL06Cargo Track · corrodedAFT CARGO LEFT TIE DOWN TRACK SPLICE CORRODED. REPLACED SPLICE PER SRM 51-30-05.SDR AALA20100504TUL04Cusp Web · corrodedCORROSION ON RIGHT CUSP. REMOVED AND REPLACED CUSP SHEET STATIONS 503 TO 541 PER AARD 53-20-00-16.SDR AALA20100505LGA02Battery Pack · dischargedEMERGENCY LIGHTS AT ROW 32 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 32. OPS CHECKED NORMAL.SDR AALA20100505LGA01Battery Pack · dischargedCEILING EGRESS LIGHTS AT ROWS 22 TO 25 INOPERATIVE. REPLACED EMERGENCY BATTERY PACK AT ROW 25DEF. OPS CHECKED NORMAL.SDR AALA20100504TUL03Strap · corrodedCORROSION ON AFT CARGO DOOR CUTOUT BEAM WEB STRAP. REMOVED CORRODED STRAP INSTALLED MANUFACTURED STRAP PER EA MD80-51-010490.SDR AALA20100504DFW01Guard · brokenEMERGENCY LIGHT AT SEAT ROW 14 HAS GUARD BROKEN. REPLACED GUARD.SDR AALA20100503TUL14Fitting · crackedFOUND LEFT LONGERON 29 END FITTING CRACKED AT STATION 1331 TO 1336. REPLACED FITTING PER SRM 51-30-00.SDR AALA20100503TUL13Cusp Web · damagedCUSP HAS DAMAGE AT STATION 1271 TO 1287 BETWEEN TRACKS 1 AND 2. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100503TUL12Cusp Web · damagedCUSP DAMAGE AT STATION 564 BETWEEN TRACKS 1 AND 2. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100503TUL09Cusp Web · damagedDAMAGE TO CUSP SHEET AT FORWARD GIRT BAR AT LEFT NUMBER 2 DOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100503TUL08Cusp Web · puncturedPUNCTURE IN CUSP STATION 190 RIGHT. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100503TUL02Cusp Web · corrodedCORROSION ON BOTTOM OF LEFT CUSP, STATION 596. REMOVED CORROSION PER SRM 53-01-00 AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100503TUL01Cusp Web · corrodedCORROSION ON LEFT CUSP, STATION 488. PERFORMED CUSP REPAIR PER AARD 53-20-00-16.SDR AALA20100502TUL01Track · corrodedCORROSION ON TIE DOWN TRACK, RIGHT SIDE, STATION 1007 TO 1155. INSTALLED NEW TIE DOWN TRACK PER AARD 51-00-00-012.SDR AALA20100501TUL02Track · corrodedCORROSION ON TIE DOWN TRACK RIGHT SIDE STATIONS 1007 TO 1155. REPLACED TIEDOWN TRACK PER IPC 25-52-00-03L ITEM 450. PER SRM 51-30-05.SDR AALA20100502LGA03Battery Pack · dischargedLEFT AND RIGHT AFT OVERWING HATCH OVERHEAD EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK. OPS CHECKED NORMAL.SDR AALA20100502LGA02Battery Pack · dischargedEMERGENCY LIGHTS BETWEEN FORWARD LAVATORY AND GALLEY. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS BETWEEN FORWARD LAVATORY AND GALLEY. OPS CHECKED NORMAL.SDR AALA20100502LGA01Battery Pack · dischargedEXIT OVERWING ESCAPE LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR EXIT OVERWING ESCAPE LIGHT. OPS CHECKED NORMAL.SDR AALA20100429TUL02Fitting · crackedCABIN AFT SIDE OF FORWARD ENTRY DOOR JAMB CRACK IN CLIP AT FASTENER, LONGERON 11 LEFT AT STATION 207. INSTALLED CLIP REPAIR PER AARD 53-10-00-11.SDR AALA20100429TUL08Structure · damagedLARGE HUCK BOLT OR HI-LOCK PROTRUDING HEAD BETWEEN STATIONS 1041 TO 1060 AND LONGERON 10 RIGHT TO LONGERON 11 RIGHT. INSTALLED DOUBLER PER EA MD80-53-010378.SDR AALA20100429TUL03Cusp Web · crackedRIGHT CUSP CRACKED BETWEEN LIGHTENING HOLES AT STATIONS 1260 TO 1265. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100430PHL01Pin · backed outEMERGENCY LIGHTING AT SEAT 12DEF INOPERATIVE. FOUND VOLTAGE TO SEAT HARNESS BUT NO VOLTAGE OUT TO SEAT LIGHT. UPON FURTHER INSPECTION DISCOVERED THAT PIN IN CONNECTOR CLOSEST TO SIDEWALL PUSHED BACK. RE-SECURED PIN IN CONNECTOR. OPS CHECKED NORMAL.SDR AALA20100428TUL03Skin · dentedDENT IN FUSELAGE AFT OF MAIN ENTRY DOOR BELOW LONGERON 17 LEFT STATION 220. INSTALLED DOUBLER PER SRM 53-04-02.SDR AALA20100428TUL02Web · corrodedAFT CARGO - CORROSION ON WEB AND STRAP FORWARD OF DOORWAY STATIONS 1155 TO 1148 BETWEEN LONGERON 27 RIGHT TO LONGERON 25 RIGHT. COMPLETED REPAIR PER EA MD80-51-010219 DATED 4/23/10 AND AARD 53-10-00-24.SDR AALA20100428TUL05Longeron · crackedAFT ACCESSORY LONGERON 2 LEFT CRACKED AFT OF STATION 1418. INSTALLED NEW LONGERON SECTION AND SPLICE PER AARD 53-30-00-2.SDR AALA20100428TUL01Frame · bentFRAME SEGMENT AT STATION 1220 LOWER LEG WAS BENT DURING FASTNER REMOVAL. REMOVED DAMAGED FRAME SEGMENT AND INSTALLED SERVICEABLE FRAME SEGMENT PER SRM 53-30-05, SRM 51-10-03 AND EA MD80-51-010298 REV C.SDR AALA20100427TUL04Flap · wornRIGHT WING WORN AREA OUTBOARD FLAP INBOARD LEADING EDGE. INSTALLED DOUBLER WITH HOT BOND PER SRM 51-70-02.SDR AALA20100427TUL02Pan · crackedNUMBER 39 RIGHT WINDOW PAN CRACKED UPPER FORWARD CORNER AT STATION 946. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20100427TUL12Skin · damagedDAMAGE ON INBOARD COVE SKIN ON SLAT NEAR THE KNUCKLE RIB. INSTALLED FLUSH REPAIR ON SLAT COVE SKIN IAW AARD 57-50-00-04.SDR AALA20100426ATL01Gauge · damagedFOUND LEFT NUMBER 1 DOOR SLIDE GAUGE DAMAGED. REPLACED SLIDE AT LEFT NUMBER 1 DOOR. OPS CHECK NORMAL.SDR AALA20100425TUL03Web · damagedCORROSION ON WEB AND STRAP FORWARD OF DOORWAY STATIONS 1155 TO 1148 BETWEEN LONGERON 27 RIGHT AND LONGERON 25 RIGHT. INSTALLED REPAIR DOUBLER PER EA MD80-51-010219 DATED 4/23/10 AND AARD 53-10-00-24.SDR AALA20100425TUL02Beam · corrodedDOOR BEAM HAS CORROSION STATIONS 1155 TO 1211. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA20100425TUL01Longeron · crackedFORWARD CABIN - CRACK IN LONGERON 3 LEFT AT STATION 160. REMOVED CRACKED LONGERON 3 LEFT AND REPLACED WITH NEW LONGERON AND SPLICE. SRM 53-02-00 FIGURE 18.
Back to Mcdonnell Douglas DC-9-82