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 AALA200810115Stringer · crackedNR 20 LEFT STRINGER CRACKED AT STATION 995. INSTALLED DOUBLER PER AARD 53-10-00-18.SDR AALA200810114Casting · crackedGROUND SPOILER WING MOUNTED CASTING CRACKED AT INBOARD FORWARD END. REPLACED GROUND SPOILER CASTING.SDR AALA200810110Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK WEAK. REMOVED AND REPLACED BATTERY PACK.SDR AALA200810109Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK.SDR AALA200810108Battery Pack · weakEMERGENCY LIGHT BATTERY PACK WEAK. REMOVED AND REPLACED BATTERY PACK.SDR AALA200810107Light · inoperativePORTABLE EMERGENCY LIGHT AT EPC, CHARGE LIGHT IS INOP. REMOVED AND REPLACED PORTABLE EMERGENCY BELT RACK.SDR AALA200810147Frame · corrodedCORROSION IN AFT CARGO COMPARTMENT AT STATION 1309 FRAME AFT SIDE AT LONGERON 29R TO 30. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-14 FIG 1.SDR AALA10292008001Frame · corrodedCORROSION IN AFT CARGO COMPARTMENT AT BS 1309 FRAME AFT SIDE AT L29R TO 30. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-14 FIG 1.SDR AALA200810146Skin · crackedCRACK IN FUSELAGE SKIN BELOW AIRSTAIR DOOR. CUTOUT CRACK, INSTALLED DOUBLER PER ESO 80559 DATED 10/21/08 AND DRAWING NR SR09530219.SDR AALA200810131Cargo Track · corrodedAFT CARGO RIGHT TIEDOWN TRACK CORRODED AT MOUNT HOLES STATION 1211-1322. INSTALLED NEW TIEDOWN TRACK FROM 1211 TO 1322.SDR AALA200810130Cargo Track · corrodedCORROSION AT ATTACH BOLTS, AFT CARGO, LEFT TIEDOWN TRACK AT STATION 1220 TO 1322. INSTALLED NEW TIEDOWN TRACK FROM STATION 1220 TO 1322.SDR AALA200810129Cusp Web · corrodedCORROSION ON LOWER SIDE OF LEFT CUSP STATION 427-503. REMOVED DAMAGED CUSP AND INSTALLED NEW CUSP SHEET PER SRM 51-10-01.SDR AALA200810113Frame · wornDOUBLER ON FORWARD SIDE OF FRAME STATION 1380 HAS HOLE WORN IN IT. REPLACED DOUBLER PER AARD 53-10-00-28.SDR AALA200810111Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK.SDR AALA200810144Beam · corrodedAFT CARGO DOOR BEAM WEB UPPER SURFACE CORRODED STATION 1155 TO 1212. REMOVED CORROSION, TREATED AND PRIMED. INSTALLED REPAIR DOUBLER PER SRM 51-70-04 51-10-3 51-30-5.SDR AALA200810143Beam · corrodedSEVERAL AREAS OF CORROSION ON HORIZONTAL AND VERTICAL LEGS OF AFT CARGO DOOR BEAM STATION 1156 TO 1212. REMOVED CORROSION, TREATED AND PRIMED. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA200802413ABattery Pack · dischargedLGA - EXTERIOR EMERGENCY LIGHTS AT AFT CARGO COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK FOR EXTERIOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810145Seat Track · corrodedCORROSION ON UPPER OUTBOARD FLANGE ON NR 5 SEAT TRACK AT STATION 200 TO 218. REPLACED SEAT TRACK PER SRM 53-05-00 FIGURE 4F.SDR AALA200810132Cusp Web · corrodedCUSP CORRODED ON TOP SIDE UNDER GIRT BAR BRACKET AT STATION 1168. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810135Seat Track · corrodedCORROSION ON NR 2 SEAT TRACK FROM STATION 1303 TO 1309. INSTALLED NEW SEAT TRACK FROM STATION 1260 TO 1309 PER SRM 53-05-00 FIG 4F.SDR AALA200810134Cusp Web · corrodedLEFT CUSP CORRODED AT STATION 1250 TO 1309. INSTALLED NEW CUSP SHEET FROM STATION 1250 TO 1309.SDR AALA200810133Cusp Web · corrodedLEFT CUSP CORRODED AT AREA UNDER GIRT BAR AT STATION 1140. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2008132Cusp Web · corrodedLEFT CUSP CORRODED AROUND AREA UNDER GIRT BAR AT STATION 1168. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810116Guide · crackedDURING ECO3332AB A CHECK, CRACK WAS FOUND ON THE NOSE LANDING GEAR WHEEL WELL RIGHT DEFLECTOR STOP GUIDE WHEN REMOVED. A STAINLESS STEEL REPAIR WAS ACCOMPLISHED AND LOCK FASTENERS INSTALLED PER ECO AND SRM AND PER FMR NR 53053 E 4B3. FABRICATED DOUBLER FROM SDR AALA200810112Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1437 AFT SIDE. REPLACED SHEAR TIE AT STATION 1437 PER SRM 53-01.SDR AALA200810106Structure · crackedCABIN SUBFLOOR CRACKED, 1/2 INCH IN LENGTH. INSTALLED NEW CUSP SECTION PER 51-30-02 AND 51-30-5, 8 INCH BY 16 INCH.SDR AALA200810105Structure · corrodedCABIN SUBFLOOR CORROSION, 8 INCH BY 16 INCH, INSTALLED NEW SUBFLOOR DOUBLER PER 53-20-00-16.SDR AALA20081027001Seat Track · corrodedCORROSION ON UPPER OUTBOARD FLANGE ON NUMBER 5 SEAT TRACK AT STATION 200 TO 218. REPLACED SEAT TRACK PER SRM 53-05-00 FIG 4F.SDR AALA200810142Cusp Web · gougedLEFT CUSP GOUGED AT STATION 387. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA200810141Cusp Web · corrodedCORROSION ON LEFT CUSP AT STATION 695. INSTALLED CUSP REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA200810140Cusp Web · corrodedUNDERSIDE OF LEFT CUSP CORRODED AT STATION 695 - 699. INSTALLED DOUBLER PER AMERICAN AIRLINES REPAIR DOCUMENT 53-20-00-16.SDR AALA200810139Longeron · crackedLONGERON L2 CRACKED AFT OF STATION 1418. INSTALLED LONGERON SPLICE REPAIR PER AMERICAN AIRLINES REPAIR DOCUMENT 53-30-00-2.SDR AALA200810138Cusp Web · corrodedLEFT CUSP TORN AND CORRODED SEVERAL AREAS BETWEEN STATION 503 AND 518. INSTALLED REPAIR DOUBLER TO LEFT CUSP FROM STATION 503 TO 522 PER AMERICAN AIRLINES REPAIR DOCUMENT 53-20-00-16. MAJOR STRUCTURAL REPAIR NUMBER 016606.SDR AALA200810136Beam · corrodedMID CARGO DOOR BEAM CORRODED FROM 636 TO 693. INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA200810137Seat Track · corrodedNR 1 SEAT TRACK CORROSION AT STATION 1234 - 1238. INSTALLED NEW SEAT TRACK FROM STATION 1174 - 1309 AT NR 1 SEAT TRACK.SDR AALA200802397ABattery Pack · inoperativeLGA - FORWARD SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802396BBattery Pack · dischargedLGA - FORWARD SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 20DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802395AWire Harness · shortedBOS INFLIGHT - DURING CLIMB AT 300 FEET ALTERNATE ALERT WINDOW WENT BLANK. AUTOPILOT AND AUTO THROTTLE ONE AND TWO INOPERATIVE. CIRCUIT BREAKER POPPED. RETURNED TO BOS AND LANDED WITHOUT INCIDENT. FOUND WIRING FAULTS. REPAIRED SHORTED WIRE IN AFT ACCESSORSDR AALA200802393AWire Harness · brokenDFW INFLIGHT. LANDING GEAR INDICATIONS INOPERATIVE DURING APPROACH. PERFORMED GO-AROUND TO CONFIRM LANDING GEAR DOWN AND LOCKED. LANDED DFW WITHOUT INCIDENT. FOUND BROKEN WIRE ON ANNUNCIATOR PANEL IN COCKPIT FOR LANDING GEAR INDICATION. REPAIRED WIRE. SYSDR AALA200802387ABattery · inoperativeLGA - AFT GALLEY EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED BATTERY FOR AFT GALLEY EMERGENCY FLASHLIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810128Intercostal · crackedINTERCOSTAL IN AFT CARGO CRACKED AT CEILING AREA STATION 1271-1287. INSTALLED NEW INTERCOSTAL PER SRM 51-10-1.SDR AALA200810127Intercostal · crackedINTERCOSTAL IN AFT CARGO CRACKED, CEILING AREA AT STATION 1287-1309. INSTALLED NEW INTERCOSTAL PER SRM 51-10-1.SDR AALA200810126Cusp Web · corrodedUNDERSIDE OF RIGHT CUSP CORRODED AT STATION 530-534. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810148Frame · crackedCRACK IN 905 FRAME AT LONGERON 18L. INSTALLED NEW FRAME AT STATION 905 PER ADK 3290AC.SDR AALA200810040Pan · corrodedDOOR PAN CORRODED AROUND FORWARD STOP STATION 389. REPAIRED PER ESO 80559 DATED 21 OCT 2008.SDR AALA200810123Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 864 - 886. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810122Cusp Web · corrodedUNDERSIDE OF RIGHT CUSP CORRODED AT STA 544 - 548. INSTALLED DOUBLER PER AARD 53-20-00-3.SDR AALA200810121Bracket · corrodedAFT CARGO AREA, T BRACKET AT STATION 1155 IS CORRODED. INSTALLED NEW T BRACKET PER SRM 51-10-01.SDR AALA200810120Cusp Web · puncturedHOLE PUNCTURED IN LEFT CUSP AT STATION 1183. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810104Structure · corrodedCABIN SUBFLOOR CORRODED, STATION 160-200 RIGHT. REMOVED AND REPLACED SUBFLOOR PER AARD 53-20-00-16.
Back to Mcdonnell Douglas DC-9-82