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 ORJA98310Charger · failedAT LAS, FLIGHT ATTENDANT REPORTED THAT EMERGENCY EXIT LIGHTS AT ROWS 20 AND 21 CAME ON IN FLIGHT AND COULD NOT BE TURNED OFF. REPLACED BATTERY CHARGER AT RIGHT AFT O/W EXIT. OPS CHECK GOOD. (M)SDR ORJA98321Battery Pack · dischargedAT RENO, CABIN EVACUATION LIGHTS AT ROWS 19-22 ILLUMINATED DURING FLIGHT. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT RIGHT AFT OVERWING DOOR. ALSO, CHECKED POWER TO BATTERY PACK, POWER OK. REPAIRED WIRES AT ROWS 21 AND 22. EMERGENCY LIGHT SYSTEM OPS CHSDR ORJA98294Battery Pack · dischargedAT LAS, RED EMERGENCY LIGHTS WILL NOT EXTINGUISH AT 19D, 20D AND 21D. INSTALLED NEW BATTERY PACK ON FORWARD RIGHT OVERWING EXIT. OPS CHECK NORMAL. (M)SDR ORJA98293Actuator · malfunctionedAT SEATTLE, GATE RETURN, FLAPS DROPPED TO ABOUT 20 DEGREES WHILE AT GATES, AFTER ENGINE START WITH HYD AUS AND TRANS FOR PUMP ON AND ENGINE PUMPS BOTH ON HIGH, FLAPS WOULD NOT MOVE (STILL 20-25 DEGREES) WITH FLAP HANDLE UP/RET. AFTER SEVERAL ATTEMPTS (10 TO 2SDR ORJA98290Battery Pack · dischargedAT SJC, EMERGENCY LIGHTS INOPERABLE AT ROWS 19-22. REMOVED AND REPLACED BATTERY PACK, OPS CHECK GOOD. (M)SDR 99ZZZM17Valve · malfunctionedAT SEATTLE, GATE RETURN, FLAPS DROPPED TO ABOUT 20 DEGREES WHILE AT GATES, AFTER ENGINE START WITH HYD AUS AND TRANS FOR PUMP ON AND ENGINE PUMPS BOTH ON HIGH, FLAPS WOULD NOT MOVE (STILL 20-25 DEGREES) WITH FLAP HANDLE UP/RET. AFTER SEVERAL ATTEMPTS (10 TO 2SDR ORJA98289Battery Pack · dischargedAT LAS, TRACK LIGHTS WILL NOT EXTINGUISH AT 19D, 20D AND 21D. REMOVED AND REPLACED BATTERY PACK AT ROW 20. ALL EMERGENCY TRACK LIGHTS, OPS CHECK NORMAL. (M)SDR ORJA98283Relay · failed'DC BUS OFF' ANNUNCIATION ON APPLICATION OF TAKEOFF POWER SETTING ABORTED TAKEOFF AT SLOW SPEED (APPROX 20 KNOTS). RETURNED TO GATE. REPLACED EMERGENCY POWER DC TRAN RELAY (R2-326). GROUND CHECK NORMAL. (M)SDR ORJA98279Relay · failedAT SAN DIEGO, 'DC BUS OFF' ANNUNCIATION ON APPLICATION OF TAKEOFF POWER SETTING. ABORTED TAKEOFF AT LOW SPEED, APPROX 20 KTS. RETURNED TO GATE. REPLACED EMERGENCY POWER DC TRANS RELAY (R2-326). GROUND CHECK NORMAL. (M)SDR ORJA98278Battery Pack · dischargedEMERGENCY LIGHTS INOPERABLE AT ROW 23-26, OCCURING AT RENO. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK. OPS CHECK GOOD. (M)SDR ORJA98270Battery · dischargedAT SJC, REAR TAIL EMERGENCY LIGHT NO OPERATING. REPLACED BATTERIES AND ONE POWER PACK. EMERGENCY EXIT LIGHTS, TAIL STAIRWAY. REPAIRED ONE LIGHT HANGING LOOSE. OPS CHECK OK. (M)SDR ORJA98269Battery Pack · dischargedAT SJU, EMERGENCY LIGHTS ON ROWS 19, 20, 21, 22 FOUND INOPERATIVE. FOUND PACK TO BE BAD. REMOVED AND REPLACED WITH NEW PACK, ROW DEF. OPS CHECKS GOOD. (M)SDR 98ZZZM942Power Pack · inoperativeAT SJC, REAR TAIL EMERGENCY LIGHT NO OPERATING. REPLACED BATTERIES AND ONE POWER PACK. EMERGENCY EXIT LIGHTS, TAIL STAIRWAY. REPAIRED ONE LIGHT HANGING LOOSE. OPS CHECK OK. (M)SDR ORJA98256Battery · dischargedAT LAS VEGAS, RIGHT OVERWING EMERGENCY LIGHTS CAME ON DURING DESCENT AND WOULD NOT GO OUT. REPLACED RIGHT OVERWING EXIT EMERENCY LIGHTS BATTERIES WITH NEW. OPS CHECK NORMAL. (M)SDR ORJA98217Power Supply · inoperativeAT SJC, EMERGENCY EXIT LIGHTS AT ROWS 23-26 CAME ON, COULD NOT EXTINGUISH. INSTALLED NEW BATTERY ASSEMBLY. OPS CHECK GOOD AT ROWS 23-26. (M)SDR ORJA98200Battery Charger · failedAT SJC, FLOOR EMERGENCY EGRESS LIGHTS ILLUMINATED WITH SWITCH IN ARMED POSITION AT SEATS, 19, 20, 21 AND 22. REPLACED BATTERY CHARGER AND BATTERY PACK AT ROWS 19, 20, 21 AND 22. (M)SDR ORJA98199Indicator · failedAT SJC, TAKEOFF WAS DISCONTINUED AS NR 2 ENGINE EPR INDICATION NEVER GOT ABOVE 1.3, APPROXIMATELY. REMOVED AND REPLACED NR 2 ENGINE EPR GAUGE AND PERFORMED ENGINE RUN IAW MM 71-00-00. OPS CHECKED GOOD. (M)SDR ORJA98187Battery Pack · dischargedSJC - EMERGENCY LIGHTS AT ROW 21 ILLUMINATE AT ALL TIMES. REMOVED BATTERY PACK RIGHT AFT EMERGENCY DOOR, OPS CHECK NORMAL. (M)SDR ORJA98185Charger · failedEMERGENCY FLOOR PATH, ROWS 19-21, AIRCRAFT RIGHT, CAME ON IN FLIGHT. STAYED ON 30 MINUTES AND WENT OUT. LIGHTS DO NOT TEST ON GROUND AT ORD. REPLACED BATTERY/CHARGER PACK FOR EMERGENCY FLOOR PATH LIGHTS AT RENO 21, SEAT F IAW BRUCE INDUSTRIES MM400-079. OPSDR ORJA98184Battery Pack · dischargedAT SJC, EMERGENCY LIGHTS INOPERATIVE, ROWS 20-23. REMOVED AND REPLACED R/A AG BATTERY PACK/CHARGER. OPS CHECK GOOD. (M)SDR ORJA98163Battery · dischargedEMERGENCY EXIT LIGHTS INOPERABLE AT ROWS 9-14 AND 21-25. REMOVED AND REPLACED EMERGENCY BATTERIES. OPS CHECK OK. (M)SDR ORJA98159Batteries · dischargedLAST THREE ROWS AND AFT DOOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERIES IN CHARGER. OPS CHECK GOOD. (M)SDR ORJA98167Light · inoperableROW 9 EMERGENCY FLOOR TRACK LIGHT INOPERABLE. REPAIRED BROKEN WIRES. OPS CHECK GOOD. (M)SDR ORJA98124Light · inoperableROA 20B EMERGENCY RED LIGHT INOP. FOUND LOOSE WIRE AT 20B EMERGENCY LIGHT. OPS CHECKED GOOD. (M)SDR ORJA98114Wire · failedEMERGENCY LIGHTS AT 10W 20D INOPERATIVE. RE-INSTALLED WIRE INTO CONNECTOR. OPS CHECK GOOD. (X)SDR ORJA98109Battery · dischargedEMERGENCY EXIT LIGHTS AT ROWS 11, 12, 13 - STAY ON. REPLACED BATTERY PACK FOR ROWS 11, 12, AND 13. OPS CHECK GOOD. (X)SDR ORJA98102Battery Pack · dischargedEMERGENCY LIGHTS IN ROWS 15-18 REMAIN ON WHEN EMERGENCY LIGHT SWITCH IS SELECTED TO OFF. REPLACED BATTERIES IN BATTERY PACK FOR ROW 15-18. OPS CHECK NORMAL. (M)SDR ORJA9898Battery Pack · dischargedTAILCONE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED VENTRAL STAIR BATTERY PACK. OPS CHECK GOOD. (M)SDR ORJA9892Wire · brokenEMERGENCY EXIT LIGHT OUT AT ROW 11 SEAT D. REPAIRED BROKEN WIRES ON LIGHT. OPS CHECK GOOD. (M)SDR ORJA98113Connector · failedSEAT 26D (AISLE SEAT) EMERGENCY LIGHT INOPERATIVE. REPAIRED CONNECTOR ON BOTTOM OF SEAT. (X)SDR ORJA9880Wire · brokenEMERGENCY LIGHT OUT AT SEAT 23D. REPAIRED BROKEN WIRE AT SEAT 23D. OPS CHECK GOOD. (M)SDR ORJA9870Wire · failedEMERGENCY LIGHT AT ROW 14 INOP. REPINNED BROKEN WIRE AT CONNECTOR. OPS NOW OK. (M)SDR ORJA9866Wire · failedEMERGENCY LIGHT INOP AT ROW 9 DEF AND 19 DEF. REPAIRED WIRING. OPS CHECK GOOD. (M)SDR ORJA9858Battery Pack · dischargedPRE-FLIGHT RNO, LEFT FORWARD OVERWING EMERGENCY EXIT LIGHTS INOP. REPLACED LEFT FORWARD OVERWING BATTERY PACK ASSY, OPS CHECK OK. (M)SDR ORJA9855Battery Pack · dischargedRETURNED TO GATE DURING PUSH BACK EMERGENCY LIGHTING AT ROWS 16, 17, 18, 19 CAME ON COULD NOT BE EXTINGUISHED ALSO EMERGENCY EXIT LIGHT AT ROW 20 A/C LEFT CAME ON AND COULD NOT BE EXTINGUISHED. REPLACED LEFT FORWARD EMERGENCY EXIT SIGN BATTERY PACK ASSY AND RSDR ORJA9854Battery Pack · dischargedOVERWING FORWARD LEFT EMERGENCY FLOOR LIGHTS POWER SUPPLY WON'T SHUT OFF EMERGENCY LIGHTS REMAIN ON UNTIL BATTERY EXHAUSTION. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK, OPS CHECK GOOD AT THIS TIME. (M)SDR ORJA9843Battery Charger · inoperativeROWS 15-18 AIRCRAFT RIGHT EMERGENCY LIGHTS STAY ON IN ARMED POSITION 18, REST OF THE SYSTEM WORKS NORMALLY. REMOVED AND REPLACED BATTERY CHARGER AT SEAT 18A, SYSTEM OPS CHECK NORMAL. (M)SDR ORJA9838Apu · inoperativeAT PUSH BACK, FOUND APU TO BE INOP RETURNED TO GATE, REF DMI NR 13018. (M)SDR ORJA9837Wire · disconnectedEMERGENCY LIGHTS AT SEAT 9DEF WILL NOT ILLUMINATE. RECONNECTED BROKEN WIRE, OPS CHECK OK. (M)SDR ORJA9833Power Supply · inoperativeOVERWING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED OVERWING EMERGENCY LIGHTS POWER SUPPLY. OPS CEHCK GOOD PER MM. (M)SDR ORJA9840Compressor · stalledLEFT ENGINE COMPRESSOR STALLED DURING TAKEOFF RUN SUSPECT ICE INGESTION DUE TO SEVERE WINTER CONDITIONS. INSPECTED NR 1 ENGINE INLET FAN AND EXHAUST AREAS, NO DAMAGED NOTED RAN NR 1 ENGINE TO TAKEOFF POWER AND PERFORMED ACCELERATION AND POWER ASSURANCE RUN NRSDR ORJA9832Tranducer Pins · backed outON TAKEOFF ROLL, APPROX 60 KNOTS WHEEL NOT TURNING LIGHT ILLUMINATED AFTER RETURNING TO TAXI SPEED THE LIGHT WENT OUT. REMOVED NR 1 WHEEL HUB CAP FOUND TRANSDUCER PINS BACKED OUT. REPLACED PINS BIT CHECK NORMAL OF ANTI-SKID CONTROLLER. (M)SDR ORJA9825Charger · failedEMERGENCY ESCAPE PATH LIGHTS IN ROWS 19, 20, 21, AND 22 ILLUMINATED WOULD NOT SHUT OFF UNTIL BATTERY PACK WAS DISCHARGED. INSTALLED NEW EMERGENCY PATH LIGHT BATTERY PACK CHARGER ROWS 19-22. OPS CHECK NORMAL IAW MM 33-00-00. (M)SDR ORJA97222Wire · brokenEMERGENCY LIGHT AT SEAT 10 OUT. REPAIRED BROKEN WIRE ON EMERGENCY LIGHT, OPS CHECK GOOD. (M)SDR ORJA97211Wire · disconnectedEMERGENCY LIGHT ROW 10 INOP. RECONNECTED WIRE UNDER SEAT 10F, OPS CHECK GOOD. (M)SDR ORJA97206Battery Pack · dischargedEMERGENCY LIGHT OUT IN ROW 14-18. REPLACED FUSE IN BATTERY PACK, OPS CHECK GOOD. (M)SDR ORJA97202Light · inoperativeRIGHT FORWARD EMERGENCY EXIT LIGHT INOP. REPLACED RIGHT FORWARD EMERGENCY LIGHT ASSEMBLY. OPS CHECK NORMAL. (M)SDR ORJA97188Pt2 Line · leakingAIR TURN BACK DUE TO NR 2 ENGINE NOT PRODUCING NORMAL CLIMB POWER. LARGE SPLIT IN EPR WITH ALL OTHER INDICATIONS NORMAL. FOUND PT2 FLEX LINE FROM APRON TO BULKHEAD WITH INTERNAL LEAK. MAINTENANCE REQUEST FOR CHECK FLIGHT TO FL330 TO VERIFY FIX OF CHRONIC PRSDR ORJA97186Transmitter · failedEPR SPLIT AT ALTITUDE AS CLIMB CONTINUED, LT EPR CLIMBED OFF SCALE. REMOVED AND REPLACED PT2 LINE IN PYLON. LEAK CHECK, OPS CHECK GOOD. REMOVED AND REPLACED NR 1 EPR TRANSMITTER AS PRECAUTION. TESTED GOOD PER MM 77-11-01. AIRCRAFT RETURNED TO SERVICE. (MSDR ORJA9810Doubler · corrodedLEVEL 2 CORROSION, FOUND ON INTERNAL SKIN DOUBLER AND SHEAR TIE AT STATION 1030 BETWEEN L30 AND L29R. FABRICATED AND INSTALLED INTERNAL DOUBLER IAW DC-9 SRM 53-04 FIG 38. (M)
Back to Mcdonnell Douglas DC-9-87