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 AALA200810103Pan · corrodedCORROSION ON BOTTOM SIDE OF G1 GALLEY DRAIN PAN STATION 148-160 RIGHT SIDE OF CABIN. REMOVED CORROSION INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810102Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 160-168. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810041Support Bracket · corrodedSUPPORT AT STATION 1210 IS CORRODED AT AFT CARGO DOOR. REPLACED SUPPORT BRACKET PER SRM 53-01-00 AND 51-01-00.SDR AALA200810039Spar · corroded03 PLANK BOLTS SEALANT LOOSE AND EMITTING RUST AT CENTER SPAR BOX RIGHT TOP SIDE. REMOVED 05 BOLTS, FOUND CORROSION IN BORES. REAMED HOLES TO REMOVE CORROSION. TREATED AND PRIMED BORES. MANUFACTURED AND INSTALLED 05 BUSHINGS IN ACCORDANCE WITH ESO 80559 DASDR AALA200810125Seat Track · corrodedCORROSION ON NR 1 SEAT TRACK AT STATION 307. INSTALLED REPAIR PLUG PER AARD 53-20-00-10.SDR AALA200810124Seat Track · corrodedCORROSION ON NR 3 SEAT TRACK AT STATION 302 TO 306. INSTALLED PLUG PER AARD 53-20-00-10.SDR AALA200810119Cusp Web · crackedCRACK IN LEFT CUSP AT STATION 222. INSTALLED DOUBLER ON CUSP AT STA 222 PER AARD 53-20-00-16.SDR AALA200810118Seat Track · gougedGOUGES IN THE BOTTOM OF NR 4 SEAT TRACK PLUG AT STATION 900 - 901. INSTALLED SEAT TRACK PLUG AT STATION 900 - 901 PER AARD 53-20-00-10.SDR AALA200802378SLens · incorrectLGA - EMERGENCY LIGHT AT OVERHEAD FORWARD OF RIGHT LAVATORY HAS INCORRECT LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD FORWARD OF RIGHT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802377SLens · missingLGA - EMERGENCY LIGHT AT AFT TAIL COMPARTMENT WALK WAY MISSING LENS. REPLACED LENS FOR THE AFT EMERGENCY LIGHT AT AFT TAIL COMPARTMENT WALK WAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802376SShroud · damagedLGA - SEAT MOUNTED FORWARD EMERGENCY LIGHT HAS DAMAGED SHROUD AT SEAT 6E. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 6E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802375SLens · missingLGA - SEAT MOUNTED FORWARD EMERGENCY LIGHT MISSING LENS AT SEAT 4E. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 4E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802374SShroud · missingLGA - SEAT MOUNTED FORWARD EMERGENCY LIGHT MISSING SHROUD AT SEAT 4E. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 4E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802373VLamp · missingLGA - SEAT MOUNTED FORWARD EMERGENCY LIGHT MISSING LAMPS AT SEAT 4E. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 4E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802372DStrap · brokenLGA - EMERGENCY FLASHLIGHT STRAP BROKEN AT FORWARD GALLEY. REPLACED FLASHLIGHT STRAP AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802371VConnector · looseLGA - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 29D INOPERATIVE. RESET CONNECTOR AT SEAT 29D FOR INOPERATIVE EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802370VConnector · looseLGA - FORWARD AND AFT SEAT MOUNTED EMERGENCY LIGHTS AT SEAT 6E INOPERATIVE. RESET CONNECTOR AT SEAT 6E FOR INOPERATIVE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810101Pan · corrodedFWD CARGO DOOR PAN CORRODED, STATION 370-427. INSTALLED NEW DOOR PAN SECTION FROM STATION 370 TO 427 PER SRM 53-05-00 FIG 44 SHEET 14.SDR AALA200810117Bracket · crackedAFT BULKHEAD DOORWAY RIGHT MID DOOR STOP BRACKET CRACKED AT UPPER FASTENER (STA 1338). INSTALLED NEW BRACKET PER SRM 51-01.SDR AALA200802365Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 23D HAS CRACKED SHROUD. REPLACED CLEAR PLASTIC SHROUD FOR EMERGENCY LIGHT AT SEAT 23D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802364Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 17D HAS CRACKED SHROUD. REPLACED CLEAR PLASTIC SHROUD FOR EMERGENCY LIGHT AT SEAT 17D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802362Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 14D HAS CRACKED SHROUD. REPLACED CLEAR PLASTIC SHROUD FOR EMERGENCY LIGHT AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810043Pan · corrodedAFT LAV SERVICE PANEL PAN HAS CORROSION AT OUTBOARD RADIUS OF PAN STATION 1322. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-30-00-7.SDR AALA200810098Cusp Web · crackedRIGHT CUSP VERTICAL ANGLE CORRODED AT STATION 200. INSTALLED NEW VERTICAL ANGLE.SDR AALA200810092Cargo Track · corrodedAFT CARGO, CORROSION ON OUTBOARD LEG AND CLIPNUT HOLES OF RIGHT TIE DOWN TRACK AT STATION 1211-1309. REMOVED AND REPLACED TIE DOWN TRACK PER SRM 51-30-1.SDR AALA200810091Splice Plate · corrodedAFT CARGO SPLICE PLATE CORRODED ON LEFT TIE DOWN TRACK AT STATION 1213. INSTALLED NEW SPLICE PLATE PER AARD 51-00-012.SDR AALA200802357Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 12 TO 16 INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 13DEF FOR INOPERATIVE EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 12 TO 16. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802356ABattery Pack · dischargedLGA - EMERGENCY LIGHTS AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810093Frame · crackedCRACK AT LEFT OVERWING FRAME RADIUS STATION 905. REMOVED AND REPLACED FRAME PER BOEING SERVICE REWORK DRAWING SRO9530282-7013.SDR AALA200810090Cusp Web · cutCUT IN LEFT CUSP SHEET AT STATION 895 TO 905. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200802348Coalescer Bag · dirtyATL INFLIGHT - DURING CLIMB-OUT BETWEEN 4000 AND 10000 FEET, FLIGHT ATTENDANT REPORTED WHITE SMOKE IN CABIN. ACCOMPLISHED CABIN SMOKE AND FIRE CHECKLIST AND SMOKE BEGAN TO DISSIPATE. RETURNED TO ATL AND LANDED WITHOUT INCIDENT. ACCOMPLISHED BURN OUT OF HIGHSDR AALA200810099Cusp Web · corrodedCUSP HAS CORROSION AT STATION 664. INSTALLED DOUBLER PER SRM 53-20-00-16.SDR AALA200810035Mount · corrodedCORROSION ON TOP OF INBOARD GALLEY TIE DOWN. REPLACED INBOARD GALLEY MOUNT PER SRM 51-01-00.SDR AALA200810034Attach Angle · crackedLEFT LOUVER BOX INBOARD FORWARD UPPER CORNER ATTACH ANGLE CRACKED. INSTALLED REPAIR DOUBLER ON ATTACH ANGLE PER SRM 53-01-00.SDR AALA200510032Diaphragm · corrodedCORROSION ON DIAPHRAGM UNDER G-1 GALLEY DRAIN PAN. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA200810089Longeron · corrodedAFT CARGO, CORROSION ON LONGERON 23L AT STATION 1287. REMOVED CORROSION AND INSTALLED DOUBLER PER SRM 51-10-1.SDR AALA200810088Web · corrodedAFT CARGO, CORROSION ON DOOR WEB AT STATION 1155-1174. INSTALLED WEB REPAIR PER AARD 53-10-00-24.SDR AALA200810033Mount · corrodedCORROSION TOP OF FORWARD OUTBOARD GALLEY TIE DOWN FITTING. REPLACED FORWARD OUTBOARD OUTBOARD GALLEY MOUNT PER SRM 51-00-00.SDR AALA200810031Diaphragm · corrodedCORROSION ON SUB FLOOR DIAPHRAM BETWEEN STATION 160-200. INSTALLED DOUBLER/DIAPHRAM DOUBLER BETWEEN STATION 160-200, RBL 42-57,PER AARD 53-20-00-16.SDR AALA200810085Beam · corrodedMID CARGO DOOR BEAM CORRODED AT STATION 636-693. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA200802346Wire · damagedDFW - EMERGENCY DOUBLE ARROW EXIT MARKER AT FORWARD ENTRY INOPERATIVE. REPAIRED DAMAGED WIRING FOR EMERGENCY DOUBLE ARROW EXIT MARKER AT FORWARD ENTRY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802345Lens · damagedDFW - EMERGENCY DOUBLE ARROW EXIT MARKER AT FORWARD ENTRY HAS DAMAGED LENS. REPLACED LENS FOR EMERGENCY DOUBLE ARROW EXIT MARKER AT FORWARD ENTRY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802344Strap · missingLGA - EMERGENCY FLASHLIGHT AT AFT JUMPSEAT HAS MISSING STRAP. REPLACED STRAP FOR EMERGENCY FLASHLIGHT AT AFT JUMPSEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810075Cusp Web · corrodedLEFT CUSP HAS CORROSION AT STATION 505 TO 509. REMOVED CORROSION, INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA10162008001Cusp Web · corrodedCORROSION ON RIGHT HAND CUSP AT STATION 1179-1189. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA200810038Cusp Web · corrodedCORROSION ON TOP OF SUBFLOOR CUSP FORWARD OF NR 6 SEAT TRACK. INSTALLED CUSP REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA200810094Beam · corrodedAFT CARGO DOOR BEAM CORRODED AT STATION 1155-1211. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR AALA200810036Fitting · corrodedCORROSION ON GALLEY TIE DOWN FITTING. REPLACED GALLEY TIE DOWN FITTING PER SRM 51-01-00.SDR AALA200810087Bracket · corrodedCORROSION ON BRACKET ON AFT CARGO DOOR, LOWER AFT CORNER AT STATION 1212. INSTALLED NEW BRACKET PER SRM 51-10-01.SDR AALA200810086Bracket · corrodedAFT CARGO DOOR LOWER FORWARD CORNER CORROSION ON BRACKET AT STATION 1155. INSTALLED NEW BRACKET PER SRM 51-10-01.
Back to Mcdonnell Douglas DC-9-82