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 FDEA202508181495Repair · no discrepancyEXISTING REPAIR AT LEFT HAND WING FIXED LEADING EDGE COMPARTMENT BEADED DOUBLER BETWEEN STATION XOS 629 TO XOS 634 EXISTING REPAIR AT LEFT HAND WING FIXED LEADING EDGE COMPARTMENT BEADED DOUBLER BETWEEN STATION XOS 629 TO XOS 634 EVALUATED AND FOUND REPAIRSDR FDEA202508181494Repair · not reportedEXISTING REPAIR AT LEFT HAND WING FIXED LEADING EDGE COMPARTMENT BEADED DOUBLER BETWEEN STATION XOS 621 TO XOS 625 EXISTING REPAIR AT LEFT HAND WING FIXED LEADING EDGE COMPARTMENT BEADED DOUBLER BETWEEN STATION XOS 621 TO XOS 625 EVALUATED AND FOUND REPAIRSDR FDEA202508181493Floor Panel · dentedRAMP REPORTS POSSIBLE FLOOR DAMAGE ON MAIN CAGO DECK FLOOR PANEL 232LFF, P/N 143T5876-128, APPROX STA.654 22 TO STA.700 BETWEEN RBL54.75 TO RBL 77.5. REPAIRED MAIN DECK FLOORBOARD PANEL # 232LFF, P/N 143T5876-128, AT STA 654- STA 700, RBL 54.75"- RBL 77.50"SDR FDEA202508181492Seat Track · chafedEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1531 TO STATION 1631 X = -8.5 RIGHT HAND SIDE EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN BS 1531 TO 1631 X = -8.5 RT SIDE EVALUATED AND FOUND CHAFFEDSDR IPXA2025081826064Light · inoperativeFOUND THE UPPER DECK AISLE EMERGENCY LIGHT M4915 AND L5733 INOPERATIVE.SDR IPXA2025081828045Battery Pack · inoperativeEMERGENCY DOOR LIGHTS AND R/H DOME EMERGENCY LIGHT INOP. REPLACED M735 EMERGENCY BATTERY PACK AND TESTED LIGHT SATIS IAW AMM 33-51-07-401 REV 145.SDR DALA2025081806146Flap System · lockedSHIP 3714 -UFC/DE- DECLARED EMERGENCY DUE TO FLAP LOCKOUT ON APPROACH TO LAND. CORRECTIVE ACTION: REPLACED FSEU. LUBRICATED #1 FLAP ROLLER. AHM REPORT SHOWS #4 SKEW SENSOR INVALID. REPLACED #4 AND #7 SKEW SENSORS. OPS CHECK GOOD.SDR IXXA20250818002Skin · dentedSTA 1576 STR 15L NEW DENT ON AFT FUSELAGESDR QR9R2025081800001Fire Bottle · unserviceableAFTER RECEIPT OF PART FROM SUPPLY, MAINTENANCE DETECTED THE FIRE BOTTLE SQUIB CARTRIDGE WAS LOOSE. REPLACED FIRE BOTTLE IAW AMM 26-21-01, 4-3.SDR REXA2025081800808Floorbeam · corrodedR/H F.S.280 CROSSBEAM APPEARS TO BE CORRODED ON AFT EDGE UNDER CAP ANGLE, RBL 11. REMOVED RH FS280 BULKHEAD CROSSBEAM BETWEEN BL 0 TO RBL37, IAW CRJ-900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. INSTALLED NEW SERVICEABLE RH FS280 BULKHEAD CROSSBESDR 2A6D20250818001Mount Flange · gougedDAMAGE TO THE LANDING GEAR LH OTBD AFT BEARING IN THE FORM OF GOUGE. THE GOUGE DAMAGE IS AT LOWER FLANGE OF THE BEARING AND WAS MEASURED TO BE APPROXIMATELY 0.3895” X 0.1105” X DEPTH MORE THAN HALF THE THICKNESS OF THE BEARING.SDR IXXA20250818001Skin · corrodedCORROSION ON LEFT WING UPPER SURFACE AT WSTA 120.00,34 INCHES AFT OF LEADING EDGE. FOUND TO BE OUT OF LIMITS DUE TO FASTENER PROXIMITY.SDR QMLA2025081820088Control Unit · failedNR 2 ENG FADEC FAIL IN FLIGHT. SLIDE ON LANDING NO DAMAGE. TROUBLESHOT DOWN TO NR 2 ENGINE FADEC ( EECU ) INOPERATIVE. READ POWER TO CONNECTORS, SWAPPED EECU WITH NR 1 SIDE AND PROBLEM FOLLOWED. INSPECTED AIRCRAFT FOR OTHER DAMAGE OF SKIDS AND SKID PLATES. ALSDR SCNA20250818325Bracket · loose1R SLIDE BRACKET LOOSE. ADJUSTED R1 DOOR SLIDE BRACKET REF AMM 25-66-01.SDR JR2R20250818444Cam · chafedAFT CARGO DOOR, FORWARD AND AFT VENT BOX CAMS WORN. REPAIREDSDR JR2R20250818445Cam · chafedFORWARD CARGO DOOR, FORWARD AND AFT VENT BOX CAMS WORN. REPAIREDSDR 2025FA0000546Compressor Blade · dentedHAESL REPORTED RIPPLED FOUND ON THE CONCAVE SIDE OF THE AIRFOIL (LPC BLADE) WHICH EXCEEDED THE RR RM REPAIR LIMIT. THE LPC BLADE WAS REJECTED (CSN: 10715 FC) BEFORE ITS DECLARED LIFE IN TLM (15000 FC). THIS IS AN ENGINE INPUT FROM AMERICAN AIRLINE. DETAILS OF SDR 9WGA2025082354636Spar · corrodedDURING HEAVY MAINTENANCE CHECK RH OUTER WING LOWER REAR SPAR HAS CORROSION @ APPROX. (XORS-597). AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS, AT RH OUTER WING LOSDR 9WGA202608204635Spar · corrodedDURING HEAVY MAINTENANCE CHECK RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-581. AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR & BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS, AT RT OUTER WING LOWER SDR 9WGA2026012024634Spar · corrodedRIGHT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX. XORS-574. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RT OUTER WING LOWER REAR SPAR AT APPROX. XORS-5SDR SWIA2025123000817Frame · corrodedSIGNS OF CORROSION NOTED AT BS 847.00+16, STRINGER 26R. REPAIRED DAMAGE ON BS 847+16, STGR 26R IAW REO 690-53-51-511, REV-P1. SRM 51-42-06, 53-51-06, 51-42-21, 51-21-11, 51-25-06, 51-25-16, AND AMM 20-70-00.SDR SWI2025F01687Lever · chafedFWD BAGGAGE BAY DOOR AFT OUTER LEVER HAD CHAFE DAMAGE. REPAIRED AFT OUTER LEVER IAW TEMPORARY REO 690-52-35-586, REV -. COMPLETED SKYWEST TASK CARD 51-900-1002-SKY.SDR SWI2025F01686Door Frame · crackedLEFT FORWARD OVERWING EMERGENCY-EXIT DOOR TOP EDGE MEMBER CRACKED AT AFT TANG FITTING. REPAIRED LEFT FORWARD OVERWING EMERGENCY-EXIT DOOR TOP EDGE MEMBER AT AFT TANG FITTING IAW REO 670-52-21-103, REV -, STEPS 1-17. COMPLETED SKYWEST TASK CARD 51-900-1002-SKSDR SWI2025F01685Door Frame · crackedRIGHT FORWARD OVERWING EMERGENCY-EXIT DOOR TOP EDGE MEMBER CRACKED AT AFT TANG FITTING. REPAIRED TOP EDGE MEMBER CRACK AT AFT TANG FITTING REF REO 670-52-21-103 REV-. COMPLETED SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA20251202817Structure · crackedLEFT AFT OVERWING EMERGENCY-EXIT DOOR TOP EDGE MEMBER CRACKED AT FORWARD AND AFT TANG FITTING. REPAIRED LEFT AFT OVERWING EMERGENCY-EXIT DOOR IAW REO 670-52-21-103, REV-.SDR SWAA2025093005270Lens · crackedCRACKED EXIT SIGN LENS AFT LT DOORWAY LINING. REPLACED THE EXIT SIGN LENS IAW AMM 33-51-01-960-801.SDR SWAA2025092905480Gusset · crackedCRACK GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 19R AT FWD CARGO COMPARTMENT. REPLACED GUSSET LOCATED BS 500I AT LEVEL STR 19R AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02; AND DWG 143A7902; SHEET 256; SHEET 257 REV. B.SDR SWAA2025092905481Gusset · crackedCRACK GUSSET ANGLE LOCATED BS 500I AT LEVEL STR 21L AT FWD CARGO COMPARTMENT. REPLACED GUSSET LOCATED BS 500I AT LEVEL STR 21L AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG 143A7902; SHEET 256; SHEET 257 REV. B.SDR SWAA2025092905375Web · crackedCRACK ON WEB LOCATED BTW BS 312 TO BS 328 RBL 31 WL 208.1 AT FWD GALLEY AREA. REPLACED WEB AND FASTENERS LOCATED BTW BS 312 TO BS 328 RBL 31 WL 208.1 AT FWD GALLEY AREA IAW SRM 51-40-02; SRM 51-10-02 AND DWG 141A5400 SHEET 39 REV -.SDR 9WGA2025092654679Spar · corrodedDURING HEAVY MAINTENANCE RH OUTER WING LOWER REAR SPAR HAS CORROSION @ APPROX (XORS-799). AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RH OUTER WING LOWER REAR SDR 9WGA2025092654678Spar · corrodedDURING HEAVY CHECK RT OUTER WING UPPER REAR SPAR HAS CORROSION AT APPROX XORS-608. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RH OUTER WING UPPER REAR SPAR ATSDR 9WGA2025092654666Spar · corrodedDURING HEAVY CHECK RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-601. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANANET REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RH OUTER WING LOWER REAR SPAR ASDR 9WGA2025092554677Spar · corrodedDURING HEAVY MAINTENANCE, RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-597. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RT OUTER WING LOWER REAR SDR 9WGA2025092554675Spar · corrodedDURING HEAVY MAINTENANCE RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-574. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED LOCATION AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT RH OUTER WING LOWER REAR SSDR 9WGA2025092554674Spar · corrodedDURING HEAVY MAINTENANCE, RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-536. ACCOMPLISHED STRAP AND SHIM REPAIR AT R/H WING OUTER LOWER REAR SPAR AFT FLANGE AT XORS 544.000 IAW MD-11 SRM 51-35-01 AND BOEING MESSAGE WGA-WGA-26-0020-01C. THE AIRCRSDR 9WGA2025092454673Spar · corrodedDURING HEAVY MAINTENANCE LH OUTER WING UPPER REAR SPAR HAS CORROSION @ APPROX (XORS-694). AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED AREA AS A PERMANENT REPAIR AND BEEN ACCOMPLISHED WITH ALL THE REQUESTED PROVISIONS AT LH OUTER WING UPPER REAR SPARSDR 9WGA2025092454672Spar · corrodedLEFT OUTER WING UPPER REAR SPAR HAS CORROSION @ APPROX. (XORS-702). AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANNET REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT LH OUTER WING UPPER REAR SPAR AT APPROX AT XORS-7SDR SWAA2025092305468Rib · crackedCRACKED ACCESS PANEL 331B LEADING EDGE ON RIB, LE STA 95.96 AT LT HORIZONTAL STABILIZER. REPLACED RIB LOCATED ON ACCESS PANEL 331B LEADING EDGE ON STA95.96 AT LT HORIZONTAL STABILIZER. IAW SRM 51-40-02-0G-0, AND DWG 186A1001-1, SHEET 19, REV-.SDR SWAA2025092305370Intercostal · crackedCRACKED WEB BTW BS 294.5 & 303.9, STR 16L, FWD GALLEY AREA. REPLACED WEB-INTERCOSTAL IAW SRM 51-40-02-0G-0, DWG 141A8180, SHEET 27, REV C, DWG 141A8180, SHEET 28 C, & DWG 141A8180, SHEET 30, REV C.SDR SWAA2025092305369Tie Clip · crackedCRACK TIE CLIP BS 277, STR 10R, PAX CABIN. REPLACED THE TIE CLIP IAW SRM-51-40-02, DWG 141A1110, SHEET 18, REV-, AND DWG 141A8380, SHEET 21, REV-.SDR SWAA2025092305371Frame · crackedCRACK FRAME ON BS 312 BTW STRINGERS 4L - 5L IN FWD GALLEY AREA. PERFORMED FRAME REPAIR IAW M-22-153-01244.SDR IXXA20250923001Latch · bent#2 ENGINE, INBOARD THRUST REVERSER, LOWER END, FWD LATCH BOX HAS CHAFE MARK AND BENT.SDR SWAA2025092205466Frame · crackedCRACKED FRAME ON BS 907 BTW STRINGERS 8R & 9R IN PAX CABIN. PERFORMED A PERMANENT FRAME REPAIR IAW EA 25-153-02348, REV A.SDR AALA202509058701Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON EXTERNAL SKIN GOGO ANTENNA DOUBLER / COVER PLATE BETWEEN FR 56 AND FR 57, BETWEEN S42L AND S43L. REPLACED GOGO ANTENNA DOUBLER / COVER PLATE PER SRM 51-72-11.SDR SWAA2025090405377Web · corrodedCORROSION ON WEB LOCATED BTW BS 440 TO BS 492 AT LEVEL STR 18R AND WL 201 AT FWD CARGO COMPARTMENT. REPLACED WEB AND FASTENERS UPPER WEB LOCATED BTW BS 440 TO BS 492 AT LEVEL STR 18R RBL 70 WL 201 IAW SRM 51-40-02-0G-0 AND DWG 143A8111; SHEET 12; REV.A. AND DSDR SWAA2025090305368Handle · looseL1 FWD ENTRY DOOR ASSIST HANDLE LOOSE. THIGHTNED L1 FWD ENTRY DOOR ASSIST HANDLE IAW AMM 52-11-31-400-802.SDR SWAA2025090305461Support Beam · out of limitsINBOARD FWD SUPPORT ROD ATTACH POINT ON I/B SUPPORT BEAM ASSY COMMON TO FWD BEARING WALLOWED OUT BEYOND LIMITS ON COMMON TO LT WING T/E PANEL 551GB. REMOVED I/B FWD SUPPORT ROD ATTACH POINT ON I/B SUPPORT BEAM ASSY COMMON TO FWD BEARING IAW 51-40-02-0G-0. INSDR R61A2025090200380Stringer · corrodedSTRINGER 28R CORRODED AT FRAME 86/87. REPAIRED STRINGER 28R FR 83-90. REF:ETD2025-170-926813SDR DALA2025090206477Handle · detachedATB - DUE TO A LEFT AFT OVERWING EXIT OPEN MESSAGE. HANDLE COVER FELL OFF. REINSTALLED THE EXIT HANDLE COVER FLAP. PANEL WAS REPORTED AS VERY SECURE AFTER BEING REINSTALLED. POSSIBLY DISLODGED BY A PASSENGER.SDR AALA202508290913Slide · deterioratedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EMERGENCY ESCAPE SLIDE GIRT FLAP IS DETERIORATED. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE.