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 AALA20041072Battery Pack · inoperativePHX - BATTERY CHARGER AT STATION 902R FOR CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK/CHARGER ASSEMBLY AT STATION 902R FOR CABIN EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041073Battery Pack · inoperativeLGA - LEFT AND RIGHT EMERGENCY EXIT LIGHTS AT ROW 21 ARE INOPERATIVE. RESEATED BATTERY PACKS AT B5105 FOR EMERGENCY EXIT LIGHTS AT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040822Lanyard · looseL1 DOOR GIRT BAR WAS DIFFICULT TO UNLATCH. FOUND LANYARD LOOSE, RESECURED LANYARD AND CLEANED GIRT BAR LATCH, OPS CHECK GOOD.SDR AALA20041070Charger · inoperativeEMERGENCY LIGHTS IN CEILING BETWEEN AFT LAVATORIES ARE INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY FOR EMERGENCY LIGHTS IN CEILING BETWEEN AFT LAVATORIES. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR GTIA040827Line · rupturedDURING CLIMB, LT HYDRAULIC QTY WENT TO 3 PRESS 0, LT HYD PRESSURE LOW ANNUN, DID QRH CHK LIST. FOUND LT ELEVATOR POWER CONTROL HYDRAULIC LINE RUPTURED NEAR UNION AT THE CONTROL VALVE, REMOVED AND REPLACED RUPTURED LINE. AIRCARFT TAIL SWAP WITH N814NK.SDR AALA20041066Battery Pack · inoperativeSAT - EMERGENCY EXIT LIGHT IN COCKPIT R1 SERVICE DOOR IS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHT IN COCKPIT R1 SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040825Gyro · inaccurateHEADING LIGHT ON IN FLIGHT 6 FT-8 FT OFF. REPLACED NR 1 DG AND SWITCHING UNIT.SDR GTIA040814Landing Gear · unknownAFTER TAKEOFF, LT MAIN RED GEAR REMAINED ON WITH GEAR HANDLE UP. FOLLOW QRH PROCEDURE. ADVISED DISPATCH FOR FUEL BURN AND CONSULTED WITH MECHANIC CONTROL. CONTINUED TO ACY AT REDUCED SPEED AND ALT. CHECKED GEAR UP AND DOWN PROX SENSORS WIRING RESISTANCE IASDR AALA20041060Battery Pack · inoperativeFORWARD ENTRY COCKPIT OVERHEAD EMERGENCY EXIT LIGHTS WOULD NOT ILLUMINATE. REPLACED POWER SUPPLY B5-23 FOR FORWARD ENTRY COCKPIT OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR GTIA040816Spring · brokenR1 SVC, DOOR BAYONET ROLLER HELICAL TORSION SPRING BROKEN. REMOVED AND REPLACED R1 DOOR BAYONET ROLLER HELICAL TORSION SPRING. OPS CHECK GOOD IAW 52-41-00.SDR GTIA040818Retract Cylinder · out of adjustAFTER TAKEOFF, RT MAIN GEAR RED LIGHT REMAINED ON WITH GEAR HANDLE UP. FOLLOWED PROCEDURE IN QRH AND CONSULTED WITH MECHANIC CONTROL. CONTINUED TO DESTINATION AT REDUCED SPEED IAW QRH. ON DESCENT IN TPA AT 10,000 PRIOR TO EXTENDING LANDING GEAR, RED LIGHT WSDR AALA20041054Wire · shortedMCO - INFLIGHT T2226/16 HAZY SMOKE AND SHARP ELECTRICAL WIRE BURNING SMELL COMING FROM FIRST CLASS LAVATORY WAS REPORTED 40 MINUTES AFTER TAKEOFF. PERFORMED QRH SMOKE PROCEDURE AND SMOKE AND SMELL DISSIPATED. FOUND FORWARD LAVATORY WATER TANK SHORTING. PLACSDR AALA20041052Battery Pack · inoperativeRDU - EMERGENCY EXIT LIGHTS IN FIRST CLASS CEILING INOPERATIVE. REPLACED BATTERY PACK AT B5100 FOR EMERGENCY EXIT LIGHTS IN FIRST CLASS CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041061Engine · inoperativeACT - T/323 EN ROUTE DFW - PVR LEFT HAND ENGINE COMPRESSOR STALLS AND HIGH EGT. LANDED ACT WITHOUT INCIDENT. REPLACED LEFT HAND ENGINE.SDR AALA20041049Battery Pack · inoperativeSFO - EMERGENCY LIGHTS AT RIGHT HAND FORWARD EMERGENCY EXIT OVERWING DOOR AND LEFT HAND SERVICE DOOR CEILING INOPERATIVE. REPLACED BATTERY PACK B5103 (6011779 FROM HONEYWELL) AND B5107 (60030451 FROM HONEYWELL). SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041045Battery Pack · inoperativeDFW - EMERGENCY EXIT CEILING LIGHTS AT FORWARD ENTRY DOOR AND ROW 25 INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY EXIT CEILING LIGHTS AT FORWARD ENTRY DOOR AND ROW 25. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041044Connector · crossedDFW - EMERGENCY ESCAPE PATH LIGHTS AT FORWARD TAIL STAIRS INOPERATIVE. FOUND CONNECTORS CROSS CONNECTED. RECONNECTED CONNECTORS FOR EMERGENCY ESCAPE PATH LIGHTS AT FORWARD TAIL STAIRS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041041Battery Pack · inoperativePHX - EMERGENCY LIGHTS AT AFT RIGHT HAND LAVATORY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT RIGHT HAND LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR P9RA20040047Power Supply · inoperativeAIRCRAFT IN MAINTENANCE, SYR. EMERGENCY LIGHT AT ROW 28 INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW MM.SDR P9RA20040046Power Supply · inoperativeAIRCRAFT IN MAINTENANCE, SYR. EMERGENCY LIGHTS INOPERATIVE AT ROW 26. REMOVED AND REPLACED POWER SUPPLY IAW MM.SDR GTIA040810Handle · defectiveAIL SLIDE MANUAL DEPLOY HANDLE (RED STRAP) NOT ROUTED THROUGH DEPLOYMENT LANYARD RELEASE. UPON ATTEMPTING TO REROUTE TAIL SLIDE MANUAL DEPLOY HANDLE FOUND SLIDE COMING APART. REMOVED AND REPLACED SLIDE PACK.SDR GTIA040811Cable · misroutedR1 SLIDE INFLATION CABLE NOT ROUTED THROUGH GROMMET TAB. RE-ROUTED CABLE.SDR AALA20041059Battery Pack · inoperativeCOCKPIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-23 FOR COCKPIT EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR AALA20041058Battery Pack · inoperativeFORWARD NR 1 SPOT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-23 FOR FORWARD NR 1 SPOT OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR AALA20041057Battery Pack · inoperativeFORWARD NR 1 GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-23 FOR FORWARD NR 1 GALLEY EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR AALA20041056Battery Pack · inoperativeFORWARD ENTRY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-23 FOR FORWARD ENTRY OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR AALA20041063Battery Pack · inoperativeDFW - AFT OVERWING EMERGENCY EXIT IDENTIFIERS INOPERATIVE. REPLACED BATTERY PACK FOR AFT OVERWING EMERGENCY EXIT IDENTIFIERS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041039Battery Pack · inoperativeATL - EMERGENCY EXIT SIGNS OVER ROW 20AB AND 20DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT SIGNS OVER ROWS 20AB AND 20DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041036Battery Pack · inoperativeDFW - TAIL CONE EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK B527 FOR TAIL CONE EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041035Battery Pack · inoperativeDFW - AFT ENTRY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B527 FOR AFT ENTRY OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041043Wire · damagedDFW - EMERGENCY LIGHTS FOR SEAT ROWS 19 AND FORWARD INOPERATIVE. REPAIRED WIRING UNDER SEAT ROW TRACK 9 FOR EMERGENCY LIGHTS FOR SEAT ROWS 19 AND FORWARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041042Slide · dischargedMSP - AFT GALLEY DOOR SLIDE PRESSURE OUT OF LIMITS. REPLACED SLIDE AT AFT GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0400665Beam · crackedL1 DOOR UPPER CORNER BEAM CRACKED. STOP DRILLED CRACK, INSTALLED NEW DOUBLER PER SRM 52-05, FIG 31.SDR AALA20041029Battery Pack · inoperativeDFW - EMERGENCY ESCAPE PATH LIGHTING IN TAIL CONE COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY ESCAPE PATH LIGHTING IN TAIL CONE COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041028Switch · inoperativeDFW - FLIGHT ATTENDANT SWITCH WILL NOT ILLUMINATE EMERGENCY LIGHTS. REPLACED FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH AND AFT CARGO EMERGENCY LIGHT BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR ASMF200410005Modulator · leakingDURING LT ENGINE STARTING CAPTAIN REPORTED LT HYDRAULIC SYSTEM LEAKAGE AND PRESSURE DROP TO ZERO. DURING REVISION THE TECHNICAL PERSONNEL DETECTED THAT THE LEAK WAS FROM A LINE OF THE MAIN FILTERS MODULE. LINE WAS TIGHTENED AND HYDRAULIC FLUID RECHARGED. TESTSSDR AALA20041033Actuator · inoperativeLAX - INFLIGHT T13956 SNA TO STL. UNABLE TO RETRACT NOSE LANDING GEAR. FLIGHT CREW CYCLED GEAR THREE TIMES AND NOSE GEAR DID NOT RETRACT, RED LIGHT WAS ON. LANDED LAX WITHOUT INCIDENT. LANDING WEIGHT WITHIN LIMITS. PERFORMED BITE TEST ON NOSE GEAR UPLOCK SDR AALA20041027Connector · looseDFW - RIGHT HAND EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. CLEANED AND RESEATED CONNECTORS ON RIGHT HAND AFT EMERGENCY EXIT SIDEWALL LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040834Intercostal · corrodedAFT PIT - CORRODED INTERCOSTAL AND FRAME AT FS 1326, LONG 28L - 27L. REMOVED CORROSION ON FRAME, REMOVED CARGO TRACK FROM STA 1320-1271 (FOM), REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-30-5, 51-30-2.SDR CALA0400664Beam · crackedLEFT MAIN LANDING GEAR DOOR PAN CRACKED AFT OUTBOARD SIDE OF DOOR. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 52-05 FIG 28.SDR CALA0400662Intercostal · crackedFUSELAGE INTERCOSTAL AFT ATTACH ANGLE CRACKED AT INBOARD CORNER STATION 120 BELOW AND OUTBOARD OF FIRST OFFICERS BRIEFCASE BOX. INSTALLED FABRICATED ANGLE PER SRM 51-30-5.SDR GTIA040841Seat Track · corrodedPASSENGER SEAT TRACK EXFOLIATED AT FS 1058, LT OB AND 1250 LT IB. CUT AND REMOVED DAMAGED SEAT TRACK, FABBED NEW SEAT TRACK AND SPLICE, TREAT, PRIME AND TOPCOAT SEAT TRACK AND INSTALLED.SDR AALA20041010Battery Pack · inoperativeDFW - CEILING EMERGENCY LIGHTS AT ROW 14 AND 20 INOPERATIVE. REPLACED BATTERY PACK ASSEMBLY FOR CEILING EMERGENCY LIGHTS AT ROW 14 AND 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041011Battery Pack · inoperativeDFW - CEILING EMERGENCY LIGHTS AT FORWARD GALLEY AND COCKPIT INOPERATIVE. REPLACED BATTERY PACK ASSEMBLY FOR CEILING EMERGENCY LIGHTS AT FORWARD GALLEY AND COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA040793Handle · looseL1 DOOR HANDLE LOOSE. SECURED HANDLE.SDR GTIA040794Slide · unsecureL1 SLIDE PACK CAME OFF DOOR. RESECURED SLIDE PACK.SDR AALA20041014Wire · brokenAUS - EMERGENCY LIGHT AT FORWARD GALLEY INOPERATIVE. REPAIRED BROKEN WIRE FOR EMERGENCY LIGHT AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041013Battery Pack · inoperativeMSP - CEILING EMERGENCY LIGHTS AT ROW 28 INOPERATIVE. REPLACED BATTERY PACK AND CHARGER FOR CEILING EMERGENCY LIGHTS AT ROW 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041021Battery Pack · inoperativeTPA - CEILING EMERGENCY LIGHTS AT ROWS 3 TO 6 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT ROWS 3 TO 6. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR CALA0400659Seat Track · corrodedRIGHT CENTER SEAT TRACK CORRODED FROM STA 229-235, APPROX 35 INCHES. INSTALLED SEAT TRACK PER SRM 51-30-0 & 53-05, FIG 4H.
Back to Mcdonnell Douglas DC-9-82