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 AALA200803095Oil System · leakingINFLIGHT, CREW REPORTED SMOKE IN CABIN AND SMELLED LIKE BURNED RUBBER. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND APU OIL LEAK ON LEFT SIDE WITH INGESTION INTO AIR CONDITIONING SYSTEM. REPLACED APU ON 13 DEC AT DFW. SYSTEM GROUND CHECKED NORMAL OPESDR AALA200910575Former · crackedCRACKED FORMER.SDR AALA20080391Light · inoperativeLGA - EMERGENCY LIGHT AT OVERHEAD CATWALK INOPERATIVE. REPLACED LAMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803090Lens · missingLGA - EMERGENCY LIGHT AT SEAT 7D MISSING LENS. REPLACED LENS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810514Battery · weakEMERGENCY LIGHTING BATTERY PACK TESTED WEAK (AMM 33-60-98-4). INSTALLED A SERVICEABLE BATTERY PACK.SDR AALA200810513Battery · weakEMERGENCY LIGHTING BATTERY PACK TESTED WEAK (AMM 33-60-98-4). INSTALLED A SERVICEABLE BATTERY PACK.SDR AALA200810512Battery · weakEMERGENCY LIGHTING BATTERY PACK TESTED WEAK (AMM 33-60-98-4). INSTALLED A SERVICEABLE BATTERY PACK.SDR AALA200810511Battery · weakEMERGENCY LIGHTING BATTERY PACK TESTED WEAK (AMM 33-60-98-4). INSTALLED A SERVICEABLE BATTERY PACK.SDR AALA200810478Shelf · crackedSHELF ABOVE RIGHT WHEEL WELL DOOR ACTUATOR TOP MOUNT IS CRACKED AT AFT END IN RADIUS. INSTALLED REPAIR ANGLE PER ESO 80559 DATED 12/11/08.SDR AALA200810476Angle · crackedANGLE CRACKED AT STATION 1474 AND LONGERON 19 LEFT. REMOVED AND REPLACED ANGLE PER SRM 53-01.SDR AALA200803079Strap · brokenLGA - FORWARD JUMPSEAT UPPER FLASHLIGHT SAFETY STRAP IS BROKEN. REPLACED SAFETY STRAP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803078Strap · brokenLGA - AFT EMERGENCY FLASHLIGHT STRAP BROKEN. REPLACED STRAP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810477Stiffener · crackedSTIFFENER AT STATION 1418 AND LONGERON 2 RIGHT CRACKED IN 2 PLACES. INSTALLED DOUBLER PER SRM 53-01 FIGURE 2.SDR AALA200803077Lens · missingMSP - EMERGENCY LIGHT AT RIGHT FORWARD OVERWING EXIT MISSING LENS. REPLACED LENS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803076Battery Pack · dischargedMSP - OVERHEAD EMERGENCY LIGHTS AT RIGHT AND LEFT EMERGENCY EXIT DOORS INOPERATIVE. REPLACED BATTERY PACK AT EXIT DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803075Battery Pack · dischargedMSP - EMERGENCY LIGHTS IN MID COACH CABIN INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 14. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803072A/C Pack · frozenMSY INFLIGHT - CREW REPORTED AT FL340 FLOW ON BOTH AIR CONDITIONING PACKS REDUCED TO ZERO FLOW FOLLOWED BY CABIN PRESSURE CLIMB. FLOW CAME BACK TO NORMAL WHEN DESCENDING THROUGH LOW TEENS. LANDED MSY WITHOUT INCIDENT. NO FAULTS FOUND. SUSPECT BOTH PACKS FRSDR AALA200803070Control Box · faultedDFW INFLIGHT - CREW REPORTED ATT FOUR ANTISKID WARNING LIGHTS ILLUMINATED WHEN GEAR LOWERED. LANDED DFW WITHOUT INCIDENT. REPLACED ANTI SKID CONTROL BOX. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810546Longeron · crackedSTATION 1260 LONGERON 22L, SPLICE CRACKED AT AFT END. INSTALLED SERVICEABLE LONGERON SPLICE PER SRM 51-02-00.SDR AALA200810545Longeron · corrodedCORROSION ON LONGERON 22L STATION 1286 TO 1295. REPAIRED PER SRM 53-02-00 FIG 18.SDR AALA200810490Stiffener · crackedSTIFFENER ON AFT SIDE OF FRAME STATION 1418 AT LONGERON 2R IS CRACKED AT ATTACH POINTS. REPAIRED PER SRM 53-01-00.SDR AALA200810489Frame · crackedFRAME CRACKED AT STATION 1418 LONGERON 2L. REPAIRED PER SRM 53-01-00 FIGURE 2.SDR AALA200803051Plate · missingSFO - EMERGENCY LIGHT AT SEAT 13D MISSING BACK PLATE. REPLACED BACK PLATE AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200910599Battery Pack · dischargedEMERGENCY LIGHTS AT AFT LAVS INOPERATIVE. REPLACED BATTERY PACK, OPERATION CHECK GOOD.SDR AALA200810548Cusp Web · corrodedCORROSION ON CUSP STATION 135 TO 155. INSTALLED DOUBLER.SDR AALA200810547Seat Track · corrodedCORROSION ON NUMBER 5 SEAT TRACK STATION 200 TO 205. SPLICED IN NEW SEAT TRACK FROM STATION 200 TO 242 PER SRM 53-05-00.SDR AALA200810544Doubler · corrodedCORROSION ON DOUBLER AT FORWARD SERVICE DOOR STATION 180 TO 200. REMOVED AND REPLACED DOUBLER PER AARD 53-20-00-16.SDR AALA200810543Pan · corrodedCORROSION ON LOWER VERTICAL AND HORIZONTAL PAN LEGS, FORWARD CARGO PAN STATION 370 TO 425. INSTALLED SERVICEABLE DOOR PAN AND SPLICES PER SRM 53-05-00 FIG 44.SDR AALA200810542Structure · corrodedCORROSION ON RIGHT SUBFLOOR STATION 218. REPAIRED PER AARD 53-20-00-16.SDR AALA200810541Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 220. INSTALLED A SERVICEABLE CUSP SHEET FROM STATION 218 TO 237.SDR AALA200810540Intercostal · crackedCRACKS IN INTERCOSTAL AT FASTENER HOLE STATION 1287 TO 1309, AFT CARGO. INSTALLED A SERVICEABLE INTERCOSTAL.SDR AALA200810539Fitting · corrodedCORROSION LOWER AFT CORNER FITTING IN AFT CARGO DOOR CUTOUT STATION 1212. INSTALLED A SERVICEABLE FITTING PER SRM 51-30.SDR AALA200810538Fitting · corrodedCORROSION ON LOWER FORWARD CORNER FITTING IN AFT CARGO DOOR CUTOUT STATION 1155. INSTALLED A SERVICEABLE FITTING PER SRM 51-30.SDR AALA200810537Angle · corrodedCORROSION ON RIGHT CUSP TEE ANGLE STATION 220. INSTALLED A SERVICEABLE TEE ANGLE FROM STATION 180 TO 228 PER SRM 53-05-00.SDR AALA200810493Frame · crackedCANT FRAME CRACKED STATION 1510 BELOW MAIN LIGHT SWITCH LEFT SIDE AT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER EA MD80 53-005083.SDR AALA200810492Frame · crackedFRAME CRACKED, STA 1510 BELOW RT LOWER TAIL CONE LATCH AT 2 EACH ALIGNMENT PINS. INSTALLED REPAIR DOUBLER IAW 53-005083.SDR AALA20081094Fitting · crackedCRACK IN GROUND SPOILER ACTUATOR FITTING LEFT WING. REPAIRED PER AARD 57-20-00-15 AND ESO 80559 DATED 12-05-08.SDR AALA200810486Casting · crackedRIGHT GROUND SPOILER CASTING CRACKED. INSTALLED DOUBLER OF 17-7 PH 0.100 THICK, (FULL LENGTH), AARD 57-20-00-15.SDR AALA200810491Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF STATION 1451 FRAME AT LONGERON 2R. REPLACED WITH SERVICEABLE SHEAR TIE PER SRM 53 01.SDR AALA200803062Switch · faultedDFW INFLIGHT - CREW REPORTED SLAT DISAGREE INDICATION WITH SLAT HANDLE IN THE UP POSITION. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED FLAP SLAT HANDLE POSITION SWITCH AND TRANSMITTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810536Beam · corrodedCORROSION ON MID CARGO DOOR BEAM STATION 636 TO 693. REPAIRED PER AARD 53-10-00-3.SDR AALA200810534Floorbeam · crackedFLOORBOARD SUPPORT CRACKED UNDER BOARD C-14 STATION 1060. INSTALLED A SERVICEABLE SUPPORT PER SRM 51-01.SDR AALA200810533Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK STATION 1041 TO 1220, AFT CARGO. INSTALLED A SERVICEABLE TIE DOWN TRACK PER SRM 53-01.SDR AALA200810532Cusp Web · corrodedCORROSION ON LEFT CUSP BETWEEN STATION 1250 AND 1304. REPAIRED PER AARD 53-20-00-16.SDR AALA200803054Lamp · burned outLGA - OVERHEAD EMERGENCY LIGHT AT STAIRWELL DOOR INOPERATIVE. REPLACED LAMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803053Battery Pack · looseLGA - OVERHEAD EMERGENCY LIGHT IN TAIL CONE COMPARTMENT INOPERATIVE. SECURED LOOSE BATTERIES IN BATTERY PACK AT AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803049Lens · missingSFO - EMERGENCY LIGHT AT SEAT 13D MISSING LENS. REPLACED LENS AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803048Lamp · damagedSFO - EMERGENCY LIGHT AT SEAT 13D INOPERATIVE. REPLACED LAMP AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803047Fuel Control · failedAUS INFLIGHT, CREW REPORTED ON SHORT FINAL APPROACH NR 1 ENGINE STOPPED PRODUCING THRUST. LANDED AUS WITHOUT INCIDENT. REPLACED NUMBER ONE ENGINE FUEL CONTROL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810552Floor Support · corrodedCORROSION ON AFT END OF FLOORBOARD SUPPORT ON RT SIDE.(AFT CARGO) INSTALLED A SERVICEABLE SUPPORT IAW SRM 51-10-1.
Back to Mcdonnell Douglas DC-9-82