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 ORJA99136Battery Pack · dischargedAT SJC, FORWARD GALLEY EMERGENCY EXIT BATTERY PACK INOPERABLE. REMOVED AND REPLACED GALLEY EMERGENCY EXIT BATTERY PACK IAW 33-21-00. OPS CHECK GOOD. (M)SDR ORJA99139Light · inoperableAT SJC, EMERGENCY LIGHTING LAST ROW FLOOR LAMP INOPERABLE. REPAIRED EMERGENCY LIGHTING AT LAST ROW SEAT LIGHT IAW MM 20-50-04. OPS CHECK GOOD. (M)SDR ORJA99135Battery · dischargedAT SJC, FORWARD SECTION OF EMERGENCY LIGHTS CAME ON DURING FLIGHT. REMOVED AND REPLACED FORWARD BATTERY AT EMERGENCY LIGHT MODULE IAW MM 33-53-00. OPS CHECK GOOD. (M)SDR ORJA99133Power Pack · inoperativeAT SJC, EMERGENCY SEAT LIGHTING IS OFF AT 18 DEF. REMOVED AND REPLACED POWER SUPPLY ASSEMBLY IAW MM 33, OPS CHECK GOOD. (M)SDR ORJA99130Power Supply · inoperativeAT SJC, EMERGENCY SEAT LIGHTING IS OFF AT 18 DEF. REMOVED AND REPLACED POWER SUPPLY ASSEMBLY IAW MM 33. OPS CHECK GOOD. (M)SDR ORJA99116Tail Pipe · fireAT SJC, MAINTENANCE ASKED FLIGHT 101 TO RETURN TO GATE AFTER OBSERVING ABNORMAL START. ENGINE START PARAMETERS DID APPEAR WITHIN NORMAL LIMITS. UPON TAXI OUT SAW EVIDENCE OF A TIAL PIPE FIRE. PERFORMED INSPECTION OF ENGINE PER MM, CHAP 72-00-00, PAGE 813. SDR ORJA99107Battery Pack · inoperativeAT LAX, EMERGENCY EXI TLIGHTS ON AT ROWS 25, 26, 27, 28. REPLACED BATTERY PACK WITH SPARE IN AFT STAIRWELL. OPS CHECK OK. (M)SDR ORJA99127Battery Charger · inoperativeAT LAX, EMERGENCY LIGHTS AT ROWS 19-26 OUT. REMOVED AND REPLACED 3 BATTERY CHARGERS AT 21A, 20A AND 21F. SYSTEM OPS CHECK GOOD. (M)SDR ORJA99106Battery Charger · inoperativeAT LAX, EMERGENCY LIGHTS AT ROWS 19-26 OUT. REMOVED AND REPLACED 3 EACH, BATTERY CHARGERS AT 21A, 20A AND 21F. SYSTEM OPS CHECK GOOD. (M)SDR ORJA99105Battery Pack · dischargedAT LAX, EMERGENCY LIGHTS REMAIN ON AT ROWS 23-26. CAME ON AT 10,000 IN DESCENT. REMOVED AND REPLACED LEFT BATTERY PACK. SYSTEM OPS CHECK GOOD. (M)SDR ORJA99100Battery Pack · dischargedAT RNO, INFLIGHT EMERGENCY LIGHTS CAME ON AT ROWS 22-26. REPLACED LEFT AFT O/W EXIT SIGN BATTERY PACK ASSY. OPS CHECK OK. (M)SDR ORJA9999Wire · brokenAT SJC, EMERGENCY LIGHT AT ROW 14 INOPERABLE. REPAIRED WIRING AT TWO PLACES. OPS CHECK GOOD. (M)SDR ORJA9998Battery Pack · dischargedAT SJC, EMERGENCY TRACK LIGHTING FORWARD PART OF CABIN CAME ON IN FLIGHT. COULD NOT BE TURNED OFF. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IN FORWARD GALLEY. OPS CHECK GOOD. DONE IAW 33-50 MM. (M)SDR ORJA9997Wire · brokenAT SJC, SEAT MOUNTED 'E' PATH LIGHT WIRE BROKEN AT SIDEWALL CONNECTOR AT 24 DEF. REPAIRED WIRE AT SEAT 24 DEF 'E' PATH CONNECTOR LIGHT. OPS CHECKS GOOD. (M)SDR ORJA9984Switch · out of adjustAT LAS, GATE RETURN, WHEN THROTTLES ADVACED FOR TAKEOFF, FORWARD CARGO COMPARTMENT DOOR LIGHT CAME ON. TAKEOFF DISCONTINUED AT LOW SPEED. LIGHT WENT OUT DURING TAXI IN. ADJUSTED FORWARD CARGO DOOR SWITCH. OPS CHECK OK. (M)SDR ORJA9987Wire · failedAT SJC, EMERGENCY LIGHT OUT AT SEAT 1, ROW 29. REWIRED EMERGENCY LIGHT. OPS CHECK GOOD. (M)SDR ORJA9985Wire · brokenAT SJC, EMERGENCY LIGHT AT SEAT ON ROW 1 INOPERABLE. FIXED BROKEN WIRE AT SEAT ON ROW 1 EMERGENCY LIGHT. OPS CHECK GOOD. (M)SDR ORJA9986Battery Pack · dischargedAT BUR, EMERGENCY AISLE LIGHT ON ROWS 1-9 WILL NOT GO OUT. REMOVED AND REPLACED BATTERY PACK. OPS CHECK NORMAL. (M)SDR ORJA9982Battery Pack · dischargedAT BUR, EMERGENCY AISLE LIGHTS ON ROWS 1-9 WILL NOT GO OUT. REMOVED AND REPLACED BATTERY PACK. OPS CHECK NORMAL. (M)SDR ORJA9977Wire · brokenAT RNO, EMERGENCY LIGHTS INOPERABLE AT SEATS 28 AND 29 D-F. REWIRED CONNECTIONS. OPS CHECK GOOD. (M)SDR ORJA9981Battery Pack · dischargedAT SJC, FORWARD GALLEY EMERGENCY LIGHT FOR EXIT INOPERABLE. REMOVED AND REPLACED EMERGENCY EXIT BATTERY PACK FROM FORWARD GALLEY. OPS CHECKS NORMAL. (M)SDR ORJA9976Battery Pack · dischargedAT SJC, EMERGENCY LIGHTS INOPERABLE AT ROWS 19 TO 22. REPAIRED CHAFED WIRINGS. REMOVED AND REPLACED BATTERY PACK. OPS CHECK GOOD. (M)SDR ORJA9975Batteries · dischargedAT RNO, SEVERAL CABIN EMERGENCY LIGHTS INOPERABLE. REMOVED AND REPLACED BATTERIES. OPS CHECK GOOD. (M)SDR ORJA9960Charger · inoperativeAT SJC, ROWS 17-20 ESCAPE LIGHTS ARE INOPERABLE. FOUND AND REPAIRED SHORTED WIRE ON SEAT 19. INSTALLED NEW CHARGER. OPS CHECK GOOD. (M)SDR ORJA99104Battery Charger · inoperativeAT SJC, ROWS 17-20 ESCAPE LIGHTS INOPERABLE. FOUND AND REPAIRED SHORTED WIRE ON SEAT 19. INSTALLED NEW CHARGER. OPS CHECKS GOOD. (M)SDR ORJA9959Wire · looseFLIGHT ATTENDANT REPORTS EXPOSED WIRING ALONG SIDEWALL AT ROW 14. SECURED WIRING AT ROW 14 DEF. EMERGENCY SEAT WIRING. OK FOR CONTINUED SERVICE. (M)SDR ORJA9958Battery Pack · dischargedAT SJC, FORWARD EXIT BATTERY PACK (EMERGENCY) IS BAD. REMOVED AND REPLACED EMERGENCY BATTERY PACK. OPS CHECK GOOD. (M)SDR ORJA9957Light · inoperativeAT SJC, EMERGENCY LIGHT AT ROW 16 INOPERABLE. REMOVED AND REPLACED LIGHT ASSEMBLY. OPS CHECK GOOD. (M)SDR ORJA9937Wire · brokenSJC - BROKEN WIRE TO EMERGENCY LIGHTS AT SEAT 12F. REPAIRED BROKEN WIRE AT SEAT 12F. OPS CHECK GOOD. (X)SDR ORJA9936Wire · damagedSJC - FOUND BARE WIRE FOR EMERGENCY LIGHTS. REPAIRED AND SECURED WIRES AT ROW 12 DEF. (X)SDR ORJA9924Battery Pack · dischargedAT SJC, AFT OVERWING EXIT LIGHTS WOULD NOT GO OFF. REMOVED AND REPLACED RIGHT AFT OVERWING EXIT BATTERY PACK. OPS CHECKS GOOD. (M)SDR ORJA9962Sign · failedAT PHX, LEFT DIVIDER WALL (EXTERNAL), FIRST CLASS AND COACH EMERGENCY EXIT SIGN FAILED LUMINOSITY CHECK. REMOVED AND REPLACED LEFT DIVIDER WALL AT FIRST CLASS AND COACH EMERGENCY EXIT SIGN PER MM 11-00-01. SIGN REPLACED AND RETESTED, INSPECTION APPROVED. (MSDR ORJA9920Battery Pack · dischargedAT PHOENIX, FLOOR PROXIMITY LIGHTING IS OUT FROM SECTINOS 9-26, IN NEED OF TROUBLESHOOTING AND REPAIR. REMOVED AND REPLACED BATTERIES IN BATTERY PACKS. ALL SEAT LIGHTING WORKS WELL AS PER MM 33-53-00. (M)SDR ORJA9944Slide · failedAT PHX, R-1 DOOR EMERGENCY SLIDE FAILS. SLIDE LIGHT BATTERY OK PER MM 25-62-05. REPLACED EMERGENCY SLIDE ASSY WITH SERVICEABLE SLIDE ASSY. (X)SDR ORJA9969Battery Pack · dischargedAT SJC, TAIL CONE LIGHTS (ESCAPE) INOPERABLE. RELAMPED BATTERY PACK EMERGENCY ESCAPE LIGHTS. OPS CHECK GOOD. (M)SDR ORJA9930Battery Pack · dischargedAT PHOENIX, ROWS 15 THROUGH 18 EMERGENCY SEAT LIGHT INOPERABLE. TROUBLESHOT SYSTEM, FOUND LOW VOLTAGE ON BATTERY PACK AND CHARGED SYSTEM USING A/C POWER PER MM 33-53-00. SYSTEM OPERATIONS CHECK GOOD PER MM 33-53-00. (X)SDR ORJA9929Battery Pack · dischargedAT PHOENIX ON ROWS 1 THROUGH 9, EMERGENCY SEAT LIGHTING IS INOPERABLE. TROUBLESHOT SYSTEM, FOUND LOW VOLTAGE ON EMERGENCY BATTERY PACK. CHARGED SYSTEM PER MM 33-53-00. OPS CHECKS GOOD PER MM 33-53-00. (X)SDR ORJA9928Battery Pack · dischargedAT PHOENIX, R-1 DOOR EMERGENCY EXIT IDENTIFIER INOPERABLE. TROUBLESHOT SYSTEM, FOUND LOW VOLTAGE ON EMERGENCY BATTERY PACK. CHARGED SYSTEM PER MM 33-53-00. OPS CHECKS GOOD PER MM 33-53-00. (X)SDR ORJA9919Battery Pack · dischargedAT PHOENIX, AT ROWS 15 THROUGH 18 EMERGENCY SEAT LIGHTING WAS INOPERABLE, NEEDED TROUBLESHOOTING AND REPAIRING. TROUBLESHOT SYSTEM, FOUND LOW VOLTAGE ON BATTERY PACKS. CHARGED SYSTEM, USING A/C POWER PER MM 33-53-00. SYSTEM OPS CHECKED GOOD PER MM 33-53-00.SDR ORJA9918Battery Pack · dischargedAT PHOENIX IN ROWS 1 THROUGH 9 EMERGENCY LIGHTING WAS INOPERABLE, NEEDS TROUBLESHOT AND REPAIRED. TROUBLESHOT SYSTEM, FOUND LOW VOLTAGE ON EMERGENCY BATTERY PACK. CHARGED SYSTEM PER MM 33-53-00. OPS CHECK GOOD PER MM 33-53-00. (M)SDR ORJA9914Light · inoperativeAT SJC, EMERGENCY LIGHT INOPERABLE AT ROW 2. REPLACED EMERGENCY LIGHT CABLE ASSEMBLY AT 2 DF. OPS CHECKS GOOD. (M)SDR ORJA9912Battery Pack · dischargedAT SEA, EMERGENCY LIGHTS WERE ON AT ROW 21 DEF. REPLACED BATTERY PACK AT 21D. OPS NORMAL. BAD BATTERY PACKS IN E/E. (M)SDR ORJA9927Frame · corrodedAT PHOENIX LEVEL 2 CORROSION ON CAP OF FRAME AT FS 1062 IN AFT BAGGAGE PIT ABOVE S30. REMOVED CORRODED CAP. FABRICATED REPLACEMENT, TREATED AND PRIMED BARE METAL SURFACES. INSTALLED CAP IAW SRM REF 51-30-2. VERIFIED NO FURTHER CORROSION. (M)SDR ORJA9926Angle · corrodedAT PHOENIX LEVEL 2 CORROSION, LOWER CHORD ANGLE, STATION 1002, HAS CORROSION BEYOND LIMITS. REMOVED LOWER CHORD ANGLE 24542 1002. REMOVED TRACK SUPPORT ANGLES FOM. INSTALLED SPLICE, P/N 3936445-1 PO NR X9S454606. TRACK SUPPORT ANGLES TO BE INSTALLED ON WO SDR ORJA9907Battery Pack · dischargedAT SJC, EMERGENCY LIGHTS AT ROWS 19, 20, 21, 22 INOPERABLE. REMOVED AND REPLACED BATTERY PACK ON RIGHT EXIT SIGN. (M)SDR ORJA9904Engine · malfunctionedAT LAS ON TAKEOFF FROM LAS, RIGHT ENGINE WOULD NOT PRODUCE TAKEOFF POWER. COULD ONLY GET 1.6 EPR. ABORTED TAKEOFF. RETURNED TO GATE. INSPECTED NR 2 ENGINE INLETS AND EXHAUST, NO DEFECTS NOTED. INSPECTED AND CLEANED MOISTURE TRAPS. PERFORMED PER MM 71-00-SDR ORJA9901Battery · dischargedAT RENO, OVERHEAD EMERGENCY LIGHTS INOPERABLE FROM ROW 16 TO ROW 20. REMOVED AND REPLACED BATTERIES. (M)SDR ORJA98330Battery · dischargedAT RENO, EMERGENCY EXIT LIGHT INSIDE TAIL SECTION INOPERATIVE. REMOVED AND REPLACED BATTERY. OPS CHECK GOOD. (M)SDR ORJA98325Switches · contaminatedIN LAS - TAKEOFF DISCONTINUED FOR SPOILER DEPLOYED ANNUNCIATOR. THROTTLES WERE ADVANCED BUT TAKEOFF POWER NOT REACHED, SPEED APPROXIMATELY 20 KTS. CLEANED THROTTLE BANK SWITCHES SPOILER LIGHT SYSTEM. OPS CHECK OK. (M)SDR ORJA98326Harness · failedIN SJC, EMERGENCY LIGHTING ON SEAT 23 DEF INOPERATIVE. REMOVED AND REPLACED WIRING HARNESS, OPS CHECK OK. (M)
Back to Mcdonnell Douglas DC-9-87