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 AALA20041138Wire Harness · damagedMIA - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. FOUND EMERGENCY LIGHT SEAT HARNESS DAMAGED AT SEATS 9DEF. REPAIRED HARNESS FOR EMERGENCY LIGHT SEATS A 9DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA040209Strap · damagedAFT PRESSURE BULKHEAD TEE HAS FOUR HOLES WITH TOO SHORT OF EDGE DISTANCE IN FORWARD UPPER FLANGE OF TEE BETWEEN LONGERON 18 RIGHT AND 17 RIGHT. SUBMITTED TO BOEING FOR DISPOSITION. FABRICATED AND INSTALLED NEW STRAPS AND FASTENERS.SDR GTIA040847Skin · crackedLP NR 0167013; LT MAIN GEAR DOOR SKIN CRACKED ABOVE AND BELOW SKIN PLATE. UNSCHEDULED CHANGE OF AIRCRAFT EN ROUTE. PERFORMED REPAIR AND INSTALLED DOUBLER.SDR 200411007Start Valve · inoperativeAIRCRAFT RETURNED TO PLATFORM DUE TO STARTER VALVE WAS NOT OPEN. SYSTEM WAS CHECKED AND LINE WAS FOUND BROKEN. LINE WAS REPLACED IAW MM 80-10-00, TEST CORRECT.SDR AALA20041133Battery · inoperativeDFW - OVERHEAD EMERGENCY LIGHTS AT ROWS 23 TO 26 INOPERATIVE. CLEANED CONTACTS AND RECHARGED BATTERY FOR OVERHEAD EMERGENCY LIGHTS AT ROWS 23 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041132Battery Pack · inoperativeDFW - CABIN CEILING EMERGENCY LIGHTS AT ROWS 7 TO 13 INOPERATIVE. REPLACED BATTERY PACK B5101 FOR CABIN CEILING EMERGENCY LIGHTS AT ROWS 7 TO 13. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041131Light · inoperativeDFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTING AT 18D INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041130Battery Pack · inoperativeSFO - CEILING EMERGENCY LIGHTS ABOVE SEATS 23, 24, AND 26 INOPERATIVE. REPLACED BATTERY PACK AT ROWS 23 VOR CEILING EMERGENCY LIGHTS ABOVE SEATS 23, 24, AND 26. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR GTIA040846Selector · dirtyLP NR 3022501; DEPARTING DCA AFTER GEAR RETRACTION, ALL 3 RED UNSAFE LIGHTS REMAINED ILLUMINATED, GEAR DOOR LIGHT EXTINGUISHED. ACCOMPLISHED QRH PROCEDURE WITH NO CHANGE IN INDICATIONS. ACP BITE CHECK OF PSEU, CLEANED LANDING GEAR HANDLE SWITCH S1-89 AND THRSDR GTIA040852Stud · backed outLP NR 0126074-1; LT OIL PRESSURE LOW LIGHT CAME ON WITH OIL QUANTITY DROPPING AND OIL PRESSURE DROPPING, SHUT DOWN NR 1 ENGINE. FOUND 2 FWD MOUNTING STUDS FOR OIL FILTER CAP LOOSE AND BACKED OUT, INSTALLED HELICOIL THREADED INSERTS AND RE-INSTALLED STUDS, NO SDR GTIA040842Skin · damagedDENT ON LT OB FLAP LOWER SIDE, 19 INCH FROM T/E AND 8 INCHES FROM IB END OF T/E WEDGE, DEPTH 0.095 INCH, DIAM 2.0 INCH. REMOVED DAMAGED SKIN, FABRICATED SKIN AND DOUBLER TREATED AND PRIMED, INSTALLED SKIN AND DOUBLER, BONDED SKINS AND PAINTED.SDR MWEA040203Bulkhead · damagedAFT PRESSURE BULKHEAD REQUIRES REPLACEMENT DUE TO BLENDING BETWEEN LONGERONS 19 AND 20 RIGHT. FABRICATED AND INSTALLED NEW SECTION.SDR WX0400055Autothrottle Sys · malfunctionedSCHEDULED FLIGHT MSN TO LAS, CREW ABORTED TAKEOFF AFTER BRAKE RELEASE ON TAKEOFF ROLL AT ABOUT 60 KNOTS DUE TO AUTO THROTTLES CLICKING OFF. CREW REPORTED THE AUTO THROTTLES KICKED OFF AS SOON AS POWER WAS SET FOLLOWED BY A POWER LOSS TO THE NR 1 FMA, NR 1 FD SDR AALA20041119Battery Pack · inoperativeDEN - OVERHEAD EMERGENCY LIGHTS AT ROWS 13 TO 16 INOPERATIVE. REPLACED BATTERY PACK AT B5102 FOR OVERHEAD EMERGENCY LIGHTS AT ROWS 13 TO 16. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040837Intercostal · crackedAFT PIT OVERHEAD FLOORBEAM INTERCOSTAL CRACKED AT (4 EA) PLACES ALONG FASTENER HOLES, FS 1287-1309. REMOVED FLOORBEAM INTERCOSTAL AT FS 1287-1309, FABRICATED NEW INTERCOSTAL SRM 51-10-2 FROM 7075-T6-.063. HEAT TREATED NEW INTERCOSTAL, LOCATED AND DRILLED HOLSDR AALA20041115Battery Pack · inoperativeSFO - CEILING EMERGENCY LIGHTS BETWEEN ROWS 22 AND 26 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS BETWEEN ROWS 22 AND 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041118Wire · brokenDTW - LOWER EMERGENCY EXIT LIGHT MARKER BETWEEN FIRST CLASS GALLEY AND FIRST CLASS SEATS INOPERATIVE. FOUND BROKEN WIRE IN FLOOR NEAR LIGHT. SPLICED NEW WIRE FOR LOWER EMERGENCY EXIT LIGHT MARKER BETWEEN FIRST CLASS GALLEY AND FIRST CLASS SEATS. SYSTEM GROUSDR AALA20041117Battery Pack · inoperativeDFW - OVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 23 AND 26 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 23 AND 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041116Battery Pack · inoperativeDFW - TAIL CONE WALKWAY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR TAIL CONE WALKWAY EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA040202Actuator · out of adjustRIGHT MAIN LANDING GEAR UNSAFE LIGHT REMAINED ON. FOUND RIGHT WEIGHT ON WHEELS CONDUIT HITTING ON BACK OF SHELL OF UP LATCH SENSOR. REPOSITIONED WEIGHT ON WHEEL CONDUIT & REPOSITIONED BACK SHELL OF UP LATCH SENSOR. REMOVED AND REPLACED RIGHT MAIN LANDING GESDR AALA20041112Battery Pack · inoperativeRDU - EMERGENCY LIGHTS AT FORWARD OVERWING ESCAPE HATCH INOPERATIVE. REPLACED BATTERY PACK AT BF103 FOR EMERGENCY LIGHTS AT FORWARD OVERWING ESCAPE HATCH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041111Display · inoperativeEWR-MIA, LIGHT SMOKE WITH ELECTRIC BURNING SMELL AT CRUISE. EMERGENCY FIRE SMOKE CHECK LIST COMPLETED. SMOKE ABATED UNTIL LANDING. SMOKE REAPPEARED IN COCKPIT AREA. FOUND NUMBER ONE NAVIGATION DISPLAY BURNED. REPLACED NUMBER ONE NAVIGATION DISPLAY MODE SESDR CALA0400704Frame · corrodedINSPECTION FOUND BELL FRAME CORRODED AT STA 1320 ABOVE LONGERON 30. REPAIRED BELL FRAME IAW SRM 53-03, PAGE 4A AND SRM 53-01, FIGURE 2, PAGE 3.SDR AALA20041098Light · brokenDFW - TAIL CONE JETTISON HANDLE EMERGENCY LIGHT ASSEMBLY BROKEN. REPLACED TAIL CONE JETTISON HANDLE EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041097Light · inoperativeFORWARD SEAT MOUNTED EMERGENCY EXIT LIGHT AT 7D INOPERATIVE. REPLACED FORWARD SEAT MOUNTED EMERGENCY EXIT LIGHT ASSEMBLY AT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041108Battery Pack · inoperativeDFW - OVERHEAD EMERGENCY LIGHTS AT ROWS 24 TO 28 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROWS 24 TO 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041110Battery Pack · inoperativeLAX - EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK AT B5107 FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041100Duct · rupturedDFW - DURING CLIMBOUT FIRE DETECTION LOOP -A- LIGHT ILLUMINATED THEN -B- ILLUMINATED. RETARDED THROTTLE AND LIGHTS EXTINGUISHED. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED RIGHT HAND ENGINE ANTI-ICE DUCT. LEAK CHECKED. SYSTEM GROUND CHECKED NORSDR CALA0400702Web · crackedINSPECTION FOUND A 1 INCH CRACK IN WEB AT STA 1212 ABOVE LONGERON 24R IN AFT BAGGAGE BIN, RBL 6 TO RBL 14. A PAN SECTION AND SPLICE DOUBLER WERE INSTALLED IAW ECRA 5311-01211.SDR AALA20041125Socket · inoperativeTUL - EMERGENCY ESCAPE LIGHTS IN OVERHEAD SWITCH PANEL INOPERATIVE. REPLACED LIGHT SOCKET FOR EMERGENCY ESCAPE LIGHTS IN OVERHEAD SWITCH PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041104Battery Pack · inoperativeBOS - CEILING EMERGENCY LIGHTS BETWEEN ROWS 8D AND 11D INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS BETWEEN ROWS 8D AND 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR P9RA20040049Slide · deployedTHE L2 DOOR WAS PARTIALLY OPEN WHEN A GUST OF WIND FORCED THE DOOR TO THE FULL OPEN POSITION CAUSING THE SLIDE BOTTLE TO DEFLATE AND PARTIALLY DEPLOY THE SLIDE.SDR AALA20041103Battery Pack · inoperativePHX - EMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD GALLEY EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041102Light · brokenATL - EMERGENCY LIGHTS AT ROW 15DEF BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHTS AT ROW 15DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041095Battery Pack · inoperativeDEN - CEILING EMERGENCY LIGHTS AT STATIONS 1296 AND 1336 INOPERATIVE. REPLACED BATTERY PACK B527 FOR CEILING EMERGENCY LIGHTS AT STATIONS 1296 AND 1336. SYSTEM GROUND CHECKED NORMAL OPERTION.SDR GTIA040840Engine · bird ingestionLP NR 0252843; MULTIPLE BIRD STRIKES ON APPROACH TO LGA, NR 2 LT EGT HIGH. REMOVED AND REPLACED NR 2 ENGINE.SDR AALA20041106Wire · brokenDFW - EMERGENCY LIGHTS AT TAIL CONE SIDE WALL INOPERATIVE. REPAIRED BROKEN WIRE FOR EMERGENCY LIGHTS AT TAIL CONE SIDE WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041105Light · brokenDFW - AFT SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTING AT SEAT 7D IS BROKEN. REPLACED THE AFT SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY FOR SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041090Light · inoperativeDFW - OVERHEAD EMERGENCY LIGHT AT FORWARD GALLEY SERVICE DOOR DIM. REPLACED LIGHT ASSEMBLY FOR OVERHEAD EMERGENCY LIGHT AT FORWARD GALLEY SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041092Pressure Switch · inoperativeFUEL ANOMALY WITH CROSSFEED VALVE OPEN AND ONE LEFT FUEL PUMP OFF. FUEL IS BURNED FROM RIGHT TANK ONLY. ATTEMPTS TO TURN OFF BOTH LEFT PUMPS RESULTS IN LEFT LOW PRESSURE LIGHT ILLUMINATED. LANDED RDU WITHOUT INCIDENT. CHECKED FUEL CROSSFEED FROM LEFT TO RISDR AALA20041091Connector · looseLAX - EMERGENCY LIGHT AT SEAT 5E INOPERATIVE. SECURED LOOSE CONNECTOR UNDER SEAT 5E FOR EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA040206Skin · dentedSKIN DENT AT STATION 294 LONGERON 24 RIGHT. FOUND TO BE OUT OF LIMITS. REMOVED DOUBLER, COLD WORK SKIN AND INSTALLED DOUBLER.SDR AALA20041088Battery Pack · inoperativeNR 1 FLEX PANEL EMERGENCY PATH LIGHTING AND NR 2 AND NR 3 OVERHEAD EMERGENCY ESCAPE PATH LIGHTING AT STATIONS 925, 812 AND 642 INOPERATIVE. REPLACED BATTERY PACKS FOR NR 1 FLEX PANEL EMERGENCY PATH LIGHTING (BATTERY PACK B5 28) AND NR 2 (BATTERY PACK B5 104) SDR AALA20041087Battery Pack · inoperativeSEVERAL AFT CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT STATION 1190 FOR AFT CEILING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED, NORMAL OPERATION. (CLOSED)SDR AALA20041082Engine · shutdownDURING CRUISE WITH NO WARNING CREW HEARD A BOOM & LT ENGINE STARTED TO ROLL BACK ACCOMPANIED BY SEVERE VIBRATION & SMOKE IN COCKPIT & CABIN. SMOKE DISSIPATED RAPIDLY, SEVERE VIBRATION CONTINUED TO LANDING, ENGINE CONTINUED TO ROTATE. LANDED WITHOUT INCIDENT.SDR WX0400045Actuator · failedAFTER TAKEOFF FROM PIA EN ROUTE TO LAS, CREW REPORTED NOSE GEAR WOULD NOT RETRACT PROPERLY. AIRCRAFT RETURNED TO PIA , CREW PERFORMED NORMAL OVERWEIGHT LANDING UNDER THE FOLLOWING CONDITIONS; SINK RATE 256 TO 300 FEET PER MINUTE, NO SIDE LOADS, LANDING WEIGHTSDR AALA20041078Battery Pack · inoperativeATL - EMERGENCY LIGHTS FROM 20D TO 31D INOPERATIVE. REPLACED BATTERY PACK AT 20D FOR EMERGENCY LIGHTS FROM 20D TO 31D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040828Engine · malfunctionedLT 283881; INFLIGHT SHUTDOWN - DIVERSION, SHUTDOWN LT ENGINE DUE TO LOW OIL PRESSURE, LOW OIL QTY. REMOVED AND REPLACED NR 1 ENGINE.SDR AALA20041076Light · inoperativeDFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTING AT 12D AND 17D INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTING ASSEMBLY AT 12D AND 17D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041075Battery Pack · inoperativeDFW - OVERWING EXIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ASSEMBLY B549 FOR OVERWING EXIT EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82