Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 DALA2025112708682Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-1552.5 BETWEEN FR 33 AND FR 34. REPLACED SEAT TRACK PER A330 SRM 51-72-11 REV 127.03-NOV-16-2025. (LP 1323750)SDR DALA2025112708681Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-1447.8 BETWEEN FR 75 AND FR 76. SEAT TRACK REPLACED AS PER A330 SRM 51-72-11 REV 127.03-NOV-16-2025. (LP 1323741)SDR DALA2025112708680Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT YC1 BETWEEN FR 73 AND FR 74. SEAT TRACK REPLACED AS PER SRM 51-72-11 REV 127.02-OCT-09-2025. (LP 1323719)SDR KCSA202511271227Lamp · inoperativeONE LIGHT INOP IN MAIN DECK EMERGENCY LIGHT ASSEMBLY.SDR SWIA2025112676562Intercostal · corrodedPAX DOOR MID DD3 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW MID DD3 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 REV. 38 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA2025112676535Floorbeam · corrodedRH CROSSBEAM AT FS 280.00 HAS CORROSION TRANS 31259851 (C-CHECK RO 07/02/2026)REMOVED AND INSTALLED NEW RH CROSSBEAM AT FS 280.00 REF CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-22-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01 AND DWG CC670-34010 REV -K.SDR REXA2026052700779Channel · crackedCRACK ON CHANNEL AT AFT BAGGAGE BAY STRUCTURE CRACK ON CHANNEL AT AFT BAGGAGE BAY STRUCTURE WAS REPAIRED PER EA CRJ953-20952 REV IRSDR SWIA202604175725Skin · scratchedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA106889-601R-52-31-439 REV. -A 2025-11-20 MXCODEID118398-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 106889DUE TO SCRATCH ON THE OUTSIDE TOP OF THE CARGO DOOR, PER REO 601R-52-31-439 REV. -A 2025-11-20, PERMANENT REPAIRSDR SWIA2026031075497Slat Track · damagedLH WING SLAT TRACK 5 LOWER SURFACE LAND HAS SIGNS OF PITTING AND OB ROLLER LAND HS GROOVES. PERFORMED BLENDED OUT AND EVALUATED AREAS ON LH WING SLAT TRACK 5 LOWER SURFACE LAND AND ROLLER LAND, FOUND TO BE STRUCTURALLY AND FUNCTIONALLY ACCEPTABLE IAW SRM 51-1SDR SWIA2026022705383Floor Support · corrodedCORROSION FOUND ON FLOOR BEAM AT WL 73.00 AND RBL 9.00 FROM FS 565.00 - FS 581.00 (C-CHECK RO 02/25/2026)COMPLIED WITH REO 670-53-31-1142 DATED: 2025-12-16 REV"A" DISPOSITION FOR ELONGATED HOLES AND LOW E.D. CONDITION ON RBL9.0 FLOOR BEAM AND REPAIR SPLICE BSDR SWIA202602274474Buttstrap · corrodedCORROSION ON BUTTSTRAP AT FS280.00 BTW STR 25R - STR 23R (C-CHECK RO 02/25/2026)CHAFFING UNDER FUSELAGE SKIN ON STRG 27, FS 977.00 TO 989.00 BLEND-OU AND FOUND WITHIN LIMITS IAW MHICRJ700 SRM 53-00-01-101-001-A01, L:3" W:2" D:0.016",SURFACE REPROTECTED IASDR SWIA2026022575327Floorbeam · corrodedFOUND SURFACE CORROSION ON THE RH FLOOR BEAM UPPER FLANGE/SEAT TRACK MOUNTING SURFACE FS 582.00 RBL 9.00 & FS 585.00 RBL 9.00. (C-CHECK RO 02/22/2026)COMPLIED WITH REO 670-53-31-1131 REV-- DATED 2025-11-28 AND BLENDED SURFACE CORROSION ON THE RH FLOOR BEAM USDR SWIA2026022575314Pressure Blkhd · corrodedFOUND SURFACE CORROSION ON THE LH FORWARD PRESSURE BULKHEAD FITTING UPPER SURFACE FLANGE FS 686.00 - FS 698.00 & LBL 9.00 (C-CHECK RO 02/22/2026)COMPLIED WITH REO 670-53-41-777 REV-- DATED 2025-11-28. AND BLENDED SURFACE CORROSION ON THE LH FORWARD PRESSURESDR HNAA2026012100046Shear Tie · crackedSHEAR CLIP IS CRACKED AT FRAME 25 BETWEEN STRINGERS 15R-16R. REMOVED AND REPLACED SHEAR CLIP AT FRAME 25 BETWEEN STRINGERS 15R-16R IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100045Shear Tie · crackedSHEAR CLIP IS CRACKED AT FRAME 24 BETWEEN STRINGERS 15R-16R. REMOVED AND REPLACED SHEAR CLIP AT FRAME 24 BETWEEN STRINGERS 15R-16R IAW EMB 145 SRM 51-40-02SDR HNAA2026012100025Floorbeam · corrodedCORROSION ON LT NR 2 FLOORBEAM ISLE AREA AT FRAME 29. REMOVED CORROSION ON LT NR 2 FLOORBEAM ISLE AREA AT FRAME 29 IAW EMB 145 SRM 51-10-03. BLEND OUT IS ACCEPTED AS PERMANENT REPAIR IAW ETD2025-145-933947 AND EO1-05-26-0006.SDR HNAA2026012100024Floor Support · corrodedCORROSION ON LT OTBD #2 FLOOR SILL. R & R L/H OTBD #2 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100023Seat Track · corrodedCORROSION ON RH INBD NR 4 SEAT TRACK. REMOVED AND REPLACED RT INBD NR 4 SEAT TRACK IAW EMB 145 AMM 53-01-06.SDR HNAA2026012100022Gusset · corrodedCORROSION IN LAV AREA ON LH FLOORBEAM GUSSET. RAR LH FLOORBEAM GUSSET IN LAV IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100021Gusset · corrodedCORROSION IN LAV AREA ON CENTER FLOORBEAM GUSSET. R & R CENTER FLOORBEAM GUSSET IN LAV IAW EMB 145 SRM 51-40-02.SDR HNAA2026012100020Gusset · corrodedCORROSION IN LAV AREA ON RH FLOORBEAM GUSSET. RAR RH FLOORBEAM GUSSET IN LAV IAW EMB 145 SRM 51-40-02.SDR SWAA2026011339885Light · burnedBURNED SEGMENT OVERWING EXIT LIGHT. REPLACED THE SEGMENT OVERWING EXIT LIGHT IAW AMM 33-20-00-710- 804-001, AND AMM 33-21-00-960-805.SDR SWAA2025123040076Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 14 WL 208.1. REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 14 WL 208.1 AT PASSENGER CABIN SRM 51-40-02, DWG 143A5400, SHEET 38, REV A.SDR SWAA2025123040190Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 294.5, STR 13L AT FWD GALLEY AREA. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 294.5 AT LEVEL STR 13L AT FWD GALLEY IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 141A1311, SHEET 1, REV C.SDR SWAA2025123040090Plate · crackedRIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE I/B SIDE IS CRACKED. REMOVED AND REPLACED RIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE I/B SIDE. IAW SRM 51-40-02-0G-0.SDR SWAA2025123046230Attach Angle · crackedBS 663 FWD OF LT A/C BAY; APPROXIMATE LBL 9, VAPOR BARRIER ATTACH ANGLE IS CRACKED AT FIRST FASTENER INBD OF THE SILICONIZED FLEX SEAL. HFEC VERIFIED. REMOVED BS 663 LT A/C BAY VAPOR BARRIER ATTACH ANGLE IAW SRM 57-10-10-2R-5, AND SRM 51-40-02. COMPLIED WSDR SWAA2025123040177Attach Angle · crackedBS 663 FWD OF LT A/C BAY, APPROXIMATE LBL 34; VAPOR BARRIER ATTACH ANGLE IS CRACKED AT FIRST FASTENER INBD OF THE SILICONIZED FLEX SEAL. HFEC VERIFIED. COMPLIED WITH NDT OF HOLES COMMON TO FUEL TANK UPPER ATTACH ANGLE PER NDT MANUAL PART 6, 51-00-00 FIG. 16.SDR SWAA2025123046232Attach Angle · crackedBS 663, FWD OF RT A/C BAY. APPROXIMATE RBL 9, VAPOR BARRIER ATTACH ANGLE CRACKED AT FIRST FASTENER INBD OF THE SILICONIZED FLEX SEAL. HFEC VERIFIED. REMOVED BS 663 RT A/C BAY VAPOR BARRIER ATTACH ANGLE IAW SRM 57-10-10-2R-5 AND SRM 51-40-02. COMPLIED WITH SDR SWAA2025123040180Attach Angle · crackedBS 663, FWD OF RT A/C BAY, APPROXIMATE RBL 34, VAPOR BARRIER ATTACH ANGLE IS CRACKED AT FIRST FASTENER OTBD OF THE SILICONIZED FLEX SEAL. HFEC VERIFIED. COMPLIED WITH NDT OF HOLES COMMON TO FUEL TANK UPPER ATTACH ANGLE IAW NDT MANUAL, PART 6, 51-00-00, FIG SDR SWAA2025122940078Support Angle · crackedCRACK ON SUPPORT ANGLE BTW BS 380 - 400, RBL 10, WL 208.1. REPLACED SUPPORT ANGLE IAW SRM 51-40-02, DRAWING 143A5400, SHEET 38, REV A.SDR SWAA2025122940079Support Angle · crackedCRACK ON SUPPORT ANGLE BTW BS 380 - 400, LBL 52, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DRAWING 143A5400, SHEET 38, REV A.SDR SWAA2025122946830Support Angle · crackedCRACK ON SUPPORT ANGLE BTW BS 380 - 400, LBL 14, WL 208.1 IN PASSENGER CABIN. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, DRAWING 143A5400, SHEET 38, REV A.SDR SWAA2025122940186Rib · crackedCRACKED ACCESS PANEL 341B RIB, LE STA 105.26 ON RT HORIZONTAL STAB. REPLACED THE RIB AND FASTENERS IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, & DWG 186A1001, SHEET 19, AND REV-.SDR SWAA2025122940187Rib · crackedCRACK ACCESS PANEL 341B RIB, LE STA 114.55 ON THE RT HORIZONTAL STAB. REPLACED RIB AND FASTENERS ON ACCESS PANEL 341B IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 186A1001, SHEET 19, REV-.SDR SWAA2025122940081Frame · crackedCRACKED FRAME, BS 312, BTW S5 - 6L AT FWD GALLEY AREA. PERFORMED REPAIR AT FRAME BS 312 AND BETWEEN S5 - 6L IAW M-22-153-01244.SDR SWAA2025122940077Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 - 400, BL 0, WL 208.1. REPLACED SUPPORT ANGLE IAW SRM 51-40-02, DRAWING 143A5400, SHEET 38, REV A.SDR SWAA2025122946831Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT BS 294.5, STRINGER 13L IN FWD GALLEY AREA. REPLACED SUPPORT ANGLE AND FASTENERS BS 294.5, STRINGER 13L IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 141A1311, SHEET 1, REV C.SDR SWI2025F01850Floorbeam · corrodedAFT WET AREA, RT FLOORBEAM HAS CORROSION AT FR 87. (C-CHECK RO 12/19/2025)REMOVED AND REPLACED CENTER FUSELAGE III RH FLOORBEAM PN170-65669-004 PO#338352 IAW EMB 175 SRM 51-40-08. FASTENERS USED. WEIGHT AND BALANCE IS NOT AFFECTED BY REPAIR. NO FURTHER ACTIONSDR SWIA20251222126Floor Support · corrodedFWD WET AREA FLOOR SUPPORT HAS CORROSION BETWEEN FR 12-13 AND Y+10 REPAIRED FWD WET AREA FLOOR BEAM BETWEEN FR 12-13 AND Y+10 REF EMB 175 SRM 53-10-10/REPAIR01. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR SWAA2025121740218Tray · brokenBROKEN TRAYS PAX SEATS, ROWS 10D, 12E, 14E, 15E, 16E, AND 18D RT SIDE. REPLACED THE TRAYS IAW CMM 25-21-45-3860, REV 6, PAGE 10088, FIGURE 4, ITEM 60, AND SOPM 20-50-01, REV 40.SDR ASAA2025112663082Floor Support · corrodedFLOOR SUPPOR BS 947-967, LBL 24 HAD SEVERAL AERAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION ON THE FLOOR SUPPORT BS 947-967, LBL 24, LOST .035" OF MATERIAL FOUND BEYOND LIMITS IAW SRM 53-70-51-1A-1, R & R THE FLOOR SUPPORT, PO# 1138081.2 IAW SRM 51-40SDR ASAA2025112663081Floor Support · corrodedFLOOR SUPPORT AT BS 947-967 RBL 24 HAS SEVERAL AERAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION ON FLOOR SUPPORT AT BS 947-967, RBL 24, LOST .030" OF MATERIAL FOUND BEYOND LIMITS IAW SRM 53-70-51-1A-1, REMOVED AND REPLACED INTERCOSTAL. PO 1138081.1 IAW SSDR SWAA2025121640061Support Angle · crackedLEFT WING AFT SPAR AREA, 21 INCHES INBD OF DEFLECTION CONTROL RIB SUPPORT ANGLE FOR FIXED WING UPPER PANEL JUST OTBD OF NR 6 SPOILER, CRACKED. REMOVED THE SUPPORT ANGLE IAW SRM 51-40-02, & AIPC 27-62-12-05, ITEM 55. LOCATED & DRILLED IAW SRM 51-40-05-0G-0.SDR SWAA2025121640062Support Angle · crackedRIGHT WING AFT SPAR AREA, 21 INCHES INBD OF DEFLECTION CONTROL RIB SUPPORT ANGLE FOR FIXED WING UPPER PANEL JUST OTBD OF NR 7 SPOILER, CRACKED. REMOVED AND REPLACED THE SUPPORT ANGLE FOR FIXED WING UPPER PANEL IAW SRM 51-40-02-0G-0, DWG 115A2512, REV -, AND SDR SWAA2025121640063Support Angle · crackedRIGHT WING AFT SPAR AREA UPPER WING FIXED PANEL SUPPORT ANGLE JUST INBD AND COMMON TO THE DEFLECTION CONTROL RIB CRACKED. REMOVED AND REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, AND DWG 115A6200, REV A.SDR SWAA2025121640094Tee Angle · damagedELONGATED HOLE ON TEE ANGLE TRAILING EDGE LOCATED AT ORSS250 APPROX, RT WING. REPLACED THE TEE ANGLE IAW SRM 51-10-02, ITEM 9, & SRM 51-20-01.SDR SWAA2025121647512Angle · elongatedELONGATED HOLE ON TEE ANGLE TRAILING EDGE LOCATED AT ORSS250 APPROX, RT WING. REPLACED THE TEE ANGLE LOCATED TRAILING EDGE IAW SRM 51-10-02, ITEM 9, AND SRM 51-20-01.SDR SWAA2025121540176Attach Angle · crackedBS 663, FWD OF LT A/C BAY, APPROXIMATE LBL 9, VAPOR BARRIER ATTACH ANGLE IS CRACKED AT FIRST FASTENER INBD OF THE SILICONIZED FLEX SEAL. HFEC VERIFIED. REMOVED THE BAY VAPOR BARRIER ATTACH ANGLE IAW SRM 57-10-10-2R-5, AND SRM 51-40-02. COMPLIED WITH NDT OF SDR SWAA2025121540179Attach Angle · crackedBS 663, FWD OF RT A/C BAY, APPROXIMATE RBL 9, VAPOR BARRIER ATTACH ANGLE IS CRACKED AT FIRST FASTENER INBD OF THE SILICONIZED FLEX SEAL. HFEC VERIFIED. REMOVED THE VAPOR BARRIER ATTACH ANGLE IAW SRM 57-10-10-2R-5, AND SRM 51-40-02. COMPLIED WITH NDT OF HOLSDR SWAA2025121539783Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561BB ON LT WING. REPAIRED THE ACCESS PANEL 561BB IAW SRM 51-70-04-2R-10, REPAIR 10.