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 SWI2025F01506Slat Track · wornRIGHT SLAT TRACK 1-2 AFT IB, AFT OB, FWD IB, AND FWD OB ROLLERS WORN OUT OF LIMITS. REMOVED AND REPLACED RH TRACK 1-2 AFT IB, AFT OB, FWD IB, AND FWD OB ROLLERS IAW AMM 27-81-44-400-801 (CONFIG A01).PERFORMED OPERATIONAL CHECK OF SLAT TRACK IAW AMM 27-50-00-7SDR SWI2025F01505Slat Track · wornLH SLAT TRACK 3-2 AFT IB ROLLER WORN OUT OF LIMITS. REMOVED AND REPLACED LH SLAT TRACK 3-2 IB SIDE ROLLER PER AMM 27-81-44-000-803/27-81-44-400-803. PERFORMED OPERATIONAL CHECK OFLH SLAT TRACKS IAW AMM 27-50-00-710-801.OPS CHECK GOOD AT THIS TIME.SDR SWIA2025110400624Slat Track · wornLEFT SLAT TRACK 1-2 AFT OB AND FWD IB ROLLERS WORN OUT OF LIMITS. REMOVED AND REPLACED LH SLAT TRACK 1-2 AFT OB AND FWD IB ROLLERS PER AMM 27-81-44-400-801OPS CHECK REQUIRED. PERFORMED OPERATIONAL CHECK OF SLAT TRACKS IAW AMM 27-50-00-710-801OPS CHECK GOODSDR SWIA202511030624Skin · dentedADM# N803SK-9303 LH FUSEWLAGE ABOVE FWD CARGO DOOR. BLENDED AREA IS BETWEEN STGR 18L AND 19L AND FS 549.00 AND 565.00 WITH MAX DEPTH OF .0030. PLOT, MAP, AND EVALUATE DAMAGE IF WITHIN ACCEPTABLE LIMITS OR REWORKED, ELIMINATE EVIDENCE USING STANDARD ACFT PRACTISDR COEA2025103009919Skin · corrodedLEFT WING LANDING ACCESS DOOR CUTOUT FOR 522CT HAS FRETTING. LEVEL 2 CORROSION. REPAIRED PER SRAS ES 00265302- 01-25924, ISSUE A.SDR COEA2025103007919Panel · chafedWO 264878 NR 500013 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: L/H OUTBOARD FLAP, OUTBOARD DEFLECTOR LEADING EDGE REPAIR DOUBLER AT THE THIRD FROM OUTBOARD CAM GUIDE IS CHAFED. CORRECTIVE ACTION: REPAIRED PER ATR42 SRM 575320-200-801-A01.SDR COEA2025103006919Access Panel · corrodedWO 264878 NR 600028 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: R/H WING LANDING ACCESS DOOR CUTOUT FOR 622CT HAS FRETTING. LEVEL 2 CORROSION. CORRECTIVE ACTION: REPAIRED PER SRAS ES_00265302_01...25924 ISSUE A, DATED 8/6/2025.SDR COEA2025103005919Angle · dentedWO 264878 NR 100046 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: EXTERIOR FUSELAGE SKIN EXISTING REPAIR DOUBLER ABOVE FUEL SERVICE DOOR IS DENTED AND GOUGED. CORRECTIVE ACTION: REPAIRED PER ATR42 SRM 530000-300-803-A01.SDR COEA2025103002919Skin · corrodedWO 264878 NR 500042 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: L/H WING LANDING ACCESS DOOR CUTOUT FOR 521DT HAS FRETTING. LEVEL 2 CORROSION. CORRECTIVE ACTION: REPAIRED PER SRAS ES_00265302_01...25924 ISSUE A, DATED 8/6/2025.SDR COEA2025103001919Floorbeam · corrodedWO 264878 NR 100023 HEAVY CHECK COE/MAJOR REPAIR DISCREPANCY: INTERNAL FUSELAGE FLOORBEAM 40 HAS LEVEL 2 CORROSION BETWEEN STRINGERS 16L AND 16R. CORRECTIVE ACTION: REPAIRED PER ATR42 SRM 51-25-01.SDR CNMA2025100001Spar · damagedDURING C-CHECK AT YHM, THE RH HORIZONTAL STABILIZER AUXILIARY SPAR WEB NEAR OUTBOARD CLOSURE RIB AT HSBL 357.442 WAS FOUND TO HAVE TOOLING MARKS, AFTER BLENDING OUT OF THE DAMAGED AREAS, TWO CRACKS OF 0.300" AND 0.250" LONG WERE FOUND.SDR 3EJA2025091802425Indicator · failedSETTING UP ON FINAL, LOWERED THE LANDING GEAR, HEARD GEAR COME DOWN, HYDRAULICS CAME ON AND WENT OFF AS SCHEDULED, WITH NO LANDING GEAR RED OR GREEN LIGHTS. REMOVED AND REPLACED LANDING GEAR DOWN LIGHT ASSY.SDR SWIA2025009090624Landing · crackedLEFT TRU DOOR LANDING IS CRACKED. REMOVED AND REPLACED WITH NEW LT TRU DOOR LANDING IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-22-001-001-A01 & REO 670-53-11-2154, REV-. C/W TC 51-900-1002-SKY.SDR SWIA2025082500624Door Frame · crackedFOUND CRACK UNDER RIGHT TRU DOOR LANDING. (C-CHECK RO 8/21/2025) INSTALLED REPAIR TO UPPER FLANGE ON SUPPORT INTERCOSTAL AT ELECTRONIC BAY FLOOR ON RIGHT TRU DOOR LANDINGCOMPLIED WITH THE ALL STEPS OF REO 690-53-11-2032 REV. --. DATED 2025-07-04.COMPLIESDR SWIA2025081401082Skin · nickedR/H I/B FLAP LOWER SKIN HAS A NICK BETWEEN W.S. 56.30 TO W.S. 75.27. (C-CHECK RO 08/13/2025)REPAIRED RH IB FLAP LOWER SKIN BETWEEN WS 53.60 TO WS 75.27 IAW MHIRJ REO 601R-57-52-2523 REV-- DATED 2025-07-07 COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPSDR SWIA2025081400624Hinge Arm · damagedR/H OUTBOARD FLAP, INBOARD HINGE ARM HAS EXCESSIVE PLAY AT ARM-TO-FITTING MOUNT BOLTS. FURTHER INVESTIGATION REQUIRED TO DETERMINE IF BUSHING/BORE DAMAGE IS PRESENT ON ARM OR FITTINGS. (C-CHECK RO 08/13/2025)REPAIRED RH OUTB FLAP INBD HINGE ARM AT ARM TO FITTSDR AALA202508097995Light · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON EMERGENCY EXIT LIGHTS ON UPPER SIDEWALL PANELS NEXT TO EMERGENCY EXIT DOOR 834/844 IN PASSENGER CABIN. MAINTENANCE REPLACED ON EMERGENCY EXIT LIGHTS ON UPPER SIDEWALL PANELS NEXTTO EMERGENCY EXIT DOOR 834/844 IN PASSENGSDR SIMA20250624002Seat Track · corrodedSSI 53-22-012: RH FLOOR BEAM SEAT TRACK OTBD FLANGE HAS MULTIPLE CORROSION SPOTS BETWEEN FR#59-73. (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR RH FLOOR BEAM SEAT TRACK BETWEEN FR#59-73 IAW ERJ 175 SRM 51-40-08SDR REXA2025080600783Frame · corrodedPAX DOOR F.S. BETWEEN FWD DD4 AND DD5 INTERCOSTAL FOUND TO BE CORRODED REQUIRES REPLACEMENT REMOVED DAMAGED FRAME. LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE PAX DOOR FRAME, FS313.56, BETWEEN DD4 & DD5 P/N# 601R318086-1 IAW CRJ-700 SRM TASK 51-40-11-001-00SDR REXA2025080600782Former · corrodedPAX DOOR AFT FORMER FOUND TO BE CORRODED REQUIRES REPLACEMENT REMOVED DAMAGED AFT FORMER. LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE PAX DOOR AFT FORMER FS 347 P/N#601R318034-5 IAW CRJ-700 SRM TASK 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND 51-42-21-00SDR ASAA2025062459737Skin · crackedRH HORZONTAL STAB LOWER SKIN CRACKED AT RIB 3 HSS 101.93 19IN FROM T/E. GROUNDED - YES. REPAIRED RH HORIZONTAL STAB LOWER SKIN AT RIB 3 HSS 101.93 IAW B737-800 SRM 55-10-01-2R-11 THIS IS A REPAIR CATEGORY B WITH AN INSPECTION THRESHOLD 56000 FLIGHT CYCLES AND SDR SWAA2025072984963Attach Angle · crackedB.S. 663 LOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE IS CRACKED AT R.B.L. 10; W.L. 167. REMOVED DAMAGED SECTION AND INSTALLED REPAIR PARTS ON R/H BS663 VAPOR BARRIER UPPER ATTACH ANGLE RBL5 TO RBL18 WL167.68 PER SRM 57-10-10-2R-5 REPAIR 5.SDR SWAA2025072984964Bulkhead · crackedEXTENDED CRACK AT LOWER RT COMPOSITE BULKHEAD AT BS663 RBL27 WL166.SDR SWAA2025072985116Beam · crackedCRACK NOTED ON FSD NR 4 BEAM (141A6536-14) IN RADIUS ADJACENT TO MOST I/B FASTENER; L: 0.4. CRACK ON FSD NR 4 BEAM. REPAIRED ON CUSTOMER RO NO: P007KHVS-1.SDR SWAA2025072985117Beam · crackedCRACK NOTED ON FSD NR 5 BEAM IN RADIUS ADJACENT TO MOST OTBD FASTENER, L: 0.4. CRACK ON FSD NR 5 BEAM IN RADIUS ADJACENT TO MOST O/B FASTENER; L: 0.4. REPAIRED ON CUSTOMER RO P007KHVS-1 JN 584186.SDR ASAA2025062459657Skin · crackedRH HORZONTAL STAB LOWER SKIN CRACKED AT RIB 5 STA 129.5 10 IN FROM T/E. GROUNDED - YES. REMOVED DAMAGE AND PERFORM SKIN REPAIR ON RH HORIZONTAL STAB LOWER SKIN AT RIB 5 STA 129.5 10IN FROM T/E IAW B737-800 SRM 55-10-01-2R-11. THIS IS A CAT B REPAIR WITH A SUPPSDR SCNA20250725273Skin · damagedWO 95798, NR ENG53SCA-11680: N835SY: FUSELAGE SKIN, STA 420 TO 460 BETWEEN S-21R AND S-26R - REPAIR - RESOLUTION: C/W BY FAS 4686SDR SIMA20250624001Frame · damagedINVESTIGATE POSSIBLE DAMAGE TO FWD CARGO DOOR FR4 UNDER ACCESS PANEL BENEATH MAIN HANDLE. (MAJOR REPAIR) ACCOMPLISHED A PERMANENT REPAIR ON FWD CARGO DOOR FR 4 UNDER ACCESS PANEL BENEATH MAIN HANDLE IAW ERS-EJ-52MR-1308SDR AALA202507246882Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 328, LBL 40. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR ASAA2025062459622Cargo Track · corrodedAFT CARGO RT TRACK CORROSED AT THE DOOR CUTOUT. GROUNDED - YES. REMOVED DAMAGE WITH SURFACE BLEND FOUND TO BE OUT OF LIMITS REPAIRED CARGO TRACK IAW SRM 53-00-53-2R-3. W 1, O:.070, R, 034, L, 1 D 036.SDR ASAA2025062459599Rib · crackedRIGHT HORIZONTAL RIB NR 4 CRACKED. GROUNDED - YES. REMOVED AND REPLACED RIB 4 IAW SRM 51-40-02-0G-0.SDR ASAA2025062459598Frame · crackedREF ASA TC AD20230615-NG-53-IR AD 2023-06-45. CRACK INDICATION NOTED ON RH SIDE 727 FRAME INNER CORD STGR 18R AT THE LOWER REMOVED FASTENER HOLE. GROUNDED - YES. REPAIRED R/H FRAME INNER CARD AT STR 18R IAW ALASKA 700-53EA-28960.SDR SWAA2025072285208Nut · brokenBROKEN ASSIST HANDLE NUT ON AFT ENTRY DOOR LINING AT AFT GALLEY AREA (2EA). REPLACED ASSIST HANDLE NUT ON AFT ENTRY DOOR LINING AT AFT GALLEY AREA IAW AMM 52-41-31-400-802 STEP 3.F(2).SDR SWAA2025072285204Rib · crackedCRACK RIB LEADING EDGE LOCATED LE STA105.26 AT LT HORIZONTAL STABILIZER. REPLACED RIB ON LEADING EDGE LOCATED LE STA105.26 AT LT HORIZONTAL STABILIZER IAW B737-700 SRM 51-10-02 ITEM 9 AND INSTALLED FASTENERS IAW B737-700 SRM 51-40-02 AND DWG 186A1001 SHEET: 1SDR FE6R202507220001Mount · chafedDURING THE ANNUAL INSPECTION CHAFING ON THE LOWER LEFT PORTION OF THE ENGINE MOUNT WAS DISCOVERED. THE CHAFING APPEARED TO BE CAUSED BY THE DRAIN TUBE MOUNTED ON IT. NDT WAS CONSULTED AND DETERMINED THE CHAFE TO BE .046" AT ITS LOWEST WITH THE NOMINAL THICKNESSDR SWAA2025072184969Frame · crackedCRACK FRAME LOCATED ON BS 947.5 AND LBL 9 WL 155 AT AFT CARGO COMPARTMENT. . REPLACED SECTION FRAME AND FASTENERS LOCATED ON BS 947.5 STR 23R TO 23L WL 155 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02-0G; B737-700 SRM 51-40-02-0G-0 AND B737-700 DWG 147ASDR SWAA2025071784794Lens · missingIN THE CENTER PASSENGER CABIN. THE CENTER OVERHEAD EMERGENCY EXIT LIGHT IS MISSING A LENS. INSTALLED EMERGENCY EXIT LIGHT LENS REF AMM 33-51-01.SDR SWAA2025071784707Attach Angle · crackedLEFT WING TRAILING EDGE; ATTACH ANGLE FROM DEFLECTION CONTROL RIB TO INTERCOSTAL WEB IS CRACKED. REMOVED CRACKED ANGLE PER SRM 51-40-02.;[02] ANGLE HAS BEEN REMOVED. LOCATED; DRILLED AND DEBURRED REPLACEMENT ANGLE PER SRM 51-40-05. INSTALLED REPLACEMENT ANGSDR SWAA2025071784706Intercostal · crackedL/H WING TRAILING EDGE; INTERCOSTAL WEB INBD OF DEFLECTION CONTROL RIB IS CRACKED. REMOVED AND REPLACED INTERCOSTAL WEB PER SRM 51-40-02.SDR SWAA2025071784705Angle · crackedL/H WING TRAILING EDGE; ANGLE INBD OF INTERCOSTAL WEB AT DEFLECTION CONTROL RIB IS CRACKED. REMOVED CRACKED ANGLE INBD OF INTERCOSTAL WEB PER SRM 51-40-02. CRACKED ANGLE INBD OF INTERCOSTAL WEB HAS BEEN REMOVED. LOCATED; DRILLED AND DEBURRED REPLACEMENT ANSDR ASAA2025062459466Web · corrodedAFT PIT, LOWER SILL WEB HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED AFT PIT, LOWER SILL WEB IAW B737-800 SRM 51-40-02-0G-0W= 2" O= .045 R= .040 L= 2" D= .005.SDR ASAA2025062459455Web · corrodedFWD PIT, LOWER SILL WEB HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED FW PIT LOWER SILL WEB IAW B737-800 SRM 51-40-02-0G-0W- 1 1/2" O= .045 R=- .038 L= 2" D= .007.SDR SWAA2025071585135Structure · corrodedCORROSION AROUND OF BOOST PUMP LOCATED TRAILING EDGE AT LEVEL IRSS 145 AT LT WING. PERFORMED REWORK AND EVALUATED AREA ON AROUND OF FUEL BOOST PUMP LOCATED TRAILING EDGE AT LEVEL IRSS145 AT LT WING AND FOUND WITHIN LIMITS IAW SRM 57-20-10-1A-3 ALLOWABLE DAMAGSDR SWAA2025071585134Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 261 AT LT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 261 AT LT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9. LENGTH OF CRACK IS:0.467.SDR SWAA2025071585137Support Angle · crackedCRACK ON SUPPORT ANGLE OF ACCESS PANEL 651GB LOCATED TRAILING EDGE AT RT WING 2025-390033 <[01]. REPLACED SUPPORT ANGLE OF ACCESS PANEL 651GB LOCATED TRAILING EDGE AT RT WING IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 Ï¿½TEM 9 AND DWG 115A2714 SHEET 6 REV-. MESDR SWAA2025071585133Panel · elongatedELONGATED HOLE FITTING ON ACCESS PANEL 551GB TRAILING EDGE AT LT WING 2025-390023 <[01]. REPLACED BRACKET ON ACCES PANEL 551GB TRAILING EDGE AT LT WING IAW B737-700 SRM 51-10-02-0G; 51-40-02-0G AND DWG: 115A2714; SHEET: 6; REV: -; [02] COMPLETED JOB.SDR IPXA2025071585242Fire Warning · false activationFIRE WHEEL WELL WARNING DISPLAYED AND SOUNDED BFOR ABOUT ONE SECOND WHEN LANDING GEAR SERLECTED DOWN AT 3000 FEET. R & R MASTER MONITOR A CARD IAW AMM 31-51-02, OPS CHECK GOOD. NO DEFECTS NOTED.SDR AALA202507145857Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500 TO BS 500I AT LBL 36. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202507131292Door · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT MLG CENTER DOOR LOWER FORWARD CORNER AREA CRACKED. REPAIRED LEFT MLG CENTER DOOR LOWER FORWARD CORNER. PER B737-SRM 52-80-02-2R-2- REPAIR 2.SDR IPXA2025071090624Strap · corrodedUPON REMOVAL OF FWD UPPER AND LOWER NUT PLATE STRAPS APU INLET FOUND AFT INNER AND OUTER NUTPLATE STRAPS CORRODED ATA 53-80. FABRICATED REPAIR STRAP -2 AND REPAIR FILLER-4 TREATED AND PRIMED REF. B 757-200 SRM 53-80-15-2R-1 REPAIR 1 REQUEST OK TO INSTALL.