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 AALA006021Battery Pack · inoperativeFLOOR LEVEL EMERGENCY LIGHT AT A/C RIGHT, ROWS 21-24 ARE ILLUMINATED AND WILL NOT EXTINGUISH. REPLACED EMERGENCY EXIT SIGN BATTERY PACK. OPS CHECK OK. (M)SDR AALA006022Coalescer Bags · contaminatedSMOKE IN CABIN WHEN APU AIR TURNED ON. REMOVED AND REPLACED LT AND RT WATER SEPARATOR COALESCER BAGS AND REMOVED, CLEANED AND INSTALLED LT AND RT SCUPPER DRAIN ASSY'S IAW MM 21-20-02. OPS CHECK OK. (X)SDR AALA006058Wire · looseOKC - EMERGENCY SEAT LIGHT AT ROW 23 INOPERATIVE. REWIRED WIRING AT SEAT IAW MD80 MM 33-51-11. SYSTEM OPS CHECK PERFORMED IAW 33-53-0. OPS CHECK SATISFACTORY. (M)SDR AALA006016Fuse · failedSJC - AFT EMPENNAGE A/C LEFT E-PATH BATTERY PACK INOPERATIVE. REPLACED FUSE IN E-PATH BATTERY PACK. OPS CHECK GOOD. (X)SDR GTIA000032Wire · exposedDTW - EMERGENCY TRACK LIGHT AS ROW 11 WIRE PULLED OUT. REPLACED LIGHT SOCKET ASSEMBLY IN EMERGENCY FLOOR TRACK LIGHTING AT ROW 11. FUNCTIONAL CHECK GOOD. REF MD80 MM 20-50-1 AND 33-50-00. (M)SDR AALA006013Wire · brokenRNO-CCI - EMERGENCY LEFT AT ROW 25 DEF INOPERATIVE. RESPLICED BROKE WIRE, OPS CHECK GOOD. (M)SDR AALA006014Slide · dislodgedLAS - FORWARD DOOR SLIDE PACK FELL OUT. INSPECTED AND REINSTALLED DOOR SLIDE ON LEFT FORWARD ENTRY DOOR. (M)SDR AALA006008Battery Pack · dischargedRNO - LT AFT OVERWING DOOR EMERGENCY LIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AS REQUIRED, OPS GOOD. (M)SDR AALA006007Light · inoperativeRNO - TWO UPPER TAIL SLIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED CHARGER (AFT RT LAV, AFT CHARGER), OPS CHECK GOOD. (M)SDR AALA006004Connector · damagedWHEEL NOT TURNING LIGHT ILLUMINATED VERY EARLY IN THE TAKEOFF ROLL. RETURNED TO GATE. FOUND AND REPAIRED BROKEN PIN ON TRANSDUCER CANNON PLUG (PIN A). SYSTEM OPS CHECK NORMAL IAW MM. (X)SDR AALA006002Slide · dislodgedNRO - FORWARD GALLEY DOOR SLIDE FELL OUT. CONTAINER HOLDING IT SOMETIMES WOULD NOT LATCH SHUT. RE-INSTALLED FORWARD GALLEY DOOR SLIDE. OPS CHECK GOOD. (X)SDR GTIA0000008Cover · missingDTW - FLT 378 - FROM CABIN LOG, SEAT 25D AISLE PATH LIGHT COVER MISSING. REINSTALLED PATH LIGHT COVER AT SEAT 25D IAW MM CHAPTER 33-00. OPS CHECK GOOD. (M)SDR GTIA9901237Light · looseDTW - FLT 378 - EMERGENCY FLOOR LIGHTING LOOSE NEAR FORWARD GALLEY. REPLACED AND RESECURED FLOOR TRACK LIGHTING NEAR FORWARD GALLEY AS REQUIRED. FUNCTIONAL CHECK GOOD. REF MD 80 MM 33-53-01.. (M)SDR GTIA9901233Light · inoperativeDTW - EMERGENCY FLOOR TRACK LIGHTING BETWEEN ROWS 25 NEEDS TO BE REPLACED. REMOVED AND REPLACED FLOOR TRACK LIGHT SOCKET. SYSTEM OPS CHECKS GOOD IAW MM 33-50-00. (M)SDR AALA996053Battery Pack · dischargedEMERGENCY LIGHTS ROW 23 THROUGH 26 ILLUMINATED DURING FLIGHT, COULD NOT TURN THEM OFF WITH ANY SWITCH POSITION. REMOVED AND REPLACED EMERGENCY POWER PACK FOR ROWS 23 THROUGH 26 AS REQUIRED, OPS CHECKED GOOD. (M)SDR AALA996052Connected · disconnectedSJC - FLT 11D EMERGENCY LIGHT OUT. RECONNECTED CANNON PLUG AT BULKHEAD. OPS CHECK GOOD. (M)SDR AALA996046Power Supply · failedRNO - EMERGENCY EXIT LIGHTS ON RIGHT SIDE BY EMERGENCY EXIT SIGNS OUT. REMOVED AND REPLACED EMERGENCY LIGHT PACK AT AFT RIGHT EXIT ROW. OPS CHECK GOOD. (M)SDR GTIA9900120Warning Light · illuminatedDTW - FLT 712 - LEFT REVERSER ACCUMULATOR LOW LIGHT CAME ON DURING CRUISE. COMPLIED WITH QRH AND LIGHT CAME BACK ON AFTER 45 MINUTES. PERFORM OPS CHECK ON THRUST REVERSER. PRE-CHANGE IS AT 1000 PSI. CLEANED CANNON PLUG ON SWITCH. OPS CHECKED GOOD, NO DEFESDR GTIA9901199Power Supply · inoperativeDTW - BOTH FORWARD OVERWING EMERGENCY EXITS LIGHTS INOPERATIVE. REPLACED EMERGENCY POWR SUPPLY, OPS CHECK GOOD PER MM 33-51-00. (M)SDR AALA996037Battery Pack · dischargedRNO - ROW 22-26 EMERGENCY LIGHTS INOPERATIVE. REPLACED LEFT AFT EXIT BATTERY PACK PER MM, OPS CHECK GOOD. (M)SDR AALA996019Battery Pack · dischargedRNO - EMERGENCY LIGHT IN EMPENNAGE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT PACK, OPS CHECK GOOD. (M)SDR AALA996015Power Supply · inoperativeRNO - O/H EMERGENCY LIGHTS OUT AT STATION 1113. REMOVED AND REPLACED POWER SUPPLY R5-27, OPS CHECK GOOD. ALL WORK DONE PER MM. (M)SDR AALA996014Battery Pack · dischargedSJC - EMPENNAGE 'E' PATH LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK, OPS CHECK GOOD. (M)SDR AALA6002Battery Pack · dischargedRNO - CHECK EMERGENCY AISLE BATTERY PACK. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT SEAT 20A DUE TO ROWS 15 THROUGH 18 INTERMITTENT, OPS CHECK GOOD AT THIS TIME. (X)SDR GTIA9901103Socket · damagedEMERGENCY FLOOR TRACK LIGHT BULB NEAR SEAT 3F INOPERATIVE AS WITH BARE WIRE SHOWING. FOUND BAD LIGHT SOCKET ASSEMBLY. REMOVED AND REPLACED SOCKET ASSEMBLY AS REQUIRED. OPERATION CHECK GOOD ON RAMP AT THIS TIME IAW MM 33-00-0. (X)SDR ORJA99253Battery Pack · dischargedRNO - EMERGENCY LIGHT BATTERY CHARGER BY AFT AIRSTAIR DOOR IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER 33-53-00. (M)SDR ORJA99252Fuel Control · out of adjustRNO - RETURN TO GATE ABORTED TAKEOFF AT ABOUT 30 KNOTS RIGHT ENGINE SLOW TO SPOOL. T/S PER 72-00-04 FIG 114, FOUND BOTH ENGINE IDLES LOW. RETRIM BOTH ENGINE PER 72-00-00. OPS CHECK NORMAL. (M)SDR ORJA99247Battery Pack · dischargedEMERGENCY LIGHTS RT SIDE ROW 9, 10, 11, 12 CAME ON. REMOVED AND REPLACED BATTERY PACK IN EMERGENCY ROW 20, OPS CHECK GOOD AT THIS TIME PER MM 33-00-00. (M)SDR ORJA99248Battery Pack · dischargedEMERGENCY LIGHTS FOR ROWS 9-15 CAME ON IN FLIGHT, EXTINGUISHED PRIOR TO LANDING, NO LONGER WORKING. REMOVED AND REPLACED BATTERIES FOR BATTERY PACK OF EMERGENCY EXIT LIGHT OF RT EMERGENCY EXIT IAW 35-00. OPS CHECK GOOD. (M)SDR GTIA9900999Bulb · failedA COUPLE OF LIGHTS OUT ON EMERGENCY FLOOR LIGHTING, ALSO NOTICED A FEW LENSES MISSING. INSTALLED NEW LENSE COVER AND BULBS, OPERATIONAL CHECK GOOD IAW MM REF 33-00. (M)SDR ORJA99218Power Pack · inoperativeE-LIGHTS INOPERABLE, ROWS 19-22. REMOVED AND REPLACED E-POWER PACK FOR ROWS 19-22. OPS CHECK GOOD. (X)SDR ORJA99217Power Supply · inoperativeEMERGENCY LIGHTS AT ROWS 27-29 ON IN-FLIGHT. REMOVED AND REPLACED EMERGENCY EXIT LIGHTS POWER SUPPLY AT LEFT EMERGENCY EXIT PER MM 25-50-04. OPS CHECK GOOD. (X)SDR ORJA99216Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS OUT IN AFT CABIN. CHANGED POWER SUPPLY 33-53-00. OPS CHECK NORMAL.SDR ORJA99230Power Supply · inoperableRNO - SEVERAL EMERGENCY LIGHTS OUT IN AFT CABIN. CHANGED POWER SUPPLY 33-53-00. OPS CHECK GOOD. (X)SDR AALA996059Battery Pack · inoperativeOKC - EMERGENCY LIGHTS INOPERATIVE AT ROW 27-29. REMOVED AND REPLACED BATTERY PACK FOR AFT CABIN DOOR EXIT ID. OPS CHECK GOOD IAW MD-80 MM 33-53-00. (M)SDR AALA996056Power Supply · failedOKC - THE FOLLOWING EMERGENCY LIGHTS ARE INOPERATIVE, ROWS 10-18, LT FORWARD OVERWING, RT FORWARD OVERWING, LT OVERHEAD VERTICAL STAIRS. REMOVED AND REPLACED OVERWING POWER SUPPLY IAW MD-80 MM 33-53-00. OPS CHECK GOOD IAW MD80 MM 33-53-00. (M)SDR ORJA99176Connector · failedAT SJC, EMERGENCY LIGHT AT ROW 9 INOPERATIVE. REPAIRED CONNECTION ON EMERGENCY LIGHT AT ROW 9. OPS CHECK GOOD AS PER MM 33-53-00. (M)SDR ORJA99158Battery Charger · inoperativeAT LAX, REAR ROW EMERGENCY LIGHTS CAME ON AND STAYED ON DURING FLIGHT. REMOVED AND REPLACED LEFT AFT EMERGENCY LIGHT BATTERY CHARGER PER MM 33-00-00. (M)SDR ORJA99168Battery Pack · dischargedAT LAX, EMERGENCY LIGHTS CAME ON DURING DESCENT AISLE ROW 15 THROUGH 18. REPLACED LEFT OVERWING BATTERY PACK ASSY. OPS CHECK NORMAL. (M)SDR ORJA99151Battery Pack · dischargedAT SJC, FIRST EMERGENCY EXIT LIGHTS ON. REMOVED AND REPLACED BATTERY PACK FROM FORWARD GALLEY. OPS CHECK GOOD AS PER 33-53-00. (M)SDR ORJA99150Battery Charger · failedAT RNO, EMERGENCY LIGHTS AT SEAT 8D INOPERATIVE, SEAT AND CEILING. RELAMPED CEILING LAMPS AND REPLACED FORWARD GALLEY EXIT EMERGENCY LIGHT CHARGER. OPS CHECK GOOD. (M)SDR ORJA99149Battery Pack · dischargedAT SJC, AT SEATS AT ROWS 1 THROUGH 9 EMERGENCY EXIT LIGHTS NOPERATIVE. REMOVED AND REPLACED EMERGENCY PACK, LOCATED IN FORWARD GALLEY AS PER MM 33-24-00. OPS CHECK GOOD. (M)SDR GTIA9900576Light · inoperativeLGA - TAIL COMPARTMENT OVERHEAD EMERGENCY LIGHT AT STATION 1408. BROKEN AND INOPERATIVE AT BULB HOLDER BASE. REPLACED BROKEN BULB HOLDER BASE OF LIGHT L2-637 IAW MM 33-53-00. LIGHT OPERATION CHECK OK. (M)SDR GTIA9900574Light · inoperativeLGA - L1 EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY WITH REPAIRED ASSEMBLY PER MM 33-50-00. OPERATION CHECK OK. (M)SDR ORJA99146Battery Pack · dischargedAT SJC, EMERGENCY LIGHT AT ROWS 1 THROUGH 5, RIGHT SIDE, ILLUMINATED WILL NOT TURN OFF. REMOVED AND REPLACED FORWARD BATTERY PACK PER MM 33-53-00. OPS CHECK NORMAL. (M)SDR ORJA99145Wire · failedAT SJC, EMERGENCY LIGHTS AT ROWS 1 THROUGH 5 ARE ON, WILL NOT TURN OFF. TROUBLESHOT EMERGENCY EXIT LIGHTING SYSTEM FORWARD GALLEY. RIGHT LIGHT WIRING TO SEATS AT ROW 8 DEF, GROUNDING OUT ON SEAT TRACK AND AIR GRILL. REPAIRED WIRING IAW 20-50-01 MM. OPS CHESDR ORJA99144Battery Pack · dischargedAT SJC, EMERGENCY LIGHTS AT ROWS 1, 2, 3, 8, RIGHT SIDE ONLY, ILLUMINATED DURING FLIGHT. REMOVED AND REPLACED FORWARD BATTERY PACK NEXT TO FORWARD GALLEY DOOR. OPS CHECK NORMAL PER MM 33-53-00. (M)SDR ORJA99138Air Distr · smokeAT LAX, CABIN FILLED WITH OIL SMOKE AFTER TAKEOFF, TURNED OFF BOTH PACKS AT 5000 FT, OPENED OUTFLOW VALVE. SMOKE SUBSIDED, LANDED AT LAX. REPLACED SET OF COALESCER BAGS, CLEANED WATER SEPARATORS AND PEFORMED BURNOUT OF HIGH PRESSURE PNEUMATIC DUCTING AS OUTLSDR ORJA99143Fuse · failedAT PDX, FIRST ROWS 1 THROUGH 9, AIRCRAFT RIGHT, EMERGENCY LIGHTS CAME ON IN 'ARM' AND 'OFF' POSITION OF SWITCH. REMOVED AND REPLACED FUSE AT RIGHT EMERGENCY LIGHTS. OPS CHECK NORMAL PER BRUCE INDUSTRIES MM 400-883 AND MM 33-0. (M)SDR ORJA99137Battery Pack · dischargedAT LAX, EMERGENCY ROW LIGHTS, AIRCRAFT RIGHT, ROWS 1 THROUGH 9, ARE ON WITH SWITCH IN ARM AND OFF. REPLACED BATTERY PACK LIGHT ASSEMBLY, CHECKS NORMAL. (M)
Back to Mcdonnell Douglas DC-9-87