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 AALA20130808008Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY BATTERY PACK B5-23. OPERATIONS CHECKED NORMAL.SDR AALA20130805014Battery Pack · dischargedFIRST CLASS & LT NR ONE DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS & LT NR ONE DOOR EMERGENCY LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20130805012Valve · inoperativeRDU INFLIGHT DCA-DFW CREW REPORTED RT ENGINE HIGH OIL TEMPERATURE. RT ENGINE SHUTDOWN, SINGLE ENGINE TIME 15 MINUTES. EMERGENCY DECLARED FLIGHT DIVERTED RDU LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT ENGINE FUEL HEAT VALVE. SYSSDR AALA20130805004Battery Pack · dischargedAFT TAIL CONE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-28 FOR AFT TAIL CONE EMERGENCY LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20130802001Light · inoperativeTAIL COMPARTMENT FORWARD EMERGENCY LIGHT ABOVE CATWALK INOPERATIVE. REPLACED LAMP FOR TAIL COMPARTMENT FORWARD EMERGENCY LIGHT ABOVE CATWALK. OPERATIONS CHECKED NORMAL.SDR AALA20130801006Battery Pack · dischargedAFT EMERGENCY DOME LIGHT WEAK & ILLUMINATES WHEN POWER IS OFF. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20130801005Battery · dischargedFORWARD ENTRY EMERGENCY DOME LIGHT WEAK & STAYS ILLUMINATED WHEN AIRCRAFT POWER & EMERGENCY SWITCH ARE BOTH OFF. REPLACED THE FORWARD POWER BATTERY. OPERATIONS CHECKED NORMAL.SDR AALA20130801004Battery · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. RESEATED & SECURED BATTERIES IN BATTERY PACK LOCATED IN RT AFT LAVATORY. OPERATIONS CHECKED NORMAL.SDR AALA20130801002Sensor · faultyDFW CREW REPORTED TAIL COMPARTMENT HIGH LIGHT ILLUMINATED ON CLIMB OUT. FLIGHT RETURNED DFW, LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT & RT HIGH TEMPERATURE SENSORS. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20130731017Gcu · malfunctionedDFW CREW REPORTED RT ENGINE GENERATOR OFF LIGHT ILLUMINATED. EMERGENCY DECLARED, FLIGHT RETURNED DFW, LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT ENGINE GENERATOR CONTROL UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20130731016Casting · crackedLT WING CRACKED IN CASTING RT SIDE OF NR 4 SLAT TRACK. REPLACED CASTING.SDR AALA20130729001Duct · crackedSAT CREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED. EMERGENCY DECLARED, FLIGHT LANDED SAT WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT DUCT INSIDE OF TAIL COMPARTMENT THAT WAS CRACKED. SYSTEM GROUND CHECKED NORMAL. OPERSDR AALA20130726005Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 17 - 23 FAILED TEST. REPLACED BATTERY PACK B5-106. OPERATIONS CHECKED NORMAL.SDR AALA20130723008Longeron · crackedEXTERNAL LONGERON 20 CRACKED IN RT WHEEL WELL. STOP DRILLED CRACK & INSTALLED DOUBLER IAW AARD 53-10-00-18.SDR AALA20130722004Portable Light · inoperativePORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130721004A/C Pack · dirtySMOKE/HAZE IN COCKPIT & CABIN. ACCOMPLISHED PACK BURN. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130720005Computer · faultyBOTH AUTOPILOT DISCONNECTED IN FLIGHT. REPLACED BOTH DIGITAL FLIGHT GUIDANCE COMPUTERS. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130718003Casting · crackedCASTING CRACKED INBD OF NR 4 SLAT TRACK INBD UPPER SIDE ON LT WING. INSTALLED NEW CASTING IAW AARD 51-00-05-1.SDR AALA20130718002Casting · crackedRT WING LE CASTING CRACKED INBD OF SLAT TRACK 4. INSTALLED A NEW INBD CASTING FOR NR 4 SLAT TRACK IAW AARD 51-00-05-1.SDR AALA20130717011Duct · blownTAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED DURING CLIMB OUT. REPLACED BLOWN DUCT. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130717003Indicator · malfunctionedELECTRICAL BURNING SMELL DETECTED IN COCKPIT. ACCOMPLISHED PACK BURN & REPLACED TCAS INDICATOR. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130714003Duct · crackedTAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED ON CLIMB-OUT. ACCOMPLISHED QRH PROCEDURES & THE LIGHT WENT OUT. FOUND PERI SEAL CONNECTOR LEAKING & CRACKED DUCT BEHIND RT AIR CYCLE MACHINE. REPLACED DUCT & PERI SEAL. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130713006Sensor · faultyTAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED ON CLIMB OUT. REPLACED RT & LT TEMPERATURE SENSORS. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130712007Controller · malfunctionedRED CABIN ALTITUDE LIGHT ILLUMINATED & AURAL CABIN ALTITUDE SOUNDED. CABIN ALTITUDE WAS INITIALLY ABOVE 10,000 FEET. REPLACED NR 1 & 2 AUTO CABIN PRESSURE CONTROLLERS. SYSTEM GROUND CHECKED NORMALSDR AALA20130710009Light · damagedFORWARD EMERGENCY LIGHT IN AFT STAIR WELL DAMAGED. REPLACED LAMP FOR FORWARD EMERGENCY LIGHT IN AFT STAIR WELL. OPERATIONS CHECKED NORMAL.SDR AALA20130709009Skin · crackedFS AFT CRACK IN SKIN AT STATION 1380 ABOVE LONGERON 14 RT. INSTALLED FILLER & DOUBLER IAW SRM 53-04-00 FIGURE 18.SDR AALA20130709004Frame · damagedFRAME DAMAGED & DENTED AT STATION 39 AT LONGERON 19 LT. INSTALLED DOUBLER IAW AARD 53-30-00-02 & INSTALLED NEW FRAME IAW AARD 51-00-05-1 & DRAWING 9911501.SDR AALA20130708016Seat Track · corrodedMULTIPLE SPOTS OF CORROSION IN SEAT TRACK NR 5 FROM STATIONS 200 TO 246. INSTALLED NEW NR 5 SEAT TRACK IAW SRM 53-05-00-FG 4F.SDR AALA20130707006Frame · crackedCRACK IN AFT WHEEL WALL FRAME AT TOP OTBD END ABOVE FLAP BUS CABLE PULLEYS. INSTALLED REPAIR DOUBLER & -5 JAMB SECTION IAW SRM 51-70-05.SDR AALA20130706008Duct · leakingTAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED ON CLIMB-OUT. FOUND DUCT LEAKING BETWEEN THE RT PRESSURE REGULATOR VALVE & THE FLOW CONTROL VALVE AT A SENSE LINE UNION. REPLACED DUCT. SYSTEM GROUND CHECKED NORMALSDR AALA20130704003Power Supply · inoperativeINTERIOR EMERGENCY LIGHTS FAILED TO ILLUMINATE. REPLACED INTERIOR EMERGENCY BATTERY POWER SUPPLY. OPERATIONS CHECKED NORMAL.SDR AALA20130704002Power Supply · inoperativeEXTERIOR EMERGENCY LIGHTS FAILED TO COME ON DURING MX TEST. REPLACED EXTERIOR EMERGENCY LIGHTS POWER SUPPLY. OPERATIONS CHECKED NORMAL.SDR AALA20130703002Casting · crackedSTATION 927 BELOW NR 2 SEAT TRACK, SUPPORT CASTING IS CRACKED. REPLACED CASTING IAW AARD 51-00-05-1.SDR AALA20130711004Cusp Web · damagedENLARGED HOLE IN CUSP AT STATION 237 RT SIDE JUST INBD OF FRAME FITTING. CUT OUT DAMAGE & INSTALLED DOUBLER IAW AARD 53-20-00-16.SDR AALA20130702008Cusp Web · corrodedCORROSION ON UNDER SIDE OF CUSP BELOW AFT GIRT BAR FITTING AT AFT SERVICE DOOR. INSTALLED DOUBLER IAW AARD 53-20-00-10.SDR AALA20130702002Cusp Web · damagedLIGHTING HOLE FROM FS 434 - 440 LT HAND CUSP DAMAGED. INSTALLED DOUBLER ON CUSP IAW AARD 53-20-00-16.SDR AALA20130702001Skin · crackedAFT FS CRACKED IN SKIN, FS 1309 ABOVE LONGERON 7 LEFT. INSTALLED DOUBLER IAW SRM 53-04-00 FIGURE 32.SDR AALA20130629005Power Supply · inoperativeCEILING EMERGENCY LIGHTS AT ROWS 28 & 29 INOPERATIVE. REPLACED POWER SUPPLY AT ROW 29. OPERATIONS CHECKED NORMAL.SDR AALA20130629004Portable Light · inoperativeLT NR 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED LT NR 1 DOOR PORTABLE LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130629003Sign · brokenRT NR 1 GALLEY DOOR EGRESS LIGHT FOUND BROKEN. REPLACED RT NR 1 GALLEY DOOR EGRESS SIGN. OPERATIONS CHECKED NORMAL.SDR AALA20130628013Skin · crackedRT HAND SIDE FUSELAGE SKIN CRACKED AT STATION 1437, BETWEEN LONGERONS 3 & 4 RT. CUT OUT DAMAGE & INSTALLED DOUBLER & FILLER IAW SRM 53-04-00 FIGURE 27.SDR AALA20130628005Lens · brokenEMERGENCY LIGHT AT ROW 29 HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT ROW 29. OPERATIONS CHECKED NORMAL.SDR AALA20130628004Light · inoperativeEMERGENCY LIGHT AT ROW 29 INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT ROW 29. OPERATION CHECKED NORMAL.SDR AALA20130712002Cusp Web · corrodedCORROSION ON GALLEY G-2 TIE DOWN FITTING AT STATION 218, AT INBD FLOOR MOUNT. INSTALLED SUB FLOOR DOUBLER & SERVICEABLE GALLEY FLOOR MOUNT IAW AARD 53-20-00-16.SDR AALA20130627011Clamp · looseTAIL COMPARTMENT OVERHEAT LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. FOUND CLAMP AT LT HAND AIR CYCLE MACHINE TO HEAT EXCHANGER LOOSE WITH LEAK. SYSTEM CHECKED NORMAL.SDR AALA20130626023Antenna · inoperativeWEATHER RADAR FAILED. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. REPLACED WEATHER RADAR ANTENNA. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130625010Generator · failedLT HAND GENERATOR FAILED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. REPLACED LT HAND ENGINE CONSTANT SPEED DRIVE & GENERATOR. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130622004Bracket · crackedFORWARD ENTRY DOOR INTERNAL STRUCTURE BRACKET AFT OF CENTER HUB CRACKED AT LOWER FASTENER. REPLACED BRACKET.SDR AALA20130621008Battery Pack · dischargedEMERGENCY LIGHT BY AFT GALLEY FAILED TEST. REPLACED EMERGENCY LIGHT BATTERY PACK AT ROW 29 DEF. OPERATIONS CHECKED NORMAL.
SDR AALA20130621002Coalescer Bag · dirtySMOKE ODOR IN CABIN & COCKPIT. EMERGENCY DECLARED FLIGHT DIVERTED DEN LANDED WITHOUT INCIDENT. ACCOMPLISHED CABIN ODOR CARD 21-96-01. REPLACED BOTH WATER SEPARATOR BAGS & ACCOMPLISHED HIGH POWER ENGINE RUN WITH NO ODOR NOTED. SYSTEM GROUND CHECKED NORMAL.
Back to Mcdonnell Douglas DC-9-82