Mcdonnell Douglas DC-9-87
Service difficulty reports · 786
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 = 'DC987' 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 = 'DC987' 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 ORJA96111Wire · brokenEMERGENCY LIGHTS INOP AT ROW 26 DEF AND AT ROW 20 DEF. REATTACHED BROKEN WIRE AT LOWER FLOOR/SEAT ATTACH POINT. OPS CHECK NORMAL. (M)SDR ORJA96110Battery Pack · dischargedEMERGENCY AISLE LIGHTS WILL NOT LIGHT WITH SWITCH IN 'ON' POSITION. REMOVED AND REPLACED AFT EMERGENCY LIGHT POWER SUPPLY. AISLE LIGHTS OPS NORMAL. (M)SDR ORJA9682Wire · brokenEMERGENCY LIGHTS OUT AT 6-DEF AND 15-DEF. AT 6-DEF REPINNED CONNECTOR. OPS CHECK NORMAL. AT 15-DEF REPAIRED WIRE BY SPLICE. OPS CHECK NORMAL. (X)SDR ORJA9672Ground · looseMID CABIN EMERGENCY CEILING LIGHT INOP. RELAMPED, NO HELP. FOUND LOOSE GROUND STUD AT 5225. TIGHTENED STUD. OPS NORMAL. (M)SDR GRAA9674Cover · missingLINE MAINTENANCE AT IFP, FOUND THE EMERGENCY TRACK LIGHT COVER MISSING AT ROW 8. MAINTENANCE REPLACED THE EMERGENCY TRACK LIGHT COVER. OPERATIONAL CHECKED NORMAL. NO DEFECTS NOTED. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GRAA9673Cover · looseLINE MAINTENANCE AT IFP, FOUND THE FORWARD EMERGENCY TRACK LIGHT COVER LOOSE. MAINTENANCE RESECURED THE FORWARD EMERGENCY TRACK LIGHT COVER. OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM WAS PERFORMED. NO DEFECTS NOTED. THE AIRCRAFT WAS RETURNED TO SERVISDR ORJA9668Wire · failedEMERGENCY EXIT TRACK LIGHT OUT AT SEAT ROW 22. REPAIRED WIRING. OPS GOOD. (X)SDR ORJA9656Oil Filter · cloggedRETURNED TO GATE FOR LEFT OIL STRAINER CLOGGING LIGHT. REMOVED AND REPLACED RIGHT (NR2) ENGINE OIL AND OIL FILTER. LEAKS AND OPS CHECK NORMAL AT THIS TIME. (M)SDR ORJA9655Fuse · blewEMERGENCY LIGHTS ROWS 16-18 OUT. INSTALLED NEW FUSE IN EMERGENCY POWER PACK, ROW 20 DEF. OPERATIONAL CHECK NORMAL. (M)SDR ORJA9654Battery Pack · dischargedROWS 12-15 SEAT MOUNTED EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY PACK. OPS CHECK GOOD. (M)SDR GRAA9668Start Valve · failedON CLIMB-OUT FROM RENO, A/C HAD THE RIGHT ENGINE START VALVE LIGHT ILLUMINATE. THE RIGHT START VALVE WAS PREVIOUSLY DEFERRED. THE FLIGHT SHUTDOWN AND SECURED THE RIGHT ENGINE. AIRCRAFT RETURNED TO RNO. MAINTENANCE VERIFIED THAT THE RIGHT ENGINE START CONTRSDR GRAA9663Light · inoperativeLINE MAINTENANCE AT IFP, DISCOVERED THAT THE EMERGENCY FLOOR LIGHT WAS INOPERATIVE. MAINTENANCE RELAMPED OPERATIONAL CHECKED NORMAL. NO DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE. (M)SDR GRAA9660Wire · brokenLINE MAINTENANCE AT ENV, DISCOVERED THAT EMERGENCY FLOOR LIGHT AT ROW 18 WAS INOPERATIVE. MAINTENANCE SOLDERED BROKEN WIRE, OPERATIONAL CHECK WAS PERFORMED. NO DEFECTS NOTED. OPERATIONAL CHECKED NORMAL. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GRAA9662Lens · missingLINE MAINTENANCE AT ENV, DISCOVERED RED EMERGENCY FLOOR TRACK LIGHT AT ROW 19R WAS MISSING. MAINTENANCE REPLACED THE SOCKET PIGTAIL, LAMP, AND LENS. MAINTENANCE PERFORMED OPERATIONAL CHECK. NO DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE. (M)SDR GRAA9661Lamp · inoperativeENV MAINTENANCE FOUND THE EMERGENCY LIGHT INOP AND LENS MISSING FROM ROW 19. THEY RELAMPED AND REPLACED THE LENS. SYSTEM OPS CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR 96ZZZM1379Lens · missingENV MAINTENANCE FOUND THE EMERGENCY LIGHT INOP AND LENS MISSING FROM ROW 19. THEY RELAMPED AND REPLACED THE LENS. SYSTEM OPS CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. REFERENCE GRAA9658.SDR GRAA9671Battery Pack · dischargedMAINTENANCE FOUND EMERGENCY FLOOR LIGHTING INOP FROM ROW 22 AFT WHILE PERFORMING A T/O. REMOVED AND REPLACED THE BATTERY PACK. SYSTEM OPS CHECKED GOOD. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR ORJA9641Power Supply · inoperativeAFT CABIN EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY. OPS CHECK NORMAL. (X)SDR GRAA9670Light · looseLINE MAINTENANCE AT IFP, DISCOVERED THAT EMERGENCY FLOOR PATH LIGHT STRIP CAME LOOSE IN PASSENGER CABIN. MAINTENANCE SECURED THE EMERGENCY FLOOR TRACK LIGHT STRIP. MAINTENANCE PERFORMED OPERATIONAL CHECK OF THE SYSTEM. NO DEFECTS NOTED. AIRCRAFT WAS RETURNSDR GRAA9639Socket · defectiveLINE MAINTENANCE AT ENV, DISCOVERED THAT THE EMERGENCY FLOOR TRACK LIGHT SOCKET WAS DETECTIVE. MAINTENANCE REPLACED THE EMERGENCY FLOOR TRACK PIGTAIL SOCKET AND PERFORMED AN OPERATIONAL CHECK OF THE SYSTEM. NO DEFECTS NOTED. AIRCRAFT WAS RETURNED TO SERVICESDR GRAA9636Lens · missingAT ENV, MAINTENANCE DISCOVERED THAT THE EMERGENCY FLOOR TRACK LIGHT LENS (RED) WAS MISSING. MAINTENANCE REPLACED THE LENS AND PEFORMED AN OPERATIONAL CHECK OF THE EMERGENCY FLOOR TRACK SYSTEM. NO DEFECTS NOTED. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GRAA9630Lights · inoperativeLINE MAINTENANCE AT ENV, DISCOVERED THAT THE EMERGENCY FLOOR TRACK LIGHTS AT ROW 18 WAS INOP AND MISSING ONE RED LENS. MAINTENANCE RELAMPED AND REPLACED THE MISSING RED LENS. MAINTENANCE PERFORMED AND OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. NO DEFECSDR GRAA9628Lens · missingLINE MAINTENANCE AT ENV, DISCOVERED THE EMERGENCY FLOOR TRACK LIGHT AT ROW 18 WS MISSING LENS. MAINTENANCE REPLACED THE MISSING LENS. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. NO DEFECTS NOTED. AIRCRAFT WAS RETURNED TO SERVISDR GRAA9627Batteries · dischargedLINE MAINTENANCE AT RNO, DISCOVERED THAT BOTH OVERWING EXITS OVERHEAD EMERGENCY LIGHTS FAILED. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES. MAINTENANCE PERFORMED AN OPEATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. THE EMERGENCY LIGHT SYSTEM OPSDR GRAA9625Oil Filter · dirtyAT RNO, ON ENGINE START HAD THE RIGHT 'ENGINE OIL CLOGGING' LIGHT ILLUMINATE. MAINTENANCE REMOVED AND REPLACED THE NR 2 ENGINE MAIN ENGINE OIL FILTER. MAINTENANCE PERFORMED AN OPERATIONAL AND LEAK CHECK OF NR 2 ENGINE. NR 2 ENGINE OPERATIONALLY CHECKED NORMSDR GRAA9624Lens · missingLINE MAINTENANCE AT ENV, DISCOVERED THAT THE EMERGENCY FLOOR TRACK LENS WAS MISSING AT ROW 18. MX REPLACED THE LENS ON THE EMERGENCY FLOOR TRACK AT ROW 18. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY FLOOR LIGHT SYSTEM. THE SYSTEM OPERATIONASDR GRAA9623Power Supply · inoperativeLINE MAINTENANCE AT RNO, DISCOVERED THE FORWARD EMERGENCY FLOOR LIGHT LIGHT STRIP INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOOR LIGHT POWER SUPPLY. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE SYSTEM. THE EMERGENCY FLOOR LIGHT SYSTESDR ORJA96018Batteries · dischargedAFT OVERHEAD EMERGENCY LIGHT IN EMPANNAGE INOP. INSTALLED NEW BATTERIES. OPS CHECKS NORMAL. (M)SDR GRAA9621Power Supply · inoperativeRNO - LINE MAINTENANCE DISCOVERED THE FLOOR PROXIMITY, EMERGENCY LIGHTS AT ROW 2 AND ROW 3 FAILED. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. SYSTEM OPERATIONASDR GRAA96Press Controller · failedRNO - ON CLIMB-OUT, AIRCRAFT HAD THE AUTOPRESSURIZATION SYSTEM FAIL. AIRCRAFT RETURNED TO RNO WITHOUT FURTHER OCCURRENCE. MAINTENANCE DEFERRED THE AUTOPRESSURIZATION SYSTEM IAW MEL: 21-24. THE AIRCRAFT WAS RETURNED TO SERVICE. (X)SDR ORJA96016Battery · dischargedREMOVED LEFT FORWARD EMERGENCY EXIT LIGHT BATTERY PACK. INSTALLED LEFT FORWARD EMERGENCY EXIT LIGHT BATTERY PACK. (M)SDR GRAA9616Battery Pack · dischargedLINE MAINTENANCE AT RNO, DISCOVERED THAT THE LEFT ACCESSORY COMPARTMENT EMERGENCY FLOOR TRACK LIGHTING WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BATTERY POWER SUPPLY PACK. MAINTENANCE PERFORMED AND OPERATIONAL CHECK OF THE SYSTEM. THE EMERGENCY SDR ORJA96013Power Supply · inoperativeINTERMITTENT OPERATION OF FORWARD CABIN FLOOR TRACK POWER SUPPLY. REMOVED AND REPLACED FORWARD CABIN FLOOR TRACK POWER SUPPLY DUE TO SUSPECTED INTERMITTENT OPERATION. OPS CHECKS OK. (M)SDR GRAA9613Lens · missingRNO - LINE MAINTENANCE DISCOVERED AT ROW 18, ONE EACH EMERGENCY FLOOR TRACK LIGHTING RED LENS WAS MISSING. MAINTENANCE REPLACED THE LENS. AN OPERATIONAL CHECK WAS PERFORMED ON THE EMERGENCY FLOOR TRACK LIGHTING SYSTEM. THE EMERGENCY FLOOR TRACK LIGHTING SYSSDR ORJA96012Lens · missingTHREE FLOOR EMERGENCY TRACK LIGHT LENSES MISSING. REPLACED MISSING LENSES IN FLOOR EMERGENCY LIGHTS. (X)SDR GRAA9622Socket · broken wireLINE MAINTENANCE AT RNO, DISCOVERED THAT THE EMERGENCY FLOOR LIGHT TRACK HAS 1 EACH RED LIGHT INOPERATIVE AT THE AFT OVERWING EXIT. MAINTENANCE FOUND THAT THE RED LIGHT HAD A BROKEN WIRE ON THE LAMP SOCKET. MAINTENANCE REMOVED AND REPLACED THE SOCKET. MAINTSDR ORJA96011Tie Bolt · brokenREMOVED AND REPLACED NR 4 MAIN WHEEL ASSY (PN 26088911). REMOVED AND REPLACED NR 4 MAIN WHEEL ASSY DUE TO BROKEN TIE BOLT IAW MM 32. (X)SDR ORJA96009Power Supply · inoperativeROW 23 TO EMP. FLOOR TRACK LIGHTING INOPERATIVE. INSTALLED NEW POWER SUPPLY. OPS CHECK NORMAL. (X)SDR GRAA9612Lens · missingLINE MAINTENANCE AT RNO, DISCOVERED THAT THE EMERGENCY FLOOR LIGHTS WAS MISSING 1 EACH RED FLOOR TRACK LENS ASSEMBLY AT THE OVERWING EXITS. MAINTENANCE REPLACED THE MISSING RED LENS. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. SDR ORJA96008Lens · missing'E' PATH LAMP AT ROW 26 MISSING A LENS. INSTALLED A NEW LENS FOR 'E' PATH LAMP AT ROW 26. (X)SDR GRAA9609Ahrs · failedEN ROUTE BLI-IAS AIRCRAFT DIVERTED INTO RNO DUE TO NR 2 AHRS FAILED, NR 2 VERTICAL GYRO FAILED, AND NR 1 FLIGHT MANAGEMENT ANNUNCIATOR AND FLIGHT DIRECTOR FAILED. MAINTENANCE REMOVED AND REPLACED THE NR 2 AHRS UNIT. OPERATIONAL TEST OF THE NAVIGATION SYSTEM SDR GRAA9608Circuit Breaker · failedAT RNO - AIRCRAFT BLOCKED OUT OF GATE B-10. AIRCRAFT HAD THE DC BUS OFF LIGHT ILLUMINATE ON TAXI OUT. AIRCRAFT TAXIED TO THE NORTH RAMP WITHOUT FURTHER OCCURENCE. MAINTENANCE RECYCLED THE DC BUS SYSTEM CIRCUIT BREAKERS. OPERATIONAL CHECK OF THE DC BUS SYSTSDR GRAA9604Circuit Breaker · trippedAT RNO, AIRCRAFT BEGAN TAKEOFF ROLL AND CIRCUIT BREAKER L-33 POPPED. THIS CIRCUIT BREAKER PROVIDES POWER TO THE NR 1 EPR SYSTEM. AIRCRAFT ABORTED TAKEOFF AT 60 KIAS. AIRCRAFT RETURNED TO THE GATE WITHOUT ANY FURTHER OCCURANCE. MAINTENANCE RESET CIRCUIT BRESDR GRAA9606Power Supply · inoperativeLINE MAINTENANCE AT RNO, DISCOVERED THE FWD AND AFT EMERGENCY FLOOR TRACK LIGHT TRACK INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FWD AND AFT POWER SUPPLIES. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE EMERGENCY LIGHT SYSTEM. THE SYSTEM OPERATIOSDR GRAA9607Connector · failedLINE MAINTENANCE AT ENV, DISCOVERED THAT THE FORWARD FLIGHT ATTENDANT ENTRY LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE CANNON PLUG. OPERATIONALLY CHECKED NORMAL, NO DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE. (M)SDR GRAA9603Strut · req'd servUPON TAKEOFF AT FAR, NLG WOULD NOT RETRACT. AIRCRAFT RETURNED TO FAR WITHOUT FURTHER INCIDENT. MX WAS NOTIFIED AND A FERRY PERMIT WAS GENERATED. THE AIRCRAFT DEPARTED TO MKE WITH THE GEAR DOWN AND PINNED. MX DISCOVERED THAT THE NLG TORQUE LINK SCISSORS WERSDR ORJA96004Battery · dischargedEMPENNAGE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY. OPS CHECKS GOOD. (X)SDR ORJA96003Battery · dischargedEMERGENCY CEILING LIGHTING IN 1ST CLASS INOP. REPLACED BATTERY PACK AND OPS CHECKED GOOD. (X)SDR ORJA96002Battery Pack · dischargedEMERGENCY LIGHTS IN EMPENNAGE INOP. REPLACED BATTERY PACK. (X)SDR GRAA9602Lamp · inoperativePILOT ENTERED IN LOG THAT THE CABIN EMERGENCY FLOOR TRACK LIGHT PULLED LOOSE. MAINTENANCE REPLACED THE LAMP AND LENS, P/N 079123. MAINTENANCE PERFORMED AN OPERATIONAL CHECK OF THE LIGHTING SYSTEM. OPERATIONAL CHECKED NORMAL. AIRCRAFT RETURNED TO SERVICE.
Back to Mcdonnell Douglas DC-9-87