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 AALA20050317Battery Pack · inoperativeHDQ - COCKPIT AND FORWARD CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR COCKPIT AND FORWARD CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050313Battery Pack · dischargedLGA - SEAT MOUNTED EMERGENCY LIGHTS AFT OF ROW 20 INOPERATIVE. REPLACED CHARGER AND BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS AFT OF ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050306Battery Pack · inoperativeSFO - OVERHEAD EMERGENCY EXIT LIGHTS AT SEATS 28D TO 31D INOPERATIVE. RECHARGED THE EMERGENCY LIGHTS SYSTEM IN THE ARM POSITION FOR THE OVERHEAD EMERGENCY EXIT LIGHTS AT SEATS 28D TO 31D. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20050309Engine · inoperativeABOUT 20 MINUTES INTO FLIGHT LEFT OIL PRESSURE LOW LIGHT ON. PRESSURE AND OIL QUANTITY DROPPED TO ZERO. SHUTDOWN LEFT ENGINE PER QRH. OIL TEMPERATURE 80, QUANTITY ZERO NUMBER TWO. 55 PERCENT ENGINE SHUTDOWN. AFTER OIL QUANTITY ZERO THREE MINUTES ENGINE WINDSDR MWEA050041Lanyard · detachedFORWARD GALLEY SERVICE DOOR SLIDE COVER LANYARD CAME DETACHED. RE-INSTALLED LANYARD.SDR ASMF200505009Computer · failedAIRCRAFT RETURNED TO PLATFORM AS A CONSEQUENCE OF DURING TAXING TO AUTO SLAT FAIL AND AUTO SLAT DISAGREE LIGHTS COME ON. SYSTEM WAS RESET AND TESTED BUT FAILURE CONTINUED. STALL WARNING COMPUTER BITE WAS PERFORMED AND DETECTING FAILURE IN THE NUMBER 1. THE SDR AALA20050303Battery Pack · inoperativeSFO - OVERHEAD EMERGENCY LIGHTS OVER ROWS 9 TO 11 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS OVER ROWS 9 TO 11. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR ASMF200505001Cooler · failedDURING TRANSIT CHECK, IT WAS DETECTED OIL LEAK IN THE LEFT ENGINE FUEL-OIL COOLER AND THE OIL TANK OVERFILLED WITH FUEL SMELT. FUEL-OIL COOLER OF THE LEFT ENGINE WAS REPLACED IAW MM 79-20-01 AND ENGINE LUBRICATING OIL PROCEDURE WAS PERFORMED IAW MM 72-00-00, SDR AALA20050299Battery Pack · inoperativeSFO - OVERWING EMERGENCY UPPER DOOR LIGHTS AT ROW 20ABCD INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD OVERWING EMERGENCY LIGHTS AT ROW 20ABCD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050296Cylinder · inoperativeDURING APPROACH INTO BWI, UNABLE TO EXTEND NOSE GEAR. ACCOMPLISHED EMERGENCY GEAR EXTENSION PROCEDURES. LANDED BWI WITHOUT INCIDENT. AIRCRAFT INSPECTED AND FERRIED TO DCA FOR REPAIRS. REPLACED NOSE LANDING GEAR BUNGEE CYLINDER. SYSTEM GROUND CHECKED NORMASDR GTIA050151Channel · crackedFTW - FOUND MAIN CABIN, LEFT SIDE WEB PANEL STATION 826 TO 927 CRACKED/DAMAGED AT HAT SECTION. REMOVED DAMAGED CRACK AREA FROM HAT CHANNEL. FABRICATE FILLER AND DOUBLER. TREAT, PRIMED AND INSTALLED REPAIRED FILLER AND DOUBLER. (M)SDR AALA20050294Battery Pack · dischargedLAX - CEILING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACKS AT B5104 AND B51-6 FOR CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050293Battery Pack · inoperativeBOS - LOW BATTERY IN EXIT EMERGENCY LIGHT AT CENTER AFT DOOR. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHT AT CENTER AFT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050291Seal · inoperativeDFW ENROUTE ON FLIGHT 1664 TAIL COMPARTMENT HIGH TEMPERATURE LIGHT CAME ON WHILE CLIMBING THROUGH 12000 FEET. IT WOULD GO OUT AT REDUCED THRUST AND CLIMB POWER AND THEN COME BACK ON. RETURNED DFW AND LANDED WITHOUT INCIDENT. REPLACED PERI-SEALS IN RT A/C PSDR GTIA050146Hydraulic System · contaminatedFLL - RIGHT HYDRAULIC TEMP HIGH LIGHT CAME ON DURING FLIGHT, AIRCRAFT TAIL SWAP WITH 819NK. BLED RIGHT HYDRAULIC SYSTEM RESERVOIR OF EXCESS AIR AND SERVICED TO PROPER LEVEL, OPS CHECK NORMAL. (M)SDR MWEA050035Wire · brokenEMERGENCY FLOOR TRACK ALONG GALLEY'S COAT CLOSET HAS BROKEN WIRE AT SPLICE. REPAIRED WIRES BY MEANS OF SLICING.SDR T48R20050011Engine · damagedENGINE WAS REMOVED FROM N803NK FOR INFLIGHT SHUTDOWN. DISASSEMBLY AND INSPECTION REVEALED THE HPC, HPT AND LPT MODULES HAVE HEAVY IMPACT DAMAGE.SDR AALA20050285Landing Gear · inoperativeBNA - EN ROUTE BNA-DFW LANDING GEAR WOULD NOT RETRACT. RETURNED BNA AND LANDED WITHOUT INCIDENT. PINNED GEAR AND RECYCLED GROUND DOOR RELEASE HANDLE. NO OTHER DEFECTS NOTED. FCF COMPLETED AND GEAR RECYCLED AND OPERATES NORMAL. SYSTEM GROUND CHECKED NORMALSDR AALA20050287Module · inoperativeATL - FORWARD SECTION EMERGENCY PATH LIGHTING WILL NOT TEST. REPLACED BATTERY AND MODULE FOR FORWARD SECTION EMERGENCY PATH LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050286Battery Pack · inoperativeSFO - EMERGENCY EGRESS LIGHT INOPERATIVE AT ROW 20 AFT. REPLACED BATTERY FOR EMERGENCY EGRESS LIGHT AT ROW 20 AFT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050129Acm · failedRIGHT PACK CAUSING SMOKE IN CABIN, GATE RETURN. FOUND OIL AT OUTLET OF RIGHT ACM TURBINE. REMOVED AND REPLACED RT ACM AND COALESCER BAG. OPS CHECK GOOD. (M)SDR AALA20050277Gasket · inoperativeFLIGHT ATTENDANT REPORTED SMOKE IN AFT CABIN AFTER TAKEOFF. RETURNED TO STL AND LANDED WITHOUT INCIDENT. REPLACED GASKETS ON LOOSE LEFT PACK PRESSURE REGULATING AND SHUTOFF VALVE 90 DEGREE ELBOW. REPLACED SOCKS AND ACCOMPLISHED CARDS 21-96-01 AND 21-92-12. SDR GTIA050133Hinge · crackedFORWARD PIT, BARRIER DOOR SUPPORT HINGE HALF CRACKED, 3 HOLES MOUNTING CRACKED. REMOVED HINGE AND BLENDED OUT CRACK IN HINGE. STOP DRILLED CRACK IN HAT CHANNEL. PERFORMED DYE PEN, SHOWS CRACK CONTAINED. FABRICATED DOUBLER ON BARRIER DOOR SUPPORT HINGE. (MSDR GTIA050149Hinge · crackedFTW - AFT PIT, BARRIER DOOR SUPPORT CRACKED AT HINGE HALF. REMOVED AND REPLACED HINGE HALF, TREATED AND PRIMED. (M)SDR GTIA050150Bracket · crackedFTW - AFT PIT, UPPER LATCH BRACKET SUPPORT IS CRACKED. REMOVED AND FABRICATE NEW BRACKET. TREAT, PRIMED AND INSTALLED BRACKET. (M)SDR ASMF200504014Line · damagedCAPTAIN REPORTED THAT DURING FLIGHT LOT HYDRAULIC LIQUID IN THE LEFT SYSTEM WITH HYDRAULIC PRESSURE CORRECT. DURING REVISION WAS DETECTED THE HYDRAULIC TANK LEFT SYSTEM EMPTY, IT WAS RECHARGED. THE LEFT SYSTEM WAS PRESSURIZED AND BRAKE RETURN LINE HAD A LEAKSDR GTIA050137Door · dentedFTW - FOUND DENT ON LOWER AFT CORNER OF AFT AIRSTAIR DOOR STATION 1510, D=.5, X=.040. CUT OUT DENTED AREA. FABRICATED DOUBLER AND FILLER. TREATED, PRIMED AND INSTALLED REPAIRED DOUBLER AND FILLER. (M)SDR GTIA050142Support Bracket · brokenFTW - FORWARD PIT RIGHT UPPER SIDEWALL, WATER LINE SUPPORT BRACKET IS BROKEN AT STATION 465. REMOVED AND FABRICATED NEW SUPPORT BRACKET. TREATED, PRIMED AND INSTALLED NEW SUPPORT BRACKET. (M)SDR GTIA050147Support Bracket · brokenLEFT WING LEADING EDGE PANEL NR 1160C HAS BROKEN SHIELD SUPPORT BRACKET. REMOVED AND FABRICATE NEW SHIELD SUPPORT BRACKET. TREAT, PRIMED AND INSTALLED SHIELD SUPPORT BRACKET. (M)SDR AALA20050272Blades · damagedCOMPRESSOR STALL ON TAKEOFF AT 50 FEET TO FLEX 50 DEGREES. RIGHT ENGINE EXHAUST GAS TEMPERATURE IN AMBER AREA 590 DEGREES. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND STAGE 7 BLADES DAMAGED. REPLACED RIGHT HAND ENGINE. SYSTEM GROUND CHECKED NORMAL SDR AALA20050269Battery · not seatedSFO - OVERHEAD EMERGENCY LIGHTS AT ROWS 8 TO 11 INOPERATIVE. RESEATED BATTERIES IN PACKS FOR OVERHEAD EMERGENCY LIGHTS FOR ROWS 8 TO 11. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050132Cusp Web · corrodedFTW - CABIN LEFT CUSP CORRODED FS 237-256. REMOVED CORROSION AT CUSP WEB FS 237-256. FOUND OUT OF LIMITS. REMOVED DAMAGED CUSP WEB. FABRICATED DOUBLER AND FILLER IAW SRM 51-70-4. TREATED AND PRIMED, INSTALLED REPAIRED PARTS IAW SRM 51-70-4. (M)SDR GTIA050136Floor Support · corrodedFOUND CORROSION ON TOP OF FLOORBOARD SUPPORT AT STATION 180 RBL 7 TO RBL 30. REMOVED CORROSION, FOUND OUT OF LIMITS. FABRICATED AND DRILLED SUPPORT. TREATED, PRIMED AND INSTALLED FLOOR SUPPORT. (M)SDR AALA20050262Battery Pack · dischargedDFW - PORTABLE EMERGENCY LIGHT AT LEFT ONE DOOR AND EXTERIOR OVERWING EMERGENCY LIGHTS ON LEFT AND RIGHT SIDE INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT AT LEFT ONE DOOR AND REPLACED BATTERY PACK FOR EXTERIOR OVERWING EMERGENCY LIGHTS ON LEFT AND RIGHT SISDR GTIA050134Support · crackedFTW - MID PIT, STATION 712 RIGHT SIDE CHANNEL WALL SUPPORT IS CRACKED. FABRICATED REPAIR DOUBLER. TREATED AND PRIMED DOUBLER. OK TO INSTALL. (M)SDR GTIA050135Web · crackedFTW - WEB CRACKED AT STATION 210 LEFT CABIN JUST AFT OF L1 DOOR BAYONET CATCH. TRIMMED OUT CRACKED AREA. FABRICATED DOUBLER AND FILLER. TREATED, PRIMED AND INSTALLED REPAIRED PARTS. (M)SDR GTIA050139Retainer · gougedFTW - FORWARD CARGO COMPARTMENT DOOR UPLOCK GUIDE BRACKETS FORWARD AND AFT AT SEAL RETAINER HAVE DEEP GOUGES. BLENDED FORWARD AND AFT BRACKETS, FOUND TO BE OUT OF LIMITS. FABRICATED BRACKET, TREATED AND PRIMED. REPAIRED PART INSTALLED. (M)SDR GTIA050140Bracket · crackedAFT ACCY COMPT, OVERHEAD CANT 1463, HAND RAIL SUPPORT ROD MOUNT BRACKET IS CRACKED. REMOVED AND FABRICATE NEW BRACKET. TREATED AND PRIMED. REPAIRED BRACKET INSTALLED. (M)SDR GTIA050141Bracket · brokenFTW - AFT ACCY COMP LEFT SIDE CANT 1463 WIRE HARNESS BRACKET IS BROKEN. REMOVED AND FABRICATE NEW BRACKET. TREAT, PRIMED AND REPAIRED BRACKET INSTALLED. (M)SDR AALA20050266Pin · migratedRDU - PINS MIGRATED OUT OF EMERGENCY SLIDE AT LEFT NUMBER ONE DOOR. REPLACED LEFT NUMBER ONE EMERGENCY SLIDE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050261Battery Pack · dischargedATL - FORWARD ENTRY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT B523 FOR FORWARD ENTRY OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050260Battery Pack · dischargedLAX - FORWARD DOOR OVERWING EXIT SIGNS INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD DOOR OVERWING EXIT SIGNS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050257Battery Pack · dischargedSAT - FORWARD GALLEY AND COCKPIT EMERGENCY ESCAPE LIGHT AND AFT CABIN OVERHEAD EMERGENCY LIGHTS FROM ROW 18 BACK INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD GALLEY AND COCKPIT EMERGENCY ESCAPE LIGHTS AND AFT CABIN OVERHEAD EMERGENCY LIGHTS FROM ROW 18 BACKSDR AALA20050259Seal · leakingSJC - CABIN BEGAN FILLING WITH SMOKE SHORTLY AFTER TAKEOFF. RETURNED TO SJC AND LANDED WITHOUT INCIDENT. FOUND APU OIL COOLER SEAL LEAKING. REPLACED APU OIL COOLER SEAL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050126Fuel Control · out of trimNR 1 ENGINE IDLE IS TO LOW WITH BLEED 45-47 PERCENT N2 ENGINE EXTREMELY SLOW TO ACCELERATE, EGT IS 490 AT IDLE, MUST MOVE THROTTLE 1 KNOB FORWARD TO MAINTAIN 50 PERCENT N2, NR 2 ENGINE IDLE IS TO LOW WITH BLEED ON 48 PERCENT N2 ENGINE IS VERY SLOW TO ACCELERATSDR AALA20050255Socket · defectiveDFW - EMERGENCY LIGHT AT SEAT 25D INOPERATIVE. REPLACED SOCKET AT SEAT 25D FOR EMERGENCY SEAT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050254Battery Pack · dischargedLAX - EMERGENCY LIGHTS AT AFT CABIN CEILING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT CABIN CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050249Battery Pack · dischargedBOS - EMERGENCY TRACK LIGHTING FROM SEAT 20DEF FORWARD INOPERATIVE. REPLACED BATTERY PACK ABOVE SEAT 20DEF AND IN FIRST CLASS GALLEY AND SPLICED TWO CHAFED WIRES FOR EMERGENCY TRACK LIGHTING FROM SEAT 20DEF FORWARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050251Wire Harness · defectiveLGA - EMERGENCY EGRESS LIGHTING AT SEAT 27D INOPERATIVE. REPLACED SEAT HARNESS AT SEAT 27D FOR EMERGENCY EGRESS LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050247Oil Cap · unsecureAUS - ON ROTATION BURNING OIL SMELL IN COCKPIT. AT ABOUT 2000 FEET FLIGHT ATTENDANT CALLED TO REPORT SMOKE IN CABIN THAT ALSO SMELLED LIKE BURNING OIL. RETURNED TO AUS AND LANDED WITHOUT INCIDENT. PLACARD APU FOR OIL LEAK. REPLACED COALESCER BAGS AND ACCOM
Back to Mcdonnell Douglas DC-9-82