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 AALA20140419003Cover · missingFORWARD OVERWING EMERGENCY LIGHT BATTERY PACK MISSING TOP COVER. REPLACED FWD OVERWING EMERGENCY LIGHT BATTERY PACK, OPERATIONS CHECKED NORMAL.SDR AALA20140416008Trim Motor · inoperativeORD CREW REPORTED RUNAWAY STAB TRIM FULL NOSE DOWN. EMERGENCY DECLARED FLIGHT LANDED ORD WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED PRIMARY STAB TRIM MOTOR. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20140415016Connector · faultyABI INFLIGHT SJD - DFW. CREW REPORTED RAPID DEPRESSURIZATION DUE TO LOSS OF AUTO PRESS CONTROLLERS. EMERGENCY DECLARED FLIGHT DIVERTED ABI & LANDED WITHOUT INCIDENT. PLACARDED AUTO PRESS CONTROLLERS IAW MEL 21-23B. FLIGHT CONTINUED TO DESTINATION. REPLACESDR AALA20140417007Former · crackedRIGHT WING LE NR 4 SLAT TRACK INBD FORMED IS CRACKED. INSTALLED RT WING NR 4 INBD FORMER DOUBLER IAW WORK CARD 57-98-06 & EA MD80-57-034432.SDR AALA20140417006Former · crackedLEFT WING LE NR 4 SLAT TRACK INBD FORMER IS CRACKED. INSTALLED LT WING NR 4 INBD FORMER DOUBLER IAW WORK CARD 57-98-05 & EA MD80-57-034432.SDR AALA20140410004Battery Pack · dischargedEMERGENCY EVACUATION LIGHTS IN TAIL COMPARTMENT SECTION FAILED TEST. REPLACED BATTERY PACK FOR EMERGENCY EVACUATION LIGHTS IN TAIL COMPARTMENT, OPERATIONS CHECKED NORMAL.SDR AALA20140410003Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 27 TO 30 FAILED TEST. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FORM ROWS 27 TO 30, OPERATIONS CHECKED NORMAL.SDR AALA20140410002Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 11 TO 17 FAILED TEST. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 11 TO 17, OPERATIONS CHECKED NORMAL.SDR AALA20140410001Battery Pack · dischargedEMERGENCY EGRESS LIGHT BATTERY PACK AB5 - 4 INOPERATIVE. REPLACED BATTERY PACK AB5 - 4, OPERATIONS CHECKED NORMAL.SDR AALA20140409002Battery Pack · dischargedLOWEST TAIL CONE SLIDE EMERGENCY LIGHT INOPERATIVE. R & R BATTERY PACK AT STATION 1322 RT, OPERATIONS CHECKED NORMAL.SDR AALA20140409010Rib · crackedRIGHT LE RIB CRACKED AT XIS 134. ACCOMPLISHED REPAIR TO CRACKED RIB IAW EA MD80-57-034316.SDR AALA20140409009Rib · crackedLEFT NR 4 RIB CRACKED AT XIS 134. ACCOMPLISHED REPAIR IAW EA MD80-57-034316.SDR AALA20140407002Battery Pack · dischargedEMERGENCY LIGHT AT FWD OVERWING EXIT INOPERATIVE. R & R BATTERY PACK B-103, OPERATIONS CHECKED NORMAL.SDR AALA20140407001Battery Pack · dischargedBATTERY PACK AB 5 - 4 FAILED CHECK. R & R BATTERY PACK, OPERATIONS CHECKED NORMAL.SDR AALA20140406003A/C Pack · failedBHM INFLIGHT JAX DFW, CREW REPORTED RT PACK FAILED WITH LT PACK ON PLACARD. EMERGENCY DECLARED FLIGHT DIVERTED BHM LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED RT PACK COALESCE BAG. SYS GND CHECKED NORMAL, OPERATION CLOSED.SDR AALA20140405007Skin · crackedFUSELAGE FWD SKIN CRACKED AT AFT HINGE CUT OUT FOR LT AFT NLG DOOR. INSTALLED DOUBLER IAW SRM 53-05-00-001 FIGURE 62.SDR AALA20140403001Valve · openDFW CREW REPORTED ON CLIMB OUT FUEL TANK IMBALANCE APPROACHING LIMITS. ALL PUMPS & CROSS FEED VLVS OPERATED NORMALLY. SUSPECTED FUEL TRANSFER PROBLEM. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. UPON ARRIVAL FOUND LT & RT FUELING VLVS ISDR AALA20140402004Casting · crackedRIGHT WING, GROUND SPOILER CASTING INBD FWD CORNER CRACKED. REPLACED CASTING IAW AARD 51-00-05.SDR AALA20140401009Longeron · crackedAFT ACCESSORY LONGERON 2 LT CRACKED AT AFT SIDE OF BS 1418. INSTALLED LONGERON & SPLICE DOUBLER IAW SRM 53-02-00 FIGURE 18.SDR AALA20140401001Fairing · crackedZFS=52.267 HAS CRACK INDICATION IN LOWER LE FAIRING ON LT SIDE 12TH HOLE FROM BOTTOM. FABRICATED & INSTALLED COUNTERSUNK REPAIR BUSHING IAW EA MD80-55-034271.SDR AALA20140330005Controller · inoperativeCREW REPORTED NR 2 AUTOMATIC CABIN PRESSURE CONTROLLER INOPERATIVE WITH NR 1 CONTROLLER PREVIOUSLY PLACARDED. EMERGENCY DECLARED, DIVERTED, AND LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED NR 1 & NR 2 PRESSURIZATION CONTROLLERS & ACTUATOR. SDR AALA20140328009Rib · crackedLEFT NR 4 SLAT RIB CRACKED. INSTALLED RIB DOUBLER REPAIR IAW EA MD80-57-034150.SDR AALA20140328006Rib · crackedRIGHT NR 4 SLAT RIB CRACKED. INSTALLED RIB REPAIR DOUBLE IAW EA MD80-57-034150.SDR AALA20140324005Rib · crackedRT NR 4 SLAT RIB CASTING FOUND CRACKED. INSTALLED DOUBLER REPAIR.SDR AALA20140324004Rib · crackedLT NR 4 SLAT RIB CASTING FOUND CRACKED. INSTALLED REPAIR DOUBLER.SDR AALA20140321008Doubler · wornFORWARD ACCESSORY COMPARTMENT DOOR LANDING DOUBLERS LT & RT SIDES WORN OUT OF LIMITS. REMOVED & INSTALLED NEW DOUBLERS IAW EA MD80-53-034088 & AARD 51-00-05-1.SDR AALA20140321007Longeron · crackedLT MLG WW LONGERON 20 CRACKED AT STATION 994 FROM FASTENER DOWN TO END OF LONGERON. INSTALLED REPAIR DOUBLER IAW AARD 53-10-00-18.SDR AALA20140319001Csd · failedSTL CREW REPORTED RT ENG CONSTANT SPEED DRIVE OIL PRESS LOW LIGHT CAME ON & RT GEN TRIPPED OFF. EMERGENCY DECLARED FLIGHT RETURNED STL LANDED WITHOUT INCIDENT. DEFERRED RT ENG GEN INOPERATIVE IAW MEL 24-01A. FLIGHT CONTINUED TO DESTINATION. REPLACED RT CONSSDR AALA20140319009Rib · crackedRIGHT HAND WING INBD NR 4 SLAT TRACK SUPPORT RIB CRACKED AT INBD UPPER PULLEY BRACKET ATTACH BOSS. INSTALLED REPAIR DOUBLER IAW PATTERN CARD 57-98-06 & EA MD80-57-98-06.SDR AALA20140319008Rib · crackedLEFT HAND WING NR 4 INBD SLAT TRACK SUPPORT RIB CRACKED AT UPPER INBD PULLEY BRACKET BOSS. INSTALLED DOUBLER IAW PATTERN CARD 57-98-05 & EA MD80-57-034030.SDR AALA20140317003Rib · crackedRIGHT WING NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED AT BOSS. INSTALLED REPAIR DOUBLER IAW PATTERN CARD 57-98-06 & EA MD80-57-033994.SDR AALA20140317002Rib · crackedLEFT WING NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED AT BOSS. INSTALLED REPAIR DOUBLER IAW PATTERN CARD 57-98-05 & EA MD80-57-033994.SDR AALA20140311003Rib · crackedRIGHT HAND NR 4 SLAT INBD SUPPORT RIB CRACKED. INSTALLED REPAIR DOUBLER IAW EA MD80-57-033891.SDR AALA20140311002Rib · crackedLEFT HAND NR 4 SLAT TRACK LE INBD SUPPORT RIB CRACKED. INSTALLED DOUBLER IAW EA MD80-57-033891.SDR 2CCA20140311918Sensor · failedENROUTE AT FL 36.0, RECEIVED MOMENTARY RT ICE PROTECTION TEMP HIGH LIGHT. WAS ON FOR LESS THAN A SECOND. AIRFOIL ICE OFF, ENGINE ON. CABIN PRESSURE STARTED FLUCTUATING +/- 300-500 FT A MINUTE MOMENTARILLY WITH AN INTERMITTENT FLOW LIGHT. PERFORMED QRH PROCESDR AALA20140310012Battery Pack · dischargedAFT LAVATORY EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR AFT LAVATORY EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140310011Battery Pack · dischargedRIGHT HAND EMERGENCY LIGHTS BETWEEN EMERGENCY EXITS INOPERATIVE. REPLACED BATTERY PACK, OPERATIONS CHECKED NORMAL.SDR AALA20140313006Former · crackedRIGHT HAND WING LE NR 4 SLAT TRACK INBD FORMER CRACKED. INSTALLED DOUBLER IAW EA MD80-57-033945.SDR AALA20140304020Skin · damagedLT HAND FWD FLANGES OF VERTICAL STABILIZER & LE SKIN DAMAGED. ACCOMPLISHED REPAIR TO STABILIZER IAW EA MD80 55-033866 & SRM 55-03 FIGURE 29 & 30.SDR AALA20140304019Skin · crackedLT HAND FUSELAGE SKIN CRACKED AT FASTENER HOLE JUST BELOW LONGERON NR 2 & STATION 1418. INSTALLED DOUBLER IAW EA MD80-53-033843 & SRM 53-04-00-001 FIGURE 40.SDR AALA20140303001Valve · defectiveDFW CREW REPORTED NOSE GEAR UNSAFE INDICATION DURING RETRACTION. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED VLV & ACCOMPLISHED STRUT REPACK. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140303003Structure · damagedVERTICAL STAB LT HAND HOLE, 4TH HOLE BELOW STATION ZFS 52.267 ELONGATED. INSTALLED BUSHING & STRAP REPAIR IAW DRAWING SG09550005.SDR AALA20140301001Longeron · crackedAFT ACCESSORY LONGERON 2 LT IS CRACKED AT AFT END OF STATION 1418. REPLACED LONGERON 2 LT & SPLICE IAW SRMS 53-02-00, 53-02-00-001 & DRAWING DDK2782.SDR AALA20140228003Skin · crackedCRACK FOUND IN DORSAL FIN SKIN AFT OF WRAP AROUND ACCESS PANEL. STOP DRILLED CRACK & INSTALLED DOUBLER IAW SRM 555-01-00 FIGURE 2 SHEET 2.SDR AALA20140227005Fastener · looseVERTICAL STABILIZER LE SKIN & FRONT SPAR CAP AT STATION ZFS 52.267, LOOSE & DISTRESSED FASTENERS WERE FOUND. ACCOMPLISHED FASTENER REWORK IAW 55-03-00-01 PARAGRAPH 28 FIGURE 30.SDR AALA20140226004Frame · crackedFRAME CRACKED ON FWD SIDE OF STATION 1401 AT LONGERON 1 LT. INSTALLED REPAIR DOUBLER IAW AARD 53-10-00-17.SDR AALA20140304021Skin · damagedRT HAND FWD FLANGES OF VERTICAL STABILIZER & LE SKIN DAMAGED. ACCOMPLISHED REPAIR IAW EA MD80-55-033866 & SRM 55-03 FIGURE 29 & 30.SDR 2CCA2014F00082Angle · crackedFORWARD MAIN CABIN ENTRANCE DOOR UPPER FORWARD CORNER ANGLE CRACKED.SDR 2CCA2014F00081Angle · crackedFORWARD MAIN CABIN ENTRANCE DOOR UPPER FORWARD CORNER ANGLE CRACKED.SDR AALA20140222005Casting · crackedLT HAND WING LE NR 4 SLAT TRACK CASTING CRACKED AT INBD SIDE AT PULLEY BRACKET. REPLACED SLAT TRACK CASTING IAW AARD 51-00-00-05.
Back to Mcdonnell Douglas DC-9-82