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 GTIA2025112439190Megaphone · inoperativeFORWRD EMER MEGAPHONE DROPPED AND WILL NOT WORK FOR TALKING-REMOVED AND REPLACED MEGAPHONE IAW AMM 25-65-01. NO DEFECTS NOTED. MOC 77744 NOTIFIEDSDR JR2R20251124578Sill Drain · corrodedAFT WET AREA, RH MOP SILL AT RBL36 BETWEEEN FR88-FR90, IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20251124573Sill Drain · corrodedAFT WET AREA, LH MOP SILL AT LBL36 BETWEEEN FR88-FR90, IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20251124572Support Angle · corrodedAFT WET AREA, SUPPORT ANGLE THAT ATTACHES TO INTERCOSTAL AT RBL10 BETWEEN FR90-FR90A IS CORRODED OUT OF LIMITS.SDR JR2R20251124571Intercostal · corrodedAFT WET AREA, INTERCOSTAL AT RBL10 BETWEEN FR90-FR90A IS CORRODED OUT OF LIMITS. REPLACEDSDR DALA2025112408547Anti-Skid Sys · faultedPERFORMED GO AROUND AND DECLARED AN EMERGENCY DUE TO LEFT ANTISKID CAUTION MESSAGE ON FINAL APPROACH. RECORDED BCU INTERNAL FAULT CODE 32417A. REPLACED BCU. OPS CHECK GOOD. (LP 7834420)SDR DALA2025112408546Skin · crackedAIRCRAFT 9533, CRACK ON PANEL UPPER SKIN AREA STA Y= 1142 OF LH AND RH PYLON. CORRECTIVE ACTION: PANEL UPPER SKIN AREA STA Y= 1142 OF LH AND RH PYLON WERE REPAIRED PER B717-200 SRM 54-00-00-2R REPAIR 1. (LP 1318816)SDR 2025FA0000780Cylinder · crackedDURING ROUTINE ANNUAL/100HOUR INSPECTIONS 9 CYLINDERS HAVE BEEN FOUND TO BE CRACKED IN THE SAME LOCATION BETWEEN 4 DIFFERENT AIRCRAFT. ON THE LYCOMING O-320 SERIES OF ENGINES. THEY HAVE BEEN FOUND BETWEEN 591 AND 2261 HOURS.SDR JR2R20251124569Gusset · corrodedAFT WET AREA, GUSSET AT FR90, RBL10, IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20251124568Gusset · corrodedAFT WET AREA, GUSSET AT FR90A, RBL10, IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20251124566Seal Rest · corrodedAFT WET AREA, "TEXAS" GUSSET IS CORRODED OUT OF LIMITS. REPLACEDSDR AALA202511240406Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE SKIN AT AFT LAVATORY VACUUM WASTE VENT AT STA 917 FROM S21L TO S22L. REPAIRED SKIN PER SRM 53-70-01-2R-3 REPAIR 3.SDR AALA202511245771Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATION TO RIGHT HORIZONTAL STABILIZER UPPER PANEL LOCATED FROM FSS 58.82 TO FS 102. REPAIRED PANEL PER SRM 55-10--01-2R.SDR JR2R20251124348Seal Rest · corrodedFWD CARGO DOOR, FWD LOWER SEAL REST IS CORRODED. REPLACED.SDR JR2R20251124347Seal Rest · corrodedFWD CARGO DOOR, CENTER LOWER SEAL REST IS CORRODED. REPLACED.SDR JR2R20251124346Seal Rest · corrodedFWD CARGO DOOR, AFT LOWER SEAL REST IS CORRODED OUT OF LIMITS. REPLACED.SDR JR2R20251124212Panel · bent616DB CORNER OF PANEL IS BENTSDR QMLA2025112420116Tail Cone · crackedCRACKS DISCOVERED IN TAIL CONE STATION 6616 DURING 1600 HOUR INSPECTION. AMC EO 32-5302-EO-2290 PREVIOUSLY COMPLIED WITH.SDR SWIA2025112376575Frame · corrodedBS 613 CORRODED AT S18L. REPAIRED FRAME AT BS 613, S18L WITH NEW FRAME SECTOR IAW SRM 53-00-06-201-001-A03, SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG SH690-33100 REV N, COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2026070676563Frame · corrodedFS533.00 CORRODED AT STGR18L. REPAIRED CORRODED FRAME SECTOR ON FS533 AT STR18L USING NEW FABRICATED FRAME SECTOR, REF CRJ 900 SRM 53-00-06-201-001-A03; 51-42-21-001-001-A01; 51-42-06-001-001-A01 REVISION 38: JUL 25/2020 AND COMPLIED WITH ALL STEPS OF REO #SDR SWIA2025112376561Door Sill · corrodedR/H SILL TAB BETWEEN FS748.00 - FS785.00 HAS CORROSION. REMOVED CORROSION 3 LOCATIONS ON RT FLOOR ANGLE APPROX. BS 748- 785 REF: SRM 51-21-06-001-001-A01, COMPLIED WITH REO 690-53-41-575, REV--, COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025112376559Tab · corrodedR/H SILL TAB BETWEEN FS720.00 - FS744.00 HAS CORROSION AS MARKED (C-CHECK RO 07/02/2026)REMOVED CORROSION (3 LOCATIONS) ON RH FLOOR ANGLE FS720-FS744. REF: CRJ 900 SRM 51-21-06-001-001-A01 AND COMPLIED WITH REO 690-53-41-575, REV--, DATE:2026/01/01. COMPLIEDSDR SWIA2026070676551Tab · corrodedRT SILL TAB AT APPROXIMATELY BS 813 HAS CORROSION. REPAIRED RT SILL TAB AT APPROXIMATELY BS 813 IAW REO 690-53-41-575 REV --. COMPLIED WITH ALL STEPS OF REO 690-53-41-575 REV -- . COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2026060776549Frame · corrodedFS549.00 CORRODED AT STGR18L AS MARKED (C-CHECK RO 07/02/2026)PERFORMED FRAME SECTOR REPAIR TO FS 549 STR 18L TO STR 14L REF. CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01 AND CRJ 900 SRM 53-00-06-201-001-A03 AND DWG# SH690-33100 REV: SDR SWIA2026070676542Stringer · corrodedCORROSION ON STGR22L BETWEEN FS501.00 AND FS517. REMOVED AND INSTALLED NEW STGR AT 22L FS477.00 TO FS517.00 IAW SRM 51-42-21-001-001-A01, SRM 51-42-06-001-001-A01 AND DWG SH690-33200 REV: N. PERFORMED LEAK CHECK IAW SRM 51-23-03-001-001-A01. LEAK CHECK GOOD SDR SWIA2025112376530Angle · elongatedFS280.00 LH BULKHEAD, THE AFT BOTTOM ANGLE THAT IS ATTACHED TO THE CROSSBEAM, THE FASTENER HOLES ARE ELONGATED AND BENT. REMOVED AND REPLACED WITH NEW LT CORROSION CAP PART CC670-34096-1S AT FS 280.00 REF SRM 51-42-10-001-001-A01 AND DWG CC670-34010 REV -K, SDR SWIA2025112376525Hinge · chafedPAX DOOR SURROUND STRUCTURE HAS CHAFFING ON EXTERNAL SKIN FWD OF PIANO HINGE. BLENDED CHAFFING FROM PAX DOOR SURROUND STRUCTURE EXTERNAL SKIN FWD OF PIANO HINGE SRM 51-12-00-001-001-A01. PERFORMED REPAIR IAW ALL STEPS OF REO 690-53-21-2072 REV -. COMPLIED WITHSDR SWIA2026070676524Striker · gougedPAX DOOR SURROUND STRUCTURE SEAL STRIKER LOWER EDGE HAS MULTIPLE GOUGES/CHAFFING. REMOVED CHAFED SEAL STRIKER AND INSTALLED NEW PAX DOOR SURROUND STRUCTURE SEAL STRIKER LOWER. IAW SRM 51-42-06-001-001-A01. AND DWG SH670-31810 REV. AE. COMPLIED WITH SKYWEST TASDR SWIA2025112376505Stringer · corrodedCORROSION ON STRINGER 19R BETWEEN BS 469 AND 485. INSTALLED A NEW STRINGER IAW DWG SH670-31070, REV J AND SRM 51-42-06-001-001-A01. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY, LEAK CHECK GOOD.SDR SWIA2025112376498Skin · chafedBS 913 - 927, STRINGER 27, THE AFT BODY FAIRING HAS CHAFED THE FUSELAGE EXTERIOR SKIN. REPAIRED FUSELAGE EXTERIOR SKIN AT BS 913 - 927 STRINGER 27 IAW REO 690-53-51-533 REV-. COMPLIED WITH ALL STEPS OF REO 690-53-51-533 REV-- AND REO 670-53-00-290 REV F. COMPSDR SWIA2025112376490Stringer · corrodedCORROSION ON S24L BETWEEN FS 501 AND 517. REMOVED AND INSTALLED NEW S24L BETWEEN BS 501 AND 517 IAW SRM 51-42-21-001-001-A01, SRM 51-42-06-001-001-A01 AND DWG SH690-33200 REV: N. COMPLIED WITH TASK CARD 51-900-1002-SKY. PERFORMED LEAK CHECK IAW SRM 51-23-03-SDR SWIA2025112376488Frame · corrodedCORROSION BS 501AFT SIDE BETWEEN S23L AND S26R. REMOVED AND INSTALLED NEW FRAME AT FS501.00 FROM STGR 25L TO STGR 19L IAW DWG SH690-33750 REV: AF, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. PERFORMED LEAK CHECK IAW SRM 51-23-03-001-001-A01. LEAK CSDR SWIA2025112376486Frame · corrodedFS280.00 STRG 24LH - 23RH CIRCUMFERENTIAL JOINT STRAP HAS AREAS OF CORROSION. REPAIRED CIRCUMFERENTIAL JOINT STRAP AT BS 280 S24L - 23R IAW REO 690-53-21-2075 REV -. COMPLIED WITH ALL STEPS OF REO 690-53-21-2075 REV -. PERFORMED LEAK CHECK IAW SRM 51-23-03-SDR SWIA2025112376484Crossbeam · gougedRIGHT CROSSBEAM HAS GOUGES AT FS 669. REMOVED DAMAGE FROM RT CROSSBEAM AT FS 669.00 IAW SRM 51-12-00-001-001-A01. OUT OF LIMITS IAW SRM 53-31-43-101-001-A06. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 690-53-31-1103 REV: --. COMPLIED WITH SKYWEST TASKCARD 5SDR SWIA2025112376479Attach Angle · crackedBS 280, RBL 12, THE CROSSBEAM-TO-FLOOR BEAM OUTBD ATTACH ANGLE CRACKED IN THE UPPER RADIUS. REMOVED AND REPLACED WITH NEW OTBD ATTACH ANGLE AT BS 280, RBL 12 IAW SRM 51-42-21-001-001-A01 AND DWG CC670-34010 REV -K, AND LOCATED AND DRILLED NEW ATTACH ANGLE SRMSDR SWIA2025112376464Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN STRINGER26 - 27L BETWEEN BS 501 AND 517. REMOVED AND INSTALLED NEW REPLACEMENT ANGLE FOR INTERCOSTAL ON S27-26L BETWEEN BS 501 - 517 IAW SRM 51-42-06-001-001-A01 AND DWG SH670-33399 REV -B. PERFORMED LEAK CHECK IAW SRM 51-23-03-00SDR SWIA2025112376462Structure · crackedLEFT FORWARD OVERWING EMERGENCY-EXIT DOOR TOP EDGE MEMBER SUSPECTED CRACKED AT AFT TANG FITTING. VERIFIED CRACK ON LEFT FORWARD EMERGENCY EXIT DOOR TOP EDGE MEMBER. PERFORMED ALL STEPS OF REO 670-52-21-103 REV-- FOR REPAIR. COMPLIED WITH SKYWEST TASK CARD 51-SDR SWIA2025112376460Floorbeam · corrodedBS 280, LBL 12 - RBL 12, THE COCPIT FLOOR PANEL AFT ATTACH ANGLE, ON THE BEAM, IS CORRODED. FOUND EXFOLIATED CORROSION 100% MATERIAL LOSS. FOUND OUT OF LIMITS IAW SRM 53-00-00-101-001-A01. REMOVED COCKPIT FLOOR SUPPORT ANGLE IAW SRM 51-42-21-001-001-A01 AND SSDR SWIA2025112376458Floor Support · corrodedPAX DOOR SURROUND STRUCTURE FLOOR SUPPORT ANGLE HAS MULTIPLE AREAS OF CORROSION BETWEEN APPROX. BS 310 - 349. INSTALLED NEW PAX DOOR SURROUND STRUCTURE FWD AND MID CAP ANGLES IAW SRM 51-42-06-001-001-A01, AND DWG SH670-31810, REV AE COMPLIED WITH TASK CARD 51SDR SWIA2025112376456Stringer · gougedPAX DOOR SURROUND STRUCTURE SEAL STRIKER HAS GOUGES & CHAFED AT APPROX. BS 310, STGR 5L - 7L. TRIMMED OUT DAMAGE ENSURED NO DAMAGE TO UNDERLYING STRUCTURE AND REMOVED ALL BURRS AND SHARP EDGES IAW REO 670-53-22-001, REV J. FABRICATED STRAP IAW REO 670-53-22-SDR SWIA2025112376448Fitting · corrodedPAX DOOR SURROUND STRUCTURE FWD HANDRAIL FITTING CORRODED. REMOVED AND INSTALLED NEW PAX DOOR SURROUND STRUCTURE FWD HANDRAIL FITTING IAW SRM 51-42-21-001-001-A01 AND DWG SH670-31810 REV. AE. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2026031075490Bulkhead · corrodedMAIN CABIN BS 280 BULKHEAD, LBL12, WL79.50, HAD SIGNS OF CORROSION. REMOVED AND REPLACED SECTION LOWER WEB REPAIR ON MAIN CABIN BS 280 BULKHEAD LBL12 AND WL79.50 IAW SRM 53-00-00, AMM 20-70-00, SRM 51-42-06, 51-42-21, 51-42-13, 51-25-16, REO 670-53-11-594SDR SWIA2026031075487Fitting · gougedLEFT MLG SIDE STAY FITTING GOUGED. PERFORMED BLENDED OUT AND EVALUATED AREA ON LT MLG SIDE STAY FITTING, CONDITION IS STRUCTURALLY ACCEPTABLE IAW REO 670-57-11-244, REV--, SRM 51-12-00, 51-24-11, 51-21-11, 51-25-06, 51-25-16.SDR SWIA2026031075486Bulkhead Web · corrodedMAIN CABIN FS280 BULKHEAD WEB AT WL79.50 RBL25 "AND RBL46" HAS SIGNS OF CORROSION. REMOVED AND REPLACED SECTION LOWER WEB REPAIR ON MAIN CABIN FS280.00 AT WL79.50 RBL25 AND RBL46 IAW AMM 20-70-00, SRM 51-42-13, 53-00-00, 51-42-06, 51-41-02, 51-42-21, 51-42-2SDR SWIA2025112375276Frame · corrodedFRAME AT FS 661.00 APPROX. STGR 27 CORRODED ON WEB (AFT SIDE). REPAIRED PER REO 670-53-31-1139 REV - AND SRM 51-41-02-001-001-A01. LEAK CHECK GOOD. COMPLIED WITH TASK CARD 51-900-1002-SKYSDR 2026FA0000052Spark Plug · crackedLEVELED AT 4000FT, ENGINE POWER WAS REDUCED TO 80% WITH FUEL CONSUMPTION LEANED TO 17GAL/HR. AFTER BEING SET IN THIS CRUISE PROFILE FOR APPROXIMATELY 2 MINUTES, THE ENGINE BEGAN TO RUN ROUGH. THE PILOT THEN RICHENED THE MIXTURE WHICH DID NOT FIX THE ISSUE, HE SDR HNAA2026012100041Door Frame · crackedCARGO DOOR LWR OUTBD FRAME PROFILE IS CHAFED AND CRACKED AT FWD END. REMOVED AND REPLACED CHAFED AND CRACKED CARGO DOOR LWR OUTBOARD FRAME PROFILE IAW EMB 145 SRM 51-40-02, 51-20-01, 51-20-03, 51-40-04, 51-40-06SDR HNAA2026012100040Door Frame · corrodedCARGO DOOR CORRODED AROUND FWD MOST 2 SCREW HOLES ON INBD LOWER FRAME PROFILE. R & R CARGO DOOR INBD LOWER FRAME PROFILE IAW EMB 145 SRM 51-40-02SDR HNAA2026012100039Access Door · crackedCOCKPIT UNDER FLOOR ACCESS HATCH CRACKED UNDER HINGE PIN ATTACH RING (HATCH SIDE). REPAIRED IAW EMB145 SRM 52-42-02-RE & 51-40-02, CPM 51-21-04 & 51-21-05.SDR VNAA202601180017Fitting · corrodedCORROSION FLOOR FITTING ON ACCESS 104 (1EA) AISLE SIDE AND BEHIND ACCESS 105B (1 EA) ON GALLEY 1. FLOOR FITTING ON ACCESS 104 AISLE SIDE AND BEHIND ACCESS 105B ON GALLEY 1 WERE REPLACED PER SAFRAN CMM 25-32-02