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 AALA20110316TUL03Cusp Web · corrodedCUSP MEMBRANE AT FORWARD ENTRY AREA HAS CORROSION FROM STATIONS 170 TO 200. INSTALLED DOUBLER AS PER AARD 53-20-00-16.SDR AALA20110316TUL01Cusp Web · corrodedRIGHT CUSP SHEET OUT OF LIMITS STATIONS 1022 TO 1098. COMPLETED INSTALLATION OF NEW CUSP SHEET BETWEEN STATIONS 1022 TO 1098 PER AARD 51-10-00-05.SDR AALA20110315TUL04Cusp Web · corrodedLEFT CUSP CORROSION OUT OF LIMITS FROM STATIONS 1250 TO 1309. REMOVED AND REPLACED CUSP SHEET PER AARD 51-10-00-5.SDR AALA20110315TUL03Cusp Web · corrodedRIGHT CUSP SHEET IS OUT OF LIMITS FROM STATIONS 598 TO 712. INSTALLED NEW CUSP PER AARD 51-10-00-5 AND EA MD80-51-015719.SDR AALA20110315TUL01Cusp Web · crackedCRACK IN CUSP STATION 224. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20110502TUL03Spar Cap · crackedRIGHT WING LOWER REAR SPAR CAP AT STATION XRS 164 HAS CRACK INDICATION APPROXIMATELY 1/4 INCH LONG CONFIRMED WITH HFEC SCAN. REPAIRED PER EA MD80-57-016677.SDR AALA20110314TUL10Seat Track · corrodedCORROSION REMOVAL BEYOND LIMITS ON SEAT TRACK NUMBER 2 FROM STATIONS 223 TO 224. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20110314TUL09Support Angle · crackedCABIN ABOVE CENTER TANK INTERCOSTAL LOWER SUPPORT ANGLE CRACKED AT STATION 826 BELOW NUMBER 2 SEAT TRACK. INSTALLED ANGLE DOUBLERS PER EA MD80-53-015688.SDR AALA20110314TUL08Seat Track · corrodedNUMBER 6 SEAT TRACK STATION 1105 PLUG BLENDED OUT OF LIMITS. NUMBER 6 SEAT TRACK PLUG INSTALLED PER 53-20-00-10.SDR AALA20110314TUL07Support Angle · crackedCABIN ABOVE CENTER TANK VERTICAL SUPPORT ANGLE LOWER LEG CRACKED AT STATION 927 BELOW NUMBER 5 SEAT TRACK. INSTALLED REPAIR DOUBLER AND FILLER PER EA MD80-53-015690.SDR AALA20110314TUL04Shear Tie · crackedAFT ACCS SHEAR TIE CRACKED AFT SIDE OF 1451 AFT OF LONGERON 2 LEFT. INSTALLED NEW SERVICEABLE SHEAR TIE AT STATION 1451 LONGERON 2 LEFT PER SRM 51-30-05.SDR AALA20110314TUL01Skin · dentedDENT IN BOTTOM OF SKIN APPROXIMATELY 6 FEET OUTBOARD OF ELEPHANT EAR FAIRING, LEFT HAND INBOARD FLAP. FABRICATED AND INSTALLED PERMANENT FLUSH REPAIR DOUBLER AND FILLER PER SRM 57-01-00, FIGURE 5 SHEET 2 AND AARD 51-60-00-05 AND SRM 51-30-02, PARAGRAPH 11.SDR WX0A070803Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20110313TUL03Cusp Web · crackedRIGHT CUSP STATION 1004 CRACKED ON INBOARD EDGE. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20110312TUL02Support Angle · crackedCABIN ABOVE CENTER TANK INTERCOSTAL LOWER SUPPORT ANGLE CRACKED AT STATION 826, BELOW NUMBER 5 SEAT TRACK. REPAIRED CENTER TANK INTERCOSTAL LOWER SUPPORT ANGLE AT STATION 826, BELOW NUMBER 5 SEAT TRACK PER EA MD80-53-015688.SDR AALA20110312TUL01Seat Track · corrodedNUMBER 5 SEAT TRACK STATION 235 PLUG BLENDED OUT OF LIMITS. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20110311DFW01Control Valve · failedDFW - CREW REPORTED RIGHT PACK FAILED ON TAKEOFF WITH LEFT PACK ON PLACARD. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT TEMP CONTROL VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110310TUL03Mount · damagedNUMBER 1 GALLEY INBOARD TIE DOWN FITTING HAS CORROSION STATION 160. INSTALLED NEW GALLEY MOUNT PER AARD 51-10-00-5.SDR WX0A070802Battery · dischargedDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA20110310LAS01Battery Pack · dischargedBOTH FORWARD INTERIOR OVERWING EXIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY EVACUATION LIGHTS. OPS CHECK NORMAL.SDR AALA20110309TUL04Fitting · corrodedNUMBER 2 GALLEY INBOARD TIE-DOWN FITTING HAS CORROSION STATION 218 INBOARD OF NUMBER 4 SEAT TRACK. INSTALLED NEW NUMBER 2 GALLEY INBOARD TIE-DOWN FITTING PER AARD 51-10-00-5.SDR AALA20110309TUL02Pan · crackedWINDOW PAN CRACKED AT LOWER FORWARD TAB LEFT STATION 1060. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110309TUL01Skin · dentedFUSELAGE LEFT SIDE DENT IN FUSELAGE SKIN AT STATION 370 APPROXIMATELY JUST BELOW LONGERON 27 LEFT. REPAIRED DAMAGE AT STATION 370 LONGERON 27 LEFT PER SRM 53-04-00 FIGURE 38 VIEW E.SDR AALA20110308TUL07Pan · crackedRIGHT WINDOW PAN CRACKED AT UPPER FORWARD SIDE AT STATION 927. REMOVED CRACK BY ROUTING PER AARD 53-10-00-25 AND INSTALLED REPAIR DOUBLER CDK 3488-2 PER AARD 53-10-00-25.SDR AALA20110308TUL06Pan · crackedRIGHT WINDOW PAN CRACKED, UPPER FORWARD SIDE AT STATION 946. REMOVED DAMAGE BY ROUTING PER AARD 53-10-00-25 AND INSTALLED REPAIR DOUBLER CDK 3488-2 PER AARD 53-10-00-25.SDR AALA20110308LAX02Valve · failedLAX - INFLIGHT DFW-SAN. CREW REPORTED WHEN LANDING GEAR WAS EXTENDED, ALL ANTISKID LIGHTS CAME ON. CYCLED GEAR AFTER GO AROUND, AND AGAIN ALL ANTISKID LIGHTS CAME ON. RAN QRH CHECKLIST. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. WHENSDR AALA20110302TUL09Longeron · crackedLONGERON 2 LEFT IS CRACKED ON OUTBOARD FLANGE, AFT OF FRAME 1418. REPAIRED PER SRM 53-02 AND EA MD80-53-015548.SDR EE4Y20110133Skin · corrodedSKIN CORRODED AT STA Y725 BTWN LONG 29R AND LONG 30R.SDR EE4Y20110132Skin · corrodedSKIN CORRODED LOCATED FROM STA Y1155 TO STA Y12111 BTWN LONG 26R AND LONG 28RSDR EE4Y20110131Skin · corrodedSKIN CORRODED LOCATED FROM STA Y180 TO STA Y190 BTWN LONG 29L AND LONG 30SDR EE4Y20110120Skin · dentedLOWER FUSELAGE AT STA Y441.5 BTWN LONG 21R AND LONG 22R SKIN DENTED.SDR EE4Y20110119Skin · damagedLOWER FUSELAGE AT STA Y257 BTWN LONG 21R AND LONG 22R SKIN WITH BLENDOUTSDR EE4Y20110118Skin · dentedLOWER FUSELAGE AT STA Y359 BTWN LONG 21R AND LONG 22R SKIN DENTEDSDR EE4Y20110116Skin · dentedLOWER FUSELAGE AT STA Y459 BTWN LONG 21R AND LONG 22R SKIN DENTEDSDR EE4Y20110117Doubler · crackedDOUBLER CRACKED LOCATED LT WING UPPER SURFACE AT STA XCW110 MLGSDR EE4Y20110127Longeron · corrodedLOWER FUSELAGE AFT CARGO COMPARMENT LONGERON 29LH WITH CORROSIONAT STA Y 1026SDR EE4Y20110126Longeron · corrodedLOWER FUSELAGE AFT CARGO COMPARMENT LONGERON 30 WITH CORROSION FROM STA Y 1024 TO STA Y 1032SDR EE4Y20110125Skin · bulgedLOWER FUSELAGE STA 216 BETWEEN LONGERONS 18R AND 19R SKIN BULGED.SDR EE4Y20110124Skin · dentedLOWER FUSELAGE STA 215 BETWEEN LONGERONS 18L AND 19L SKIN DENTED.SDR EE4Y20110123Skin · bulgedLOWER FUSELAGE AT STA 229 BETWEEN LONGERONS 30 AND 29L SKIN BULGEDSDR EE4Y20110122Skin · dentedLOWER FUSELAGE, AT Y STA 359 BETWEEN LONGERONS 21R AND 22R SKIN DENTED.SDR EE4Y20110121Skin · dentedLOWER FUSELAGE AT Y STA 1305 BETWEEN LONGERONS 18R AND 19R SKIN WITH DENT AND SCRATCH.SDR AALA20110222TUL01Web · corrodedHEAVY CABIN CORROSION ON SUBFLOOR, APPROXIMATELY 6 INCHES INBOARD OF FORWARD SERVICE THRESHOLD ATTACH CHANNEL, STATIONS 180 TO 190. INSTALLED REPAIR DOUBLER AND OVERLAY DOUBLER AT STATIONS 160 TO 200 RIGHT BUTTLINES 41 TO 57 PER AARD 53-20-00-16.SDR AALA20110219TUL01Cusp Web · corrodedSTATION 220, CRACK IN RIGHT CUSP BELOW NUMBER 6 SEAT TRACK. STATION 218, CRACK IN RIGHT CUSP OUTBOARD OF NUMBER 5 SEAT TRACK. REMOVED CRACKED CUSP SHEET AND INSTALLED SERVICEABLE CUSP SHEET AT STATIONS 218 TO 237 PER AARD 51-10-00-5.SDR AALA20110218TUL06Fitting · damagedMIS-DRILLED HOLE RIGHT BUTTLINE 59 AND RIGHT STATION 229. INSTALLED DOUBLER PER EA MD80-53-015353.SDR AALA20110218TUL04Pan · corrodedCORROSION FOUND AT AFT LAV PAN. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER SRM 53-04 FIGURE 38.SDR AALA20110218LGA01Battery Pack · dischargedCEILING LIGHTS ROW 16 INOPERATIVE. REPLACED BATTERY PACK, OPS CHECK NORMAL.SDR AALA20110218TUL01Plate · corrodedSTATION 1174 LONGERON 28 RIGHT, AFT CARGO DOOR CUTOUT, PLATE ON WEB HAS CORROSION. INSTALLED SERVICEABLE PLATE PER AARD 51-10-00-5 AND EA MD 80-51-015302.SDR AALA20110217TUL22Floorbeam · damagedMISDRILLED HOLE STATION 200 RIGHT BUTTLINE 56 ON FLOORBEAM. INSTALLED FLOORBEAM REPAIR STRAP STATION 200 RIGHT BUTTLINE 56 PER EA MD80-53-015352.SDR EE4Y20110115Fitting · corrodedREPORTED FITTING CORRODED LOCATED AT AFT CARGO COMPT AT STA 1231 BTWN LONG 27R AND LONG 28R. THE FITTING DAMAGED WAS REPLACED.
Back to Mcdonnell Douglas DC-9-82