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 AALA20130926013Unknown · fireDURING CLIMB OUT FLIGHT ATTENDANTS SMELLED SMOKE. WHEN THEY OPENED 26AB OVERHEAD BIN THEY SAW FLAMES COMING FROM PASSENGER BAG. FIRE WAS EXTINGUISHED BY FLIGHT ATTENDANTS. EMERGENCY DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROSDR AALA20130926014Adc · inoperativeDFW CREW REPORTED ON TAKEOFF ROLL CAPTAIN LOST AIRSPEED, ALTITUDE, & VERTICAL SPEED INDICATOR. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NR 1 AIR DATA COMPUTER. SYSTEM GROUND CHECKED NORMAL OPERSDR AALA20130929007Door Frame · crackedCABIN SIDEWALL LT AFT OVER WING EXIT DOOR CUT OUT UPPER RADIUS IS CRACKED AFT OF DOOR UPPER STRIKER. INSTALLED DOUBLER IAW EA MD80-53-031799 & SRM 53-05 FIGURE 32.SDR AALA20130925003Web · damagedTOP EDGE OF INNER WEB DAMAGED INSIDE FORWARD AIRSTAIR DOOR OPENING SIX INCHES AFT OF FORWARD END. INSTALLED FILLER & DOUBLER IAW SRM 53-01-00.SDR AALA20130924020Longeron · crackedSTATION 200, LONGERON 24 LT CRACKED AT LOWER HI LOCK. INSTALLED SPLICE IAW SRM 53-02-00.SDR AALA20130924019Longeron · crackedSTATION 200 LONGERON 24 LT CRACKED AT UPPER HI LOCK. INSTALLED SPLICE IAW SRM 53-02-00.SDR AALA20130923016Clamp · brokenDFW CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED DURING CLIMB-OUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BROKEN LT HEAT EXCHANGER EXHAUST CLAMP & LEAKING RT HEAT EXCHANGSDR AALA20130923021Longeron · crackedBS 200 LT LONGERON 23 CRACKED AT UPPER LOCK FASTENER. INSTALLED LONGERON 23 LT SIDE FROM BS 183 TO 220 IAW 53-02-00.SDR AALA20130923018Longeron · crackedBS 200 LT & LONGERON 23 CRACKED AT UPPER LOCK FASTENER. INSTALLED LONGERON 23 LT SIDE FROM BS 183 TO 220 IAW 53-02-00.SDR AALA20130922004Controller · failedEWR INFLIGHT LGA-ORD. CREW REPORTED DURING CLIMB OUT PRESSURIZATION WAS LOST FOLLOWED BY O2 MASKS DEPLOYMENT. EMERGENCY DECLARED FLIGHT DIVERTED EWR LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NR 1 CABIN PRESSURE CONTROLLER & PRESSURE SDR AALA20130920001Longeron · crackedCRACK ON TOP CHANNEL AT LONGERON 23 & STATION 200 LT. REPLACED LONGERON SECTION FROM BS 163 TO 218 IAW SRM 53-02-00.SDR AALA20130926006Fitting · crackedLEFT HAND WING FITTING CRACKED INBOARD SIDE OF NUMBER 4 SLAT TRACK. INSTALLED DOUBLER PER EA MD80-57-031567.SDR AALA20130919003Battery Pack · dischargedINTERIOR AFT OVERWING EMERGENCY LIGHT FAILED TEST. REPLACED BATTERY PACK B5-105. OPERATIONS CHECKED NORMALSDR AALA20130919015Longeron · crackedLONGERON 25 LT CRACKED AT BS 160. REPLACED LONGERON 25 LT & SPLICES FROM BS 134 TO 228 IAW SRM 53-02-00.SDR AALA20130919012Longeron · crackedCRACK ON TOP CHANNEL ON LONGERON 24 AT BS 160 LT. INSTALLED SPLICE & LONGERON REPAIR IAW SRM 53-02-00 FIGURE 18.SDR AALA20130918022Overheat Sensor · faultyDFW CREW REPORTED TAIL OVERHEAT INDICATION DURING CLIMB-OUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT & RT TAIL COMPARTMENT TEMPERATURE SENSORS. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSEDSDR AALA20130918012A/C Pack · seizedDFW CREW REPORTED UNABLE TO PRESSURIZE WITH RT PACK WITH LT PACK ON PLACARD. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT PACK THAT HAD SEIZED. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR 2CCA2013083003Cusp Web · corrodedDURING 60 MO SI; CORROSION FOUND AT BS 256 RT WEB MEMBRANE. CORROSION REMOVED AND REPAIR DOUBLER INSTALLED IAW SRM 53-05, FIG 131A-10.SDR 2CCA2013083002Cusp Web · corrodedCORROSION DISCOVERED AT BS 239 LT CUSP MEMBRANE. CORROSION REMOVED AND REPAIR DOUBLER, INSTALLED IAW SRM 53-05, FIG 131A-10.SDR 2CCA2013083001Tee Fitting · corrodedCORROSION FOUND IN RT AFT LAVATORY BS 1338 CUSP LINE AND LONG 18. INSTALLED CUSP TEE SLICE REPAIR AT BS 1300 - 1336 LONG 18R IAW SRM 53-05, FIG 25.SDR AALA20130924013Longeron · crackedCRACK ON LONGERON 23 LT AT STATION 200. INSTALLED LONGERON SPLICE IAW SRM 53-02-00.SDR AALA20130916006Valve · leakingIND CREW REPORTED RT ENGINE LOSS OF POWER. CREW ACCOMPLISHED IN-FLIGHT SHUT-DOWN OF RT ENGINE. EMERGENCY DECLARED FLIGHT RETURNED IND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND FUEL PRESSURIZING & DUMP VALVE LEAKING. REPLACED RT NR 2 P &SDR AALA20130914010Casting · crackedRT HAND WING, INBD CASTING CRACKED AT NR 4 SLAT TRACK. INSTALLED SERVICEABLE CASTING FITTING IAW AARD 51-00-05-1 & DRAWING 9937490.SDR AALA20130913018Rib · crackedLT HAND WING LE CASTING CRACKED AT TOP INBD OF NR 4 SLAT TRACK. INSTALLED NEW RIB IAW AARD 51-00-05-1 & DRAWING 9937490.SDR AALA20130912020Skin · damagedBIRD STRIKE DAMAGE TO FS SKIN JUST ABOVE FIRST OFFICER WINDOW AT STATION 148.55 & LONGERON 4 TO 5 RT. ACCOMPLISHED REPAIR IAW EA MD80-53-031441.SDR AALA20130909001Battery Pack · dischargedLT & RT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. R&R BATTERY PACK B5-105. OPERATIONS CHECKED NORMAL.SDR AALA20130908005Charger · malfunctionedTUL INFLIGHT MA-DFW CREW REPORTED BATTERY CHARGER LIGHT ILLUMINATED AFTER CLIMB-OUT. FLIGHT ATTENDANTS REPORTED A LARGE AMOUNT OF WATER THAT CAME FROM THE OVERHEAD AREA OF AIRCRAFT. FLIGHT DIVERTED TUL LANDED WITHOUT INCIDENT. FOUND CIRCUIT BREAKER L5, SDR AALA20130906021Casting · crackedLT WING LE CASTING AT NR 4 SLAT TRACK, INBD SIDE, AFT OF REAR LUG IS CRACKED. REPLACED LT WING LE CASTING IAW AARD 51-00-05-1.SDR AALA20130831005Sign · brokenEMERGENCY EXIT SIGN ABOVE LT NR 1 SERVICE DOOR FOUND BROKEN. REPLACE EMERGENCY EXIT SIGN ABOVE LT NR 1 SERVICE DOOR. OPERATION CHECKED NORMAL.SDR AALA20130911009Filler · crackedAFT ACCESSORY 1463 CANT FRAME & INBD OF LONGERON 3 RT, FRAME TO SKIN FILLER CRACKED. INSTALLED INTERNAL & EXTERNAL DOUBLERS IAW EA MD80-53-031349.SDR AALA20130828006Generator · failedDFW CREW REPORTED LT GENERATOR FAILED & AUXILIARY POWER UNIT WOULD NOT START. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT GENERATOR. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20130826021Clamp · brokenDFW CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED DURING CLIMB OUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BROKEN AIR CYCLE MACHINE OUTLET CLAMP & HEAT EXCHANGER BOOT THASDR AALA20130826018Connector · disconnectedEMERGENCY LIGHT AT SEAT 24D INOPERATIVE. RECONNECTED PLUG UNDER SEAT 24D FOR EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130826003Connector · disconnectedEMERGENCY LIGHT AT SEAT 4E INOPERATIVE. RECONNECTED PLUG UNDER SEAT 4E FOR EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130824003Check Valve · leakingDFW CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND VALVE SEAL LEAKING. REPLACED VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSEDSDR AALA20130822008Engine · bird ingestionDFW CREW REPORTED BIRD STRIKE TO NR 1 ENGINE. LT ENGINE WAS SHUTDOWN SINGLE ENGINE TIME 9 MINUTES. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. LT ENGINE FAN BLADES DAMAGED. REPLACED LT ENGINE AT DFW OSDR AALA20130816004Battery Pack · dischargedAFT INTERIOR EMERGENCY LIGHT FAILED TEST. REPLACED B5-105 EMERGENCY LIGHT BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20130816003Battery Pack · dischargedFORWARD INTERIOR OVERWING EXIT LIGHT WILL NOT STAY OFF WHEN POWER REMOVED FROM AIRCRAFT. REPLACED B5-103 EMERGENCY LIGHT BATTERY PACK. OPERATIONS CHECKED NORMAL.SDR AALA20130816002Portable Light · failedLT NR 1 DOOR PORTABLE EMERGENCY LIGHT FAILED TEST. REPLACE LT NR 1 DOOR PORTABLE EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130815012Duct · leakingTUS CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED ON CLIMB OUT. EMERGENCY DECLARED FLIGHT RETURNED TUS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. ACCOMPLISHED CARD 36-95-14 & REPAIRED ASSOCIATED LEAKS. SYSTEM GROUND CHECSDR AALA20130815011Battery Pack · dischargedCABIN EMERGENCY LIGHT WOULD NOT ILLUMINATE. REPLACED BATTERY PACK FOR CABIN EMERGENCY LIGHTS. OPERATIONS CHECKED NORMAL.SDR AALA20130813008Power Supply · inoperativeCABIN OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED B5-106 BATTERY POWER SUPPLY. OPERATIONS CHECKED NORMAL.SDR AALA20130811001Power Supply · inoperativeCABIN OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED B5-27 BATTERY POWER SUPPLY. OPERATIONS CHECKED NORMAL.SDR AALA20130810016Engine · bird ingestionDFW CREW REPORTED STRONG OIL ODOR IN THE CABIN FOLLOWED BY A STRONG VIBRATION IN THE TAIL DURING CLIMB OUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. FOUND EVIDENCE OF BIRD STRIKE TO LT ENGINE WITH TWO BLADES BENT & NR 1 BEARING LEAKISDR AALA20130810001Casting · crackedRT WING NR 4 SLAT TRACK INBD CASTING CRACKED. INSTALLED NEW INBD NR 4 SLAT TRACK CASTING IAW AARD 51-00-05. REPAIR 1 & DRAWING 9937490.SDR AALA20130810006Slide · low pressureLT NR 1 DOOR SLIDE PRESSURE BELOW GREEN. REPLACED LT NR 1 DOOR SLIDE. OPERATIONS CHECKED NORMAL.SDR AALA20130808006Battery · not seatedEMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. RESEATED BATTERIES ABOVE RT AFT LAVATORY CEILING. OPERATIONS CHECKED NORMAL.SDR AALA20130808005Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. RESEATED BATTERIES AT ROW 29DEF. OPERATIONS CHECKED NORMAL.SDR AALA20130808010Battery Pack · dischargedTAIL CONE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK IN AFT LAVATORY FOR EMERGENCY LIGHTS IN TAIL CONE. OPERATIONS CHECKED NORMAL.SDR AALA20130808009Battery Pack · dischargedROWS 23 TO 28 EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK IN AFT LAVATORY FOR ROWS 23 TO 28 EMERGENCY LIGHTS. OPERATIONS CHECKED NORMAL.
Back to Mcdonnell Douglas DC-9-82