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 AALA20100616TUL16Longeron · crackedLONGERON 20 RIGHT CRACKED ABOVE INBOARD FLAP ACTUATOR. INSTALLED DOUBLER PER AARD 53-10-00-18SDR AALA20100616TUL13Beam · corrodedCORROSION IN AFT CARGO DOOR BEAM FROM STATION 1155-1212. DOUBLER INSTALLED PER AMERICAN AIRLINES REPAIR DOCUMENT 53-10-00-3SDR AALA20100616TUL11Intercostal · crackedAFT CARGO INTERCOSTAL CRACKED AT STATION 1293 IN CENTER OF FLOOR. INSTALLED NEW INTERCOSTAL AT STATION 1287 TO 1307 PER SRM 51-30-05SDR AALA20100616TUL03Pan · crackedWINDOW PAN CRACKED AT STA 1079 LEFT HAND TOP AFT CORNER OF WINDOW. INSTALLED REPAIR ANGLE AT UPPER AFT WINDOW CORNER STA 1079 LEFT HAND SIDE PER AARD REF 53-10-00-25.SDR AALA20100616TUL02Bulkhead · crackedANGLE AT AFT PRESSURE BULKHEAD ABOVE DOORWAY APPROXIMATE CENTER IS CRACKED AT TOP. INSTALLED REPAIR DOUBLER ABOVE VAULT DOOR PER AARD 53-10-00-15.SDR AALA20100615TUL16Mount · corrodedCORROSION G2 FORWARD INBOARD TIE DOWN. REPLACED G2 MOUNT.SDR AALA20100615TUL23Cusp Web · corrodedRIGHT CUSP STATIONS 488 TO 492 CORRODED BEYOND LIMITS. CUT OUT CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100615TUL22Seat Track · corrodedSEAT TRACK NUMBER 1 CORRODED STATIONS 1084 TO 1090. INSTALLED SEAT TRACK REPAIR PER AARD 53-20-10-10.SDR AALA20100615TUL21Web · crackedWEBBING CRACKED STATION 208 LONGERON 15 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20100615TUL20Pan · crackedWINDOW PAN AT 1079 LEFT TOP AFT CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL19Pan · crackedWINDOW PAN R-36 CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL18Fitting · brokenFITTING BROKE BELOW NUMBER 2 SEAT TRACK AT STATION 927. REPLACED FITTING PER SRM 51-01-00.SDR AALA20100615TUL17Pan · crackedWINDOW PAN R-45 CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL15Pan · crackedWINDOW PAN AT STATION 1060 LEFT CRACKED TOP AFT CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL14Skin · crackedFUSELAGE LEFT SIDE CRACK INDICATION AT SKIN STATION 1474 CANT FRAME APPROXIMATELY SIX INCHES ABOVE AFT STAIR CUTOUT AT RIVET MARKED. INSTALLED DOUBLER PER SRM 53-01-00 FIGURE 2 SHEET 3.SDR AALA20100615TUL13Pan · crackedWINDOW PAN CRACKED AT WINDOW R-36 LOWER AFT. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL11Pan · damagedWINDOW PAN CRACKED AT WINDOW R-46 LOWER FORWARD. REPAIRED CRACK AT RIGHT RING PAN LOWER FORWARD AREA WINDOW 46 BY REMOVING EAR AND INSTALLING ANGLE BRACKET PER AARD 53-10-00-25.SDR AALA20100615TUL10Pan · crackedWINDOW PAN CRACKED AT STATION 1041 LEFT SIDE TOP AFT CORNER. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL09Pan · crackedWINDOW PAN CRACKED AT WINDOW R-49 LOWER FORWARD. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL06Pan · crackedWINDOW PAN CRACKED AT STATION 1060 LEFT FORWARD BOTTOM CORNER OF WINDOW. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL05Pan · crackedWINDOW PAN CRACKED AT STATION 1022 LEFT TOP AFT CORNER OF WINDOW. INSTALLED DOUBLER AT STATION 1022 LEFT TOP AFT CORNER OF WINDOW PER AARD 53-10-00-25.SDR AALA20100615TUL04Fitting · damagedDAMAGED GROUND SPOILER FITTING. REPLACED FITTING PER SRM 51-30-05.SDR AALA20100615TUL03Pan · crackedWINDOW PAN CRACKED AT WINDOW R-31 STATION 797 FORWARD UPPER CORNER. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100615TUL02Pan · crackedWINDOW PAN CRACKED AT WINDOW R-30 STATION 778 FORWARD UPPER CORNER. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100614TUL15Pan · crackedWINDOW PAN R-32 CRACKED LOWER AFT CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100614TUL14Pan · crackedWINDOW PAN R-32 CRACKED UPPER FORWARD CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100614TUL11Frame · crackedTHE 1418 FRAME APPEARS CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR AALA20100614TUL10Pan · crackedR-51 WINDOW PAN CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100614TUL09Pan · crackedWINDOW PAN CRACKED R-50. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100614TUL08Seat Track · corrodedCORROSION IN NUMBER FIVE SEAT TRACK AT STATION 205. SEAT TRACK SPLICE REPAIR WAS INSTALLED PER SRM 53-05-00 FIGURE 4F.SDR AALA20100614TUL07Pan · crackedWINDOW PAN CRACKED R-42. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100614TUL03Pan · crackedWINDOW PAN CRACKED AT WINDOW R-34 UPPER FORWARD. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100614TUL01Pan · crackedWINDOW PAN CRACKED AT WINDOW R-54 LOWER AFT. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100612TUL03Cusp Web · crackedDAMAGE ON CUSP SHEET OUTBOARD OF SEAT TRACK NUMBER 1 AT STATION 237. REPLACED LEFT CUSP SHEET FROM 218 TO 237 PER AARD 53-20-00-16 AND DOUBLER AROUND LIGHTING HOLE PER AARD 53-20-00-16.SDR AALA20100612TUL02Generator · failedMSY - CREW REPORTED LEFT ENGINE GENERATOR CYCLING WITH MULTIPLE ELECTRICAL SYSTEM FAILURES. EMERGENCY DECLARED RETURNED MSY LANDED WITHOUT INCIDENT. REPLACED THE LEFT ENGINE GENERATOR AND CONSTANT SPEED DRIVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100612TUL01Cusp Web · corrodedCABIN HAS CORROSION IN SUB FLOOR WEBBING AT STATION 200 INBOARD OF FORWARD SERVICE DOOR. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100611MSP01Duct · damagedMSP - CREW REPORTED TAIL COMPARTMENT HIGH LIGHT ILLUMINATED DURING FLIGHT. LIGHT WENT OUT AFTER POWER REDUCED BUT CAME ON MOMENTARILY SEVERAL TIMES DURING APPROACH AS POWER WAS ADDED. FLIGHT LANDED MSP WITHOUT INCIDENT. FOUND DUCT FLANGE DAMAGED. REPLACED SDR AALA20100611TUL01Skin · damagedDENT IN FUSE STATION 266 BETWEEN LONGERON 16 LEFT AND LONGERON 17 LEFT. INSTALLED DOUBLER PER SRM 53-04-00.SDR AALA20100610TUL04Seat Track · corrodedNUMBER 6 SEAT TRACK PLUG OUT OF LIMITS AT STATION 466. SEAT TRACK PLUG INSTALLED IN NUMBER 6 SEAT TRACK AT STATION 466 PER AARD 53-20-00-10 AND SRM 53-05 FIGURE 4A.SDR AALA20100610TUL03Seat Track · damagedNUMBER 6 SEAT TRACK PLUG OUT IF LIMITS AT STATION 500. REMOVED DAMAGED SEAT TRACK AREA AND INSTALLED REPAIR PARTS PER AARD 53-20-00-10 AND SRM 53-05 FIGURE 4A.SDR AALA20100610TUL07Cusp Web · corrodedWEB UNDER GIRT BAR SUPPORT MOUNT HAS CORROSION FORWARD STATION 1174 LONGERON 18 LEFT. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100610TUL06Skin · gougedFUSE - GOUGES IN SKIN STATIONS 204 TO 210 BETWEEN STRINGER 4 LEFT AND 5 LEFT INSTALLED DOUBLER PER SRM 53-04-03 & DWG SG09530002.SDR AALA20100610TUL05Seat Track · corrodedNUMBER 6 SEAT TRACK AT STATION 398 CORROSION OUT OF LIMITS. REPAIRED PER AARD 53-20-00-10.SDR AALA20100610TUL02Cusp Web · crackedSTATION 469 RIGHT CUSP CRACKED. INSTALLED DOUBLER CUSP REPAIR AARD 53-20-00-06.SDR AALA20100610TUL01Cusp Web · corrodedCORROSION BEYOND LIMITS ON LEFT CUSP STATIONS 1083 TO 1084. CUT OUT DAMAGE AND INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20100609TUL03Pan · crackedWINDOW PAN CRACKED LOWER FORWARD CORNER AFT SIDE OF STATION 598 RIGHT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100610LGA02Battery Pack · dischargedPORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR PORTABLE EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100610LGA01Battery Pack · dischargedFOUND GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER 1 DOOR. OPS CHECKED NORMAL.SDR AALA20100608DFW15Wire · chafedDFW - CREW REPORTED DURING CLIMBOUT CABIN ALTITUDE WARNING ALERT SOUNDED AND MASTER WARNING LIGHT. BOTH PRESSURE CONTROLLERS FAILED. ALSO HAD MULTIPLE ALERTS DURING DESCENT AND CABIN CHIMES COMING ON. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INSDR AALA20100608DFW14Apu · dirtyDFW - CREW REPORTED SMOKE ODOR IN AFT CABIN AFTER TAKEOFF. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. ACCOMPLISHED AUXILIARY POWER UNIT WASH AND PACK BURN. NO ODORS NOTED. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82