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 SCNA20251230513Engine · fireAFTER ENGINE SHUTDOWN NUMBER TWO ENGINE FLARED UP OUTISDE OF PLUG, HAND HELD FIRE EXTINGUSHER WAS APPLIED TO SUPPRESS FIRE. REMOVED & REPLACED #2 ENG PER TASK CARD 710000000 W/O# 101157. LEAK AND OPS TEST GOOD. OK FOR SERVICE.SDR UIEA2025123001362Rib · corrodedLH WING FIXED LEADING EDGE RIB CORROSION. REMOVED CORROSION AT LH WING FIXED LEADING EDGE RIB AS PER SRM 57-41-13-1A-1 ILES 338.33-ILES 375.50 L: 1.1"" W: 16.15"", ILES 375.50 - ILES 414.50 L: 1.1"" W: 29.92". PERFORMED SURFACE HFEC INSPECTION AT LH WING FIXESDR REXA2026073101378Seat Track · corrodedCORROSION ON RT SIDE SEAT TRACK (11 EAS) FROM BS 379 - 977 AT STR 15R IN PAX CABIN. CORROSION ON RT SIDE SEAT TRACK WAS EVALUATED OUT LIMITS IAW SRM 53-41-49-101-001-A02, SRM 53-51-49-101-001-A02, SRM 53-21-49-101-001-A01, AND SRM 53-31-49-101-001-A02, WAS RSDR REXA2026073101377Seat Track · corrodedCORROSION ON LT SIDE SEAT TRACK (12 EAS) FROM BS 379 - 977, STGR 15L IN PAX CABIN. THE LT SIDE SEAT TRACK (12 EAS) FROM BS 379 TO 977 AT STR 15L AT PAX CAB. WERE EVALUATED OUT LIMITS IAW SRM 53-21-49-101-001-A01, SRM 53-41-49-101-001-A02, AND SRM 53-51-49-1SDR REXA2026073101369Fitting · corrodedCORROSION ON FITTINGS OF ACCESS 306 (2 EA) AT GALLEY 3. NEW FITTINGS OF ACCESS 306 (2 EA) AT GALLEY 3 WERE FABRICATED IAW EA CRJ953-21295 REV: IR. AND INSTALLED IAW CMM 25-33-18SDR REXA2026073101353Seat Track · corrodedCORROSION ON FLOOR SEAT RAILS RBL9 BTW FS850.00 TO FS977.00 AT CPAX. DUE TO EXCESIVE DAMAGE FLOOR SEAT RAILS RBL9 BTW FS850.00 TO FS977.00 AT CPAX WILL BE REPLACED PER CRJ-900 SRM 53-51-49-101-001-A02 AND WERE REPLACED PER CRJ-900 AMM 53-00-49 AND INSTALLED PSDR SWIA2025122975825Roller · frozenLH OUTBD FLAP INBD GUIDE ROLLER FROZEN. REMOVED AND REPLACED LH O/B FLAP I/B GUIDE ROLLER PER CRJ 200 SRM 51-41-02 TW TUC4606 DUE 30-JUN-2026SDR SWIA2025122975824Roller · frozenRH OUTBD FLAP INBD GUIDE ROLLER FROZEN CAMP # 31447488. REMOVED AND REPLACED RH O/B FLAP I/B GUIDE ROLLER PER SRM 51-41-02 TW TUC4606 DUE 30-JUN-2026SDR SWIA2026040375664Roller · out of limitsUPON REMOVAL OF THE LT SLAT TRACK 3-2 SIDE ROLLERS FOUND 3 ROLLERS IN NEED OF REPLACEMENT. REMOVED AND INSTALLED NEW SERVICEABLE LT WING SLAT TRACK 2-2 SIDE ROLLERS 3EA INTO BRACKETS IAW SRM 51-42-07-001-001-A01 AND AMM SKY WEST SUPPLEMENT SW1636DATED 5 MAY 2SDR SWIA2026040375663Roller · out of limitsUPON REMOVAL OF THE LT SLAT TRACK 2-2 SIDE ROLLERS FOUND ALL FOUR ROLLERS TO BE IN NEED OF REPLACEMENT REMOVED AND INSTALLED NEW SERVICEABLE SLAT TRACK 2-2 SIDE ROLLERS 2EA INTO BRACKETS IAW SRM 51-42-07-001-001-A01 AND AMM SKYWEST SUPPLEMENT SW1636 DATED 5SDR SWIA2026040375662Roller · out of limitsUPON REMOVAL OF THE LT SLAT TRACK 1-2 SIDE ROLLERS, FOUND THREE ROLLERS TO BE IN NEED OF REPLACEMENT. REMOVED AND INSTALLED NEW SERVICEABLE LT 1-2 SIDE ROLLERS INTO BRACKET IAW SRM 51-42-07-001-001-A01, AMM SW1631, AND RIL 2631 REV A.SDR REXA2026030900185Floor Support · corrodedCORROSION ON UPPER FACE OF FLOOR BEAM LBL 27 BTW FS 1000.00 TO FS 1047.00 ON AFT CARGO COMPARTMENT FLOOR STRUCTURE. CORROSION ON UPPER FACE OF FLOOR BEAM LBL 27 BTW FS 1000.00 TO FS 1047.00 ON AFT CARGO COMPARTMENT FLOOR STRUCTURE WAS EVALUATED OUT OF LIMITS PSDR SWIA2026022574933Floor Support · corrodedGALLEY FLOOR SUPPORT FWD OUTBOARD FITTING IS CORRODED. REMOVED AND REPLACED GALLEY FLOOR SUPPORT FWD OUTBOARD FITTING WITH REFERENCE TO SRM 51-42-21.SDR BAGA2026020500002Barrel · corrodedCORROSION FOUND AT WASTE DOUBLER ACCESS AT REAR BARREL. REPAIRED PER AIRBUS REO.SDR CALA2026020513593Blade · damagedDURING CLIMB OUT AT 1500 FT. BIRDSTIKE RT ENG, ENG POWER SURGE WITH VIBRATION. PREFORMED FIM 71-05/801. NR 2 ENG IP2S, IP4S, & IP6S BOROSCOPE PLUGS REMOVED IAW AMM 72-00-00-846-137-R04 FOR FIM 71-05/801. PERFORMED TAP TEST INSPECTION OF LP COMPRESSOR ROTORSDR SWAA2026020356605Wire · deterioratedDETERIORATED ELECTRICAL WIRING OF EMERGENCY EXIT LIGHT ON CEILING PANEL 231YDC. REPLACED EMERGENCY EXIT LIGHT IAW AMM 33-51-01-960-802, PERFORMED AN OPS TEST. TESTED OK.SDR SWAA2026020356601Stub Frame · crackedCRACK INDICATION ON STUB FRAME, BETWEEN BS 294.5 - 296.5, S8 - 9R IN THE FWD GALLEY DOOR AREA. CRACK LENGTH: 0.875 IN. REPLACED THE STUB FRAME IAW SRM 51-40-02-0G-0, SRM 51-10-02, ITEM 9, & DWG 141A8370, SHEET 10, REV D.SDR SWIA2025122975121Repair · installedPERFORM DEVIATION TO SERVICE BULLETIN 670BA-53-044 REV -G DUE TO EXISTING CAP ANGLE SPLICE REPAIR PER REO 690-53-11-2104. (C-CHECK RO 02/01/2026)PERFORMED DEVIATION TO SERVICE BULLETIN 670BA-53-044 REV -G DUE TO EXISTING CAP ANGLE SPLICE REPAIR PER ALL STEPSSDR AALA202601302723Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR SWAA2026012956593Scuff Plate · crackedCRACK ON THE FWD CORNER OF THE SCUFF PLATE IN FWD CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2026012956602Scuff Plate · crackedCRACK ON THE FWD CORNER OF THE SCUFF PLATE IN THE AFT CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2026012856545Support Angle · crackedCRACKED SUPPORT ANGLE, BS 500I, STR 28L REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, & DWG 143A7902, SHEET 320, REV-.SDR SWAA2026012856535Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE AT LEVEL ORSS 297, LT WING. REPLACED CORRUGATED PLATE IAW SRM 51-10-02<BR>ITEM 9, SRM 51-40-02, AND DWG 115A3700 SHEET 51 REV -.SDR SWAA2026012764086Strap · out of toleranceBS 328 FRAME STRAP S20R - 22R DOES NOT MATCH WITH FIGURE 15 EA 26-153-00032. THE CONFIGURATION IS ACCEPTABLE IAW EA 26-153-00032.SDR SWAA2026012756542Support Angle · crackedCRACK SUPPORT ANGLE, BS 500I, STR 28R IN THE FWD CARGO BAY. REPLACED THE SUPPORT ANGLE, AND FASTENERS IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 143A7902, SHEET 320, REV-.SDR CALA2026012213135Skin · dentedRESKIN FWD CARGO DOOR DUE TO DENTS IAW AAR 99979572. REMOVED AND REPLACED FWD CARGO DOOR SKIN IAW SRM 51-40-02-0G-0, & DWG 143A6110.SDR SWIA202601200029Spring · brokenBOTH R1 DOOR SLIDE FITTING AFT AND FWD FITTING HAS BROKEN SPRING REMOVED AND REPLACED SPRING AT R1 DOOR SLIDE FITTING ON AFT AND FWD FITTING REF ERJ 175 AMM 53-10-25-400-804-ASDR SWAA2026012056564Fitting · crackedCRACKED FITTING LOCATE FRONT SPAR INSPAR RIB HSS 120.30 RT HORIZONTAL STABILIZER. REPLACED FITTING LOCATE FRONT SPAR INSPAR RIB HSS 120.30 RT HORIZONTAL STABILIZER IAW EA 26-155-00100-WIP1.SDR SWAA2026012056563Rib · crackedCRACK INSPAR RIB LOC FWD UPPER CHORD STAB 120.30 AND 1IN FROM FRONT SPAR HSS 120.30 AT RT HORIZONTAL STAB. REPAIRED INSPAR RIB LOC FWD UPPER CHORD STAB 120.30 AND 1IN FROM FRONT SPAR STAB 120.30 AT RT HORIZONTAL STAB IAW EA 26-155-00100-WIP1.SDR SWAA2026012056565Rib · crackedCRACK IN SPAR RIB LOCATED FWD LOWER CHORD STAB 120.30 AND 1 INCH FROM FRONT HSS 120.30 AT RT HORIZONTAL STAB. REPAIRED INSPAR RIB LOC FWD LOWER CHORD HSS 120.30 AND 1IN FROM FRONT SPAR STAB 120.30 AT RT HORIZONTAL STAB IAW EA 26-155-00100-WIP1.SDR SWAA2026012056575Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE ORSS261 AT RT WING. REPLACED CORRUGATED PLATE AND FASTENERS LOCATED TRAILING EDGE ORSS261 AT RT WING IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2001, SHEET 29, REV-.SDR SWAA2026012056583Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT LT WING. REPLACED CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT LT WING IAW SRM 51-0-02, ITEM 9, SRM 51-40-02, AND DWG 115A2001, SHEET 29, REV- .SDR SWAA2026012056587Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE ORSS261 AT LT WING. REPLACED CORRUGATED PLATE LOCATED TRAILING EDGE ORSS261 AT LT WING IAW SRM 51-0-02, ITEM 9, SRM 51-40-02 AND DWG 115A2001, SHEET 29, REV- .SDR SWAA2026012056580Plate · crackedCRACK ON CORRUGATED PLATE TRAILING EDGE LOCATED ORSS241 AT RT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS241 AT RT WING IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2001, SHEET 30, REV A.SDR SWAA2026012056582Support Bracket · crackedCRACK ON SUPPORT BRACKET TRAILING EDGE LOCATED ORSS273 RT WING. REPLACED SUPPORT BRACKET AND FASTENERS LOCATED ON TRAILING EDGE ORSS273 RT WING. MEASUREMENT OF CRACK IS: L=0.927.SDR SWAA2026012056586Plate · crackedCRACK ON CORRUGATED PLATE TRAILING EDGE LOCATED ORSS241 AT LT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS241 AT LT WING IAW SRM 51-10-02, ITEM 9, SRM 51-40-02 AND DWG 115A2001, SHEET 30, REV A.SDR SWAA2026012056588Support Bracket · crackedCRACK ON SUPPORT BRACKET LOCATED TRAILING EDGE ORSS273 INTERNAL AREA AT LT WING. REPLACED SUPPORT BRACKET LOCATED TRAILING EDGE ORSS273 INTERNAL AREA AT LT WING. MEASUREMENT OF CRACK IS: L=0.653.SDR SWAA2026012056584Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED TRAILING EDGE ORSS273 AT LT WING. REPLACED SUPPORT ANGLE LOCATED TRAILING EDGE ORSS273 AT LT WING IAW SRM 51-10-02, ITEM 9; SRM 51-40-02 AND DWG 115A2930 SHEET 6 REV -. MEASUREMENT OF CRACK IS: L= 2.437.SDR SWAA2026011956589Beam · crackedCRACKED BEAM LOCATED TRAILING EDGE ORSS285 AT LT WING. REPLACED BEAM AND FASTENERS LOCATED TRAILING EDGE ORSS285 AT LT WING IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 115A3700; SHEET 31, REV -, AND DRAWING 115A3712, SHEET 5, REV -.SDR SIMA2026011929002Seal Rest · corrodedSSI 53-21-009: FORWARD CARGO DOOR FUSELAGE CUTOUT FORWARD SILL HAS CORROSION (MARKED). (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR FWD SILL ON FWD CARGO DOOR FUSELAGE CUTOUT IAW ERJ 175 SRM 51-40-08SDR SIMA2026011929004Seal Rest · corrodedSSI 53-21-009: FORWARD CARGO DOOR FUSELAGE CUTOUT AFT SILL HAS CORROSION (MARKED). (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR AFT SILL ON FWD CARGO DOOR FUSELAGE CUTOUT IAW ERJ 175 SRM 51-40-08SDR SIMA2026011929003Seal Rest · corrodedFORWARD CARGO DOOR FUSELAGE CUTOUT MIDDLE SILL HAS CORROSION (MARKED). (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR MIDDLE SILL ON FWD CARGO DOOR FUSELAGE CUTOUT IAW ERJ 175 SRM 51-40-08SDR AALA202601154725Support · crackedAIRCRAFT WAS NOT GROUNDED: LT ECS BAY HORIZONTAL SUPPORT CRACKED 3 INCHES OTBD OF KEEL BEAM. HORIZONTAL SUPPORT REPLACEMENT ACCOMPLISHED ON NON-ROUTINE 338SDR AALA202601141457Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT BS 953, LBL 51. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA202601145459Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT BS 953, RBL 24. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR IPXA2026010969701Skin Panel · damagedFUSELAGE DAMAGE FROM PACKAGE CONTAINER AT FRAME 54 STATION 3354 LEFT SIDE PAST HYD. SERVICE DOOR. REPLACEMENT STRINGER WAS FABRICATED IAW SRM 53-10-14 AND EO-96143-PRELIM4 STEP 6.SDR SWAA2026010856261Angle · corrodedLBL 32 FWD CARGO TRANSITION ANGLE HAS CORROSION FROM BS 500D-500E. PERFORMED DEPTH CHECK PER SRM 53-00-53-1A-1, FOUND TO BE OUT OF LIMITS. REPLACED THE SECTION OF FLOOR TRANSITION ANGLE ON NON ROUTINE TTG8Q019M80W.SDR SWAA2026010856251Angle · corrodedLBL 32 FWD CARGO TRANSITION ANGLE HAS CORROSION FROM BS 500C-500D. REPLACED THE SECTION OF FLOOR TRANSITION ANGLE FROM BS 480 + 10 TO 500 I IAW SRM 53-00-53-2R-5 ON NONROUTINE TTG8Q019M80W. PERFORMED DEPTH CHECK IAW SRM 53-00-53-1A-1, FOUND TO BE OUT OF LISDR SWAA2026010856256Angle · corrodedRBL 32 FWD CARGO TRANSITION ANGLE HAS CORROSION FROM 492-500A. DAMAGE EXTENDED THRU MATERIAL. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-1. REMOVED TRANSITION ANGLE RBL 32 FROM BS 492 THRU BS 500A PER SRM 53-00-53-1A-2. ALLOWABLE DAMAGE 2, FORWARD AND SDR SWAA2026010856245Angle · corrodedRBL 32 FWD CARGO TRANSITION ANGLE HAS CORROSION FROM 500C-500D. REMOVED DAMAGE AND WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-1. REMOVED DAMAGE AND WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2. MATCH DRILLED; AND COUNTER SUNK NEW TRANSITION