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 SWIA2026070676500Stringer · corrodedMAIN AVIONICS STR 23R HAS CORROSION BETWEEN BS 349 - 364. INSTALLED NEW STRINGER 23R BETWEEN BS 333 TO 364 IAW SRM 51-42-06-001-001-A01 AND DWG SH690-31350 REV. M. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY, LEAK CHECK GOODSDR SWIA2025111776477Intercostal · crackedSUSPICIOUS CRACK ON PAX DOOR AFT DD7 INTERCOSTAL. REMOVED AND INSTALLED NEW AFT DD7 INTERCOSTAL AND NEW CLEAT IAW SRM 51-42-06-001-001-A01 REV. 38 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR IXXA04082026CC01Angle · corrodedRH AFT LOWER WING TO BODY FAIRING FRAME STA 1050 IS CORRODED.SDR 2026FA0000226Magneto · failedWHILE REDUCING POWER ON LANDING, ENG RAN VERY ROUGH. AFTER LANDING MAGNETO CHECK CAUSE LARGE DROP IN RPMS ON BOTH MAGS. MECHANICS FIRST REPAIRED INDUCTION LEAK WHICH DID NOT SOLVE MAG DROP. THEN THEY CHANGED THE CARBURETOR WHICH DID NOT SOLVE PROBLEM, THEN SDR SWIA2026031075493Drag Angle · crackedVERTICAL STAB LEFT SIDE FWD DRAG ANGLE IS CRACKED AT AFT END (C-CHECK RO 03/08/2026)PERFORMED REPAIR ON VERTICAL STAB LEFT SIDE FWD DRAG ANGLE IAW BOMBARDIER REO 670-55-31-018, REV -A, DATE 2016/11/10, CRJ700 AMM 20-70-00. SRM 51-42-06, 51-42-21SDR IXXA20262026002Support Bracket · corrodedLEFT LOWER WING - BODY FAIRING SUPPORT BRACKET STA 958 IS CORRODED.SDR IXXA20262026001Skin · corrodedFUSELAGE EXTERNAL SKIN IS CORRODED AT LAP SEAM S-20L BS 1718.SDR SWIA2026022575335Angle · crackedANGLE, BL26.00 FS280.00 (REFERENCE SRM 53-11-10 ITEM 81A) CRACKED. (C-CHECK RO 02/22/2026)REMOVED AND REPLACED THE ANGLE, (CORRECTED LOCAITON) RBL26.00 FS280.00 IN REFERENCE WITH THE CRJ-700 SRM 51-42-06 AND SRM 53-11-10. COMPLIED WITH TASK CARD 51-900-1002SDR SWIA2025111775259Splice Plate · crackedAFT BAGGAGE BAY DOOR INTERNAL STRUCTURE, UPPER FORWARD SPLICE PLATE HAD A CRACK. REMOVED AND REPLACED CRACKED UPPER FORWARD SPLICE PLATE IN AFT BAGGAGE BAY DOOR INTERNAL STRUCTURE IAW SRM 51-42-06-001-001-A01, AND DWG CC670-38702, REV F. COMPLIED WITH SKYWESTSDR 3EJA202601140002Switch · failedRECEIVED TWO CAUTION MESSAGES “T2 HEATER FAIL L AND WING ANTI-ICE OVERTEMP L. R & R LT WING ANTI-ICE OVER TEMP SWITCH WITH NEW.SDR CALA2026010212587Floorbeam · corrodedMAIN CABIN AFT WET AREA FLOORBEAM STA 947, BL 0 CORRODED ON UPPER SURFACE. ACCOMPLISHED FLOORBEAM REPAIR IAW SRM 53-00-51-2R-1 REPAIR 1. REPAIR COMPLETED HAECO GSO. ESFR COMPLETED. STATUS CHANGED.SDR SWAA2025123036150Fitting · looseFWD ENTRY DOOR SLIDE SHROUD GIRT BAR FITTING HAS LOOSE FASTENERS. REMOVED AND REPLACED FWD ENTRY DOOR SLIDE SHROUD GIRT BAR FITTING IAW SRM 51-40-02-0G-0.SDR SWAA2025123036155Fitting · looseFWD SERVICE DOOR SLIDE SHROUD GIRT BAR FITTING HAS LOOSE FASTENERS. REMOVED AND REPLACED THE FWD SERVICE DOOR SLIDE SHROUD GIRT BAR FITTING FASTENERS IAW SRM 51-40-02-0G-0, AND IPC 25-66-00-14.SDR SWAA2025123036133Scuff Plate · crackedDURING PREDOCK TEST, CABIN PRESSURE LEAKAGE. FOUND R1 DOOR SCUFF PLATE CRACKED. REPAIRED DAMAGED R1 DOOR SCUFF PLATE IAW SRM 53-10-15-2R-2. PERFORMED GOOD CABIN PRESSURE LEAK CHECK IAW AMM 05-51-91-790-801.SDR CALA2025122412437Stringer · corrodedFOUND CORROSION E/E BAY FLOOR, BILGE S28L HAS EXFOLIATE CORROSION AT BS 360. ACCOMPLISHED STRINGER REPAIR AT E&E BAY BETWEEN BS 350 - 380, S28L IAW ESR 16-13144, SRM 51-40-02-0G-0, AND DWG 140A9101.SDR ASAA2025111763265Shear Web · corrodedDRAIN SHEAR WEB AT RBL-28 HAS MULTIPLE AREAS OF CORROSION BETWEEN BS 1006 TO BS 1016. GROUNDED - YES. FABRICATED AND REPLACED DRAIN SHEAR WEB ON BS 1006 TO 1016 RBL 28 IAW IAW 53-70-55 AND SRM 51-40-02-OG-O, UPON FURTHER EVALUATION FOUND TO HAVE NO ALLOWABLE LSDR SWAA2025122236200Shield · corrodedCORROSION SHIELD WEB LOCATED BTW STA 767 TO STA 794.3 AND WL 156 AT AFT CARGO COMPARTMENT. REPLACED SHIELD WEB LOCATED BTW STA 767 TO STA 794.3 AND WL 156 IAW SRM 51-10-02-0G-0 PARAGRAPH 9 ,SRM 51-40-02-0G-0 AND DWG 146A0081, SHEET:37, REV:-.SDR SWAA2025122236192Fitting · crackedCRACK FITTING LOCATED STA 947.5 AND STR 26L AT AFT CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL FITTING BS 927 TO BS 947 AT LEVEL STR25R IAW SRM 51-40-02, SRM 51-10-02 ITEM 9 AND DWG 147A7500 SHEET 29 REV-.SDR SWAA2025122236191Fitting · crackedCRACK FITTING LOCATED STA 947.5 AND STR 26L AT AFT CARGO COMPARTMENT. REPLACED FITTING AND FASTENERS LOCATED STA 947.5 AND STR 26L AT AFT CARGO COMPARTMENT IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG 149A8103 SHEET 7 REV: A.SDR SWAA2025122347480Intercostal · crackedCRACK WEB-INTERCOSTAL LOCATED BTW STA 927 TO STA 947 STR 25R AT AFT CARGO COMPARTMENT. INTERCOSTAL REPLACED IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 147A7500, SHEET 29, REV-. SEE INDIVIDUAL SIGN OFFS BELOW.;[02] REPLACED WEB - INTERCOSTAL LOCATED BS 9SDR SWAA2025122236199Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW STA 727 TO STA 767 AT LEVEL STR 25L AND WL 156 AT AFT CARGO COMPARTMENT (14 EA) 2025-696383<SDR SWAA2025121947486Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727 - 767, S25L, WL 156 IN THE AFT CARGO BAY (14 EA). FAULT RESOLVED ON ANOTHER FAULT TTG8Q018X19T.SDR SWAA2025121947487Web · corrodedCORROSION SHIELD WEB, BETWEEN BS 767 - 794.3, WL 156 IN THE AFT CARGO BAY (4 EA). REPLACED THE SHIELD WEB IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, AND DWG 146A0081, SHEET 37, REV-.SDR SWAA2025121936201Support · corrodedCORRODED SUPPORT ZEE, BETWEEN BS 727 - 807, S25L, WL 156 IN THE AFT CARGO BAY, (12 EA). REPAIRED SUPPORT ZEE IAW SRM 53-00-53-2R-6, REPAIR 6, AND DWG 146A7500, SHEET 113, REV -.SDR SWAA2025121847479Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561CB TRAILING EDGE AT LT WING. REPAIRED THE ACCESS PANEL 561CB TRAILING EDGE AT LT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121835981Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561CB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 561CB TRAILING EDGE AT LT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR WX0A2025121032662Access Panel · damagedTHE ACFT WAS NOT GROUNDED. MAJOR REPAIR. PANEL 540KB MANHOLE COVER FASTENER AREA HAS 4 ELONGATED HOLES, IAW ERO A32X-STR-57ERO-00447. COMPLETED WORK STEPS PARA A. .REPAIRED MOUNTING HOLE NR 1 USING SRM 57-21-11-300-002. DAMAGED FULLY REMOVED. REPAIRED SDR AALA202512094157Skin · crackedAIRCRAFT IN BASE MAINTENANCE: GOUGE, POSSIBLE CRACK ON FORWARD GALLEY SERVICE DOOR SURROUND STRUCTURE AFT FRAME LOWER LATCH TORQUE TUBE CUTOUT SKIN. REMOVED DAMAGE ON FORWARD GALLEY SERVICE DOOR SURROUND STRUCTURE AFT FRAME LOWER LATCH TORQUE TUBE CUTOUT SKIN.SDR SWI2025F01744Seat Track · corrodedRIGHT INBD SEAT TRACK CORRODED BETWEEN FRAME 84-85. )REMOVED AND REPLACED SEGMENT OF RT INBD SEAT TRACK CORRODED BETWEEN FRAME 84-85. IAW ETD2022-170-022163-C, SRM 53-00-10 REPAIR 01P.SDR SWIA20251208117Seat Track · corrodedLH I/B SEAT TRACK CORRODED BETWEEN FRAME 84-85. (C-CHECK RO 12/06/2025)REMOVED AND REPLACED SEGMENT OF LH I/B SEAT TRACK CORRODED BETWEEN FRAME 84-85. REF ETD2022-170-022163-C, SRM 53-00-10 REPAIR 01P. NO CHANGE IN WEIGHT AND BALANCE. SEE CONTINUE CARD FOR WSDR CALA2025120511793Skin · damagedDAMAGE ON THE FWD CARGO DOOR SILL, DAMAGE TO THE OUTER & INNER SKIN OF THE LAP SPLICE BS 490, S24R. DAMAGE OUT OF LIMITS IAW SRM 53-00-01-1A-6. IAW AVO 16027 STEP 1. PERFORMED INSPECTION OF DAMAGED AREA, USING A 20" RADIUS. NO FURTHER DAMAGE NOTED. IAW AVO SDR SWAA2025120336010Handle · unsecureL1 DOOR ASSIST HANDLE NEEDS TO BE SECURED. SECURED L1 DOOR ASSIST HANDLE IAW AMM 52-11-31.SDR SWAA2025120336011Handle · unsecureCR RR R1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR ASSIST HANDLE IAW AMM 52-11-31-020-011.SDR AALA202512028370Ptu · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING TAKEOFF AT APPROXIMATELY 100KTS DUE TO A VERY HARD YAW TO THE RIGHT THEN A REVERSAL TO THE LEFT. FELT LIKE WE POSSIBLY HAD A FLIGHT CONTROL ISSUE WITH THE RUDDER. FIRST OFFICER SAID THE FOOT PEDALSDR AALA202512027613Module · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING TAKEOFF AT APPROXIMATELY 100KTS DUE TO A VERY HARD YAW TO THE RIGHT THEN A REVERSAL TO THE LEFT. FELT LIKE WE POSSIBLY HAD A FLIGHT CONTROL ISSUE WITH THE RUDDER. FIRST OFFICER SAID THE FOOT PEDALSDR SWAA2025120136235Shield · crackedNR 1 ENGINE, SHIELD CRACKED AT THE 2:00 POSITION AFT LOOKING FWD INBD CORE SIDE JUST UNDER AFT MOUNT. R & R HEAT SHIELD IAW AMM 70-51-00.SDR DALA2025120108744Indicator · inoperativeR1 DOOR ARMED KNUCKLE KNOCKER INOP. UPON INSPECTION OF RETRACTABLE DOOR MECHANISM FOUND BOLT MISSING. REPLACED BOLT PER AMM 20-11. CHECKS GOOD. (7379262)SDR AALA202511268050Track · chafedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME-MOUNTED UPPER LATCH TRACK FITTING HAS A CHAFE. REMOVED AND REPLACED RECEIVER AFT GALLEY SERVICE DOOR UPPER FORWARD. PER B737NG SRM51-40-02 AND PERFORMED SATISFACTORY SDR CALA2025112511442Angle · crackedFOUND CRACK AT LOWER FUSELAGE CENTER WING BOX REAR SPAR L/H VAPOR BARRIER UPPER ATTACHED ANGLE @ LBL33 STA 663.5 REF. AAR N/R:99972668 ACCOMPLISHED CAP SEAL AT LH VAPOR BARRIER ANGLE AT STA 663 PER SRM 51-31-00-390-805 WORK ACCOMPLISHED BY:V939559 INSPECTED BSDR QXEA2025112100352Frame · damaged:DAMAGE FOUND ON FRAME 10, STR 13L IN THE FLIGHT DECK. REPAIRED THE FRAME 10 AT STRINGER 13L. IAW T/C ETD 2025-170-932295.SDR QXEA2025112100351Cable · damagedL2 DOOR EMERGENCY SLIDE CABLE MECHANISM DAMAGED AT UPPER SIDE. REPAIRED L2 DOOR EMERGENCY SLIDE CABLE MECHANISM UPPER SIDE IAW AMM 52-12-40-000/400-801-A STEPS 7.5 (2.8).SDR QXEA2025112100350Tube · corrodedNUMBER 2 ENGINE AFT FIRE EXTINGUISHING LINE CORRODED IN MULTIPLE AREAS. REMOVED AND REPLACED THE NR 2 ENG AFT FIRE EXTINGUISHING LINE IAW E175 AMM 20-10-13-000-801-A/400.SDR QXEA2025112100349Tube · corrodedNUMBER 1 ENGINE AFT FIRE EXTINGUISHING LINE CORRODED IN MULTIPLE AREAS. REMOVED AND REPLACED THE NR 1 ENGINE AFT FIRE EXINGUISHER LINE IAW AMM 20-10-13.SDR SWIA2025112100017Rib · damagedDAMAGE ON THE RT WINGLET RIB LOCATED AT RIGHT SIDE WGLTS3.25 WAS FOUND TO BE OUT OF LIMITS PER SRM 57-31-14 . DAMAGE IS OUT OF LIMITS AND THE REPLACEMENT OF THE STRUCTURALLY SIGNIFICANT ITEM IS CLISSIFIED AS A MAJOR REPAIR. REPLACED RT WINGLET RIB P/N 600-1SDR SWAA2025112036060Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK M1695 WILL NOT HOLD CHARGE. REMOVED & REPLACED THE BATTERY IAW AMM 33-51-06-960-805. OPS CHECK GOOD.SDR SWAA2025112036061Fitting · crackedNR 2 AFT PYLON STRUT FAIRING HAS A CRACKED FITTING. REMOVED CRACKED PYLON BRACKET FITTING IAW SRM 51-40-02. LOCATED AND DRILLED NEW END FITTING ASSY IAW SRM 51-40-02. C/W INSPECTION OF CA NR 2. INSTALLED NEW END FITTING ASSY IAW SRM 51-40-02.SDR FDEA202511172186Floorbeam · corrodedAFT CARGO COMPARTMENT BS 1560 LBL 45.50 UPPER FLOOR BEAM LOWER CHORD WITH CORROSION. COMPLIED WITH FEDEX EA # F-5310-T0385569 P1 TILE: FUSELAGE -MAINFRAME CORROSION REPAIR -STA 1560 FLOOR BEAM LOWER FLANGE DAMAGESDR CALA2025112011360Sign · detachedEMERGENCY EXIT SIGN AT DOOR 3R HANGING BY ITS WIRES. PICTURE FO UPDATE INSTALLED TIE WRAPS PER ECRA 3351-01522. DEFFERED EMERGENCY EXIT SIGN DOOR PER MEL 3351-A. ECRA 3351-01522 HAS BEEN COMPLIED WITH. MEL 3351A TOMC REJECTS ACCOMPLISH DIP PER ECRA 3351-01522 SDR CALA2025112011354Door · out of adjustDOOR WARNING ANNUNCIATOR IS ON AFT SERVICE S195 SHOWING INTERMITTENTLY TARGET FAR WITH DOOR CLOSED AND LOCKED, REQUESTING 5203C VERIFIED ONLY AFT SERVICE DOOR IS INTERMITTENT. WILL VERIFY R2 DOOR IS CLOSED AND LOCKED PRIOR TO DEPARTURE. DISPATCH DESK: TOMC APPSDR DALA2025111908476Slider · fodR1 DOOR SLIDE LIGHT IS ILLUMINATED WITH DOOR DISARMED. REMOVED DEBRIS FROM AFT GIRT BAR SLIDER. OPS CHK NORMAL PER B757 AMM 52-71. (7887028)