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 VNAA20260203011Frame · corrodedCORROSION ON FRAME STA 863 STRINGER 27. THE FRAME WAS REMOVED IAW SRM 51-21-06-001-001-A01, EVALUATED WITHIN LIMITS IAW SRM 53-51-06-101-003-A01, & SRM 53-00-00-101-001-A01.SDR VNAA20260203010Seat Track · corrodedCORROSION AND WEAR SEVERAL POINTS ON SIDE SEAT TRACK, BS 669.40 - 977 LT& RT IN THE PASSENGER CABIN. THE SEAT TRACK WERE REPLACED IAW SRM 53-00-49-400-801 CONF. A03, AND EVALUATE IAW SRM 53-51-49-101-001-A01.SDR VNAA20260202007Frame · corrodedCORROSION ON FRAME FS349.00 BETWEEN STGR25L TO STGR26R. DUE TO EXCESS DAMAGE ON FRAME FS349.00 BETWEEN STGR25L AND STGR26R WAS REPLACED PER SRM 53-00-06-201-005-A01 AND 51-42-21-001-001-A01 AND SRM 51-42-06-001-001-A01SDR JJBA20260130058Seat Track · gougedGOUGES ON THE CENTER FLOOR SEAT TRACK AT FRAME 57. REMOVED GAUGES IN THE CENTER FLOOR SEAT TRACK AT FRAME 57SDR JJBA20260130057Floor Support · corrodedCORROSION ON THE LH SILL AT FRAMES 57. REMOVED ORIGINAL LH SILL FROM FRAME 53 TO FRAME 59, INSTALLED NEW FROM STOCKSDR JJBA20260130056Floor Support · corrodedCORROSION ON THE LT FLOOR SUPPORT, FRAMES 59 AND 61. INSTALLED A NEW FLOOR SUPPORT AND SPLICE AT LT FR 59-61.SDR JJBA20260130055Gusset · corrodedCORROSION ON THE LT GUSSET FRAMES 60-61. INSTALLED NEW GUSSET AT LH FR60-FR61SDR JJBA20260130045Skin · dentedFUSELAGE EXTERNAL MID SKIN AT FR 8, LH, HAS DAMAGE. PERFORMED RECONTOUR TO DENTED AREA BTW FR 8 - 9, AT STGR 17LSDR SWAA2026011943437Bracket · crackedRIGHT WING T/E ORSS 280 L-ANGLE COMMON TO DEFLECTION CONTROL RIB AND T/E UPPER SURFACE PANEL IS CRACKED. REMOVED AND INSTALLED NEW L ANGLE IAW SRM 51-40-02-0G 2.SDR 3EJA202601150005Valve · failedDURING TAKE-OFF, APPLIED TAKE-OFF POWER, AND THE PRESSURIZATION CLIMB RATE WENT TO -1000 FPM. REMOVED AND REPLACED RT ENG BI LEVEL FLOW VALVE, OPS CHKD GOOD.SDR SWAA2026011447658Angle · crackedRIGHT WING T/E ORSS 280 L ANGLE COMMON TO DEFLECTION CONTROL RIB AND T/E UPPER SURFACE PANEL IS CRACKED. REMOVED AND INSTALLED WITH A NEW L ANGLE IAW SRM 51-40-02-0G.SDR SWAA2026011343419Support Angle · crackedCRACKED SUPPORT ANGLE BTW BS 380 - 400, BL 0, WL 208.1. REPLACED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 177, REV A.SDR SWAA2026011343429Support Angle · crackedCRACKED SUPPORT ANGLE, BTW BS 380 - 400, RBL 40, WL 208.1. REPLACED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 184, REV -.SDR SWAA2026011343432Support Angle · crackedCRACKED SUPPORT ANGLE, BTW BS 380 - 400, LBL 53, WL 208.1. REPLACED THE SUPPORT ANGLE & FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 183, REV-.SDR SWAA2026011343427Tie Clip · crackedCRACKED TIE CLIP, BS 277, S10R IN FWD GALLEY. MEASUREMENT OF CRACK: L: 0.416 INCHES. REPLACED TIE CLIP IAW SRM 51-10-02-0G, SRM 51-40-02-0G, AND DWG 141A1110, SHEET 55, REV-.SDR SWAA2026011343428Support Angle · crackedCRACKED SUPPORT ANGLE, BTW BS 380 - 400, LBL 13, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 184, REV -.SDR SWAA2026011343426Frame · crackedCRACK ON FRAME, BS 312 BTW S5 - 6L. PERFORMED PERMANENT REPAIR TO THE FRAME IAW EA M-22-153-01244, REV B.SDR SWAA2026011343508Support Bracket · crackedCRACK ON SUPPORT BRACKET, BS 867 BTW S2 & 3R. REPLACED THE SUPPORT BRACKET IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 146A7901, SHEET 66, REV A.SDR SWAA2026011243314Scuff Plate · crackedCRACK CENTER SCUFF PLATE AT FWD SERVICE DOOR. REPAIRED THE CENTER SCUFF PLATE IAW SRM 53-10-15-2R-2, REPAIR 2. AND BAC 5975.SDR SWAA2026011243548Support Angle · crackedCRACKED SUPPORT ANGLE, BS 294.5, S13L. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, STEP 9, AND DRAWING 141A1311, SHEET 1, REV C.SDR SWAA2026011243547Stringer · crackedCRACKED STRINGER U-8 INTERNAL AREA FUEL TANK UPPER POSITION LOC BTW RIB 19 AND RIB 20 AT RT WING. ACCOMPLISHED EA 25-157-03409-WIP1.SDR AALA202601103578Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL LOCATED FR66 RH SIDE AT AFT GALLEY AREA. MAINTENANCE PERFORMED REPAIRED LOC. ON LOWER SILL LOCATED FR66 RH SIDE AT AFT GALLEY AREA IAW A320 SRM A320 SRM 53-41-14-300-001.SDR ASAA2025120663500Web · corrodedAFT CARGO DOOR WEB SILL HAS CORROSION IN MULTIPLE SPOTS (MARKED). GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED IAW B737-900ER SRM 51-40-02-0G & 51-40-05-0GW: 1" O: 0.050" R: 0.041" L: 2 D: 0.009".SDR SWIA2025123100006Rib · crackedSUSPECTED CRACK RT HORIZONTAL RIB 12 UPPER FLANGE. REMOVED AND REPLACED RT HORIZONTAL RIB 12A REF ETD2025-170-933725, SRM 51-40-08. REPLACED WITH OEM PRODUCT, NO WEIGHT AND BALANCE AND ADJUSTMENT REQUIRED.SDR AALA202512302480Spigot · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SPIGOT SLEEVE OF LEFT PYLON (L: 7.570 IN). MAINTENANCE REPLACED SPIGOT SLEEVE ON LH PYLON IAW AMM 57-26-12-400-002-A STEP 4.A.SDR SWAA2025122954814Window Post · crackedCAPTAIN`S WINDOW POST AT UPPER LT CORNER CRACKED. CAPTAIN'S WINDOW POST AT UPPER LEFT CORNER WAS REPAIRED AND DOCUMENTED ON CCN TTG8Q0199APB WITH ADDITIONAL INSTRUCTIONS PROVIDED ON EA 25-153-03346.SDR SWAA2025122343445Access Panel · crackedCRACK LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE HSS 105.26, LT HORIZONTAL STAB. REPLACED RIB LEADING EDGE ACCESS PANEL 331B IAW SRM 51-40-02, AND DWG 186A1001, SHEET 10, REV A.SDR KCSA202512170671Girt Bar · fod100278365: L1 DOOR GIRT BAR FROM SLIDE DROPPED WHEN DOOR OPENED. L/H SIDE GIRT BAR DROPS FROM INSIDE VIEW. TRANSFERRED TO DMI 100278365 IAW B777 MEL B 25-10, 52-11-01-01B. CAT C DUE 12-16-25.
PLACARDS INSTALLED "M" PROCEDURES C/W. 100287409: REFERENCE DMI SDR DALA2025121609163Bottle · low pressureR4 DOOR PRESSURE LOW. SERVICED DOOR BOTTLE PER AMM 52-15. OK FOR SERVICE. (7928488)SDR AALA202512169162Wire Harness · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 26ABC ON OVERHEAD VALENCE INOPERATIVE. WHILE TROUBLESHOOTING FOUND WIRE BUNDLE DISCONNECTED, RESECURED WIRE BUNDLE. PER WDM 33-51-04. LIGHTS OPERATIONAL CHECK GOOD.SDR AALA202512162027Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SPIGOT RECEPTACLE FITTING OF LEFT PYLON. MAINTENANCE REPLACED LOWER SPIGOT FITTING ON LH PYLON IAW A320 SRM 54-51-12-300-002.SDR DALA2025121509132Bolt · missingMISSING AND SUNKEN BOLTS ALONG DOUBLER SPLICE APPROX BTW STA ZFS=49 AND ZFS=76 AT VERTICAL STABILIZER LEADING EDGE. REPAIRED PER ER/A 630634-14. (1338826)SDR AALA202512150307Engine · stalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO SMF DUE TO THE FLIGHT CREW REPORTING MULTIPLE BIRD STRIKES DURING CLIMB OUT ALONG WITH A #1 ENGINE STALL / SURGE AND THE ENGINE THEN CAME BACK. THE AIRCRAFT LANDED SAFELY AT SMF AND SDR BAGA2025121100004Coffeemaker · odorMOMENTRY SMELL OF SMOKE FROM AFT GALLEY COFFEE POT. FA REPORTED SMELL WENT AWAY AFTER COFFEE MAKER 2 IN AFT GALLEY WAS SHUT OFF AT THE CMS. REMOVED COFFEE MAKER. FOUND NO EVIDENCE OF BURNS. REINSTALLED COFFEE MAKER. NO EMERGENCY DECLARED, AND NO PAX OR CREW RSDR ANCF2025120637Wheel · vibrationSTRONG AND CONTINIOUS NOISE ON NOSE GEAR COMPARTMENT, DURING THE INITIAL CLIMB THROUGHT 12.000FT A STRONG AND CONTINIOUS NOISE WAS HEARD AND FELT IN THE NOSE GEAR COMPARTMENT. RETURNED TO THE AIRPORT OF ORIGIN. I.A.W TSM 32-20-00-840-802-A STEP B(5), PERFORMESDR ASAA2025120662879Power Supply · inoperativeWHILE PERFORMING T/C 78233008 EMERGENCY LIGHT-OPS CHECK FOUND LH & RH EXIT INDICATOR SIGNS INOP. GROUNDED - YES. DURING WIRING T/S, FOUND BOTH SIDE O/W DOOR TRIM HTR WIRE CONNECTED WITH BOTH SIDE FWD O/W EXIT IND LT(D12068-D12704, D12072-D12706, D12064-D12680,SDR SWAA2025121043377Skin · crackedDURING INSPECTION OF AFT CARGO DOOR DENT, A CRACK WAS FOUND WITHIN THE DENT, MEASURING .156 IN L, .031 CRACK UPSET LIES WITHIN THE WELL OF THE DENT AND EXTENDS TO DOOR EDGE. C/W EA 25-152-03340. ACFT OK FOR CONTINUED SERVICE.SDR SWAA2025121050697Girt Bar · out of alignmentCREW REPORTED FWD SERVICE DOOR GIRT BAR GETTING CAUGHT ON DOOR FRAME. SECURED FWD SERVICE DOOR GIRT BAR IAW EA M23-125-01839.SDR SWAA2025121050129Frame · debondedLEFT CONDUCTIVE FRAME AT RUDDER WAS DISBONDED REF TLD 25-155-03112 TTG8Q018TDJK. REMOVED 6.125 IN. SECTION OF DISBONDED LOWER CONDUCTIVE FRAME AT RUDDER TE IAW SRM 55-40-01-1A-3. REMOVED SIX RIVETS AT RUDDER TE TO FOM IAW SRM 51-40-02. PERFORMED PERMANENT SDR SWAA2025121043590Tailpipe · fireGROUND CREW REPORTED A TAILPIPE FIRE ON THE NR 1 ENGINE AFTER SHUTDOWN. NO INDICATIONS IN THE FLIGHT DECK OR CABIN. PERFORMED TAILPIPE FIRE INSPECTION IAW EA M-23-172-03308-ETOPS.SDR SWAA2025121043254Battery Pack · inoperativeR/H OVERWING EMERGENCY LIGHTS ARE INOPERABLE. REMOVED AND REPLACED THE RT OVERWIND EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06.SDR DALA2025121009020Door Frame · damagedAFT CARGO DOOR FRAME STATION 944 - FOUND PLUG RIVET UNDER SPLICE PLATE REMOVED FOR REPAIR. REPAIRED PER ER/A 630377-14 REV. ORIG. (1338586)SDR DALA2025121009017Battery Pack · faultedSEAT ROWS 23-29 CEILING EMER LIGHTS GO OFF AFTER SHORT TIME. REMOVED AND REPLACED BATTERY FOR PACK B5-231 PER B717 AMM 33-51. (8071402)SDR AALA202512106348Shade · stuckAIRCRAFT WAS NOT GROUNDED: EXIT ROW 14F WINDOW SHADE WILL NOT OPEN. MAINTENANCE REMOVED SHADE AND REPLACED.SDR CVGA20251210001Power Supply · intermittentAUTOPILOT DISENGAGED AND THEN WE HAD A COMPLETE NAVIGATION FAILURE ON THE PFDS AND THE MFD. FMS DATA WAS REMOVED. RED FLAG BOXES ON THE PFD WERE FMS, FD, AND RA. THE MOVING MAP, RUDDER BOOST , CDU, AND TRANSPONDER, FAILED. THE RTU WAS ONLY ABLE TO INPUT COM1/NSDR CALA2025121012008Linkage · faultedNO WATER AVAILABLE, NO PRESSURE FOR TOILET. WASTE TANK 3 FULL. ON GROUND NO WATER AVAILABLE IN ACFT. WATER SERVICE CART CONFIRMED WATER TANKS FULL. ALL HANDLES CLOSED-NORMAL POSITION, CYCLED DURING SERVICE. STILL NO WATER, CONFIRMED WATER COMPRESSOR RUNNING SDR CALA2025121011974Floor Support · corrodedMAIN CABIN FLOOR SUPPORT CORRODED ON UPPER FLANGE FROM BS 953 - 958, LBL 51. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02 AND SRM 51-40-05 REF AIPC 57-42-51 AND DWG 147A5650 REV C.SDR SWAA2025120943353Hook · brokenFWD SERVICE DOOR GIRT BAR HOOK BROKEN. PREVIOUSLY COMPLIED WITH EA M23-125-01839.SDR SWAA2025120943349Light · faultedLEFT FWD OVERWING EMERGENCY EXIT LIGHT FLICKERING. PERFORMED PHASE 2 DATA LOAD. OP CHECK GOOD IAW AMM 23-42-03.SDR AALA202512099162Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 26ABC ON OVERHEAD VALENCE INOPERATIVE. (OPEN).