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 GTIA050110Structure · crackedCATWALK SIDE FILLER STATION 1510 IS CRACKED ON RIGHT SIDE. STOP DRILLED CRACK, FABRICATED REPAIR DOUBLER. TREATED AND PRIMED, INSTALLED DOUBLER IAW SRM 51-30-2. (M)SDR GTIA050111Structure · crackedCATWALK SIDE FILLER STTION 1361 LEFT AND RIGHT IS CRACKED IN RADIUS. STOP DRILLED CRACKS ON CAT WALK STATION 1361 LEFT AND RIGHT. FABRICATED TWO REPAIR DOUBLER LEFT AND RIGHT WEB REPAIR. TREATED AND PRIMED, INSTALLED TWO REPAIR ON CATWALK STATION 1361 LEFT SDR GTIA050108Attach Angle · crackedFORWARD AIRSTAIR UPPER ATTACH ANGLE ON SHROUD IS CRACKED AND DAMAGED. REMOVED ANGLE FROM FORWARD AIRSTAIR SHROUD. FABRICATE NEW ANGLE. TREATED AND PRIMED, INSTALLED ANGLE IAW SRM 51-30-1. (M)SDR GTIA050112Skin · dentedDENT AT FS 1174 BETWEEN LONGERON 21R AND 22R ON AFT CARGO DOOR, D=1.5, X=0.035, D/X=42.85, CONDITION 1B. REMOVED 2 INCH ROUND CUT OUT DAMAGED AREA OF DOOR. FABRICATED FILLER AND DOUBLER FOR AFT CARGO DOOR STATION 1174 BETWEEN L21R AND 22R IAW SRM 51-10-4 ANDSDR GTIA050113Skin · dentedDENT AT FS 1304 BETWEEN LONGERONS 18R AND 19R, D=1 INCH BY .020 INCH D/X=50, CONDITION 1B. INSPECTED FOUND FURTHER DAMAGE IN DENT (GOUGE) REQUIRING REPAIR. CUT OUT DAMAGE SKIN SECTION (2.10 DIAMETER). FABRICATED SKIN FILLER AND INTERNAL DOUBLER IAW SRM 53-0SDR GTIA050114Strip · crackedFTW - MID PIT LEFT SIDE STATION 541, UPPER SIDEWALL SUPPORT STRIP CRACKED. REPAIRED DAMAGED AREA IAW SRM 53-05 PG 137. FABRICATED DOUBLER, TREATED AND PRIMED. INSTALLED DOUBLER IAW SRM 51-30-2. (M)SDR GTIA050094Frame · crackedFROM C/O 0155770 RT WING L/E 2 EA FORMERS ST APPROX STA 351 CRACKED. FABRICATED DOUBLER IAW SRM. HEAT TREATED 2 EA DOUBLER IAW SRM. TREATED AND PRIMED INSTALLED REPAIR DOUBLER IAW SRM. LP NR 01476783. (K)SDR AALA20050182Switch · failedDEN - UPON GEAR RETRACTION GREEN NOSE GEAR LIGHT REMAINED ON, IT STAYED ON FOR THE ENTIRE FIGHT. REPLACED NOSE LANDING GEAR RETRACT SWITCH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050171Contact · dirtySFO - ENTRY EMERGENCY LIGHTS AT NUMBER ONE DOOR INOPERATIVE. CLEANED CONTACTS FOR POWER AND GROUND FOR LEFT NUMBER 1 ENTRY DOOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050185Fuel Control · malfunctionedELP INFLIGHT T2438/5 MAR RIGHT ENGINE FAILED TO RESPOND TO THROTTLE MOVEMENT. RIGHT ENGINE WAS STUCK AT 93 PERCENT N2, EGT 500, EPR2.02 AT FL350. CHECKLIST SHOWS A COMPLETE LOSS OF NUMBER 2 SIGNAL TO THE FUEL CONTROL UNIT. ENGINE PAGE 20. SHUT DOWN PER CSDR MWEA050025Seal · leakingFIRST OFFICER'S WINDOW WAS LEAKING AND WOULD GET LOUDER AS ALTITUDE WAS INCREASED. PRESSURIZED AIRCRAFT AND FOUND FIRST OFFICER'S WINDOW LEAKING, INSPECTED FIRST OFFICER'S CLEARVIEW SEAL AND FOUND VOID IN UPPER FORWARD CORNER. RESEALED VOIDS, PRESSURIZED AIRSDR GTIA050080Floorbeam · corrodedAFT CARGO COMPARTMENT, STA 1309. CABIN FLOORBEAM IS CORRODED (EXFOLIATION) AT RBL 20. FOUND LWR AFT ANGLE SUPPORT CRACKED. CORROSION FOUND TO BE ALL THE WAY THROUGH FLOORBEAM AND IS OUT OF LIMITS. DETENTIONED CABLE RUNS, DISCONNECTED 2 HYD LINES AND POT. SDR GTIA050083Floor Support · corrodedAFT CARGO COMPARTMENT, STA 1174, LBL 12, MAIN CABIN FLOORBEAM UPPER FLOOR SUPPORT ANGLE IS CORRODED (EXFOLIATION). REMOVED DAMAGED FLOORBEAM AND FOUND OUT OF LIMITS. FABRICATED NEW SUPPORT ANGLE, PRIMED AND TREATED. INSTALLED FLOOR SUPPORT ANGLE IAW SRM. (SDR AALA20050170Battery Pack · inoperativeSFO - LEFT AND RIGHT FUSELAGE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR LEFT AND RIGHT EMERGENCY LIGHT. LEFT EMERGENCY LIGHT WORKS. RIGHT EMERGENCY LIGHT STILL INOPERATIVE. REPLACED BULB IN RIGHT EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL SDR AALA20050183Apu · leakingORD INFLIGHT T9673/4 MAR TEST FLIGHT FUMES IN CABIN SHORTLY AFTER TAKEOFF. VISIBLE BLUE SMOKE COMING FROM AFT CABIN, QUICKLY FILLED ENTIRE CABIN. TURNED OFF AIR CONDITIONER PACKS. SMOKE SLOWLY DISSIPATED. LANDED, DECLARED EMERGENCY LANDING DURING TEST FLISDR GTIA050071Skin · dentedSKIN DENT AT STA 1174, BETWEEN LONGERON 17L AND 18L. REMOVED SAF-T-GLO, GALLEY 4 AND SIDE WALL PANEL TO FOM AT LT FS 1184. FOUND DENT TO BE (D=1.5 INCH, X=0.050, D/X=30) COND 2. REFORMED DENT AREA TO ORIGINAL CONTOUR. INSTALLED DOUBLER IAW SRM 53-04, FIG SDR AALA20050192Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHT AT ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20050186Fuel Control · malfunctionedAUS INFLIGHT T1705/3 MAR DESCENDING AT IDLE LEFT ENGINE DID NOT RESPOND AT LEVEL OFF. NUMBER 1 AND NUMBER 2 EPR WERE ALL SUB IDLE WITH NO THROTTLE RESPONSE. SHUT LEFT ENGINE DOWN AND SECURED VIA ENGINE FAILURE CHECKLIST. NO FURTHER ABNORMALITIES. REPLACEDSDR AALA20050162Battery Pack · dischargedDFW - TAIL CONE EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK B5 28 FOR TAIL CONE EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050163Battery Pack · dischargedLAX - EMERGENCY LIGHTS ON FUSELAGE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS ON FUSELAGE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050160Battery Pack · dischargedSFO - OVERWING EMERGENCY EXIT IDENTIFIER LIGHTS INOPERATIVE. REPLACED BATTERY PACK AND MODULE AT FORWARD RIGHT OVERWING EXIT IDENTIFIER FOR OVERWING EMERGENCY EXIT IDENTIFIER LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050159Battery · dischargedORD - OVERHEAD EMERGENCY LIGHTS FROM ROWS 3 TO 9 INOPERATIVE. REINSTALLED BATTERIES INTO CHARGER HOLDER FOR OVERHEAD EMERGENCY LIGHTS FROM ROWS 3 TO 9. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050041Rack · defectiveDURING RTS CHECK FOR LMP UPGRADE, FOUND CAPT`S RMI SYNC INDICATION NOT MOVING, COMPASS CARD DOES NOT MOVE BACK TO COMPASS HEADING, TAIL SWAP WITH AC 808. REMOVED AND REPLACED COMPASS RACK FOR CAPT`S COMPASS SYSTEM. (NR 2) NO HELP, INSTALLED NEW DG. NO HELP, SDR AALA20050158Battery Pack · dischargedMIA - OVERHEAD EMERGENCY LIGHTS ABOVE SEAT ROWS 7 TO 10 INOPERATIVE. REPLACED BATTERY PACK AFT OF SET ROW 8DEF FOR OVERHEAD EMERGENCY LIGHTS ABOVE SEAT ROWS 7 TO 10. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050055Skin · dentedLT WING FLAP VANE NR 4 HAS DENT TOP SIDE. REMOVED DAMAGED SKIN AND CORE. FABRICATED NEW CORE AND DOUBLER, TREATED DOUBLER AND BONDED CORE IAW 57-50. (K)SDR GTIA050061Floor Support · brokenFLOOR SUPPORT STA 1136 BROKEN AFT PIT 28R-28L. REMOVED FLOOR SUPPORT AND LOCATED NEW FLOOR SUPPORT AT STA 1136, 28R-28L. INSTALLED FLOOR SUPPORT FS 1136, 28R-28L, AFT PIT IAW SRM. (K)SDR MWEA050028Wire · exposedEMERGENCY TRACK LIGHTING WIRES EXPOSED. REPAIRED WIRES AND SECURED END CAP IAW 20-50-00 AND 33-50-00. OPERATION CHECK GOOD.SDR AALA20050155Battery Pack · dischargedMSP - FORWARD OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD OVERWING EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050154Connector · looseDFW - OVERHEAD EMERGENCY PATH CEILING LIGHT AT ROWS 18, 20 AND 21 INOPERATIVE. TIGHTENED LOOSE CONNECTORS ON OVERHEAD BIN EMERGENCY LIGHT BATTERY PACK AT ROW 20 FOR OVERHEAD EMERGENCY PATH CEILING LIGHTS AT ROWS 18, 20 AND 21. SYSTEM GROUND CHECKED NORMAL OPSDR AALA20050144Battery Pack · inoperativeBOS - COCKPIT AND FORWARD ENTRY DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5 23 FOR COCKPIT AND FORWARD ENTRY DOOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050143Battery Pack · inoperativeAUS - EXTERIOR EMERGENCY LIGHTS IN CABIN. REPLACED BATTERY PACK FOR EXTERIOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050138Battery Pack · inoperativeSAT - OVERHEAD EMERGENCY LIGHTS FROM ROWS 22 TO 27 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS FROM ROWS 22 TO 27. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050134Battery Pack · inoperativeDFW - EMERGENCY EXIT SIGNS AT AFT OVERWING INOPERATIVE. REPLACED BATTERY AND CHARGER ASSEMBLY FOR EMERGENCY EXIT SIGNS AT AFT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050133Battery Pack · inoperativeDFW - CEILING EMERGENCY LIGHTS AT ROWS 8 TO 17 INOPERATIVE. REPLACED BATTERY AND CHARGER ASSEMBLY FOR CEILING EMERGENCY LIGHTS FOR ROWS 8 TO 17. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050136Wire · pinchedRDU EMERGENCY ESCAPE PATH LIGHT IN AFT CABIN INOPERATIVE. FOUND PINCHED WIRE ON OUTBOARD SEAT TRACK. REPAIRED WIRE FOR EMERGENCY ESCAPE PATH LIGHT IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050064Skin · dentedFUSELAGE SKIN DENTED AT FS 304 BETWEEN LONGERON 28L-29L. (D=0.5 INCH, X=0.015 INCH D/X= 33.3). DENT WAS FOUND TO BE LESS THAN 1.0 INCH FROM FRAME REQ A CUT OUT REPAIR. CUT OUT DAMAGED SKIN AT FS 304 BETWEEN LONGERON 28L-29L. FABED NEW SKIN SECTION, REPAIR SDR GTIA050056Support Angle · corrodedTHRESHOLD SUPPORT ANGLE, STA 1212, ON DOOR JAMB BEAM IS CORRODED. REMOVED CORROSION AT SUPPORT ANGLE. MATERIAL LOSS OUT OF LIMITS. REMOVED SUPPORT ANGLE AT STA 1212. FABRICATED NEW SUPPORT ANGLE, HEAT TREATED REPAIR PART. INSTALLED SUPPORT ANGLE AT STA 12SDR GTIA050044Windshield · crackedF/O WINDSHIELD CRACKED IN FLIGHT, OUTER PANE ONLY. AIRCRAFT TAIL SWAP WITH N835NK. REMOVED AND REPLACED WINDSHIELD. (K)SDR GTIA050053Skin · dentedDENT AT FS 245, LONGERON 18L (D=1.250 INCH, X=0.054 D/X=23.14). REMOVED AIRCRAFT SKIN AT STA FS 245, LONGERON 18L (20 INCHES X 14 INCHES). FABRICATED REPAIR PARTS IAW SRM. INSTALLED, REPAIR AT FS STA 245 LONGERON 18L. (K)SDR GTIA050070Door · dentedDENT ON AFT CARGO DOOR AT STA 1183, 14 INCHES FROM UPPER EDGE/ 23 INCHES FROM AFT EDGE (D=1.0, X=0.015, D/X=66.7). REMOVED AFT CARGO DOOR TO FOM DENT FOUND TO BE COND 1B. COLD WORK PERFORMED TO ORIGINAL CONTOUR. DYE PENETRANT PERFORMED FOR CRACKS. FABRICATESDR GTIA050069Skin · dentedDENT ON AFT CARGO DOOR AT STA 1165, 13 INCHES FROM FORWARD EDGE, 14 INCHES FROM UPPER EDGE (D=2.0, X=0.05, D/X=40). FOUND DENT TO BE COND. 1B. PERFORMED COLD WORK AREA BACK TO ORIGINAL CONTOUR. DYE PENETRANT PERFORMED FOR CRACKS. FABRICATED DOUBLER. TREATSDR GTIA050068Wedge · damagedLT WING, IB FLAP, OB T/E WEDGE HAS TEMPORARY REPAIR LOWER SIDE IB. REMOVED TEMP REPAIR, REMOVED DAMAGED AREA (2 INCH DIA) FABRICATE DOUBLER AND FILLER, TREATED, PRIMED DOUBLER AND FILLER. INSTALLED REPAIRED DOUBLER AND FILLER IAW SRM. (K)SDR GTIA050065Skin · dentedFUSELAGE SKIN DENTED AT FS 310, LONGERON 29L-28L. (D=0.5 INCH, X=0.010 INCH, D/X=50). DENT WAS FOUND TO BE LESS THAN 1.0 INCH AND REQ A CUT OUT REPAIR. FAB`D NEW SKIN SECTION, REPAIR DOUBLER, FINGER DOUBLER, FABED (4 EA) STRAPS. TREATED, PRIMED AND TOP COASDR GTIA050060Skin · damagedFLUSH REPAIR FS 622 LONGERON 22R-24R HAS NO FINGER DOUBLER. REMOVED TEMP REPAIR. FABRICATED PERMANENT REPAIR PARTS. TREATED AND PRIMED ON FINAL REPAIR. INSTALLED REPAIR IAW SRM. (K)SDR GTIA050052Stiffener · corrodedAFT CARGO COMPARTMENT, STA 1338, 27L-27R AFT SIDE OF FALSE BULKHEAD, LOWER STIFFENERS ARE CORRODED. REMOVED CORROSION AT STIFFENER STA 1338L, 29L. MATERIAL LOSS OUT OF LIMITS. REMOVED STIFFENER AT STA 1338L, 29L, LOCATED AND DRILLED NEW STIFFENER. INSTALLESDR AALA20050126Apu · leakingDFW - AIRCRAFT HAD A HAZEY LOOK THROUGHOUT THE ENTIRE CABIN AND THERE WAS A MUSTY TYPE SMELL. THE HAZEY LOOK BECAME VERY THICK AND THE SMELL GOT MUCH STRONGER. FOUND APU LEAKING OIL. REPLACED THE APU. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050125Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT AT ROWS 13 TO 15 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHT AT ROWS 13 TO 15. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050057Longeron · corrodedLONGERON 28R STA 1140 HAS CORROSION AROUND FASTENERS THROUGH SKIN IN AFT PIT. REMOVED FASTENERS THROUGH SKIN AND REMOVED CORROSION. LONGERON 28R AT STA 1140 IS OUT OF LIMITS. LOCATED AND DRILLED FABED LONG SECTION AND SPLICE. TREAT AND PRIMED, INSTALLED LOSDR AALA20050120Light · brokenDFW - AFT STAIR CENTER EMERGENCY LIGHT ASSEMBLY IS BROKEN OUT OF RIVETS AND CEILING IS HANGING. SECURED EMERGENCY LIGHT ASSEMBLY AND CEILING AT AFT STAIR CENTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050123Wire · inoperativeORD - CEILING MOUNTED EMERGENCY LIGHTS AT SEAT ROWS 23 TO 26 INOPERATIVE. SECURED LOOSE WIRE ON OVERHEAD EMERGENCY LIGHTS BATTERY PACK FOR SEAT ROWS 23 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82