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 AALA20050064Battery Pack · inoperativeSFO - FIRST CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050065Battery Pack · inoperativeDFW - CEILING EMERGENCY LIGHTS FROM ROW 24 TO 31 INOPERATIVE. REPLACED BATTERY PACKS FOR CEILING EMERGENCY LIGHTS AT ROWS 24 TO 31. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050066Battery Pack · inoperativeMSP - EMERGENCY LIGHTS AT AFT FLIGHT ATTENDANT AREA INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT FLIGHT ATTENDANT AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050067Wire · brokenTPA - EMERGENCY EXIT LIGHT AT FORWARD GALLEY AISLE WALL INOPERATIVE. REPAIRED BROKEN WIRE IN AISLE FLOOR TRACK FOR EMERGENCY EXIT LIGHT AT FORWARD GALLEY AISLE WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASAA0580044Wire Harness · shorted(SMOKE/FLAMES/FUMES OVERHEAD AT 21 ABC) REPORTED BY PASSENGER AND AS A PIREP, THIS WAS PRECEEDED BY AN EARLIER REPORT PRIOR TO FLIGHT OF (WATER LEAKING AT ROW 21 ABC/DEF O/H). INSP REVEALED (FRIED) BALLAST CONNECTOR. REPLACED BALLASTS AND BALLAST HARNESS ADSDR CALA0500031Floor Panel · delaminatedINSPECTION FOUND LT CENTER FLOOR PANEL DELAMINATED AND HOLES PUNCHED IN PANEL AT STA 465-541, LBL 20 TO LBL 40. A NEW PANEL WAS INSTALLED IAW SRM 53-05, PAGE 122B.SDR CALA0500028Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1322 UNDER RT LAV, RBL 20. THE CORRODED SECTION OF FLOORBEAM WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 79A.SDR 2005F00035Engine · malfunctionedLGA - FLT 706 - AT 4,000 FEET, ON CLIMB-OUT, AFT CABIN FILLED WITH SMOKE, LAV SMOKE DETECTOR WENT OFF, TURNED RIGHT ACM OFF AND EMERGENCY RETURN TO LGA, SMOKE DISIPATED AFTER LANDING. REMOVED AND REPLACED NR 2 ENGINE. PERFORMED BURN OUT OF HIGH PRESSURE PNEUSDR AALA20050070Battery Pack · inoperativeTPA - EMERGENCY LIGHT ABOVE CATWALK AND TAIL CONE INOPERATIVE. REPLACED BATTERY PACK IN AFT RIGHT HAND LAVATORY AND REPAIRED BROKEN WIRE AT AFT CEILING ABOVE CATWALK FOR EMERGENCY LIGHTS ABOVE CATWALK AND TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0500025Floor Support · crackedINSPECTION FOUND A 1 INCH CRACK AT FORWARD O/B END OF FORWARD ENTRY FLOOR SUPPORT TEE AT STA 180, RBL 43. A REPAIR WAS INSTALLED IAW SRM 53-01, FIGURE 2.SDR AALA20050060Piston · inoperativeORD - INFLIGHT AFTER TAKEOFF NOSE GEAR OR DOORS WOULD NOT RETRACT. NOSE LANDING GEAR INDICATION WAS DOWN FLUSH BUT VERY LOUD AIRFLOW DISRUPTION AROUND COCKPIT. RED NOSE GEAR INDICATION AND TWO GREENS ON THE MAINS. CYCLED GEAR WITH SAME INDICATIONS. GOOD DOSDR CALA0500024Seat Track · corrodedINSPECTION FOUND LT MIDDLE SEAT TRACK CORRODED FROM STA 1022-1250, S18L. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-05, FIGURE 4F.SDR CALA0500022Structure · corrodedINSPECTION FOUND SUBFLOOR CORRODED UNDER LEFT O/B SEAT TRACK AT STA 1174, LBL 60. THE CORRODED AREA WAS REMOVED AND A DOUBLER WAS INSTALLED IAW SRM 51-70-4.SDR GTIA050017Duct · disconnectedDTW - FLT 973 - AIRCRAFT WOULD NOT PRESSURIZE IN FLIGHT, AUTO OR MANUAL. FOUND COLD AIR DUCTS AT LEFT AND RIGHT ACM'S DISCONNECTED, RECONNECTED DUCTS AND PRESSURIZED AIRCRAFT. OPS CHECK GOOD. (M)SDR AALA20050055Engine · shutdownDFW - ON CLIMB-OUT AT 8500 FEET, HEARD LOUD BOOM FROM RIGHT ENGINE. ENGINE SPOOLED DOWN TO WINDMILL. WINDMILLED FOR 16 MINUTES. DOWNLOADED FLIGHT DATA RECORDER PER ENGINEERING. REPLACED NUMBER TWO ENGINE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050016Door · lack of lubeACY - FLT 341 - AFTER TAKEOFF CYCLED NLG AND HAD A GEAR UNSAFE INDICATION AND A LOUD NOISE FROM GEAR DOORS BEING OPEN, DID A FLY BY AND TOWER NOTICED GEAR RETRACTED WITH GEAR DOORS STILL OPEN AND GEAR LEVER UP. AIRCRAFT RETURN TO ACY AND PERFORMED AN OVERWEIGSDR AALA20050047Retract Cylinder · inoperativeAFTER TAKEOFF, NOSE GEAR FAILED TO RETRACT. FLEW EXTENDED DOWN WIND TO BURN FUEL. LANDED AT MIA WITHOUT INCIDENT. REPLACED NOSE GEAR INNER CYLINDER. ACCOMPLISHED NOSE LANDING AND DOORS CHECK. CHECK FLIGHT COMPLETED. SYSTEM GROUND CHECKED NORMAL OPERATIOSDR CALA0500021Seat Track · corrodedINSPECTION FOUND LEFT I/B CABIN SEAT TRACK CORRODED FROM STA 1022-1250, LBL 25. THE SEAT TRACK WAS REPLACED IAW SRM 53-05, FIGURE 4.SDR AALA20050044Engine · damagedEN ROUTE PHL-DFW, COMPRESSOR STALL ON RIGHT ENGINE AFTER TAKEOFF. POWER WAS REDUCED AND STALLS CLEARED. ALL ENGINE INDICATIONS REMAINED IN NORMAL RANGE. RIGHT ENGINE KEPT RUNNING FOR APPROACH. LANDED PHL WITHOUT INCIDENT. REPLACED NUMBER 2 ENGINE DUE TO FSDR AALA20050040Charger · inoperativeTUL - EN ROUTE STL-DFW BATTERY CHARGER LIGHT CAME ON. CIRCUIT BREAKER POPPED. LANDED TUL WITHOUT INCIDENT. REPLACED BATTERY CHARGER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050039Proximity Switch · inoperativeMIA - EN ROUTE MIA-DFW NOSE LANDING GEAR WOULD NOT RETRACT. RETURNED MIA AND LANDED WITHOUT INCIDENT. REPLACED PROXIMITY SWITCH ELECTRONIC UNIT AND CLEANED NOSE GEAR UP SENSOR. CYCLED NOSE GEAR NUMEROUS CYCLES. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0500020Seat Track · corrodedINSPECTION FOUND CAPTAIN'S AFT I/B SEAT TRACK CORRODED AT STA 83.55 - 101.55, LBL 10. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-01.SDR AALA20050038Motor · inoperativeORD - EN ROUTE ORD-DCA LEVELING OFF AT 5000 FEET WITH AUTOPILOT ON, AUTOPILOT TRIM LIGHT CAME ON WITH NOSE UP PITCH. DISCONNECTED AUTOPILOT AND RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REMOVED AND REPLACED ALT STABILIZER TRIM MOTOR. SYSTEM GROUND CHECKESDR CALA0500017Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 180, LBL 12 TO LBL 37. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-3 AND 51-30-2.SDR CALA0500016Rib · crackedINSPECTION FOUND A .75 INCH CRACK IN RIB AND DOUBLER AT LT WING LEADING EDGE INTERNALLY BETWEEN NR 9 AND NR 10 SLAT TRACK CUTOUTS, STA XRS 324. THE CRACKED RIB AND CLIP ANGLE WERE REMOVED AND A NEW RIB AND CLIP ANGLE WERE INSTALLED IAW SRM 51-10-03, 51-30-02,SDR CALA0500057Cusp Web · corrodedINSPECTION FOUND RT CUSP CORRODED AT STA 200. A SMALL SECTION OF THE UPPER CUSP CHORD WAS TRIMMED OUT TO REMOVE LOCAL CORROSION AND A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5311-01216.SDR AALA20050042Pressure Switch · inoperativeEN ROUTE DFW-CMH RIGHT HAND CONSTANT SPEED DRIVE LOW OIL PRESSURE LIGHT ON WITH APU ON MEL. LANDED LIT WITHOUT INCIDENT. REPLACED RIGHT HAND CSD OIL PRESSURE SWITCH. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR GTIA050031Fitting · corrodedFTW - FORWARD ENTRYWAY CORROSION AT FS 200 CUSPLINE, LONG 18L FRAME TO CUSP FITTING. REMOVED FRAME TO CUSP FITTING STATION 200 L18L-L, REMOVED CORROSION ON CUSP, REMOVED WEB L1 DOOR STATION TO 208 L18L TO L13L. FABRICATED CUSP SECTION FROM STATION 180 TO STASDR AALA20050045Battery Pack · inoperativeDFW - EMERGENCY LIGHTS IN CEILING ABOVE ROWS 15 THROUGH 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CEILING ABOVE ROWS 15 THROUGH 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050047Floorbeam · corrodedAFT PIT FS 1338 APB FWD SIDE LOTER T-CHORD CORRODED L28L TO L28R. REMOVED CORROSION OUT OF LIMITS, REMOVED T-CAP (CHORD) STA 1338, L28L TO L29L, DRILLED AND LOCATED NEW T-CAP STA 1338. OK TO TOP COAT AND INSTALL NEW T-CAP. (K)SDR GTIA050010Strut · icedFLT 202 - DTW - AFTER TAKEOFF GEAR WOULD NOT RETRACT, RETURNED TO DTW, NORMAL LANDING WEIGHT FOR LANDING, AIRCRAFT TAIL SWAP. UPON INSPECTION, FOUND NOSE STRUT PACKED WITH ICE, CLEANED, REPACKED AND SERVICED. (M)SDR GTIA050012Engine · failedFLT 1581 - ACY - ENGINE FAILURE AT FL 240, SURGE ON AIRCRAFT, RIGHT ENGINE FAILED AIRCRAFT YAWED RIGHT, NO FIRE WARNING OR INDICATION. EGT, N1 AND N2 DECREASED RAPIDLY, SHUT DOWN ENGINE AND DIVERTED IN ACY. REMOVED AND REPLACED NR 2 ENGINE. (M)SDR GTIA050022Intercostal · corrodedFOUND LEFT AFT FUSELAGE LONGERON 8L FS 1338 INTERCOSTAL HAS CORROSION. REMOVED INTERCOSTAL 8L FS 1338, LOCATED, DRILLED NEW INTERCOSTAL, TREATED PRIMED AND INSTALLED. (M)SDR GTIA050046Doubler · corrodedAFT PIT FS 1338 APB FWD SIDE STIFFNER LOWER DOUBLER CORRODED L30. REMOVED CORROSION AND FOUND EVIDENCE OF CORROSION BETWEEN DOUBLER AND APB. REMOVED DOUBLER, REMOVED LONGERON END FITTING STA 1338 L28R, L29R, L28L AND L29L, REMOVED WEB STIFFNER ON FALSE BULKHSDR GTIA050035Bulkhead · corrodedAFT PIT FS 1338 APB FORWARD WEB CORRODED AT LONG 29L TO LONGERON 29R. REMOVED CORROSION, CUT OUT DAMAGED AREA. FABRICATED DOUBLERS AND FILLERS, TREATED PRIMED AND INSTALLED. (M)SDR AALA20050032Battery Pack · inoperativeMIA - EMERGENCY LIGHT IN COCKPIT OVERHEAD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN COCKPIT OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050037Battery · dischargedBOS - FORWARD OVERWING DOOR EXIT LIGHTS INOPERATIVE. REPLACED BATTERIES ON PATTERY PACK FOR FORWARD OVERWING DOOR EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0500012Longeron · crackedINSPECTION FOUND A .75 INCH CRACK IN LONGERON 4L AT STA 160. A NEW LONGERON SECTION WAS SPLICED IN IAW SRM 53-02 FIGURE 18.SDR AALA20050031Battery Pack · dischargedDFW - OVERHEAD EMERGENCY LIGHT IN AFT CABIN L2 615 AND LAMP 1 OF L2694 IN TAIL CONE INOPERATIVE. REPLACED BATTERY PACK AND CHARGER ASSEMBLY AT B5 27 FOR OVERHEAD EMERGENCY LIGHTS IN AFT CABIN L2 615 AND LAMP 1 OF L2694 IN TAIL CONE. SYSTEM GROUND CHECKED NORSDR AALA20050033Battery Pack · dischargedSFO COCKPIT EGRESS LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5 23 FOR COCKPIT EGRESS LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR CALA0500009Floor Support · corrodedINSPECTION FOUND CENTER FLOOR SUPPORT BETWEEN I/B AND MIDDLE SEAT TRACKS CORRODED AROUND SCREW HOLES AT LT SIDE STA 1155, BL 0 TO LBL 30. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-30-01.SDR 2005F00036Fire Warning · false indicationPBI - FLT 165 - FIRE WARNING IN AFT LAVATORY DURING CLIMB-OUT, DETERMINED TO BE FALSE. ALL LAV SMOKE DETECTORS CHECK NORMAL, CHECKED APU COMPARTMENT FOR OIL LEAKS, NONE FOUND. CHECKED APU SUPPLY DUCTING FOR OIL CONTAMINATION, NONE FOUND. CHECKED NR 1 AND NRSDR GTIA050025Floor Support · corrodedFOUND CABIN FLOOR SUPPORT CORRODED AT FS 160 7 INCHES LBL. REMOVED CORROSION AT FLOOR SUPPORT, FABRICATED BRACKET, LOCATED AND DRILLED AND INSTALLED NEW FLOOR SUPPORT. (M)SDR GTIA050033Floorbeam · gougedFTW - FOUND MID PIT STATION 655 CEIING RBL 2 FLOORBEAM GOUGED. FABRICATED FILLER, ANGLE AND SHIM. TREATED, PRIMED AND INSTALLED. (M)SDR AALA20050030Battery Pack · dischargedLAX - EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACKS AT B5101, B5100, AND B5105 FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050029Battery Pack · dischargedLAX - OVERHEAD EMERGENCY LIGHTS ABOVE AFT FLIGHT ATTENDANT STATION INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS ABOVE AFT FLIGHT ATTENDANT STATION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050008Windshield · delaminatedTPA - F/O'S WINDSHIELD HAS AREA OF DELAMINATION NEAR BOTTOM AND CENTER, AREA IS APPROX 2.5 BY 4, AIRCRAFT TAIL SWAP. REMOVED AND REPLACED F/O'S SIDE WINDSHIELD. (M)SDR AALA20050027Battery Pack · inoperativeDFW - EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED EXTERIOR EMERGENCY LIGHT BATTERY PACK AND CHARGER ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050026Wire Harness · faultyBOS - SEAT MOUNTED EMERGENCY LIGHTS AT SEAT ROW 7DEF INOPERATIVE. FOUND CONNECTION FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 7DEF FAULTY NEAR SIDEWALL. SECURED PIN FOR WIRE HARNESS AND RECONNECTED HARNESS FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 7DEF. SYSDR CALA0500010Light · inoperativeWHEN THE R-2 SERVICE DOOR SLIDE WAS DEPLOYED DURING TESTING, THE SLIDE LIGHTS FAILED TO ILLUMINATE. THE R-2 DOOR SLIDE WAS REMOVED AND REPLACED.
Back to Mcdonnell Douglas DC-9-82