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 SWIA2025111376476Stringer · corrodedMAIN AVIONICS STR 26L HAS CORROSION BETWEEN BS 280 - 310. INSTALLED NEW MAIN AVIONICS S26L BETWEEN BS 280 - 333 IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG SH670-31630 REV K. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOSDR SWIA2025111376465Longeron · corrodedMAIN AVIONICS STR 25R LONGERON HAS CORROSION BETWEEN BS 333 - 349. INSTALLED NEW MAIN AVIONICS S25R LONGERON BETWEEN BS 333 - 364 IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG SH670-32050 REV J. LEAK CHECKED GOOD, COMPLIED WITH SKYWEST TASDR REXA2026052800806Fitting · corrodedCORROSION ON LH / RH UPPER FITTINGS (2EAS), ALSO MIGRATED BUSHINGS WERE FOUND LH / RH UPPER FITTINGS (2EAS), ON AFT NLG DOOR WERE REPLACED PER CRJ 900 SRM 51-41-02-001-001-A01 AND MIGRATED BUSHINGS WERE REPLACED WITH CARD 900-32-710-902SDR REXA2026052800797Access Panel · crackedCRACK ON 433BB ACCESS PANEL HOLE AND WEAR ACCESS PANEL 433BB WAS REPLACED PER AMM 54-12-01-000-802 (CONFIG A02) AND AMM 54-12-01-400-802 (CONFIG A02).SDR VNAA20260511039Seat Track · corrodedLBL 9 SEAT RAIL IS CORRODED BETWEEN FS 485 AND FS 581. INSTALLED SERVICEABLE SEAT RAIL PN SH-670-33426-1 FOR LBL 9 FS 485 TO 581 IAW CRJ 700 AMM 53-00-49-400-801-A03.SDR VNAA20260511035Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 708 AND FS 761. REMOVED UNSERVICEABLE SIDE SEAT RAIL AT FS 708 TO FS 761 IAW CRJ 700 AMM 53-00-49-000-801-A03. INSTALLED NEW SERVICEABLE SIDE SEAT RAIL (P/N SH670-37509-1) RT STGR 15R FS 708 TO FS 761 SDR VNAA20260511034Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 677 AND FS 708. INSTALLED NEW SERVICEABLE RH SIDE SEAT RAIL PN SH670-36255-3 AT STGR 15R BETWEEN FS 677 AND FS 708 IAW AMM 53-00-49-400-801-A03.SDR VNAA20260511033Seat Track · corrodedLEFT SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 863 AND FS 969. INSTALLED NEW SERVICEABLE LH SIDE SEAT RAIL, P/N SH670-37543-3, BETWEEN FS 863 AND FS 969 IAW CRJ 700 AMM 53-00-49-400-801-A03.SDR VNAA20260511028Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 379 AND FS 485. INSTALLED SERVICEABLE R/H SIDE SEAT RAIL PN SH670-32233-3 BETWEEN FS 379.00 AND 485.00 IAW AMM 53-00-49-400-801-A03.SDR SWIA2025111375922Skin · gougedCOMPLY WITH PERMANENT REPAIR ON RA ID: 94134RH SLAT NR 1, TWO AREAS OF GOUGE DAMAGE BETWEEN SS58.75 - TRACK 1-1 DATUM, AND BETWEEN SS 142.25 - SS 155.25. COMPLIED WITH TEMP REPAIR IAW REO 670-57-42-1734 REV A. PERFORM PERMANENT REPAIR BEFORE 3250 FLT HRS IAW SDR SWIA2025111375921Skin · damagedCOMPLY WITH PERMANENT REPAIR ON RA ID: 94135 RT SLAT NR 2 HAS NEW DAMAGE OF A BLENDED REPAIR ON THE TRAILING EDGE SKIN 48 INCHES FROM THE INBOARD EDGE OF THE SLAT. TEMPORARY REPAIR OF RT SLAT NR 2 COMPLIED WITH PER REO 670-57-42-1742 REV A, ON LOWER EDGE SURFSDR IXXA03062026CC01Skin · corrodedRIGHT WING LOWER SURFACE (INSPAR) IS CORRODED AROUND FASTENER AND RUNS UNDER PYLON RIGHT AT I/B SIDE OF PYLON APROX 5 INCHES AFT OF FWD SPAR AT STRINGER 14.SDR SWIA2026030275395Hinge Arm · gougedLH WING OB FLAP HINGE ARM AT WS178.00 FWD AND AFT BOTH MOUNTS GOUGED (C-CHECK RO 02/28/2026)REPAIRED DAMAGE TO LH WING OTBD FLAP HINGE ARM AT WS.178.00 IAW BOMBARDIER REO 601R-57-53-002 REV-C DATE 03-04-2008, MHIRJ REO 670-57-53-434 REV-- DATE 2025-11-25, CRSDR SWIA2026022575308Floorbeam · crackedFLOORBEAM, BS 280 AND RBL 12 CRACKED ON THE AFT OTBD FLANGE FROM APPROX WL 70 - WL 72.50. COMPLIED WITH GREO 670-53-11-896 REV -. COMPLIED WITH REO 670-53-11-2231, REV -. REPAIR TO CENTER COCKPIT FLOORBEAMS AT LBL12. & RBL 12. PERFORMED EDDY CURRENT INSPSDR SWIA2026022375305Floor Support · corrodedRIGHT UPPER SURFACE PRESSURE FLOOR SILL STRUCTURE SHOWING SIGN OF CORROSION AT BS 424 - 449. REMOVED, & TREATED CORROSION ON RT FLOOR SILL IAW REO 601R-53-41-666, REV C, SRM-51-21-11, SRM-51-25-06, & SRM-51-25-16. ORIGINAL THICKNESS MEASURED 0.080", REMAININSDR SWIA2025111375284Shaft · damagedLEFT WING INBOARD FLAP THE MOST OUTBOARD FLAP VANE ACTUATOR SHAFT HAS DAMAGE & GROOVED ON THE LOWER SURFACE. COMPLIED WITH GREO 670-57-52-257 REV -B FOR REPAIR OF LEFT WING INBOARD FLAPVANE ACTUATOR SHAFT, ALL CHECKS GOOD AT THIS TIME. COMPLIED WITH SKYWEST TSDR SWIA2026021375264Shaft · groovedRIGHT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR SHAFT HAS DAMAGED & GROOVED ON THE LOWER SURFACE. REMOVED DAMAGE ON RIGHT WING INBOARD FLAP INBOARD FLAP VANE ACTUATOR SHAFT LOWER FACE IAW SRM 51-12-00-001-001-A01. COMPLIED WITH REO 670-57-52-257 REV B. CSDR SWIA2026021375256Slat Track · groovedRIGHT WING SLAT TRACK 3-1 HAS LIGHT GROOVING. REPAIRED GROOVING ON RT WING SLAT TRACK 3-1 IAW SRM 51-12-00-001-001-A01. COMPLIED WITH REO 670-57-42-2289 REV-. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025111375255Slat Track · groovedRIGHT WING SLAT TRACK 2-3 HAS LIGHT GROOVING, AREAS. REPAIRED THE RT WING SLAT TRACK 2-3 IAW REO 670-57-42-2288 REV-. COMPLIED WITH ALL STEPS OF REO 670-57-42-2288 REV-. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2026021375254Slat Track · damagedLEFT WING SLAT TRACK 1-3 HAS LIGHT GROOVING. REPAIRED THE LT WING SLAT TRACK 1-3 IAW REO 670-57-42-2295, REV -. COMPLIED WITH ALL STEPS OF REO 670-57-42-2295 REV -. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2026021375253Attach Angle · corrodedLEFT MLG WHEEL WELL, TIRE BURST PANEL, THE FWD ATTACH ANGLE, ON THE AFT WING SPAR IS CORRODED ON THE TOP AND BOTTOM. REMOVED AND INSTALLED NEW LT MLG WHEEL WELL TIRE BURST PANEL, THE FWD ATTACH ANGLE. IAW DWG CC670-10320, REV F SRM 51-42-21-001-001-A01, REV 3SDR SWIA2025111375252Shaft · damagedLEFT WING INBD FLAP THE MOST INBOARD FLAP VANE ACTUATOR SHAFT HAD DAMAGE & GROOVED ON THE LOWER SURFACE. BLENDED LT WING INBD FLAP AT MOST INBD FLAP VANE ACTUATOR SHAFT ON THE LOWER SURFACE IAW SRM 51-12-00-001-001-A01. COMPLIED WITH REO 670-57-52-257 REV -B.SDR SWIA2025111375251Shaft · damagedRIGHT WING INBD FLAP, SECOND FROM INBD END FLAP VANE ACTUATOR SHAFT HAS DAMAGE & GROOVED ON THE LOWER SURFACE. REMOVED DAMAGE ON RT WING INBD FLAP SECOND FROM INBD END FLAP VANE ACTUATOR SHAFT LOWER SURFACE IAW SRM 51-12-00-001-001-A01. COMPLIED WITH REO 670-SDR SWIA2025111375249Slat Track · groovedRIGHT WING SLAT TRACK 3-3 HAS LIGHT GROOVING, AREAS MARKED IN RED. REPAIRED GROOVING ON RIGHT WING SLAT TRACK 3-3. IAW SRM 51-12-00-001-001-A01. COMPLIED WITH ALL STEPS OF REO 670-57-42-2290 REV-. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025111375248Slat Track · groovedRIGHT WING SLAT TRACK 1-1 HAS LIGHT GROOVING, AREAS MARKED IN RED. REPAIRED RT WING SLAT TRACK 1-1 IAW REO 670-57-42-2296 REV -. COMPLIED WITH ALL STEPS OF REO 670-57-42-2296 REV --. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2026020975223Skin · gougedLOWER SKIN GOUGED AT APPROXIMATELY BS 969, STGR 27. REPAIRED LOWER SKIN GOUGE AT APPROX BS 969, STGR 27 IAW REO 670-53-00-290 REV F.SDR VNAA202601180001Intercostal · corrodedCORROSION ON INTERCOSTAL (STRINGER 26L, STGR 27L, STGR 27R) BTW F.S. 349.00 AND F.S. 364.00 AT AVIONICS COMPARTMENT. CORROSION ON INTERCOSTAL (STRINGER 26L, ) BTW F.S. 349.00 AND F.S. 364.00 AT AVIONICS COMPARTMENT WAS REMOVED PER CRJ-900 SRM 51-21-06-001-00SDR VNAA202601170020Door Sill · corrodedCORROSION ON LOWER SILL AT AFT DOOR CARGO COMPARTMENT. LOWER SILL AT AFT DOOR CARGO COMPARTMENT WAS EVALUATE FOUND EXCESSIVE DAMAGE PER CRJ-900 SRM 51-10-06-001-001-A01 AND REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 , SRM 51-42-13-001-001-A01 AND SRM 51-4SDR VNAA202601170019Angle · corrodedCORROSION ON KICKPLATE ANGLE AND ON MID CAP ANGLE FROM FS310 TO FS 349 AT PASSENGER DOOR SURROUND STRUCTURE. KICKPLATE ANGLE AND ON MID CAP ANGLE FROM FS310 TO FS 349 AT PASSENGER DOOR SURROUND STRUCTURE WERE EVALUATED FOUND EXCESSIVE DAMAGE PER CRJ-900 SRM 5SDR VNAA202601170017Drip Tray · corrodedCORROSION ON DRAIN CHANNELS (2 EAS) FS281.00 LBL14.00 AND RBL14.00 AT PAX CABIN . CORROSION WAS REMOVED ON DRAIN CHANNEL RH (1 EA) ON FS281.00 AT PAX CABIN PER CRJ 900 SRM 51-21-06-001-001-A01 AND EVALUATED THEREFORE IT IS WITHIN LIMITS PER CRJ-900 SRM 53-21SDR VNAA202601170016Bracket · corrodedCORROSION ON BRACKETS FS514.00, FS565.00, FS626.00, FS661.00 + 9.00 BTW STGR 26LH & 27 AND BTW STGR 22LH & STGR 23LH AND FS652.00 STGR 24RH & 25RH AT FWD/CENTER BAGGAGE BAY COMPARTMENT.
BRACKETS FS514.00 BTW STGR 26LH & 27 AND FS514.00, FS565.00, FS626.00, SDR VNAA202601170012Fitting · corrodedCORROSION ON RH/LH FITTINGS SUPPORTS OF CONECTORS PX10J1/PX02J1, PX09J1/PX01J1 AT MLG WHEEL WELL. RH/LH FITTINGS SUPPORTS OF CONECTORS PX10J1/PX02J1, PX09J1/PX01J1 AT MLG WHEEL WELL WERE REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR VNAA202601170010Nut Plate · corrodedCORROSION ON NUT STRIPS (2 E/A'S) AT UPPER AREA OF LH/RH WHEEL WELL AREA (APROX. RBL/LBL 49). NUT STRIPS (2 E/A'S) AT UPPER AREA OF LH/RH WHEEL WELL AREA (APROX. RBL/LBL 49) WERE EVALUATED FOUND EXCESSIVE DAMAGE PER CRJ-900 SRM 51-10-06-001-001-A01 AND REPLACSDR VNAA202601170009Angle · corrodedCORROSION ON SETTLEMENT ANGLE OF ACCESS PANEL642AZ AT RH WING. SETTLEMENT ANGLE OF ACCESS PANEL 642AZ AT RH WING WAS EVALUATED FOUND EXCESSIVE DAMAGE PER CRJ-900 SRM 51-10-06-001-001-A01 AND REPLACED PER SRM 51-42-21-001-001-A01SDR VNAA202601170006Angle · corrodedCORROSION ON ATTACHMENT POINT ANGLE OF SIDE STAY BONDING JUMPER AT LH MLG WHEEL WELL. ATTACHMENT POINT ANGLE OF SIDE STAY BONDING JUMPER AT LH MLG WHEEL WELL WAS EVALUATE FOUND TO EXCESSIVE DAMAGE PER CRJ900 SRM 51-10-06-001-001-A01 AND REPLACED PER CRJ-900SDR VNAA202601170004Shim · corrodedCORROSION ON SHIMS OF DOOR HINGES OF LP GROUND CONNECTION ACCESS DOOR AT AFT FUSELAGE. SHIMS OF DOOR HINGES OF LP GROUND CONNECTION ACCESS DOOR AT AFT FUSELAGE WERE REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR VNAA202601170003Hinge · corrodedCORROSION ON HINGE (1E/A) OF REFUEL ACCESS DOOR AT FWD LOWER FUSELAGE. HINGE (1E/A) OF REFUEL ACCESS DOOR AT FWD LOWER FUSELAGE WAS EVALUATED FOUND TO EXCESSIVE DAMAGE PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01 AND SDR ASAA2025111363577Cargo Track · crackedAFT CARGO, CARGO TRACK AT RBL13.84 CRACKED AT MULTIPLE FRAMES BETWEEN BS 727+4 - 878. GROUNDED - YES. REPAIRED CARGO TRACK AT RBL 13.84 BETWEEN BS 727+4 AND 878 IAW SRM 53-00-53-1R-3.SDR IPXA2026010559590Stringer · corrodedDURING DVI INSPECTION ON EO-91261-REQ1 REV3 FOUND AFT CARGO COMPARTMENT. BILGE AREA WITH CORROSION ON STR-28R BETWEEN STA1420 AND 1440. REMOVED AND REPLACED STRINGER 28RH PER DRAWING 146N3305,146N3300 AND IAW SRM CHAPTER 51 GUIDELINES.SDR ASAA2025111363363Transition Panel · corrodedAFT CARGO SIDE PLATE AT LBL-21 CORRODED BETWEEN BS 727+4 TO STA 807. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS, REPAIRED IAW SRM 53-00-53-2R-5W= 1" O= .040 R= .026 L= 1" D = .014.SDR IPXA2025122959619Intercostal · corrodedDURING DVI INSPECTION ON EO-91261-REQ1 REV3 FOUND AFT CARGO COMPARTMENT. BILGE AREA WITH CORROSION ON WEB LOCATED APPROX STR 30 BETWEEN BS 1400 AND 1420. REMOVED AND REPLACED INTERCOSTAL PER DRAWING 146N5425 AND IAW SRM CHAPTER 51 GUIDELINES, USING THE ORIGISDR AALA202512245002Hinge Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON MLG FWD HINGE FITTING RH SIDE, AFT LUG POSITION. CRACK LENGTH IS L= 0.180 INCH. MAINTENANCE REPLACED MLG FWD HINGE FITTING RH SIDE IAW EA 369995 AND REPAIR DWG R53370500 ISSUE F, A319 SRM 51-42-11-801 ANDSDR ASAA2025111363264Shield · corrodedAFT CARGO SHIELD ASSY CORRODED MULTIPLE AREAS ON SHIELD AND WEB BETWEEN BS 767 TO BS 787. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1. REMOVED AND REPLACED SHIELD IAW SRM 51-40-02-0G-0.W= 1.25 O= .050 R= .043 L= 2.25 D= .SDR ASAA2025111363263Plate · corrodedAFT CARGO SIDE PLATE AT RBL-21 CORRODED BETWEEN BS 727B+10 TO BS 767. GROUNDED - YES. REMOVED CORR, FOUND OUT OF LIMITS IAW SRM 53-00-53-1A-2 & REPAIRED SIDE PLATE IAW SRM 53-00-83-2R-5. W 1.25, O .040, R .0.35, L 3.75, D .005.SDR ASAA2025111363260Shield · corrodedFWD CARGO AFT SHIELD CORRODED BETWEEN BS 500 TO BS 500A. GROUNDED - YES. EVALUATED AFT SHIELD LOC BTW BS 500 TO BS 500A, FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED IAW SRM 53-30-15-01-1, SRM 51-40-02-OG-OW: 1.00 O: 0.032 R: 0.024 L: 1.500 D: 0.008.SDR ASAA2025111363259Plate · corrodedAFT CARGO SIDE PLATE AT RBL-21 CORRODED BETWEEN BS 727+4 TO BS 727B+10. GROUNDED - YES. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 53-00-53-1A-2 & REPAIRED SIDE PLATE IAW SRM 53-00-53-2R-5. W 1, O .040, R .3034, L 3, D.006.SDR SWAA2025122235042Skin · corrodedCORROSION ON EXTERNAL SKIN BTW BS 967 AND BS 986.5 AND BTW STR 26L AND STR 27L LOWER FUSELAGE. FAULT RESOLVED ON OTHER FAULT SEE TTG8Q018UWBN.SDR SWAA2025122234830Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 192HR BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 192HR BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025122234831Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 192AR BODY FAIRING AT FUSELAGE EXTERIOR . REPAIRED ACCESS PANEL 192AR BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025122234826Access Panel · elongatedELONGATED HOLE ACCESS PANEL 192AL BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 192AL BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-9 REPAIR 9.