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 ASMF200512018Door · false indicationAIRCRAFT RETURNED TO PLATFORM DURING TAKE OFF, AFTER NOSE LANDING GEAR ROTATION, THE ELECTRICAL/ELECTRONIC COMPARTMENT OPEN DOOR LIGHT TURNED ON. DURING MAINTENANCE REVISION, THE DOOR WAS DETECTED OPEN WITH THE SAFETY PINS ACTIVATED. THE ELECTRICAL/ELECTRONICSDR ASAA0580536Longeron · corrodedC-CHECK, LONGERON CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPLACEMENT SECTION WITH 2 REPAIR SPLICES. (K)SDR AALA20050824Battery Pack · dischargedLGA - EMERGENCY LIGHTS THROUGHOUT CABIN INOPERATIVE. REPLACED BATTERY PACKS AT B27, B28, B5104 AND B5107 FOR EMERGENCY LIGHTS THROUGHOUT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050827Battery Pack · inoperativeLGA - CABIN EMERGENCY CEILING LIGHTS AT ROWS 3DEF, 6DEF, 13DEF, 27DEF AND 11AB AND 27AB INOPERATIVE. REPLACED BATTERY PACK AT B5102, B5104, B5106, AND B5100 FOR CABIN EMERGENCY CEILING LIGHTS AT ROWS 3DEF, 6DEF, 13DEC, 27DEF, 11AB AND 27AB. SYSTEM GROUND CHESDR GTIA050289Powerpack · inoperativeOVERHEAD EMERGENCY LIGHTS IN TAIL COMPARTMENT INOPERATIVE. REMOVED AND REPLACED POWER PACK FOR EMERGENCY LIGHTS IN TAIL COMPARTMENT OVERHEAD. (K)SDR MWEA050136Skin · bentPASSENGER DOOR OUTER SKIN BENT AT LOWER REAR EDGE FROM JETWAY. COLD FORMED OUTER SKIN.SDR MWEA050135Skin · bentPASSENGER DOOR OUTER SKIN BENT AT DOOR LOWER FORWARD EDGE FROM JETWAY. COLD FORMED BENT OUTER SKIN.SDR AALA20050821Battery Pack · dischargedLGA - OVERHEAD AISLE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACKS IN MID CABIN FOR OVERHEAD AISLE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050817Battery Pack · dischargedDTW - OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050818Wire · inoperativeLGA - CEILING EMERGENCY LIGHTS AT AFT DOOR INOPERATIVE. CLEANED AND ADJUSTED CONTACTS ON BATTERY PACKS FOR CEILING EMERGENCY LIGHTS AT AFT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050813Compressor · stalledSTL - AT FL280 RIGHT ENGINE COMPRESSOR STALLED. OPERATED ENGINE AT IDLE AND LANDED STL WITHOUT INCIDENT. REPLACED RIGHT HAND ENGINE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050810Battery Pack · dischargedSFO - CEILING EMERGENCY LIGHTS AT ROWS 23 TO 27 INOPERATIVE. REPLACED BATTERY PACK AT ROW 27 FOR CEILING EMERGENCY LIGHTS AT ROWS 23 TO 27. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050812Battery Pack · inoperativeSFO - SEAT MOUNTED EMERGENCY LIGHTS FROM 21D TO AFT CABIN INOPERATIVE. REPLACED AFT BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS FROM 21D TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050807Oil System · leakingORD - COMING IN FOR LANDING AT ABOUT 2000 FEET SMELLED AN UNIDENTIFIED ODOR. AFTER LANDING FLIGHT ATTENDANTS INFORMED CREW OF A LITE HAZY SMOKE IN THE CABIN. SHUT OFF THE WING AND ENGINE ANTI-ICE AND THE SMOKE SUBSIDED. SUSPECT OIL LEAKING INTO APU INLET. RSDR AALA20050808Acm · inoperativeJFK - AIR INTERRUPTED TO JFK DUE TO STRONG ODOR OF OIL AND SMOKE THROUGHOUT CABIN AND COCKPIT. LANDED JFK WITHOUT INCIDENT. PULLED COALESCER BAGS AND FOUND OIL. REPLACED LEFT AND RIGHT HAND PACK AIR CYCLE MACHINE AND COALESCER BAGS. SYSTEM GROUND CHECKED NSDR ASMF200512007Pin · brokenDURING PUSH BACK THE NOSE LANDING GEAR TOWING FUSE PIN WAS BROKEN. IT WAS REPLACED IAW MM 32-21-14 AND THE NOSE LANDING GEAR AND GENERAL INSPECTIONS FOR EXCESSIVE LOAD WERE PERFORMED IAW MM 05-51-03 AND MM 32-20-00 RESPECTIVELY, NO DAMAGES WERE FOUND.SDR AALA20050795Battery Pack · inoperativeSAT - FORWARD EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AND CHARGER FOR FORWARD EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050794Handle · inoperativeAFTER TAKEOFF, LANDING GEAR WOULD NOT RETRACT. HANDLE WOULD NOT COME UP. FOLLOWED QRH. NOSE WHEEL WAS STEERABLE. LANDED ORD WITHOUT INCIDENT. ACCOMPLISHED WORK CARD 32-96-14. NO DEFECTS NOTED. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050802O-Ring · cutDFW - REPORTS OF SMOKE AND FUEL STREAMING OUT OF LEFT HAND ENGINE DURING LANDING, REVERSE, AND ROLL OUT. FUEL CONTINUED TO LEAK FOR 20 MINUTES AFTER ALL POWER REMOVED. FOUND LEFT HAND ENGINE FILTER BOWL LEAKING. O-RING CUT. REPLACED O-RING. SYSTEM GROUNDSDR AALA20050800Battery Pack · inoperativeSFO - OVERHEAD EMERGENCY LIGHT AT AFT FLIGHT ATTENDANT SEAT AND ROWS 12 TO 16 INOPERATIVE. REPLACED BATTERY PACKS AT B5 27 AND B5 102 FOR OVERHEAD EMERGENCY LIGHT AT AFT FLIGHT ATTENDANT SEAT AND ROWS 12 TO 16. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050797Piston · inoperativeNOSE GEAR WOULD NOT RETRACT. LANDED BNA WITHOUT INCIDENT. FOUND CHROME MISSING FROM PISTON. REPLACED PISTON AND SCHRADER VALVE. SERVICED STRUT WITH OIL AND AIR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050799Light · inoperativeSFO - EMERGENCY LIGHTS AT TAIL COMPARTMENT SIDEWALL INOPERATIVE. REPLACED AFT VETICAL EMERGENCY LIGHT ASSEMBLY FOR EMERGENCY LIGHTS AT TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050792Module · inoperativeLGA - EMERGENCY LIGHTS IN AFT CABIN INOPERATIVE. REPLACED LIGHT CONTROL MODULE FOR EMERGENCY LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050791Battery Pack · looseLGA - TWO OVERHEAD EMERGENCY LIGHTS IN TAIL CONE INOPERATIVE. SECURED LOOSE BATTERY PACKS FOR TWO OVERHEAD EMERGENCY LIGHTS IN TAIL CONE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050790Battery Pack · inoperativeSFO - CEILING EMERGENCY LIGHTS AT ROWS 7D TO 15D INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT ROWS 7D TO 15D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050788Battery Pack · inoperativeLGA - COCKPIT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR COCKPIT OVERHEAD EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050787Battery Pack · inoperativeLGA - FORWARD SECTION SEAT MOUNTED EMERGENCY EGRESS LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD SECTION SEAT MOUNTED EMERGENCY EGRESS LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050786Battery Pack · looseLGA - EMERGENCY LIGHT AT STAIRWELL WALKWAY INOPERATIVE. RESECURED LOOSE BATTERY PACK FOR EMERGENCY LIGHT AT STAIRWELL WALKWAY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050784Battery Pack · inoperativeORD - CEILING EMERGENCY LIGHTS BETWEEN ROWS 13 AND 19 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS BETWEEN ROWS 13 AND 19. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050779Battery Pack · inoperativeSFO - OVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 23 AND 27 INOPERATIVE. REPLACED BATTERY PACK AT B5106 FOR OVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 23 AND 27. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050778Battery Pack · inoperativeSFO - CEILING EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050777Switch · inoperativeLAX - EMERGENCY LIGHTS IN SEATS INOPERATIVE. REPLACED SWITCH FOR FORWARD FLIGHT ATTENDANT EMERGENCY LIGHT PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050773Line · crossedLAX - ON LANDING ROLLOUT THE NR 2 MAIN WHEEL BRAKE LOCKED CAUSING THE NR 2 TIRE TO BLOW OUT. FOUND THE FORWARD BRAKE LINES CROSSED ON THE LT MAIN LANDING GEAR. REPOSITIONED THE BRAKE LINES AND ACCOMPLISHED ANTI-SKID TEST. SYSTEM GROUND CHECKED NORMAL OPERATSDR AALA20050769Battery Pack · inoperativeSFO - EMERGENCY LIGHTS IN FORWARD CEILING AT ENTRY, SERVICE DOOR AND COCKPIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FORWARD CEILING AT ENTRY, SERVICE DOOR AND COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050772Battery Pack · inoperativeSFO - EMERGENCY LIGHT IN TAIL COMPARTMENT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN TAIL COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050771Pump · inoperativeORD - FORWARD CENTER TANK BOOST PUMP CIRCUIT BREAKER POPPED IN FLIGHT. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED THE CENTER TANK BOOST PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050766Battery Pack · inoperativeLAX - OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050768Battery Pack · inoperativeSFO - ALL OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ABOVE ROWS 6, 13, 20, AND 25 FOR ALL OVERHEAD EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050764Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT FORWARD SEATS INOPERATIVE. REPLACED BATTERY PACK ABOVE FIRST CLASS LAVATORY FOR EMERGENCY LIGHTS AT FORWARD SEATS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050759Oxygen Bottle · dischargedINFLIGHT CREW OXYGEN PRESSURE DROPPED TO ZERO PSI IN CRUISE. REPLACED CREW OXYGEN CYLINDER AND FIRST OFFICER OXYGEN REGULATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050756Apu · failedINFLIGHT - DURING CLIMB AND HIGH POWER SETTING SMOKE/HAZE IN BOTH CABIN AND COCKPIT. SMOKE/HAZE WOULD ONLY DISSAPATE DURING LOWER POWER SETTINGS. RETURNED TO ORD AND LANDED WITHOUT INCIDENT. REPLACED APU. SYSTEM GROUND CHECKED NORMAL OPERATIONS.SDR GTIA050271Windshield · leakingFRONT CENTER WINDSHIELD LEAKING WATER, AIRCRAFT TAIL SWAP WITH N808NK. WINDSHIELD SEALANT FOUND DELAPIDATED, RE SEALED WINDSHIELD, LEAK CHECKS GOOD. (K)SDR AALA20050751Manifold · inoperativeLAX - LEFT ENGINE LOOP-A LIGHT FOLLOWED BY LEFT ENGINE FIRE WARNING DURING CLIMBOUT AT APPROXIMATELY 6000 FEET. THROTTLES TO IDLE AND LIGHTS AND WARNING WENT OUT. LEFT EXHAUST GAS TEMPERATURE AT TAKEOFF IN YELLOW ZONE. RIGHT ENGINE EXHAUST GAS TEMPERATURE NSDR AALA20050752Battery Pack · inoperativeDFW - CEILING EMERGENCY LIGHTS AT ROW 14D INOPERATIVE. REPLACED BATTERY PACK AND CHARGER ASSEMBLY FOR CEILING EMERGENCY LIGHTS AT ROW 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050748Battery Pack · inoperativeBOS - EMERGENCY LIGHTS IN CEILING FROM ROWS 22 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CEILING FROM ROWS 22 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050745Battery Pack · inoperativeLGA - EMERGENCY LIGHTS FOR FIRST CLASS OVERHEAD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050738Duct · failedDFW INFLIGHT T1680/12 NOV - NUMBER ONE ENGINE LOOP B FIRE WARNING INDICATION. LIGHT WENT OUT AFTER LOWERING THROTTLE ON ENGINE. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED BLOWN LEFT AFT ENGINE ANTI ICE DUCT. SYSTEM GROUND CHECKED NORMAL OPERATISDR AALA20050740Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT RIGHT OVERWING AFT EXIT INOPERATIVE. REPLACED BATTERY PACK B2505 FOR EMERGENCY LIGHTS AT RIGHT OVERWING AFT EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050735Battery Pack · inoperativeLGA - FOUND CEILING EMERGENCY EXIT LIGHTS ABOVE AFT STAIRS INOPERATIVE. FOUND AND REPAIRED BROKEN WIRE AT S3156. REPLACED BATTERY PACK AS PRECAUTION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050734Oven · fireFIRE INSIDE FIRST CLASS OVEN. USED TWO FIRE EXTINGUISHERS AND PULLED CIRCUIT BREAKERS. AIR INTERRUPTED TO ATL. REPLACED OVEN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82