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 AALA20130620001Battery Pack · dischargedOVERHEAD ESCAPE PATH LIGHT JUST FORWARD OF AFT AIRSTAIR INOPERATIVE. REPLACED BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20130622001Light · inoperativeESCAPE PATH LIGHT AT ROW 17D INOPERATIVE. INSTALLED NEW LIGHT ASSEMBLY FOR ROW 17D ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130618024Longeron · crackedEXTERNAL LONGERON 20 RT HAND CRACKED AFT OF WHEEL WELL. STOP DRILLED CRACK & INSTALLED DOUBLER IAW AARD 53-10-00-18.SDR AALA20130618001Controller · inoperativeAIRCRAFT LOST CABIN PRESSURIZATION IN AUTO MODE. EMERGENCY DECLARED FLIGHT DIVERTED ATL LANDED WITHOUT INCIDENT. REPLACED NR 1 & 2 PRESSURE CONTROLLER. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130616003Clamp · leakingTAIL COMPARTMENT HIGH TEMPERATURE INDICATION DURING CLIMB. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. TIGHTENED LEAKING INBOUND CLAMP AT RT HAND AUGMENTATION VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20130614012Cadc · inoperativeNR 2 CENTRAL AIR DATA COMPUTER, ALTITUDE ALERT & AUTO PILOT FAILED AFTER TAKE OFF. EMERGENCY DECLARED FLIGHT RETURNED MCO LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NR 2 CENTRAL AIR DATA COMPUTER SYSTEM. GROUND CHECKED NORMAL OPERATIONSDR AALA20130613006Generator · failedCREW REPORTED RT GENERATOR FAILED WITH APU ON PLACARD. EMERGENCY DECLARED FLIGHT RETURNED LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED RT ENGINE CONSTANT SPEED DRIVE AND GENERATOR. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130612004Skin · damagedVERTICAL STABILIZER HAS DAMAGED HOLES, L/E DORSAL SKIN AND SPAR. ACCOMPLISHED REPAIR IAW EA MD 80-55-030222.SDR AALA20130611015Skin · damagedDORSAL L/E DAMAGED. INSTALLED DOUBLER REPAIR IAW SRM 55-03-00, PARA 27, FIG 30.SDR AALA20130611003Skin · crackedSKIN CRACKED AT STATION 1437 RT BETWEEN LONGERONS 3 AND 4. INSTALLED DOUBLER IAW SRM 53-04-00 AND 51-60-00.SDR AALA20130610001Battery · dirtyEMERGENCY LIGHT IN AFT CABIN BY ROW 28 INOPERATIVE. CLEANED BATTERY. OPS CHECK NORMAL.SDR AALA20130608001Clamp · leakingCREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE INDICATION. EMERGENCY DECLARED, FLIGHT RETURNED TO DEPARTURE, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. SECURED LOOSE CLAMP ON RT ACM TO HEAT EXCHANGER AND SECURED LOOSE BOOT ON DUCT DOWN STREAM OF TESDR AALA20130606015Switch · faultyCREW REPORTED PRESSURIZATION FLOW LIGHT ILLUMINATED. PERFORMED QRH PROCEDURE AND DESCENDED TO 10,000 FEET. FLIGHT DIVERTED, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED BOTH SECON SEGMENT CLIMB SWITCHES. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130808020Battery Pack · dischargedEMERGENCY CABIN & COCKPIT OVERHEAD LIGHTING WILL NOT SHUT-OFF. RECHARGED BATTERY. OPERATIONS CHECKED NORMAL.SDR AALA20130603003Portable Light · defectiveLEFT NR 1 DOOR PORTABLE EMERGENCY LIGHT VERY DIM. REPLACED LT NR 1 DOOR PORTABLE EMERGENCY LIGHT. OPS CHECK NORMALSDR AALA20130603002Battery Pack · dischargedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. RESEATED BATTERIES IN BATTERY PACK. OPS CHECK NORMALSDR AALA20130603001Wire · pulledFORWARD AND AFT ESCAPE PATH LIGHTING AT SEAT 19D INOPERATIVE. WIRES PULLED FROM CONNECTOR. RECONNECTED WIRES AT SEAT 19D. OPS CHECK NORMAL.SDR AALA20130602005Regulator Valve · inoperativeF/A REPORTED BURNING ODOR IN CABIN. EMERGENCY DECLARED FLIGHT LANDED TPA WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED LT AND RT AIR CONDITION REGULATOR VALVES. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130531062Csd · overservicedCREW REPORTED, ON CLIMBOUT, RT CONSTANT SPEED DRIVE TEMP HIGH. CREW DISCONNECTED THE CSD. EMERGENCY DECLARED, FLIGHT RETURNED TO DEPARTURE, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. FOUND RT CSD OVERSERVICED. CONSTANT SPEED DRIVE FLUSHED AND SERSDR AALA20130531008Pin · crackedCRACK AT STA 37, LOWER RT RADOME GUIDE PIN. CUT OUT CRACK AND INSTALLED DOUBLER AND FILLER IAW AARD 53-10-00-19.SDR AALA20130528013Acm · inoperativeCREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED, FLIGHT RETURNED TO DEPARTURE, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED LT AUG VALVE SENSE LINE AND RT AIR CYCLE MACHINE. SYS GROUND CHECK NORMAL OPERSDR AALA20130529001Light · dirtyTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. CLEANED TAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK. OPS CHECK NORMALSDR AALA20130528014Frame · crackedLOWER RT TAILCONE CANT FRAME AT STA 1510 CRACKED AROUND ALIGNMENT PIN. INSTALLED DOUBLER IAW SRM 53-01-00 AND SRM 51-30-05.SDR AALA20130528006Skin · crackedCRACK IN SKIN AT STATION 1309 ABOVE LONGERON 7 LT. CUT OUT CRACK AND INSTALLED TEMPORARY DOUBLER IAW SRM 53-04-02, FIG 2, SHEET 29 AND PARA 3.C. (1)(C).SDR AALA20130526010Hydraulic Line · leakingCREW REPORTED STRONG ODOR DURING. EMERGENCY DECLARED FLIGHT DIVERTED, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPAIRED HYD LEAK AT NOSE GEAR STEERING LINE IN MID CARGO COMPARTMENT. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130525004Light · inoperativeAFT LT SIDE LOWER TAILCONE EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR AFT LT SIDE LOWER TAILCONE LIGHT ASSY. OPS CHECK NORMAL.SDR AALA20130525003Battery Pack · not seatedOVERHEAD EMERGENCY LIGHTS IN FRONT OF AFT ENTRY DOOR INOPERATIVE. RESEATED BATTERY PACK IN AFT LAVATORY. OPS CHECK NORMAL.SDR AALA20130525002Battery Pack · not seatedOVERHEAD EMERGENCY LIGHTS AT SEATS 15 AND 16. RESEATED BATTERY PACK AT SEAT 13DEF. OPS CHECK NORMAL.SDR AALA20130524012Casting · crackedRIGHT WING GROUND SPOILER CASTING CRACKED. REPLACED CASTING IAW AARD 51-00-05-1.SDR AALA20130524010Frame · cracked1485 CANT FRAME CRACKED BELOW STAIR RETENTION ACTUATOR. INSTALLED DOUBLER IAW AARD 53-10-00-33.SDR AALA20130521015Sense Line · disconnectedCREW REPORTED PRESSURIZATION FLUCTUATION, AUTO PILOT DISCONNECT AND CAPTAINS PITOT FAULT. EMERGENCY DECLARED FLIGHT DIVERTED LIT LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. RECONNECTED SENSE LINE FOR LT PACK. SYS GROUND CHECK NORMAL OPERATION. (CLSDR AALA20130521016Skin · crackedLT FUSELAGE SKIN AT STATION 1309 AND LONGERON 7 LT CRACKED. INSTALLED DOUBLER IAW EA MD80-53-029892.SDR AALA20130521013Support · crackedSUPPORT STRUT ON STA 218, LT SIDE IS CRACKED AT LOWER END BETWEEN LONGERONS 23 AND 24 LEFT. INSTALLED DOUBLER REPAIR IAW SRM 53-14-01.SDR AALA20130518004Cover · damagedFORWARD ENTRY DOOR FLOOR EMERGENCY LIGHT COVER SMASHED AND WIRES PULLED FROM CONNECTOR. REPLACED BASE LIGHT ASSEMBLY. OPS CHECKED NORMAL.SDR AALA20130516015Switch · inoperativeCREW REPORTED LANDING GEAR UNSAFE INDICATION. EMERGENCY DECLARED, FLIGHT LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED S1-89 GEAR HANDLE SWITCH. SYS GROUND CHECK NORMAL OPS.SDR AALA20130516007Skin · damagedFUSELAGE SKIN FROM STATIONS 496 TO 500 BETWEEN STRINGERS 28 AND 29 LEFT HAD IMPACT DAMAGE. ACCOMPLISHED EXTERNAL DOUBLER REPAIR PER SRM 53-04-03.SDR AALA20130515102Shutoff Valve · leakingDFW - CREW REPORTED LEFT HYDRAULIC FLUID WENT TO ZERO QUANTITY DURING CRUISE. FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT SPOILER SHUTOFF VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130514005Heater · malfunctionedAMA - INFLIGHT DFW-ABQ. CREW REPORTED ODOR IN THE FLIGHT DECK. EMERGENCY DECLARED FLIGHT DIVERTED AMA LANDED WITHOUT INCIDENT. FOUND FORWARD CARGO COMPARTMENT HEATER POPPED CIRCUIT BREAKER AND CREATED ODOR. PLACARD FORWARD CARGO COMPARTMENT HEATER AND FLIGHSDR AALA20130514009Longeron · crackedLONGERON 24 LEFT CRACKED AT STATION 200 AT BELTFRAME ATTACH POINTS. ACCOMPLISHED LONGERON 24L SPLICE REPAIR FROM STATIONS 165 TO 229 PER SRM 53-02-00.SDR AALA20130514008Longeron · crackedLONGERON 23 LEFT CRACKED AT STATION 200 AT BELTFRAME ATTACH POINT. ACCOMPLISHED LONGERON 23 LEFT SPLICE REPAIR FROM STATIONS 190 TO 229 PER SRM 53-02-00.SDR AALA20130512007Shutoff Valve · leakingDFW - CREW REPORTED RIGHT HYDRAULIC SYSTEM QUANTITY LOSS. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. DETERMINED A LARGE LEAK IN THE TAIL AREA. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT SYSTEM SPOILER ROTARY GROUND SHUT OFF VALVE. SYSTEM GROSDR AALA20130511004Diode · failedDFW - CREW REPORTED BATTERY CHARGER FAIL LIGHT ILLUMINATED AND SEVERAL CABIN LIGHTS FAILED. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED R7-51 DIODE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130512004Charger · inoperativeBATTERY CHARGER LIGHT ILLUMINATED WITH GROUND SERVICE BREAKERS TRIPPED. REPLACED BATTERY CHARGER. OPS CHECK NORMAL.SDR AALA20130512003Relay · inoperativeBATTERY CHARGER LIGHT ILLUMINATED WITH GROUND SERVICE BREAKERS TRIPPED. REPLACED R2-56 RELAY. OPS CHECK NORMAL.SDR AALA20130512002Battery Pack · dischargedBATTERY CHARGER LIGHT ILLUMINATED WITH GROUND SERVICE BREAKERS TRIPPED. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130511006Cover · missingEMERGENCY EXIT LIGHT COVER AT FORWARD GALLEY DOOR MISSING. REPLACED EMERGENCY EXIT LIGHT COVER AT FORWARD GALLEY DOOR. OPS CHECKS NORMAL.SDR AALA20130510009Light · inoperativeEMERGENCY LIGHT NOT ARMED LAMP INOPERATIVE. REPLACED LIGHT BULBS IN EMERGENCY LIGHT NOT ARMED INDICATOR. OPS CHECK NORMAL.SDR AALA20130510004Control Unit · inoperativeDFW - CREW REPORTED MULTIPLE AC POWER INTERRUPTIONS WITH CHIMES IN THE LAVATORIES AND FIRST OFFICER INSTRUMENTS BLINKING. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT TR-2 AND BUSS CONTROL UNITSDR AALA20130510003Frame · damagedDAMAGED HOLE AT FRAME SPLICE FUSELAGE STATION 200 AT LONGERON 24 LEFT. INSTALLED FREEZE PLUG AND REINFORCING STRAP AT FRAME SPLICE FUSELAGE STATION 200 AND LONGERON 24 LEFT PER EA MD80-53-029731.SDR AALA20130509009Sensor · failedDFW - CREW REPORTED NOSE GEAR UNSAFE LIGHT ILLUMINATED AND GEAR UNSAFE AURAL WARNING SOUNDED. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED D1-32 GEAR LOCKED SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82