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 SWIA2025122775787Window Frame · crackedPILOT WINDSHIELD OUTBOARD POST LOWER OUTBOARD CLIP IS VISIBLY CRACKED. REMOVED AND REPLACED WITH 1 EA OF NEW PILOT WINDSHIELD OUTBOARD POST LOWER OUTBOARD CLIP REF. SRM 51-42-21 AND DWG 601R33007 REV -U.SDR REXA2026030900183Rib · crackedCRACK ON MACHINED RIB OF LEADING EDGE ON SS57.16 SIDE LEFT WING CRACK ON MACHINED RIB OF LEADING EDGE ON SS57.16 SIDE LEFT WING WAS REPAIRED REO 690-57-41-240 REV.-SDR REXA2026030900168Rib · crackedCRACK ON MACHINED RIB LEADING EDGE SS57.16 AT RIGHT WING. CRACK ON MACHINED RIB LEADING EDGE SS57.16 AT RIGHT WING WERE REPAIRED PER GREO 690-57-41-240 REV--SDR SWAA2026012855959Fitting · crackedCRACKED FITTING, BS 947.5, S26L. REPLACED THE FITTING AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 149A8103, SHEET 7, REV A.SDR SWAA2026012856045Web · crackedCRACKED WEB, ORSS 271 RT WING T/E. REPLACED THE WEB IAW SRM 51-10-02, STEP 9, SRM 51-40-02-0G-0, & DWG 115A2512, SHEET 16, REV-.SDR SWAA2026012856040Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 193AL ON BODY FAIRING. REPAIRED ACCESS PANEL 193AL IAW SRM 51-70-05-2R-8, REPAIR 8.SDR SWAA2026012856037Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561AB, T/E LT WING. REPAIRED THE ACCESS PANEL 561AB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026012856038Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561BB T/E LT WING. REPAIRED THE ACCESS PANEL 561BB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026012856039Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561CB TRAILING EDGE AT LT WING. REPAIRED THE ACCESS PANEL 561CB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026012755964Shield · corrodedCORRODED SHIELD WEB, BTW BS 767 - 787, RBL 22, WL 156.1 IN THE AFT CARGO BAY. REPLACED THE SHIELD WEB IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 146A0081, SHEET 37, REV-.SDR SWAA2026012755962Angle · crackedCRACKED ANGLE LOCATED BS 867, STR 26L AT AFT CARGO COMPARTMENT. REPLACED ANGLE LOCATED BS 867, STR 26L IAW SRM 51-40-02 AND DWG 149A8102 SHEET 17 REV -. MEASUREMENT OF CRACK: 0.746 IN.SDR SWAA2026012155952Angle · crackedCRACKED ANGLE, FLOOR STRUCTURE BS 500I AT STR28L IN FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-05, SRM 51-20-01, DWG 143A7902, SHEET 320, REV -.SDR SWAA2026012155953Angle · crackedCRACKED ANGLE LOCATED FLOOR STRUCTURE BS 500I AT STR28R IN FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-05, SRM 51-20-01, DWG 143A7902, SHEET 320, REV -.SDR SWIA2026012175092Seat Track · damagedCENTER FUSELAGE III RT INBD SEAT TRACK HAS SEVERAL DAMAGES FROM FR 74 TO FR 84. REMOVED AND REPLACED SEAT TRACK FR 74 TO FR 84 IAW SRM 51-40-08. REPLACED WITH NEW OEM PART,SDR SWIA2025122775089Seat Track · damagedCENTER FUSELAGE III LEFT INBD SEAT TRACK HAS SEVERAL DAMAGES FROM FR 74 TO FR 84. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-08.SDR SWIA2025122775087Seat Track · gougedRIGHT CENTER SEAT TRACK SEGMENT FR 43-59 HAS NICKS & GOUGES AT FRAMES 45, 47, 50, 52, 53, 56, AND 58. REMOVED AND REPLACED RT CENTER SEAT TRACK SEGMENT FR43-59. IAW SRM 51-40-08.SDR SWAA2026011955971Rib · crackedCRACKED INSPAR RIB 120.30 LOCATED AT 36 INCHES OF FRONT SPAR AT RT HORIZONTAL STAB. REPAIRED INSPAR RIB LOCATED STAB STA 120.30 AND 36 INCH FROM REAR SPAR AT RT HORIZONTAL STABILIZER IAW SRM 55-10-09-2R-5, REPAIR 5.SDR AALA202601156552Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 947, RBL 23. REPLACED FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202601150567Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F PLUS 16 INCHES, AT RL 30. REPAIRED TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR SWAA2026011255864Tee Fitting · crackedPANEL 195AL FWD SUPPORT TEE FITTING CRACKED AT LOWER END BS 520. REMOVED PANEL 195AL FOR ACCESS IAW AMM 53-51-21-000-802. REMOVED AND REPLACED WING TO-BODY FIRING SUPPORT FRAME BS 520 IAW SRM 51-40-02 AND DWG 116A3010 REV: B. CLOSED PANEL 195AL IAW AMM 53-51SDR CALA2026011212866Battery Pack · inoperativeEMERGENCY LIGHT BATTERY M1671 HAS LOW VOLTAGE CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M1671, OPS CHECKED GOOD IAW AMM 33-51-06-906-805.SDR AALA202601108908Apu · contaminatedAIRCRAFT WAS GROUNDED: WHEN AIRCRAFT WENT TO IDLE ON DESCENT, FO AND MYSELF NOTICED HEAVY "DIRTY SOCK" SMELL. IT WAS ONLY IN COCKPIT. MAINTENENCE DEONTAMINATED APU AND ACCOMPLISHED J/C 26L00021002 AND 26L00021014, NO LEAKS NOTED FROM APU OR COMPONENTS. OK FORSDR AALA202601084562Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202601081496Fuel Control · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT FUEL TANK PUMP 2 LOW PRESSURE ECAM MESSAGE AT FLIGHT LEVEL 340. FLIGHT CREW ACCOMPLISHED ECAM PROCEDURES AND TURNED PUMP 2 OFF. **SUPPLEMENTAL REPORT FOR AALA202512311496 SUBMITTED 12/31/2025 BY TUL: MAINTENANCE REPLACED LEFT WISDR DALA2026010700134Elec Connector · unsecureFOUND EMERGENCY CEILING LIGHT INOP ABOVE SEAT 3D ON SERVICE CK. SECURED CONNECTOR AS REQUIRED PERFORMED OPERATION TEST OF EMERGENCY LIGHTING AS PER B767 AMM 33-51. (8139658)SDR DALA2026010700122Proximity Sensor · faultedL1 DOOR LIGHT AND EICAS MSG DURING TAXI INTERMITTENT. REMOVED AND REPLACED TS10094 PROX SWITCH AND PLUNGER ASSY IAW B757 AMM 52-71. ADJUSTED PLUNGER. OPS OK. (8413701)SDR ASMF202601060355Generator · warning lightELECTRIC GENERATION SYS L2, DIVERTED TO HND. ITEM DEFERRED BY MEL 24-22-01-03B CAT A, VFSG L2 WAS REPLACED IAW AMM DMC-B787-A-24-21-09-008-520ASDR AALA202601062443Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202601069824Light · detachedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT THE EMERGENCY ESCAPE PATH MARKING LIGHT TORN OFF AND MISSING AT SEAT 8C. **SUPPLEMENTAL REPORT FOR AALA202512319824 SUBMITTED 12/31/2025 BY TUL: MAINTENANCE INSTALLED A NEW LIGHT ON SEAT 8C AND ACCOMPLISHED SDR REXA2025010601071Intercostal · corrodedPAX DOOR MID INTERCOSTAL DD2 FOUND TO BE CORRODED REQUIRE REPLACEMENT. REMOVED PAX DOOR FORMER FS 329.50 FOR ACCESS IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. REINSTALLED PAX DOOR FORMER FS 329.50 IAW SRM 51-42-06-001-001-A01 AND 51-42-21-0SDR REXA2025010601070Intercostal · corrodedPAX DOOR AFT INTERCOSTAL DD2 FOUND TO BE CORRODED REQUIRE REPLACEMENT. REMOVED UNSERVICEABLE PAX DOOR AFT INTERCOSTAL DD2 IAW SRM TASK 51-41-06-001-001-A01. LOCATED AND DRILLED NEW SERVICEABLE PAX DOOR AFT INTERCOSTAL DD2 IAW SRM 51-40-11-001-001-A01 INSTALLSDR SWAA2026010556557Floorboard · delaminatedFLOORBOARD 231AAF HAS DELAMINATION. REMOVED AND REPLACED 231AAF FLOORBOARD IAW AMM 53-21-00-401-NG.SDR SWAA2026010555813Pressure Blkhd · crackedCRACK INDICATION AT BS 1016 APB DOME APEX UPPER LEFT FASTENER ON THE GORE WEB LAP SPLICE AT S-23R MEASURING 0.0625 INCH IN LENGTH FROM FASTENER HEAD. REPAIRED BS 1016 APB IAW EA 25-153-03516.SDR DALA2026010509567Stringer · corrodedCORROSION ON S-30, BS 936-984. CORRODED LONGERON REPLACED ON NR 450 IAW SRM 53-20-05 (1371383)SDR DALA2026010509565Warning Message · false activationATO, ABORTED TAKE-OFF AT 60KTS DUE TO A STABILIZER CONFIGURATION MESSAGE. MAINTENANCE PERFORMED A HORIZONTAL STABILIZER CHECK, THE SYS OPS PROPERLY, AND AIRCRAFT WAS RETURNED TO SERVICE.(8144086)SDR AALA202601058632Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO DFW DUE TO THE FLIGHT CREW REPORTING THAT WHILE IN CRUISE AT FL340 WITH AUTO THRUST ON, #1 ENGINE FAILED. NO NOTICEABLE DAMAGE AND N2 ROTATION INTACT. DESCENDED TO FL180 TO ATTEMPT RESTART. ENGINE SSDR DALA2025123009519Unknown · odorFA REPORTED SMELLING BURN RUBBER OR TAR SMELL COMING FROM AROUND THE 4R DOOR. DEFERRING PER MEL 21-45-03. R/R 4R DOOR HEATER REF AMM 21-45. OPS/LEAK CHK GOOD. (7534174)SDR CALA2026010212595Stringer · corrodedAFT CARGO BAY CORROSION BETWEEN FR 57 & 58, S41L. REMOVED & REPLACED CORRODED S41L, FR 56 - 59, AFT CARGO IAW SRM 51-42-11 CAT A & SRM 51-72-11.SDR CALA2026010212594Stringer · corrodedAFT BULK CARGO COMP CORROSION BETWEEN FR 62 AND 63 , STRINGER 42L. REMOVED & REPLACED CORRODED STGR 42L FR61-64 AT AFT CARGO IAW SRM 51-42-11 CAT A & SRM 51-72-11-911-001.SDR CALA2026010212593Stringer · corrodedAFT CARGO COMPARTMENT CORROSION BETWEEN FR 56 AND FR 57 AT STR 42L PER AAR LCQ N/R 9292875/28875. REMOVED & REPLACED CORRODED STGR 42L FR54-FR60 AT AFT CARGO IAW SRM 51-42-11 CAT A & SRM 51-72-11.SDR DXTA2025123106320Cover · unsecureFOAM DOOR HINGE COVER HAD BECOME UNVELCROED AND GOT STUCK IN DOOR DURING CLOSING. DOOR WAS LOWERED AND AND PIECE OF FOAM WAS REMOVED. DOOR CLOSED NORMALLY. ON DEPARTURE, HEARD LOUD HISS FROM DOOR SEAL AND PRESSURIZATION WAS NOT ON SCHEDULE. STAYED AT 10000' ANSDR R61A2025122700549Actuator · failedSLAT FAILED IN FLIGHT ON RETRACTION BETWEEN 1 AND 0. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED LH SLAT ACTUATOR.SDR SWAA2026010157157Data Plate · detachedENGINE DATA PLATE (P/N'S 649-804-020-0, 649-804-023-0, 649-804-024-0, 649-804-027-0), DETACHES FROM THE ENGINE FAN FRAME. <THIS ALL EA PROVIDES TEMPORARY RELIEF AND INITIATES EA M-20-172-00810-TLD TO AUTHORIZE A 45-DAY DEFERRAL OF REINSTALLATION OF DATA PLATE SDR AALA202512319824Light · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT THE EMERGENCY ESCAPE PATH MARKING LIGHT TORN OFF AND MISSING AT SEAT 8C. (OPEN)SDR AALA202512311496Pump · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT FUEL TANK PUMP 2 LOW PRESSURE ECAM MESSAGE AT FLIGHT LEVEL 340. FLIGHT CREW ACCOMPLISHED ECAM PROCEDURES AND TURNED PUMP 2 OFF. (OPEN)SDR AALA202512318632Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO DFW DUE TO THE FLIGHT CREW REPORTING THAT WHILE IN CRUISE AT FL340 WITH AUTO THRUST ON, #1 ENGINE FAILED. NO NOTICEABLE DAMAGE AND N2 ROTATION INTACT. DESCENDED TO FL180 TO ATTEMPT RESTART. ENGINE SSDR JJBA20251231035Smoke Detector · malfunctionedLAV SMOKE DETECTOR TEST DOES NOT TURN OFF AND LAV SMOKE MESSAGE LINGERS ON EICAS. OPS CHECK LAV SMOKE DETECTION TEST. OPS CHECK SAT.SDR SWAA2025123056096Battery · dirtyLEFT AFT F/A FLASHLIGHT INOPERATIVE. CLEANED FLASHLIGHT BATTERY CONTACTS. OPS CHECK GOOD IAW AMM 25-64-00.SDR SWAA2025123055899Hook · looseL1 DOOR SLIDE J HOOK LOOSE PERM RESOLUTION. REMOVED TEMP FASTENER AND INSTALLED PERM FASTENER PER SRM 51-40-02 AND AIPC 25-66-00.SDR SWAA2025123055930Sign · brokenEMERGENCY EXIT SIGN BROKE. R&R EMERGENCY EXIT SIGN HOUSING IAW AMM 33-51-01.