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 SWAA2025091098898Support Angle · crackedCRACKED SUPPORT ANGLE, 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 142, REV-.SDR SWAA2025091098893Support Angle · crackedCRACKED SUPPORT ANGLE, 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 142, REV -, & DWG 143A5400, SHEET 138, REV -.SDR SWAA2025091098892Support Angle · crackedCRACKED SUPPORT ANGLE, BS 380 - 400, LBL 50, WL 208.1. REPLACED SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A5400, SHEET 141, REV -.SDR SWAA2025091099099Angle · crackedCRACKED ANGLE BTW BS 291.5 - 294.5, STR 17R IN FWD GALLEY. REPLACED THE ANGLE IAW SRM 51-40-02, AND DWG 141A8310, SHEET 33, REV -, DWG 140A9810, SHEET 35, REV A.SDR SWAA2025090999119Panel · delaminatedPANEL 193B HAS DELAMINATION ON OUTER SURFACE. PANEL 193B REPAIRED IAW SRM 51-70-05-2R-2.SDR SWAA2025090898765Lens · damagedEMERGENCY EXIT LIGHT LENS AT RT OVERWING EXIT SIDEWALL DAMAGED. REMOVED, REPLACED, & PERFORMED A GOOD OPS TEST OF EMERGENCY EXIT LIGHT AT RT OVERWING EXIT SIDEWALL IAW AMM 33-51-01-960-802.SDR REXA2025090400847Stringer Splice · corrodedFOUND HEAVY CORROSION ON STGR24R SPLICE AT FS333 REMOVED STGR24R SPLICE AT FS333 FOR REPLACEMENT IAW CRJ700 SRM 51-42-06-001-001-A01 DRILLED AND LOCATED STGR24R SPLICE PN:SH670-32429-2 IAW CRJ700 SRM 51-40-11-001-001-A01 INSTALLED STGR24R SPLICE PN:SH670-3242SDR SCNA20250903352Doubler · crackedCRACK ON INNER SURROUND DOUBLER OF AFT CUTOUT AT EXTERNAL POWER RECEPTACLE DOOR EMP 317018 - INNER SURROUND DOUBLER OF AFT CUTOUT AT EXTERNAL POWER RECEPTACLE DOOR WAS REPAIRED PER B737-800 SRM 53-10-15-2R-4 REPAIR 4.SDR SWI2025F01140Crossbeam · corrodedFRAME 19 CROSSBEAM CORRODED OUTBOARD OF LH SEAT TRACK. PERFORMED PERMANTENT DOUBLER REPAIR ON THE CROSSBEAM IAW ETD2025-170-926443.SDR SWI2025F01139Shear Tie · corrodedCORROSION AT AFT CARGO SHEAR CLIP AT FR 89 STGR 29R-29L REMOVED AND REPLACED AFT CARGO SHEAR CLIP AT FR 89 STGR 29R-29L REF: SRM 51-40-08.SDR SWI2025F01138Seat Track · chafedLEFT LATERAL SEAT TRACK HAS CHAFING DAMAGE AT FR 84/83, 82/83, 81/82, 80/81, 79/80, 78/79, 77/78, 76/77, 75/76, 74/75. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-08. REPLACED WITH NEW OEM PART,SDR SWI2025F01137Seat Track · corrodedAFT WET AREA RT SEAT TRACK HAS CORROSION AT FR 87. REMOVED AND REPLACED AFT WET AREA RT SEAT TRACK BETWEEN FR86 - FR89 REF: SRM 51-40-08.SDR SWI2025F01136Seat Track · corrodedPAX FLOOR, LT INBD SEAT TRACK CORRODED BETWEEN FRS 19-20. REMOVED AND REPLACED THE SEAT TRACK BETWEEN FR 12-20 IAW SRM 51-40-08.SDR SWI2025F01135Seat Track · corrodedPAX FLOOR, RT SEAT TRACK CORRODED AT FR17. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-08.SDR SWI2025F01134Seat Track · corrodedLEFT SEAT TRACK HAS CORROSION AT FR 84, 84/83, 82/83, 81/82, 80/81, 79/80, 78/79, 77/78, 76/77, 75/76, 74/75. REMOVED DAMAGED SECTION OF THE LT CENTER SEAT TRACK AT FRAME 84 AND INSTALLED A FABRICATED FILLER AND DOUBLER TO REPAIR REF ETD2025-170-926606 AND RESDR SWI2025F01133Seat Track · corrodedRIGHT SEAT TRACK HAS CORROSION AT FR 84, 84/83, 82/83, 81/82, 80/81, 79/80, 78/79, 77/78, 76/77, 75/76, 74/75. REMOVED AND REPLACED RT INBD SEAT TRACK FR74-84 REF SRM 51-40-08.SDR SWI2025F01132Floorbeam · corrodedPAX FLOOR, FR 14 CROSSBEAM CORRODED AT RH TRACK/ BEAM. PERFORMED SRM DOUBLER REPAIR AT PAX FLOOR, FR 14 CROSSBEAM AT RH TRACK REF SRM 53-00-10/REPAIR 03P. RESTORED SURFACE PROTECTION REF SRM 51-23-04, 51-23-05, 51-23-06.CPM 51-25-00 (PO:331184)NO CHANGE TO WEISDR SWIA2025090200806Beam · corrodedAFT WET AREA LH BEAM HAS CORROSION AT FR 87. INSTALLED AFT WET AREA LH BEAM BETWEEN FR86 - FR89 IAW SRM 51-40-08.SDR CALA2025090108312Frame · crackedFR35, S30L, FRAME FWD FACE HAS CRACK INDICATION AT FASTENER ADJACENT TO HOLE 2. CRACK EXTENDING APPROX .050 FROM FASTENER IN THE 10 OCLOCK DIRECTION. ACCOMPLISHED PART 1: INTERIM REPAIR IAW REO-L25490, REV IR. MAJOR REPAIR. COMPLIED WITH RII INSPECTION SDR IPXA2025082126495Angle · crackedKRUGER FLAP I/B REINFORCING ANGLE HAS A CRACK. INSTALLED REINFORCING ANGLE AND BRACKET AT KRUGER FLAP I/B IAW A300-600, SRM 51-40-21.SDR AALA202508254736Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SEAT TRACK -Y765 AT LEVEL FR 20 FWD GALLEY AREA L:1.850 INCHES,W:0.386 INCHES,D:0.138 INCHES. MAINTENANCE REPLACED SEAT TRACK -Y765 BTW FRAME 12 TO FRAME 24 IN FWD GALLEY AREA.SDR SWAA2025082298619Angle · crackedLH WING ANGLE CRACKED INBOARD OF MIDSPAN DEFLECTION CONTROL RIB<[01] REMOVED L/H WING ANGLE INBOARD OF MID SPAN DEFLECTION CONTROL RIB FOR REPLACEMENT.;[02] LOCATED AND DRILLED FASTENER HOLES IN NEW ANGLE PER SRM 51-40-05.;[03] INSPECTED WORK PERFORMED IN CORRSDR AALA202508207140Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 6 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM FITTING 6 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508205069Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 5 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM FITTING 5 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508205551Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 2 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM 2 FITTING ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508203061Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 3 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM FITTING 3 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508202380Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 1 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM FITTING 1 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508206708Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 4 ON RH HORIZONTAL STABILIZER. MSINTENANCE REPLACED ELEVATOR HINGE ARM FITTING 4 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR 3EJA202508200003Wheel · out of adjustTAKING OFF OUT OF CVG, RUNWAY WE RETRACED THE LANDING AFTER A POSITIVE RATE, AT FRA FLAPS WERE SELECT TO UP POSITION AND HYDRAULIC LIGHT KEPT ON. WE HAVE A GEAR IN SAFE RED LIGHT ON. REALIGNED LH MLG AND RH MLG WHEEL CAMBERSDR SWAA2025081998882Fitting · crackedNUMBER 1 ENGINE OTBD FAN COWL AFT HOLD OPEN ROD STOW PIN FIITING CRACKED. REMOVED AND REPLACED NR 1 OTBD FAN COWL AFT HOLD OPEN ROD STOW PIN FITTING PER AMM 51-40-02-0G-0. AFT HOLD OPEN ROD STOW PIN FITTING REPLACED WHEN THE FAN COWL WAS REPLACED ON SWA NON-RSDR AALA202508197754Oil System · leakingAIRCRAFT WAS GROUNDED: STRONG MUSTY ODOR COMING FROM THE PACKS ON THE GROUND AND IN THE AIR. MX VERIFIED APU SOURCE, PLACED ON MEL. MAINTENANCE REPLACED APU IAW JC 26L31049003. COMPLIED WITH ENHANCED DECONTAMINATION OF ECS IAW JC 26L00021014.SDR SWAA2025081999143Panel · debondedLEFT WING LEADING EDGE PANEL 521TB DISBONDED AT LEADING EDGE<[01] 04 - REPAIRED PER [SRM 51-70-05-2R-6-D00323 (REPAIR 6 - REPAIR OF DAMAGE TO THE EDGEBAND OF A HONEYCOMB PANEL - AIRFRAME - PERMANENT)]SDR JJBA20250818044Plate · crackedNLG UPPER PLATE FOUND CRACKED. REPAIR DOUBLER ON FWD FUSE I NLG UPPER PLATE ON RH FWD SIDESDR JJBA20250818042Web · corrodedSKIN UNDER FLOOR BTW FR 66-67 AND BTW STR 21L-21R AT DRAIN VALVE FOUND CORRODED. REPAIR DOUBLER ON REAR FUSELAGE I LOWER SKIN PANEL AT FR 67 AND BTW 21L-21RSDR JJBA20250818041Torque Box · corrodedCORROSION FOUND INSIDE UPPER HOLE OF RH TORQUE BOX #1. HOLE OVERSIZED ON RH TORQUE BOX AT RIB 01A AND SPAR IIISDR JJBA20250818040Skin · dentedFWD FUSELAGE 1, BTW STR 1-4R FRAME 06 FOUND DENTED. SPLICE REPAIR ON FWD FUSE II FRAME 6, BTW STR 4R-6R AND BTW STR 4L-6L.SDR SWAA2025081498886Scuff Plate · crackedFWD ENTRY DOOR FWD CORNER SCUFF PLATE IS CRACKED. REPAIRED PER EA 25-153-02123.SDR CALA2025081407755Window Frame · crackedEA 5310-08195 REV B CRACK FOUND AT LH SIDE NUMBER 3 WINDOW FRAME POST 4TH HOLE FROM THE BOTTOM. ACCOMPLISHED ON THE LT NR 3 WINDOW POST FRAME E-F IAW ECRA 5310-08666 PART 1. AFTER 49900 TOTAL AIRCRAFT FLIGHT CYCLES (FC), BUT BEFORE 50000FC PERFORM AN INSPSDR CALA2025081407746Spar · corrodedLEFT WING L/E TO FRONT SPAR APPROXIMATELY RIB 26 HAS CORROSION. ACCOMPLISHED INTERIM REPAIR CATEGORY B AT LEFT WING FRONT SPAR LOWER CHORD BETWEEN OFSS 700 AND OFSS 710 AS PER EC/RA 5720-03555 PART 1 PARAGRAPH 1.SDR FDEA202508061377Floorboard · damagedMAIN DECK COMP. AT APOX. STA 350 & RBL33 TO RBL54.75 FLOORBOARD PANEL 222BFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) FABRICATED NEW FLOOR PANEL (PNL 222BFF MPN: 141T5856-106) AT STA 350 BETWEEN RBL 33 AND RBL 54.75 IN REF TO BOEING DWG# 1415856-106. THSDR REXA2025081200798Frame · damagedF.S. 280 FRAME HAS 5EA OVERSIZED HOLES (PREVIOUS REPAIR) BETWEEN STGR 17L AND STGR 18L. COMPLIED WITH MHIRJ REO 670-53-11-2156 REV -- DATED 2025-07-28 TEMPORARY REPAIR FOR OVERSIZED HOLES ON F.S.280 FRAME BETWEEN STR17L AND STR18L.SDR QXEA2025081100293Fan · malfunctionedFLIGHT 2067. BURNING SMELL IN AFT GALLEY, FOLLOWED BY RH RECIRC FAN REMOTE CB TRIP. PLACED ON MEL AND RETURNED TO SERVICE. MEL CLEARED 8/10 BY REPLACING RH RECIRC. FAN IAW AMM 21-24-01-000/400-801-A. OPS CHECK GOOD. MTX PROCUDRES REVERSED & PLACARDS REMOVED. CSDR WX0A2025081132538Unknown · odor(AIRCRAFT NOT GROUNDED) FORWARD AND AFT FA'S REPORTED DIRTY SOCK SMELL DURING DESCENT. RESOLVED ON W/O: 528423 TASKCARD: NR-00002 , C/W TC 21-000-002. C/W TC 21-000-003. NO DEFECTS NOTED AT THIS TIME. NO SMELLS NOTED AT THIS TIME.SDR SWAA2025081198768Lens · damagedOVERHEAD BIN TRIM PIECE AT 10D HAS DAMAGED LIGHT. R & R CABIN OVERHEAD BIN TRIM EMERGENCY LIGHT LENS PER AMM 33-51-03. OPS CK GOOD.SDR SWAA2025081198812Megaphone · damagedAFT. MEGAPHONE HANDLE IS DAMAGED.<[01] R/R THE AFT. MEGAPHONE; OP?S CHECKS IAW AMM 25-64-00.SDR SWAA2025081198955Megaphone · missingMEGAPHONE MISSING MOUTH PIECE<[01] R&R MEGAPHONE PER AMM 25-64-00SDR SWAA2025081198825Lamp · inoperativeEMERGENCY LIGHTS / BIN OVHD AREA LAMP INOP AT SEAT 16 FED AND 19 FED. REMOVED AND REPLACED LAMP BULBS FOR EMERGENCY LIGHTS / BIN OVHD AREA LAMP AT SEAT 16 FED AND 19 FED IAW AMM 33-51-03. OPS CHECK GOOD.SDR SWAA2025081199211Cover · out of adjustCREW REPORTS RT SIDE; LOWER EMERGENCY EXIT SIGN COVER IS LOOSE. SECURED RT SIDE; LOWER EMERGENCY EXIT SIGN COVER; PER AMM 33-51-01.SDR DALA2025081105988Cover · unsecureSHIP 9500 ROW 19C & 19D EMERGENCY BATTERY COVER LOOSE. CORECTIVE ACTION: RE-SECURED AS REQUIRED (7813580)SDR DALA2025081105987Apu · odorSHIP 9500 DIRTY SOCKS SMELL WITH APU AIR ON WHEN TAKING OVER THE AIRPLANE. CORECTIVE ACTION: R/R APU REF B717 AMM 49-10 (7813574)