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 AALA200910566Cusp Web · corrodedCORROSION ON LEFT CUSP BS 503. INSTALLED REPAIR PER AARD 53-20-00-16.SDR AALA200910565Cusp Web · corrodedCORROSION ON RIGHT CUSP STATION 1287. INSTALLED REPAIR PER AARD 53-20-00-16.SDR AALA200803190Battery Pack · looseLGA - EMERGENCY LIGHT FROM OVERHEAD SEAT ROW 28 TO 30 INOPERATIVE. RESEATED BATTERY PACK BATTERIES AT SEAT ROW 29. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803189Battery Pack · dischargedDFW - EMERGENCY LIGHT EXIT MARKER AT OVERWING INOPERATIVE. REPLACED BATTERY PACK AT SEAT ROW 20 FOR EXIT MARKER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803180Turbine Blades · failedORD INFLIGHT - DURING CLIMB AT ABOUT 3000 FT, THE NR 2 ENGINE HAD ONE COMPRESSOR STALL AND ROLLED BACK TO IDLE. CREW REPORTED OIL QUANTITY AND PRESSURE WENT TO ZERO. CREW SHUT DOWN NR 2 ENGINE AND RETURNED TO ORD AND LANDED WITHOUT INCIDENT. SINGLE ENGINE TSDR AALA200803179Tie Bolt · brokenDFW INFLIGHT - AFTER TAKEOFF AT MEM FLIGHT ATTENDANT REPORTED STRONGER THAN NORMAL RUBBER ODOR AND UNUSUAL VIBRATION COMING FROM THE LEFT MAIN TIRE AND WHEEL WELL AREA. CREW REPORTED NO INDICATIONS IN COCKPIT. ALL BRAKE TEMPERATURES NORMAL. LANDED DFW WITHOSDR RYNA2008122300047Landing Gear · lack of lubeDURING LANDING NLG FAILED TO EXTEND, MLG INDICATION GREEN, NLG INDICATION LIGHT RED, GEAR WARNING HORN SOUNDED NLG PEDESTAL PIN WAS FLUSH. RECYCLED GEAR HANDLE ON SECOND ATTEMPT ALL GEAR DOWN AND IN LOCKED POSITION. JACKED A/C CYCLED GEAR ALL CHECKS NORMAL. SDR AALA200803170Battery Pack · dischargedLGA - EMERGENCY LIGHTS IN FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803167Strut · dischargedCOS - INFLIGHT, CREW REPORTED NOSE LANDING GEAR GRINDING OR SPINNING NOISE ON RETRACTION WITH BURNING RUBBER ODOR NOTED. RETURNED TO COS AND LANDED WITHOUT INCIDENT. REPLACED LEFT AND RIGHT NOSE TIRES AND ACCOMPLISHED STRUT SERVICE. SYSTEM GROUND CHECKED NOSDR YYFA20080004Amplifier · inoperativePA SYS INTERMITTENT.SDR AALA200803154Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT FORWARD CABIN OVERHEAD INOPERATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803148Bearing · failedORD INFLIGHT - CREW REPORTED UNABLE TO RETRACT NOSE GEAR. PLACED GEAR DOWN AND GREEN LOCKED LIGHT ILLUMINATED. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED TURNING TUBE THRUST BEARING AND REPACKED NOSE LANDING GEAR. SYSTEM GROUND CHECKED NORMAL OPSDR AALA200803144Battery Pack · dischargedLGA - EMERGENCY LIGHTS FROM SEAT ROWS 21 TO 32 INOPEATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803143Module · failedLGA - EMERGENCY LIGHTS FROM SEAT ROWS 21 TO 32 INOPERATIVE. REPLACED BATTERY PACK AND MODULE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810554Shear Tie · crackedSHEAR TIE CRACKED AT FRAME STA 1418 BETWEEN LONGERON 1 AND 2 RT. INSTALLED REPAIR ANGLE IAW ESO 80559 DATED 12-18-08 AND AARD 53-10-00-20.SDR RYNA2008122200046Bungee Cylinder · defectiveDURING LANDING NLG FAILED TO EXTEND CHECKED TILLER ALIGNMENT MLG INDICATION WAS GREEN NLG INDICATION RED NLG PEDESTAL PIN WAS FLUSH. REACCOMPLISHED GEAR EXTENSION NLG INDICATED SAFE. AIRCRAFT WAS FERRIED TO HAMILTON IN TUS FOR TROUBLESHOOTING. JACKED FWD NOSDR AALA200803139Wire · brokenLGA - EMERGENCY LIGHT AT SEAT ROWS 1 TO 20 INOPERATIVE. REPAIRED BROKEN WIRE UNDER SEAT 1DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803138Light · dischargedLGA - PORTABLE EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803137Battery Pack · dischargedLGA - EMERGENCY LIGHT AT LEFT NR 2 DOOR INOPERATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200910560Attach Angle · crackedRIGHT ATTACH ANGLE, VERTICAL STABILIZER IS CRACKED. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-2, REFERENCE ECO K2221CC.SDR AALA200910578Casting · crackedGROUND SPOILER CASTING CRACKED ON OUTBOARD SIDE ABOVE GROUND SPOILER ACTUATOR FORWARD ATTACH BOLT. REPLACED CASTING.SDR AALA200910577Battery Pack · dischargedBATTERY PACKS TESTED DIM.SDR AALA200810515Battery · weakBATTERY PACK TESTED DIM, REF- AMM 33-60-98-4. INSTALLED SERVICABLE BATTERY PACK.SDR AALA200803131Clamp · looseICT INFLIGHT - CREW REPORTED DIRTY SOCK ODOR IN CABIN. RETURNED TO ICT AND LANDED WITHOUT INCIDENT. REPLACED RIGHT AFT WATER SEPARATOR SUPPORT CLAMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200910597Power Supply · dischargedFAILED OPERATIONAL TEST. REPLACED BATTERY POWER SUPPLY. OPERATIONAL CHECK OK, PER AMM 33-53-00-5.SDR AALA200910564Cusp Web · corrodedCORROSION ON CUSP STATION 697 TO 702, LEFT SIDE. INSTALLED REPAIR PER AARD 53-20-00-16.SDR AALA200910563Cusp Web · crackedCUSP MEMBRANE CRACKED AT STATION 218 OUTBOARD OF NUMBER 2 SEAT TRACK. INSTALLED REPAIR PER AARD 53-20-00-16.SDR AALA200910562Mount · corrodedCORROSION ON AFT SERVICE DOOR, FORWARD GIRT BAR MOUNT. INSTALLED A SERVICEABLE GIRT BAR MOUNT PER SRM 51-01.SDR AALA200910576Light · faultyCABIN EMERGENCY LIGHTS TEST DIM.SDR AALA200803129Piston · failedSDF - CREW REPORTED NOSE LANDING GEAR DID NOT RETRACT. RETURNED TO SDF AND LANDED WITHOUT INCIDENT. REPLACED PISTON AND SERVICED STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803122Proximity Sensor · failedLAX, INFLIGHT PSP TO DFW - CREW REPORTED UNSAFE NOSE LANDING GEAR INDICATION ON TAKEOFF. EXTENDED MAIN LANDING GEAR WITH THREE GREEN INDICATIONS. DIVERTED TO LAX AND LANDED WITHOUT INCIDENT. REPLACED D1 32 PROXIMITY SENSOR. SYSTEM GROUND CHECKED NORMAL OPESDR AALA200910561Mount · corrodedCORROSION ON NUMBER 2 GALLEY TIE DOWN MOUNT. INSTALLED A SERVICEABLE GALLEY MOUNT PER SRM 51-01-51-30.SDR AALA200910558Mount · corrodedCORROSION ON FORWARD GIRT BAR MOUNT STATION 1145. INSTALLED A SERVICEABLE GIRT BAR MOUNT.SDR AALA200810510ALight · inoperativePORTABLE EMERGENCY LIGHT B5-29 ARM LIGHT DOES NOT COME ON. INSTALLED SERVICEABLE LIGHT.SDR AALA200910559Seat Track · corrodedCORROSION ON NUMBER 4 SEAT TRACK STATION 290. INSTALLED SEAT TRACK PLUG AT STATION 290.SDR AALA200910556Doubler · corrodedCORROSION ON DIAMOND DOUBLER (DELTA PLATE) STATION 1338 AT LONGERON 30. REMOVED DIAMOND DOUBLER AND INSTALLED A SERVICEABLE DOUBLER PER SRM 51-01.SDR AALA200810475Stop Fitting · crackedFORWARD SIDE OF AFT CARGO DOOR, LOWER STOP PAD FITTING CRACKED. FITTING WAS REMOVED AND REPLACED WITH NEW FITTING SRM 53-01.SDR AALA200803111Start Valve · inoperativeDFW INFLIGHT - CREW REPORTED NUMBER TWO ENGINE START VALVE OPEN INDICATION. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED NUMBER TWO ENGINE START VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION. SUPPLEMENT TO CORRECT CONTROL NUMBER FROM AALA20080311SDR AALA20080311Start Valve · inoperativeDFW INFLIGHT - CREW REPORTED NUMBER TWO ENGINE START VALVE OPEN INDICATION. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED NUMBER TWO ENGINE START VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810480Tee Fitting · crackedLOWER FORWARD TEE FITTING CRACKED. REMOVED AND REPLACED CRACKED TEE FITTING.SDR AALA200803110Connector · disconnectedSFO - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. RECONNECTED WALL TO SEAT CONNECTOR AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803109Battery Pack · dischargedSFO - EMERGENCY LIGHTS AT MID COACH CABIN DIM. REPLACED BATTERY PACK AT OVERHEAD SEAT 20D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803105Battery Pack · dischargedEMERGENCY LIGHT AT SEAT ROWS 20 TO 32 INOPERATIVE. REPLACED BATTERY PACK AT AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803104Module · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROWS 20 TO 32 INOPERATIVE. REPLACED CONTROL MODULE AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803103Contact · dirtyLGA - EMERGENCY LIGHT AT OVERHEAD TAIL CONE SLIDE INOPERATIVE. CLEANED AND ADJUSTED CONTACTS OF POWER SUPPLY FOR TAIL CONE SLIDE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803102Contact · dirtyLGA - EMERGENCY LIGHTS IN SIDEWALL BY AFT STAIRS INOPERATIVE. CLEANED AND ADJUSTED CONTACTS FOR POWER SUPPLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803101Battery · looseLGA - EMERGENCY LIGHT BY AFT JUMPSEAT INOPERATIVE. RESEATED BATTERY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803100Light · inoperativeLGA - EMERGENCY LIGHTS ACROSS FROM FORWARD LAVATORY INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803099Battery Pack · dischargedLGA - SEAT MOUNTED EMERGENCY LIGHTS AFT OF OVERWING EXITS INOPERATIVE. REPLACED BATTERY PACK AT AFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803096Duct · leakingMSP INFLIGHT - CREW REPORTED HEARING LOUD BANG IN AFT CABIN FOLLOWED BY FLIGHT ATTENDANTS REPORTING SMOKE IN CABIN AND AFT CARGO FIRE WARNING INDICATION. CREW DISCHARGED CARGO FIRE SYSTEM. RETURNED TO MSP AND LANDED WITHOUT INCIDENT. REPLACED BLOWN WING ANT
Back to Mcdonnell Douglas DC-9-82