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 AALA20050122Battery Pack · inoperativeDEN - EMERGENCY LIGHT IN CABIN INOPERATIVE. REPLACED BATTERY PACK AT B5101 FOR EMERGENCY LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050062Angle · crackedMID PIT DOOR INTERNAL ANGLE CRACKED AT LOWER CENTER EDGE. REMOVED INTERNAL ANGLE FROM MID CARGO DOOR LOWER CENTER EDGE. LOCATED AND DRILLED NEW INTERNAL ANGLE (FITTING), INSTALLED NEW FITTING IAW SRM. (K)SDR GTIA050048Angle · corrodedDOOR FRAME TO SKIN CORNER ANGLES STA 1155 AND 1212 AT DOOR JAMB BEAM ARE CORRODED IN AFT PIT. REMOVED CORROSION ON DOOR FRAME TO SKIN CORNER ANGLES AND DOOR JAMB. MATERIAL LOSS OUT OF LIMITS. DRILLED AND LOCATED NEW ANGLE, TREATED, PRIMED AND INSTALLED NEW SDR GTIA050066Skin · damagedRT WING OB FLAP MID FIXED VANE DAMAGED. REMOVED DAMAGED SKIN AND CORE TO OB FLAP VANE, FABRICATED REPAIR DOUBLER AND HONEYCOMB CORE. TREATED METAL, BONDED CORE AND DOUBLER. INSTALLED REPAIRED CORE AND SKIN IAW SRM. (K)SDR GTIA050063Angle · corrodedDOOR FRAME TO SKIN CORNER ANGLES STA 1155 AND 1212 AT DOOR JAMB BEAM ARE CORRODED IN AFT PIT. REMOVED CORROSION ON DOOR FRAME SKIN, CORNER ANGLES STA 1155 AND 1212 AT DOOR JAMB BEAM. CORNER ANGLE IS OUT OF LIMITS STA 1212 AND LOCATED NEW ANGLE, INSTALLED ANGSDR GTIA050054Skin · crackedFUSELAGE EXTERIOR STA 1485 CANT. LT LOWER SKIN CRACKED. CUT OUT DAMAGED AREA 2 INCH X 4.8 INCH AT STA 1485. FABED FINGER DOUBLER, TREATED AND PRIMED. INSTALLED REPAIR ON LT LOWER SKIN, STA 1485 CANT IAW SRM. (K)SDR GTIA050045Beam · corrodedAFT PIT LOWER DOOR JAMB BEAM CORRODED AND HAS BARE METAL. REMOVED CORROSION, FABRICATED REPAIR IAW SRM. OK TO TREAT, PRIME AND TOPCOAT REPAIR. LOCATED AND DRILLED 2 DOOR STOP FITTINGS AND INSTALLED DOOR JAMB BEAM REPAIR. (K)SDR AALA20050117Light · inoperativeDFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT 9D AND 18D INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT 9D AND 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050116Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT L2 615, L2 671 AND L2 694 INOPERATIVE. RESTORED CONNECTION IN THE CLIPS OF BATTERY PACK ASSEMBLY B5 27 FOR EMERGENCY LIGHTS AT L2 615, L2 671, AND L2 694. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050067Skin · dented(1EA) MINOR DENT ON MID CARGO DOOR EXTERNAL SKIN AT LOWER L/R MARKED. DENT MEASURE IS OUT OF LIMITS CONDITION. 2(D=0.25, X=0.75). REMOVED CARGO DOOR FOR FOM, APPLIED DYE PENETRANT FOR CRACKS. FABED (3 SHIMS) AND REPAIR DOUBLER. TREATED SKIN, SHIMS AND DOUSDR AALA20050110Light · inoperativeDFW - EMERGENCY ESCAPE PATH LIGHTS AT SEATS 13B AND 18D INOPERATIVE. REPLACED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY FOR SEATS 13B AND 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050106Battery Pack · inoperativeTUL - OVERWING EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050104Battery Pack · dischargedSFO - CEILING EMERGENCY LIGHTS OVER SEATS 17 TO 21 INOPERATIVE. REPLACED BATTERY PACK B5104 FOR CEILING EMERGENCY LIGHTS OVER SEATS 17 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050107Battery Pack · dischargedDEN - CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORY INOPERATIVE. REPLACED BATTERY PACK AT B527 FOR CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050115Smoke · detectedDFW INFLIGHT T2324/11 - STRONG ODOR OF OILY SMELL IN COCKPIT AT LIFT OFF. F/A REPORTED SMOKE IN CABIN. ALSO, VERY LIGHT HAZE IN COCKPIT. TURNED OFF RECIRCULATION FAX AND OPENED RADIO RACK VENTURE IN ATTEMPT TO REMOVE SMOKE. ACCOMPLISHED SMOKE OR FUME REMOSDR AALA20050177Wire · damagedORD - FORWARD GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED WIRING FOR FORWARD GALLEY EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050103Battery Pack · inoperativeDFW - OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050102Battery Pack · inoperativeDFW - CEILING EMERGENCY LIGHTS AT ROWS 19 TO 21 AND BETWEEN AFT LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT ROWS 19 TO 21 AND BETWEEN AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050113Acm · leakingLAX - AFTER TAKEOFF AT ABOUT 200 FEET, SMELL OF SMOKE AND VISIBLE SMOKE IN COCKPIT AND CABIN. SMELL AND SMOKE CONTINUED FOR SEVERAL MINUTES TO APPROXIMATELY 5000 FEET. ALL ENGINE AND AIR CONDITIONING PACKS APPEAR NORMAL. REPLACED COALESCER BAGS IN AIR CONDISDR GTIA050024Cusp Web · damagedREPAIRED CRACK AT CUSP WEB FS 788 LBL 44, NUMEROUS OVERSIZED HOLES IN CUSP WEB TO FS 845 LBL 44. REMOVED CUSP WEB FROM FS 778-798 LBL 44, FABRICATED CUSP WEB FROM 7075-T6 .025, TREATED, PRIMED AND INSTALLED CUSP WEB. (M)SDR GTIA050026Floor Support · corrodedFTW - FOUND PASSENGER CABIN FLOOR SUPPORT CORRODED AT FS 169, 4 INCHES RBL. REMOVED CORROSION AND PORTION OF FLOOR SUPPORT, FABRICATED FLOOR SUPPORT, TREATED, PRIMED AND INSTALLED FLOOR SUPPORT. (M)SDR GTIA050027Floor Support · corrodedFOUND CABIN FLOOR SUPPORT CORRODED AT FS 195-200 14 INCH LBL. REMOVED CORROSION AND FLOOR SUPPORT, FABRICATED FLOOR SUPPORT, TREATED, PRIMED AND INSTALLED FLOOR SUPPORT. (M)SDR GTIA050028Floor Support · corrodedFTW - FOUND CABIN FLOOR SUPPORT CORRODED AT FS 200 9 INCH LBL 13 INCH LBL. REMOVED CORRODED FLOOR SUPPORT, FABRICATED FLOOR SUPPORT, TREATED, PRIMED AND INSTALLED NEW FLOOR SUPPORT. (M)SDR GTIA050030Cusp Web · corrodedFOUND CABIN FS 330, FS 1022-1041, FS 1041-1060, FS 1060-1079, FS 1079-1098, FS 1307 L-18L CUSP WEB CORRODED. REMOVED CORROSION AND WEB, DRILLED AND LOCATED NEW WEB FITTING ALONG L18L, TREATED, PRIMED AND INSTALLED DOUBLER AND NEW WEB SECTION. (M)SDR GTIA050029Floor Support · corrodedFTW - FOUND PAX CABIN FLOOR SUPPORT CORRODED AT FS 230 10 INCH RBL. REMOVED CORROSION AND FLOOR SUPPORT AT FS 230, FABRICATED, TREATED, PRIMED AND INSTALLED NEW FLOOR. (M)SDR AALA20050101Battery Pack · dischargedSFO - CEILING EMERGENCY LIGHTS BETWEEN ROWS 27 TO 30 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS BETWEEN ROWS 27 TO 30. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050100Battery Pack · dischargedSAT - CEILING EMERGENCY LIGHTS AT LAST THREE ROWS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT LAST THREE ROWS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050032Bulkhead · corrodedLOWER APB AREA STATION 1338 STRINGER 28R STIFFENER CORRODED AND LEFT ANGLE CORRODED. REMOVED AND REPLACED STIFFENER AND ANLE. LOCATED AND DRILLED HOLES AND INSTALLED. (M)SDR AALA20050099Schrader Valve · defectiveDFW INFLIGHT T1181/07 - UNABLE TO RETRACT NOSE GEAR AFTER TAKEOFF. RAN CHECKLIST. NO DAMAGE TO NOSE GEAR AREA. FOUND NOSE STRUT FLAT. REPLACED SCHRADER VALVE AND SERVICED NOSE GEAR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050097Light · inoperativeDFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 22D INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050095Light · inoperativeDFW - FORWARD SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 27D INOPERATIVE. REPLACED THE FORWARD MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 27D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050094Light · inoperativeDFW - SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 14D. REPLACED SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050096Light · inoperativeDFW - AFT SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 27D INOPERATIVE. REPLACED THE AFT SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 27D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050098Light · inoperativeDFW - AFT EMERGENCY ESCAPE PATH LIGHT AT SEAT 19D INOPERATIVE. REPLACED AFT EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050092Battery Pack · dischargedORD - CEILING EMERGENCY LIGHTS AT ROWS 7 TO 12 INOPERATIVE. REPLACED BATTERY PACK AT B5101 FOR CEILING EMERGENCY LIGHTS AT ROWS 7 TO 12. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050088Battery Pack · inoperativeTUL - OVERHEAD EMERGENCY LIGHTS AT AFT GALLEY SERVICE DOOR INOPERATIVE. REPLACED BATTERY PACK AT STATION 1190R FOR OVERHEAD EMERGENCY LIGHTS AT AFT GALLEY SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASMF200502003Valve · leakingDURING TRANSIT CHECK WERE DETECTED HYDRAULIC LEAK AT RIGHT MAIN LANDING GEAR IN VALVE LOCKOUT. THE VALVE LOCKOUT WAS REPLACED IAW MM 32-42-06, TESTED CORRECT. CORRECT, DEFERRED REPORT WAS CLOSEDSDR AALA20050082Battery Pack · inoperativeRIGHT AND LEFT HAND EMERGENCY ESCAPE PATH HATCH AND FORWARD EXIT DOOR LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR RIGHT AND LEFT HAND EMERGENCY ESCAPE PATH HATCH AND FORWARD EXIT DOOR LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0500042Seat Track · corrodedINSPECTION FOUND F/O'S AFT O/B SEAT TRACK CORRODED. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-40-01.SDR AALA20050085Battery Pack · inoperativeDFW - OVERHEAD EMERGENCY LIGHT AT ROWS 14 TO 17 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROW 14. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050084Socket · inoperativeDFW - FORWARD EMERGENCY ESCAPE PATH LIGHT AT SEAT 7D INOPERATIVE. REPLACED SOCKET FOR FORWARD EMERGENCY ESCAPE PATH LIGHT AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050080Battery Pack · inoperativeDTW - OVERHEAD EMERGENCY LIGHTS AT ROWS 29 AND 30 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROWS 29 AND 30. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0500041Panel · crackedINSPECTION FOUND A 2 INCH CRACK IN UPPER TRAILING EDGE PANEL LOCATED FORWARD OF O/B SIDE OF GROUND SPOILER, LEFT UPPER WING, XRS 91.0 TO 111.5. A NEW PANEL WAS INSTALLED IAW SRM 51-30-2.SDR CALA0500040Door Frame · crackedINSPECTION FOUND A 1.75 INCH CRACK IN NWW LT DOOR JAMB AT UPPER LOCK FASTENER FOR SPRAY DEFLECTOR GUARD, STA 45. THE CRACK WAS STOP DRILLED AND A REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 110.SDR AALA20050079Wire · brokenSEA - AFT TAIL CONE EMERGENCY LIGHT ON LEFT SIDE INOPERATIVE ON TEST OF LOWER TAIL CONE HANDLE. FOUND WIRE BROKEN FROM THREE WIRE SPLICE IN TAIL CONE AREA. RESPLICED BROKEN WIRE IN AFT TAIL CONE AREA FOR EMERGENCY LIGHT ON LEFT SIDE. SYSTEM GROUND CHECKED NSDR CALA0500036Skin · crackedINSPECTION FOUND A 1 INCH CRACK BELOW LOWER FORWARD LATCH OF MID CARGO DOOR SKIN. THE DOOR SKIN WAS REPAIRED IAW SRM 52-05, FIGURE 26A.SDR AALA20050069Contact · dirtyTPA - OVERWING FORWARD EMERGENCY EXIT LIGHTS INOPERATIVE. CLEANED BATTERY CONTACTS FOR OVERWING FORWARD EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050078Socket · inoperativeLAX - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 7D FORWARD INOPERATIVE. REPLACED SOCKET FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 7D FORWARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050077Battery Pack · inoperativeSEA - OVERHEAD EMERGENCY EXIT LIGHTS AT AFT ENTRY AISLE INOPERATIVE. REPLACED BATTERY PACK B527 AT RIGHT HAND AFT LAVATORY FOR OVERHEAD EMERGENCY EXIT LIGHTS AT AFT ENTRY AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0500035Pan · crackedINSPECTION FOUND A .75 INCH CRACK AT CORNER OF LOWER FORWARD INNER PAN OF FORWARD CARGO DOOR. THE CRACK WAS STOP DRILLED AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 52-05, FIGURE 26A.
Back to Mcdonnell Douglas DC-9-82