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 AALA20151216004Stop Fitting · crackedCARGO MID CX, CRACKED DOOR STOP PAD SUPPORT BRACKET, FWD SIDE OF DOOR AT LOWER STOP. INSTALLED NEW MID CARGO DOOR, FWD LOWER DOOR STOP PAD FITTING IAW AARD 51-00-05-1 & DWG 4920233.SDR AALA20151211013B-Nut · looseEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING DECENT WHEN FLAPS 15 WAS SELECTED, THE RT HYD QTY & PRESS DROPPED TO ZERO. FOUND HYD FLUID LEAKING AT RT THRUST REVERSER B NUT. TIGHTENED B NUT. OPERATIONAL & LEAK CHECKED GOOD IAW AMM 29SDR AALA20151211006Battery Pack · dischargedAIRCRAFT WAS NOT GNDED. EMER LIGHTS INOPERATIVE IN THE CABIN. R & R BATTERY PACKS B5-104 & B5-28. PERFORMED OPERATIONAL CHECK IAW AMM 33-53-00. SYS CHECKED NORMAL. SEE ALSO AALA201511003.SDR AALA20151211003Battery Pack · dischargedAIRCRAFT WAS NOT GNDED. EMER LIGHTS INOPERATIVE IN THE CABIN. R & R BATTERY PACKS B5-104 & B5-28. PERFORMED OPERATIONAL CHECK IAW AMM 33-53-00. SYS CHECKED NORMAL. SEE ALSO AALA201511006.SDR AALA20151210005Stop Fitting · crackedMID CARGO DOOR, FWD CTR DOOR STOP CRACKED. INSTALLED NEW SERVICEABLE MID CARGO DOOR, FWD CTR DOOR STOP FITTING CDK2345-3 IAW AARD 51-00-05-1 & DWG 4920233. ACFT IN BASE MX.SDR AALA20151210004Stop · crackedMID CARGO DOOR, FORWARD TOP DOOR STOP CRACKED. INSTALLED NEW SERVICEABLE MID CARGO, FWD TOP DOOR STOP FITTING CDK2345-3 IAW AARD 51-00-05-1 & DWG 4920233. ACFT IN BASE MX.SDR AALA20151210003Stop Fitting · crackedFORWARD CARGO DOOR, FWD SECOND FROM TOP DOOR STOP CRACKED. INSTALLED NEW FWD CARGO DOOR, FWD SECOND FROM TOP DOOR, STOP FITTING CDK2345-3 IAW AARD 51-00-05-1 & DWG 4920223. ACFT IN BASE MX.SDR AALA20151211011Light · damagedAIRCRAFT WAS GNDED. FUSELAGE MOUNTED RT OVERWING EMER EVACUATION LIGHT HAS A FASTENER MISSING. FOUND FASTENER & NUTPLATE DAMAGED. R & R LIGHT ASSEMBLY & ALL FASTENERS IAW AMM 33-53-00.SDR AALA20151211001Transducer · damagedAIRCRAFT WAS GNDED. DURING TAKEOFF ROLL, WHEEL NOT TURNING LIGHT ILLUMINATED. TAKEOFF ABORTED PRIOR TO 80 KNOTS. FOUND BROKEN PINS AT NR 2 WHEEL SPEED TRANSDUCER. R & R TRANSDUCER IAW AMM 32-43-02.SDR AALA20151210006Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1451, BETWEEN LONGERON 1R & 2R. R & R SHEAR TIE IAW SRM 51-30-05. ACFT IN BASE MX.SDR AALA20151210002Battery Pack · dischargedREFERENCE WORK CARD 5403. EGRESS POWER SUPPLY AB5-3 FAILED TEST. REPLACED AB5-3 EGRESS LIGHT POWER SUPPLY BATTERY PACK IAW AMM 33-60-98. TESTED OK. THE ACFT WAS NOT GNDED.SDR AALA20151211010Cylinder · corrodedAIRCRAFT WAS GNDED. FOUND CORROSION ON RT MLG STRUT CYLINDER WHILE REMOVING GEAR INSPECTION PATCH. ACCOMPLISHED STEP B THROUGH STEP H OF AARD 32-10-00-4 IAW EA 256707 FOR TIME LIMITED REPAIR.SDR AALA20151206003Pan · corrodedFORWARD CARGO DOOR PAN HAS CORROSION. R & R FWD CARGO DOOR PAN IAW SRM 53-05-00-001. ACFT IN BASE MX.SDR AALA20151205001Warning System · false activationAFTER GEAR RETRACTION, NOSE RED LIGHT REMAINED ON WITH LOUD GEAR DOOR NOISE. THE FLIGHT DECLARED AN EMER & RETURNED. ON FINAL, WITH GEAR DOWN, AGAIN THERE WAS A FLUTTERING SOUND FROM NOSE GEAR. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. THE ACFT WAS NOT GSDR AALA20151204008Skin · corrodedFORWARD FUSELAGE SKIN BULGED & 7 EACH RIVET HEADS SHEARED OR CUPPED, BETWEEN L30R & L29R, AT PRODUCTION SPLICE, APPROX STATION 590. REMOVED CORROSION IAW SRM 51-10-03 & INSTALLED DOUBLER IAW 53-04-03 FIGURE 11. ACFT IN BASE MX.SDR AALA20151204005Battery Pack · dischargedMOD VISIT 27, FLIGHT DECK EMER LIGHTS FOUND INOPERATIVE. R & R BATTERY PACK IAW AMM 33-53-00.SDR AALA20151203002Battery Pack · dischargedFORWARD INTERIOR OVERWING EMER EXIT SIGNS FAIL TEST. R & R B5-103 EMER LIGHT BATTERY PACK IAW AMM 33-53-00. SYSTEM CHECKED NORMAL.SDR AALA20151126008Apu · seizedDIVERTED, APU FLAMED OUT & LT ENG CSD IS ON PLACARD. EMER LANDING WAS DECLARED. UNEVENTFUL LANDING. ACFT REMOVED FROM SERVICE. R & R APU IAW MCM WC 49-96-82.SDR AALA20151126001Battery Pack · dischargedREFERENCE WC 5403 EGRESS POWER SUPPLY AB5-3 FAILED TEST. REPLACED EGRESS POWER SUPPLY AB5-3 BATTERY PACK IAW AMM 33-60-98. TESTED OK.SDR AALA20151125001Beam · corrodedAFT CARGO, CORROSION EMITTING FROM BELOW STAINLESS DOUBLER ON LOWER DOOR BEAM STATION 1160-1200. REMOVED DOUBLER & CLEANED UP CORROSION, MANUFACTURED FILLERS & REINSTALLED DOUBLER IAW AARD 53-10-00-3 & EA 256278.SDR AALA20151124008Stop Fitting · crackedFORWARD CARGO COMPARTMENT DOOR, FWD SIDE, UPPER DOOR STOP CASTING IS CRACKED. INSTALLED NEW DOOR STOP CASTING, FITTING, IAW AARD 51-00-50-1, DWG 4920233 & DWG CD K2345.SDR AALA20151124007Stop Fitting · crackedFORWARD CARGO COMPARTMENT DOOR FWD SIDE, LOWER DOOR STOP CASTING IS CRACKED. INSTALLED NEW DOOR STOP CASTING, FITTING, IAW AARD 51-00-50-1, DWG 4920233, & DWG CD K2345.SDR AALA20151124006Stop Fitting · crackedMID CARGO COMPARTMENT DOOR AFT SIDE SECOND FROM BOTTOM DOOR STOP CASTING IS CRACKED. INSTALLED NEW DOOR STOP CASTING, FITTING, IAW AARD 51-00-05-1, DWG 4920233 & DWG CDK 2345.SDR AALA20151124003Battery Pack · dischargedREFERENCE WORK CARD 0801. EMER LIGHTS IN COCKPIT & FWD GALLEY DO NOT TEST. REPLACED BATTERY PACK B5-23 IAW AMM 33-53-00. TESTED OK.SDR AALA20151120007Stop Fitting · crackedAFT CARGO DOOR FWD STOP FITTING CRACKED. R & R STOP BRACKET IAW AARD 51-00-05-1.SDR AALA20151120008Skin · crackedFUSELAGE DENT IN SKIN AT STATION 1351 AT L6L. HFEC REVEALED CRACK, EXTERNAL DOUBLER INSTALLED IAW SRM 53-01-00-001.SDR AALA20151120002Longeron · crackedCRACK FOUND AT FASTENER HOLE, UPPER FLANGE ON LONGERON 23L AT STATION 200. REPAIRED WITH SPLICE REPAIR IAW SRM 53-02-00.SDR AALA20151119013Pressure Switch · failedLEFT ENG OIL STRAINER LIGHT FLICKERED, THEN CAME ON CONTINUOUSLY AFTER TAKEOFF. THE LT ENG WAS BROUGHT BACK TO IDLE. OIL PRESS, TEMP, & QTY NORMAL. EMER WAS DECLARED & FLIGHT RETURNED WITHOUT FURTHER INCIDENT. LT ENG WAS SHUT DOWN ON TAXI IN. ACFT REMOVEDSDR AALA20151117004Stop Fitting · crackedFORWARD CARGO DOOR, FWD 2ND FROM BOTTOM STOP PAD FITTING CRACKED. INSTALLED NEW CARGO DOOR STOP FITTING IAW AARD 51-00-05-1, DWG 4920233 & DWG CDK2345.SDR AALA20151116005Casting · crackedLEFT WING, CRACK IN GND SPOILER CASTING INBD EDGE. R & R CRACKED CASTING IAW SRM 51-01-00 & OPERATIONALLY CHECKED SPOILER IAW AMM 27-62-01-2.SDR AALA20151115001Structure · corrodedCORROSION ON CABIN SUBFLOOR, FWD SIDE OF STATION 160, APPROX 14 INCHES LT OF CTR. REMOVED CORROSION & INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20151113011Control Valve · defectiveON FINAL, GEAR DOWN, LT OTBD ANTI-SKID CAUTION LIGHT ON. EMER WAS DECLARED. ON GO AROUND, RAISED GEAR FOR SECOND APPROACH FOLLOWING QRH CHECKLIST. LT ANTI-SKID LIGHTS STAYED OUT AS NORMAL & THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. ACFT WAS REMOVED FROM SDR 2WAA20151106001Oil System · overservicedFLIGHT ATTENDANTS & PAXS REPORTED SMELLING SMOKE, PRECAUTIONARY DIVERSION. PERFORMED E & E VISUAL INSPECTION, NO DEFECT NOTED IAW 05-21-01 601. PERFORMED TAIL CONE AREA VISUAL INSPECTION, NO DEFECT NOTED IAW 05-21-01 501. PERFORMED BOTH ACM VISUAL INSPECTIOSDR AALA20151106012Regulator Valve · odorSHORTLY AFTER TAKEOFF ROTATION, THERE WAS A FAINT SHORT DURATION, APPROX 1 MINUTE, ODOR, EITHER A BURNING RUBBER OR OIL RESIDUE ODOR. NO SMOKE, JUST SMELL OR ODOR. THE FLIGHT CONTINUED TO DESTINATION WITHOUT FURTHER INCIDENT. R & R RT AIR CONDITIONING PRESSSDR AALA20151106011Regulator Valve · odorSHORTLY AFTER TAKEOFF ROTATION, THERE WAS A FAINT, SHORT DURATION, APPROX 1 MINUTE, ODOR, EITHER A BURNING RUBBER OR OIL RESIDUE ODOR. NO SMOKE, JUST SMELL OR ODOR. THE FLIGHT CONTINUED TO DESTINATION WITHOUT FURTHER INCIDENT. R & R LT AIR CONDITIONING PRESSDR AALA20151106010Water Separator · odorSHORTLY AFTER TAKEOFF ROTATION, THERE WAS A FAINT, SHORT DURATION, APPROX 1 MINUTE, ODOR, EITHER A BURNING RUBBER OR OIL RESIDUE ODOR. NO SMOKE, JUST SMELL OR ODOR. THE FLIGHT CONTINUED TO DESTINATION WITHOUT FURTHER INCIDENT. R & R RT WATER SEPARATOR IAW ASDR AALA20151106009Water Separator · odorSHORTLY AFTER TAKEOFF ROTATION, THERE WAS A FAINT, SHORT DURATION, APPROX 1 MINUTE, ODOR, EITHER A BURNING RUBBER OR OIL RESIDUE ODOR. NO SMOKE, JUST SMELL OR ODOR. THE FLIGHT CONTINUED TO DESTINATION WITHOUT FURTHER INCIDENT. R & R THE LT WATER SEPARATOR ISDR AALA20151102005Skin · delaminatedDELAMINATION AT END OF LT ELEVATOR, OTBD TE. INJECTED WITH RESIN & CLAMPED IAW SRM 55-03-00-001 FIGURE 5 & EA 255658.SDR AALA20151027001Portable Light · failedL1 DOOR PORTABLE EMER LIGHT DOES NOT TURN OFF AFTER EMER LIGHT TEST. ON & OFF SWITCH ON LIGHT ASSEMBLY HAS TO BE CYCLED. REPLACED L1 DOOR PORTABLE EMER LIGHT ASSEMBLY IAW AMM 33-53-00. TESTED OK.SDR AALA20151027009Strap · disconnectedTAIL CONE SLIDE COVER STRAP DISCONNECTED FROM BRACKET ON FLOOR. CONNECTED TAIL CONE SLIDE COVER STRAP IAW AMM-25-62-01.SDR AALA20151022011Angle · crackedANGLE CRACKED ON THE FWD UPPER SIDE OF THE RT MAIN GEAR DOOR ACTUATOR MOUNT ON THE CTR WALL OF THE RT MAIN GEAR WW. STRAP DOUBLER INSTALLED IAW SRM 51-70-05 & EA 255478.SDR AALA20151022007Portable Light · defectiveL1 DOOR PORTABLE EMER LIGHT LOCKING TAB MISSING. REPLACED L1 DOOR PORTABLE EMER LIGHT IAW AMM 33-53-00. OPERATIONALLY CHECKED NORMAL.SDR AALA20151021011Casting · crackedLEFT WING, CRACK AT INBD FWD CORNER OF GND SPOILER ACTUATOR CASTING. REPLACED GND SPOILER CASTING IAW AARD 51-00-05.SDR AALA20151021010Stop Fitting · crackedFORWARD CARGO DOOR CRACKED STOP PAD BRACKET AT AFT SIDE 2ND FROM TOP OF CARGO DOOR. INSTALLED NEW STOP PAD FITTING, PN CDK2345.SDR AALA20151021008Stop Fitting · crackedFORWARD CARGO DOOR, CRACKED STOP PAD BRACKET AT AFT LOWER CORNER OF CARGO DOOR. INSTALLED NEW STOP PAD FITTING, PN CDK2345.SDR AALA20151021007Stop Fitting · crackedFORWARD CARGO DOOR CRACKED, STOP PAD BRACKET AT FWD UPPER CORNER OF CARGO DOOR. INSTALLED NEW STOP PAD FITTING, PN CDK2345.SDR AALA20151021006Stop Fitting · crackedMID CARGO DOOR CRACKED, STOP PAD BRACKET AT FWD UPPER CORNER OF CARGO DOOR. INSTALLED NEW STOP PAD FITTING, PN CDK2345.SDR AALA20151020011Longeron · crackedLONGERON 23L AT STATION 200 CRACKED. REMOVED & INSTALLED NEW SECTION OF LONGERON & REPAIRED SPLICE ON LONGERON 23L, STATION 192 - 235 IAW SRM 53-20-00 FIGURE 18 & SRM 53-14-01 FIGURE 3.SDR AALA20151013001Battery Pack · dischargedAFT EMER LIGHTS CONTROLLED BY BATTERY PACK B5-28 INOPERATIVE. R & R B5-28 BATTERY PACK IAW AMM 33-53-00. AFFECTED AFT EMER LIGHT OPERATIONALLY CHECKED GOOD.SDR AALA20151009006Duct · leakingLEFT ENG FIRE INDICATION AT APPROX 1,500 FEET ON TAKEOFF. AN EMER WAS DECLARED & THE FLIGHT RETURNED WITHOUT FURTHER INCIDENT. THE LT ENG WAS NOT SHUTDOWN. ACFT REMOVED FROM SERVICE. R & R LT ENG COWL ANTI-ICE BLEED DUCT IAW AMM 71-10-01. OPERATIONALLY CH
Back to Mcdonnell Douglas DC-9-82