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 AALA200810531Cusp Web · crackedRIGHT CUSP CRACKED STATION 800. INSTALLED A SERVICEABLE CUSP SHEET PER SRM 51-01.SDR AALA200810529Cargo Track · corrodedCORROSION ON RIGHT TIE DOWN TRACK IN AFT CARGO STATION 1041 TO 1155. INSTALLED SERVICEABLE TIE DOWN TRACK.SDR AALA200803045Shroud · brokenMSP EMERGENCY LIGHT AT SEAT 22D HAS BROKEN SHROUD. REPLACED SHROUD. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200803044Shroud · brokenMSP EMERGENCY LIGHT AT SEAT 30D HAS BROKEN SHROUD. REPLACED SHROUD. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200803043Charger · inoperativeMSP EMERGENCY LIGHT AT OVERHEAD SEAT ROW 29 INOPERATIVE. REPLACED CHARGER FOR SEAT ROW 29C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200803042Lamp · burned outLGA LT COCKPIT EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200810535Beam · corrodedCORROSION ON VERTICAL LEG OF AFT CARGO DOOR BEAM AT STATION 1163. INSTALLED FULL BEAM DOUBLER PER SRM 51-10-3 AND AARD 53-10-00-3.SDR AALA200810528Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 810. REPAIRED PER AARD 53-20-00-16.SDR AALA200810527Longeron · crackedLONGERON 2L CRACKED AT STATION 160. REPAIRED LONGERON 2L FROM 148 TO 168 PER SRM 53-02-00 FIG 18.SDR AALA200810485Beam · crackedNOSE WHEEL WELL, LEFT J BEAM REPAIR DOUBLER CRACKED AT LOCK FASTENER AT UPPER AFT SIDE. REMOVED AND REPLACED DOUBLER PER AARD 53-10-00-4.SDR AALA200803030Battery Pack · dischargedLGA EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 8 FOR EMERGENCY LIGHTS AT FORWARD CABIN.SDR AALA200802630ABattery Pack · dischargedLGA - EMERGENCY LIGHTS AT FORWARD COACH CABIN INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 8. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810526Floorbeam · crackedVERTICAL FLOORBEAM SUPPORT CRACKED STATION 927 UNDER SEAT TRACK NUMBER 2. INSTALLED A SERVICABLE SUPPORT.SDR AALA200810525Mount · corrodedFORWARD GALLEY INBOARD MOUNT CORRODED STATION 160. INSTALLED A SERVICABLE MOUNT.SDR AALA200810524Mount · corrodedFORWARD GALLEY OUTBOARD MOUNT CORRODED STATION 160. INSTALLED SERVICEABLE MOUNT.SDR AALA200810523Seat Track · corrodedCORROSION ON NUMBER 1 SEAT TRACK STATION 1278. INSTALLED REPAIR PLUG PER SRM 53-05-4A.SDR AALA200810522Support Bracket · crackedVERTICAL FLOORBEAM SUPPORT BRACKET CRACKED STATION 927 UNDER NUMBER 5 SEAT TRACK. INSTALLED A SERVICEABLE SUPPORT BRACKET PER SRM 51-01.SDR AALA10521Angle · crackedVERTICAL ANGLE CRACKED BELOW LONGERON 1 STATION 1338. REPAIRED PER AARD 53-10-00-15.SDR AALA200810451Frame · cracked0.250 CRACK AT RIGHT CANT FRAME STATION 1474, AFT OF ELEVATOR ACCUMULATOR ACCESS. 5.5 INCH BY 3.5 INCH, .040 7075 T6 DOUBLER INSTALLED AFTER END OF CRACK STOP DRILLED.SDR AALA200802627ALamp · burned outEMERGENCY LIGHT AT SEAT ROW 19 RIGHT INOPERATIVE. REPLACED LAMP AT SEAT ROW 19 RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090121TUL01Lens · brokenEMERGENCY LIGHT AT SEAT ROW 19 RIGHT HAS BROKEN LENS. REPLACED LENS AT SEAT ROW 19 RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802625AHose · leakingFLL INFLIGHT - CREW REPORTED RIGHT HYDRAULIC QUANTITY AND PRESSURE LOSS. EXTENDED LANDING GEAR MANUALLY. LANDED FLL WITHOUT INCIDENT AND AIRCRAFT WAS TOWED OFF RUNWAY. REPLACED RIGHT HYDRAULIC SYSTEM HOSE AND SERVICED HYDRAULIC SYSTEM. SYSTEM GROUND CHECKESDR AALA200810530Attach Angle · crackedATTACH ANGLE CRACKED BELOW RIGHT HAND TIE DOWN TRACK STATION 237 FORWARD CARGO. INSTALLED SERVICEABLE ANGLE.SDR AALA200810420Bracket · crackedNUMBER 4 SEAT TRACK SUPPORT BRACKET CRACKED STATION 864. REMOVED AND REPLACED WITH SERVICEABLE SUPPORT BRACKET.SDR AALA200810416Strap · corrodedSTRAP CORRODED IN LONGERON 23L FROM 1287 TO 1306. REMOVED AND REPLACED WITH SERVICEABLE STRAP.SDR AALA200802621Rod · brokenABQ INFLIGHT. CREW REPORTED LT MAIN LANDING GEAR UNSAFE INDICATION. RETURNED TO ABQ AND LANDED WITHOUT INCIDENT. FOUND LT MAIN LANDING GEAR BUNGEE ROD END SHREARED OFF. REPLACED LEFT MAIN LANDING GEAR BUNGEE ROD. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSDR AALA200802620ADuct · crackedINFLIGHT CREW REPORTED UNABLE TO PRESSURIZE CABIN. RETURNED TO STL AND LANDED WITHOUT INCIDENT. FOUND BROKEN DUCT ON RIGHT HAND AIR CYCLE MACHING. REPLACED RIGHT HAND AIR CYCLE MACHINE DUCT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802612AProximity Sensor · failedINFLIGHT. CREW REPORTED GEAR UNSAFE INDICATION FOLLOWING GEAR EXTENSION. ACCOMPLISHED ALTERNALE GEAR EXTENSION PROCEDURE. LANDED ABQ WITHOUT INCIDENT. REPLACED LEFT HAND MAIN LANDING GEAR PROXIMITY SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810448Seat Track · corrodedCORROSION ON SEAT TRACK BLENDED BEYOND LIMITS. REPLACED SEAT TRACK.SDR AALA200802601ABattery Pack · dischargedLGA EMERGENCY LIGHT AFT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20091101TUL01Pan · corrodedFLOOR PAN CORRODED STA 207-210 FORWARD OF NUMBER 6 SEAT TRACK. INSTALLED REPAIR PER AARD 53-20-00-16.SDR AALA200802590ARelay · failedINFLIGHT ORD TO LAX. CREW REPORTED ALL FUEL QUANTITY INDICATIONS INOPERATIVE. CIRCUIT BREAKER POPPED. LANDED ABQ WITHOUT INCIDENT. REPLACED RELAY FROM AFT GALLEY DRAIN MAST HEAT POSITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802589AConnector · looseINFLIGHT, RIGHT ENGINE START VALVE INDICATION. RETURNED TO TUL AND LANDED WITHOUT INCIDENT. RESEATED VALVE CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810446Beam · corrodedCARGO DOOR BEAM CORRODED/PITTED IN SEVERAL AREAS FROM STATION 1155 TO STATION 1211. BLENDED CORROSION, REMOVED CORROSION, WITHIN LIMITS PER ESO 80559 DATED 11/21/08.SDR AALA200810445Cusp Web · crackedCRACK IN CUSP AT LIGHTENING HOLE STATION 222 LEFT AT NR 2 SEAT TRACK. REPAIRED CUSP PER AARD 53-20-00-16 USING NEW CUSP MATERIAL FROM STATION 218 TO STATION 237.SDR AALA200810444Door Frame · corrodedCORROSION ON AFT CARGO DOOR CUT-OUT BOX FRAME FORWARD SIDE OF DOOR, STATION 1148 TO STATION 1155 BETWEEN LONGERON 26 RIGHT AND LONGERON 27 RIGHT. BLENDED OUT DAMAGE, FOUND TO BE OUT OF LIMITS. INSTALLED WEB REPAIR PER ESO 80559 DATED 11/26/08.SDR AALA200810443Gusset · crackedGUSSET IS CRACKED AT LEFT STATION 207 WHERE IT ATTACHES TO INTERCOSTAL AT LONGERON 15 LEFT. INSTALLED "T" DOUBLER AT STATION 207 AND LONGERON 15 LEFT PER SRM 53-10-00-11.SDR AALA200810441Cusp Web · corrodedCORROSION ON CUSP FROM STATION 598 TO STATION 617 LEFT HAND. REMOVED AND INSTALLED SERVICEABLE CUSP SHEET FROM STATION 598 TO STATION 712 PER AARD 53-20-00-16.SDR AALA200802587ACharger · inoperativeEMERGENCY LIGHTS AT RIGHT HAND FROM SEAT ROWS 3 TO 21 INOPERATIVE. REPLACED BATTERY CHARGER AT FIRST CLASS FOR EMERGENCY LIGHTS AT RIGHT HAND FROM SEAT ROWS 3 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802586ABattery Pack · dischargedEMERGENCY LIGHT AT SEAT ROW 6EF INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 6EF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810450Stop Fitting · corrodedAFT DOOR FRAME STOP FITTING CORROSION. REMOVED AND REPLACED FITTING.SDR AALA200810449Stop Fitting · corrodedAFT DOOR FRAME STOP FITTING CORROSION. REMOVED AND REPLACED FITTING.SDR AALA200810442Skin · crackedCRACK IN RIGHT ELEVATOR UPPER SKIN ALONG TOE, OUTBOARD OF GEAR TAB. INSTALL DOUBLER REPAIR PER ESO 80559 DATED 11/25/08.SDR AALA200810440Angle · crackedCRACK IN TEE ANGLE OUTBOARD AND AFT OF VENTRAL STAIRS ACTUATOR RIGHT SIDE, 1497 TO 1510 CANT FRAME. INSTALLED NEW TEE ANGLE PER SRM 51-30-05.SDR AALA200810439Longeron · crackedLONGERON 4 LEFT CRACKED AT STATION 160 AND STATION 200. REMOVED LONGERON FROM END CAP AT STATION 148 TO PRODUCTION SPLICE AT STATION 234. INSTALLED NEW LONGERON.SDR AALA200810245Tee Fitting · crackedFORWARD CARGO DOOR, LOWER FORWARD STOP, TEE FITTING CRACKED. REMOVED AND REPLACED TEE FITTING.SDR AALA200802588ABattery Pack · dischargedEMERGENCY LIGHT AT LEFT HAND AFT CABIN AT AIR STAIR INOPERATIVE. REPLACED BATTERY PACK AT AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802576ADuct · leakingDFW INFLIGHT. CREW REPORTED TAIL COMPARTMENT OVERTEMP INDICATION DURING CLIMB. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND DUCT BLOWN IN TAIL COMPARTMENT. AIRCRAFT OUT OF SERVICE FOR REPAIRS. REPLACED RIGHT HAND AIR CONDITIONING WATER SEPARATOR DUSDR AALA200810419Cargo Track · corrodedTIE DOWN TRACK SPLICE PLATE CORRODED STATION 1212 TO 1225 (AFT CARGO, LEFT SIDE). REMOVED AND REPLACED WITH SERVICEABLE TRACK SPLICE PLATE.SDR AALA200810418Cargo Track · corrodedCORROSION AROUND TIE DOWN TRACK FASTENERS LEFT SIDE STATION 1210 TO 1322 (AFT CARGO). REMOVED AND REPLACED WITH SERVICEABLE TRACK PER SRM 51-10-01.
Back to Mcdonnell Douglas DC-9-82