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 WX0A071403Cusp Web · corrodedREPAIR DOUBLER IS CORRODED ON CUSP WEB BETWEEN FS 1060 TO 1079 ON LEFT SIDE. REMOVED CORRODED DOUBLER, FABRICATED AND INSTALLED.SDR AALA20121127005Angle · corrodedCORROSION BEYOND MANUAL LIMITS IN AFT CARGO AT STATION 1322 BETWEEN LONGERONS 29 LEFT AND 29 RIGHT. REMOVED AND REPLACED CORRODED J-ANGLE AT STATION 1322 BETWEEN LONGERONS 29 LEFT AND 29 RIGHT.SDR AALA20121127002Fairing · distressedDORSAL FAIRING, STATION 52.267, HAS IN EXCESS OF 24 DISTRESSED HOLES REQUIRING EXTERNAL DOUBLER PER SRM 55-03-00. INSTALLED REPAIR DOUBLER PER SRM 55-03-00.SDR WX0A071422Cusp Web · corrodedPASSENGER CABIN RT CUSP WEB CORRODED AT FS 1030. CUT OUT DAMAGED AREA, FABRICATED DOUBLER AND RING DOUBLER AND INSTALLED.SDR AALA20121127004Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 13 TO 16 INOPERATIVE. RESEATED BATTERIES FOR CEILING EMERGENCY LIGHTS FROM ROWS 13 TO 16. OPS CHECK NORMAL.SDR AALA20121127003Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 23 TO 26 INOPERATIVE. RESEAT BATTERY FOR CEILING EMERGENCY LIGHTS FROM ROWS 23 TO 26. OPS CHECK NORMAL.SDR AALA20121126018Ballast · failedORD - CREW REPORTED LEFT OVERHEAD LIGHT BALLAST BEHIND ROW 8AB FAILED WITH FUMES AND ELECTRICAL SMELL. PER EMERGENCY PROCEDURE, PULLED CIRCUIT BREAKERS L6, J7, L19, L20, L21 AND F6. EMERGENCY DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT RESDR AALA20121126017Pan · crackedRIGHT WINDOW PAN: LOWER FORWARD WINDOW PAN IS CRACKED BETWEEN STATIONS 1022 TO 1041. INSTALLED RIGHT WINDOW PAN DOUBLER AT LOWER FORWARD WINDOW BETWEEN STATIONS 1022 TO 1041 PER AARD 53-10-00-25.SDR AALA20121126016Pan · crackedLEFT WINDOW PAN CRACKED AT STATION 1098 UPPER AFT CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR WX0A071401Cusp Web · corrodedRIGHT CUSP WEB CORRODED AT STATION 636. REPAIRED CORRODED WEB.SDR WX0A071400Cusp Web · corrodedPASSENGER CABIN RIGHT CUSP WEB CORREDED AT FS 389. REMOVED CORRODED CUSP, FABRICATED REPAIR DOUBLER AND INSTALLED.SDR WX0A071399Frame · gougedCABIN LEFT FRAME GOUGED AT STATION 1212 NEAR LONGEON 17L. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLE, FILLER, STRAP AND INSTALLED.SDR AALA20121126015Pan · crackedRIGHT WINDOW PAN: UPPER AFT WINDOW PAN IS CRACKED BETWEEN STATIONS 1022 TO 1041. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20121126014Pan · crackedRIGHT WINDOW PAN: UPPER AFT WINDOW PAN IS CRACKED BETWEEN STATIONS 1174 TO 1193. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20121126012Pan · crackedRIGHT WINDOW PAN: LOWER FORWARD WINDOW PAN IS CRACKED BETWEEN STATIONS 1155 TO 1174. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20121126011Attach Fitting · crackedRIGHT WING, NUMBER 5 SLAT, NUMBER 14 TRACK, HAS CRACK INDICATION. INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20121126003Pan · crackedLEFT WINDOW PAN CRACKED AT STATION 1098 UPPER FORWARD CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20121126002Seat Track · corrodedNUMBER 1 SEAT TRACK FROM STATIONS 728 TO 729 CORRODED. INSTALLED PLUG REPAIR PER AARD 53-20-00-10.SDR AALA20121126001Seat Track · corrodedSEAT TRACK NUMBER 4 AT STATION 1276 CORRODED. INSTALLED PLUG REPAIR PER AARD 53-20-00-10.SDR WX0A071396Cusp Web · corrodedPASSENGER CABIN RIGHT CUSP WEB CORRODED AT FS 1030. CUT OUT DAMAGED AREA, FABRICATED DOUBLER AND RIGHT DOUBLER INSTALLED.SDR WX0A071395Shear Tie · corrodedAFT CARGO PIT SHEAR TIE CORRODED AT STATION 1174 BETWEEN LONGERON 30 AND 29L. REMOVED DAMAGED AREA, FABRICATED SHEAR TIE AND REPAIR.SDR WX0A071394Cusp Web · corrodedRIGHT CUSP WEB CORRODED AT STATION 370. REPAIRED RIGHT CUSP WEB.SDR WX0A071393Frame · gougedCABIN LEFT FRAME GOUGED AT STATION 1231 NEAR LONGERON 17L. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLE, FILLER, STAMP AND INSTALLED.SDR WX0A071421Cusp Web · corrodedCABIN LEFT CUSP WEB 3 AREAS OF CORROSION STATION 712 TO 786. CUT OUT DAMAGED AREAS, FABRICATED REPAIR FILLERS, RING DOUBLERS, REPAIR DOUBLERS AND INSTALLED.SDR AALA20121122003Elbow · looseDFW - CREW REPORTED NO PRESSURIZATION DURING TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. RE-SECURED LOOSE ELBOW CONNECTION ON RIGHT PRESSURE REGULATOR VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR WX0A071397Skin · chafedFWD CARGO DOOR EXTERNAL SKIN CHAFED OUT OF LIMITS AT FWD LOWER CORNER. CUT OUT DAMAGED AREA, FABRICATED, DOUBLER, FILLER, LOCATED AND INSTALLED.SDR AALA20121126004Attach Fitting · crackedRIGHT WING, NUMBER 4 SLAT, NUMBER 12 TRACK, HAS A CRACK INDICATION. INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR WX0A071392Cusp Web · crackedCABIN LEFT CUSP WEB CRACKED AT STATION 810 LBL 55. CRACK MEASURES .400. CUT OUT CORROSION AND FABRICATED REPAIR DOUBLER DRILLED AND INSTALLED.SDR AALA20121121007Skin · dentedLEFT SIDE DEEP DENT IN FUSELAGE SKIN AT STATION 436, BELOW LONGERON 21 LEFT. INSTALLED EXTERNAL DOUBLER PER SRM 53-04-03 FIGURE SHEET 1.SDR AALA20121121005Attach Fitting · wornLEFT WING NUMBER 4 SLAT OUTBOARD KNUCKLE WORN. REMOVED OUTBOARD ATTACH FITTING AND INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20121201017Skin · crackedLEFT ELEVATOR UPPER SKIN HAS CRACK IN TRAILING EDGE EXTENSION ABOVE GEAR TAB OUTBOARD CRANK. INSTALLED DOUBLER PER EA MD80-55-027320.SDR AALA20121201003Skin · dentedRIGHT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 12 INCHES FROM INBOARD END AND 3 INCHES UP FROM TRAILING EDGE OF ELEVATOR. INSTALLED DOUBLER PER SRM 51-70-06.SDR AALA20121201002Skin · dentedRIGHT ELEVATOR TOP SKIN HAS TWO DENTS LOCATED APPROXIMATELY 150 INCHES FROM INBOARD END AND 10 INCHES FROM TRAILING EDGE OF ELEVATOR. INSTALLED REPAIR DOUBLER PER SRM 51-70-06.SDR AALA20121119019Longeron · crackedLONGERON 4 LEFT CRACKED FROM STATIONS 160 AND 200. ACCOMPLISHED SPLICE REPAIR PER SRM 53-02-00 FIGURE 18.SDR AALA20121119007Door · damagedFORWARD ENTRY DOOR DAMAGED AT LOWER FORWARD CORNER. STRAIGHTENED LOWER EDGE OF FORWARD ENTRY DOOR, DYE CHECKED AND NO CRACKS FOUND. INSTALLED DOUBLER PER AARD 52-10-00-02 FIGURE 1.SDR AALA20121118001Charger · inoperativeDFW - CREW REPORTED BATTERY CHARGER LIGHT ILLUMINATED AND CIRCUIT BREAKER POPPED IN FLIGHT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITH INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BATTERY CHARGER AND BOTH BATTERIES. SYSTEM GROUND CHECK NORMAL SDR AALA20121116019Structure · damagedDAMAGE TO STATION 400 AT LONGERON 19 LEFT. INSTALLED DOUBLER AND SHIMS PER SRM 53-04-02.SDR AALA20121130007Structure · corrodedSUB-FLOOR AT STATION 160, RIGHT BUTTLINE 11 CORRODED. INSTALLED SUB FLOOR DOUBLER PER AARD 53-20-00-16.SDR AALA20121116018Skin · damagedDAMAGE TO SKIN FROM STATIONS 503 TO 512, LONGERON 22 TO 23 RIGHT. INSTALLED DOUBLER PER SRM 53-04-03.SDR AALA20121116006Battery · not seatedCEILING EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY FOR 10DEF AND FOR RIGHT AFT LAVATORY. OPS CHECK NORMAL.SDR AALA20121115011Web · crackedWEB IS CRACKED AT STATION 208 AT LONGERON 15 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20121115010Cusp Web · corrodedBOTTOM OF RIGHT CUSP AT STATION 702 CORRODED. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20121115001Intercostal · crackedSTATIONS 1271 TO 1287, CABIN FLOORBOARD INTERCOSTAL CRACKED AT FASTENER HOLE. REMOVED DAMAGED INTERCOSTAL AND INSTALLED SERVICEABLE INTERCOSTAL FROM STATIONS 1271 TO 1287 AS PER AARD 51-00-05-1.SDR AALA20121129007Membrane · corrodedSUBFLOOR UNDER G-1 DRAIN PAN IS CORRODED. REMOVED CORROSSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20121115003Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 4B INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT SEAT 4B. OPS CHECK NORMAL.SDR AALA20121115002Battery · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK ARE INOPERATIVE. RESEATED BATTERIES IN PACK FOR EMERGENCY LIGHTS IN CATWALK. OPS CHECK NORMAL.SDR AALA20121114016Skin · crackedFORWARD FUSELAGE HAS CRACK AND LOOSE FASTENERS IN SKIN, AFT OF LEFT AFT CORNER OF NOSE LANDING GEAR CUTOUT. INSTALLED DOUBLER REPAIR PER SRM 53-01-00 FIGURE 2 AND AARD 53-30-01-2.SDR AALA20121114015Pan · crackedRIGHT WINDOW RING PAN CRACKED UPPER AFT CORNER AFT OF STATION 788. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20121113009Controller · inoperativeDFW - CREW REPORTED LOSS OF ELECTRICAL POWER DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER TWO CABIN CONTROLLER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20121113012Oxygen Bottle · low pressureBNA - INFLIGHT BWI-DFW. CREW REPORTED FLIGHT DECK CREW O2 LOW PRESSURE. EMERGENCY DECLARED FLIGHT DIVERTED BNA LANDED WITHOUT INCIDENT. REPLACED FLIGHT DECK CREW O2 BOTTLE. SYSTEM GROUND CHECK NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82