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 VNA2025F00030Seat Track · corrodedCORROSION ON LH SIDE SEAT RAILS STGR15 BTW FS379 TO FS385(1E/A), FS385 TO FS565(1E/A), FS581 TO FS661+16(1E/A), FS661+90 TO FS677(1E/A), FS679 TO FS720 (1E/A), FS785 TO FS851 (1E/A), FS847+18 TO FS903 (1E/A) AND FS903 TO FS974(1E/A). LH SIDE SEAT RAILS STGR15SDR CNMA2025100005Stringer · dentedDENT #13, REPAIRED ON STRINGER 19L BETWEEN STATION 368-388 IAW B767-300 SRM 53-00-03-2R-1 REV128.SDR CNMA2025100004Skin · debondedDISBOND AROUND HOIST POINT ATTACH POINT L/H WING UPPER SURFACE.SDR CNMA2025100003Skin · gougedGOUGES ON LH H-STAB LOWER INSPAR SKIN AT S-2 AND STA 226.605 (RIB 12 CENTERLINE).SDR CNMA2025100002Skin · dentedREASSESS DENT 20 RH FUSELAGE STATION 368+6INCHES STRINGER 26+4INCHES. FOUND TO BE OUTSIDE OF ALLOWABLE DAMAGE LIMITS IAW B767-300 SRM 53-00-01-1A-1 REV 128.SDR SWIA2025F01392Skin · corrodedCORROSION ON EXTERNAL SKIN AND AROUND FASTENER HEADS BETWEEN FS559.00 - 559.00+32 & STGR26L -26R. MARKED (C-CHECK RO 09/24/2025)REPAIRED EXTERNAL SKIN AND AROUND FASTENER HEADS BETWEEN FS559.00 - 559.00+32 & STGR26L -26R IAW REO 601R-53-51-714 REV -- DATED 2SDR SWIA2025F01391Skin · corrodedCORROSION ON EXTERNAL SKIN AND AROUND FASTENER HEADS BETWEEN FS559.00+32 - 559.00+80 & STGR26L -26R. MARKED (C-CHECK RO 09/24/2025)REPAIRED EXTERNAL SKIN AND AROUND FASTENER HEADS BETWEEN FS559.00+32 - 559.00+80 & STGR26L -26R IAW REO 601R-53-51-715 REV -- DSDR SWIA202509250721Skin · corrodedCORROSION ON EXTERNAL SKIN AND AROUND FASTENER HEADS BETWEEN FS559.00+80 - 559.00+112 & STGR25L -25R. MARKED (C-CHECK RO 09/24/2025)REPAIRED EXTERNAL SKIN AROUND FASTENER HOLES @FSFS559.00+80 - 559.00+112 & STGR25L -25R AND REPAIRED IAW REO 601R-53-51-713 RESDR IPXA2025081434048Floor Support · crackedMAJOR REPAIR, MAIN CARGO DECK FLOOR STRUCTURE BETWEEN FRAMES 74 AND 75, Y2127.5 HAS A CRACK ON Z CHANNEL. VERIFIED ACCOMPLISHMENT OF PERMANENT REPAIR IAW EA 300-5318-27-A4081, REV. -.SDR IPXA2025081433299Seat Track · corrodedMAJOR REPAIR, MAIN CARGO DECK FLOOR STRUCTURE BETWEEN FRAMES 73 AND 74, -Y2127.5 HAS CORROSION. COMPLIED WITH REMOVED AND REPLACED SEAT TRACK PER DWR SPECS AND SRM REQUIREMENTSSDR AALA202509107240Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL AT LEVEL STR23L BTW FR66 AND FR68 AT AFT GALLEY AREA MEASURES OF CORROSION ARE L=0.939 IN, W=0.589 IN,D=0.040 IN. MAINTENANCE REPLACED LOWER SILL LH SIDE BTW FR66 TO FR68 AND STR 23L AFT GALLEY AREA IAW A319SDR AALA202509101294Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR SUPPORT +Y1292 BTW FR65 AND FR66 AT AFT GALLEY AREA L=0.887 INCH, W=0.380 INCH, D=0.020 INCH. MAINTENANCE REPLACE FLOOR SUPPORT Y1292 LOC. BTW FR64 AND FR66 AT AFT GALLEY IAW SRM 51-42-11-801, SRM 51-72-11-911-001SDR SWAA2025090393434Vapor Barrier · crackedCRACK ON VAPOR BARRIER WEB LOCATED AT BS 663.75 BTW RBL 40 TO RBL 54.21 MAIN WHEEL WELL. REPAIRED VAPOR BARRIER WEB LOCATED AT BS 663.75 BTW RBL 40 TO RBL 54.21 IAW SRM 51-70-04-2R-10, REPAIR 10.SDR AALA202509030592Frame · inoperativeAIRCRAFT WAS NOT GROUNDED: CRACK FRAME 68 UPPER CORNER CUTOUT AT LEVEL STR8R AT AFT GALLEY AREA, CRACK MEASURE IS L=0.650 INCH. MAINTENANCE REPLACED FRAME UPPER CORNER CUTOUT AT FR68 LEVEL STR8R AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND DWG D53480009.SDR AALA202509023251Sill Drain · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL AT LEVEL STR 23R BTW FR 66 AND FR 68 AT AFT GALLEY AREA L=2.450 INCH W=2.037 INCH D=0.013 INCH. MAINTENANCE REPLACED LOWER SILL RH SIDE BTW FR66 TO FR68 AND STR23R AFT GALLEY AREA IAW A319 SRM 51-42-11-801, A3SDR ASAA2025072160395Skin · crackedCRACK INDICATION FOUND: R/H HORZONTAL STAB LOWER SKIN FWD OF AFT SPAR FASTENER ROW, 3.5" O/B OF STAB STA.92.70, 2" LONG. GROUNDED - YES. REMOVED DAMAGE IAW SRM 55-10-01-1A-2. INSTALLED FILLER & DOUBLER IAW SRM 55-10-01-2R-11, FIG 204, SHEET 7.SDR SIMA20250721004Shear Tie · corrodedSSI 53-23-003 SHEAR CLIP IS CORRODED BETWEEN FR 81 AND STR 21R. (LEVEL 2 CORROSION) REMOVED AND REPLACED SHEAR CLIP AT FR81 BTW STR 20R-21R IAW ERJ 170 SRM 51-40-08SDR SIMA20250721005Intercostal · corrodedSSI 53-23-003 STIFFENER SUPPORT IS CORRODED BETWEEN FR86-87 AND STR27R-28R. (LEVEL 2 CORROSION) REMOVED AND REPLACED STIFFENER SUPPORT BTW FR 86-87 AND STGR 27R-28R IAW ERJ 170 SRM 51-40-08.SDR SIMA20250721003Shear Tie · corrodedSSI 53-23-003 SHEAR CLIP CORRODED AT FR 88 AND BETWEEN STR27R-28R. (LEVEL 2 CORROSION) REMOVED AND REPLACED SHEAR CLIP AT FR 88 BTW STGR 27R-28R IAW ERJ 170 SRM 51-40-08.SDR SWAA2025082293628Attach Angle · crackedBS 663 VAPOR BARRIER ATTACH ANGLE CRACKED ON INBOARD SIDE OF FLEX JOINT @ LBL 9.<[01] REMOVED RIVETS AT L/H STA 663 ATTACH ANGLE COMMON TO VAPOR BARRIER FROM LBL 5 TO LBL 30 PER SRM 51-40-02.;[02] REMOVED CRACKED L ANGLE L/H A/C BAY AFT WALL STA 663 PER SRM 51SDR SWAA2025082193713Intercostal · elongatedELONGATED HOLE ON WEB INTERCOSTAL LOCATED BTW BS 747 TO BS 767 AT LEVEL OF STR 25R AND WL 156.4. REPLACED WEB AND FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, PARAGRAPH 9, DWG 146A7500, SHEET 88, REV A, DWG 146A7502, SHEET 26, REV-.SDR SWAA2025082193758Skin · delaminatedRIGHT OUTBOARD AFT FLAP; INBOARD LOWER CORNER DELAMINATED. REMOVED RIGHT OUTBOARD AFT FLAP IAW AMM 27-51-22. REMOVED & INSTALLED SERVICEABLE REPLACEMENT RT OTBD AFT FLAP INSTALLATION IAW AMM 27-51-22-400-801.SDR REXA2025081900822Lug · damaged"FOUND L/H AILERON SIDE LUGS LABELED ""D"" AND ""E"" TO BE PREVIOUSLY OVERSIZED. COMPLIED WITH BOMBARDIER REO 670-57-61-237 REV-- DATED 2017-07-25 AND MHIRJ REO 690-57-61-420 REV-- DATED 2025-08-11."SDR REXA2025081800817Hinge Arm · crackedBROKEN BONDING SUPPORT WS 54.55 AT LH INBOARD FLAP HINGE ARM BONDING SUPPORT WS 54.55 AT LH INBOARD FLAP HINGE ARM WAS REPLACED PER CRJ900 SRM 51-42-21-001-001-A01SDR SWAA2025081593551Seal · crackedLEFT HORIZONTAL STAB FWD UPPER SLIDE SEAL CRACKED. REMOVED AND REPLACED LT HORIZONTAL STAB FWD UPPER SLIDE SEAL IAW AMM 53-31-31-000-802; AMM 53-31-31-400-802 AND AMM 20-50-11-910-801 STEP 2.C.(1); D. TABLE 210.SDR IPXA2025081543299Seat Track · corrodedMAIN CARGO DECK FLOOR STRUCTURE BETWEEN FRAMES 73 AND 74, -Y2127.5 HAS CORROSION REMOVE AND REPLACE SEAT TRACK P/N: A53279221211 PER DWG SPECS AND SRM REQUIREMENTS.<BR><BR>THIS IS A MINOR REPAIR PER GMM 05.04SDR IPXA2025081544048Floor Support · crackedMAIN CARGO DECK FLOOR STRUCTURE BETWEEN FRAMES 74 AND 75, Y2127.5 HAS A CRACK ON Z CHANNEL VERIFIED STEP # 16 OF EA # 300-5318-27-A4081 OF PRELIMINARY 2 WERE RIISDR SWAA2025081493778Bear Strap · crackedCRACK FOUND ON FSD BEAR STRAP AT BS294.5; WL 266.1; 2' IN LENGTH (MARKED)<[01] 'REPAIRED BY 737 SRM 53-10-01-2R-6 AND EA M-25-153-01539';[02] VERIFIED CORRECTIVE ACTIONSDR SWAA2025081493777Stub Frame · crackedCRACK FOUND ON FSD STUB FRAME AT BS291.5+7.5; .6' ABOVE SEAL DEPRESSOR; 1.8' IN LENGTH. REMOVED AND REPLACED FSD STUB FRAME UPPER FWD CORNER IAW SRM 51-40-02 AND DWG 141A8370 REV D.SDR CALA2025081407750Skin · no discrepancyLEFT HORIZONTAL STAB LOWER SKIN AT HSS 111.10 WAS CUT TO GET ACCESS TO DAMAGED AREA OF RIB. REPAIRED LT HORIZ STAB LOWER SURFACE SKIN STA 101.90 TO 138.70 APPOX 3INCHES FROM AFT SPAR IAW SRM 55-10-01-2R-11 REPAIR 11.SDR IPXA2025080234385Strap · corrodedAPU INLET DOOR FWD STRAP AT STA 1787.45 FROM STR 3R TO STR 6R HAS EXFOLIATION. INSTALLED NEW FWD STRAP IAW SRM 51-40-02-0G-0.SDR ASAA2025072160015Angle · corrodedAPU COMPARTMENT STRUCTURE L/H ANGLE 148A8615 BETWEEN STA 1088 AND STA 1104 HAS CORROSION. GROUNDED - YES. REMOVED CORROISON, FOUND TO BE OUT OF LIMITS, REMVOED AND REPLACED L/H ANGLE IAW B737-800 SRM 51-40-02-0G-0W= 1.25 O= .063 R= .043 L= 4" D= .020.SDR SWI2025F01078Seat Track · corrodedFWD WET AREA L/H SEAT TRACK BETWEEN FR 12 - FR 18 CORRODED. (C-CHECK RO 08/10/2025)REMOVED AND REPLACED FWD WET AREA L/H SEAT TRACK BETWEEN FR 12 - FR 20 REF SRM 51-40-08. REPLACED WITH OEM PART AND DOES NOT EFFECT WEIGHT AND BALANCE.SDR SWI2025F01077Beam · corrodedAFT WET AREA L/H BEAM BETWEEN FR 86 - FR 89 CORRODED. (C-CHECK RO 08/10/2025)REMOVED AND REPLACED AFT WET AREA L/H BEAM BETWEEN FR 86 - FR 89. REF EMB SRM 51-40-08.REPLACED WIRH OEM PART AND DOES NOT EFFECT WEIGHT AND BALANCE.SDR SWI2025F01076Seat Track · corrodedFWD WET AREA R/H SEAT TRACK BETWEEN FR 12 - FR 18 CORRODED. (C-CHECK RO 08/10/2025)PERFORMED A SEAT TRACK UPPER CAP REPAIR AT FRAME 17 REF SRM 53-10-10/REPAIR 01P. SEE CONTINUATION CARD FOR WORKED PERFORMED.SDR SWI2025F01075Flap Track · out of limitsRH WING FLAP TRACK 2 OB HAS DEPTH REDUCTION THAT EXCEEDS 0.549INCH IN LENGTH AND IS OUT OF LIMITS. (C-CHECK RO 08/09/2025)REMOVED AND REPLACED THE RH INBOARD FLAP TRACK #2 O/B REF. AMM 57-54-23. ASSET#: TC1-604 CAL: 03/06/26, ASSET#: TC2-10468 CAL: 10/07/25, SDR SWI2025F01074Flap Track · out of limitsLH WING FLAP TRACK 2 OB HAS DEPTH REDUCTION THAT EXCEEDS 0.549 INCH IN LENGTH AND IS OUT OF LIMITS. (C-CHECK RO 08/09/2025)REMOVED AND REPLACED THE LH INBOARD FLAP MAIN TRACK #2 O/B REF. AMM 57-54-23. ASSET#: TC1-609 CAL: 03/06/26, ASSET#: TC2-10406 CAL: 06/19SDR SWI2025F01073Flap Track · out of limitsLH WING FLAP TRACK 3 OB HAS DEPTH REDUCTION THAT EXCEEDS 0.578 INCH IN LENGTH AND IS OUT OF LIMITS. (C-CHECK RO 08/09/2025)REMOVED AND REPLACED THE LH OUTBOARD FLAP TRACK #3 O/B REF. AMM 57-57-33. ASSET#: TC1-604 CAL: 03/06/26, ASSET#: TC2-10468 CAL: 10/07/25,SDR SWI2025F01072Flap Track · out of limitsLH WING FLAP TRACK 3 IB HAS DEPTH REDUCTION THAT EXCEEDS 0.578 INCH IN LENGTH AND IS OUT OF LIMITS. (C-CHECK RO 08/09/2025) REMOVED AND REPLACED THE LH OUTBOARD FLAP TRACK #3 I/B REF. AMM 57-57-33. ASSET#: TC1-604 CAL: 03/06/26, ASSET#: TC2-10468 CAL: 10/07/25SDR SWI2025F01071Flap Track · out of limitsRH WING FLAP TRACK 3 OB HAS DEPTH REDUCTION THAT EXCEEDS 0.578 INCH IN LENGTH AND IS OUT OF LIMITS. (C-CHECK RO 08/09/2025)REMOVED AND REPLACED THE RH OUTBOARD FLAP TRACK #3 O/B REF. AMM 57-57-33. ASSET#: TC1-604 CAL: 03/06/26, ASSET#: TC2-10468 CAL: 10/07/25SDR SWIA2025081200721Flap Track · out of limitsRH WING FLAP TRACK 3 IB HAS DEPTH REDUCTION THAT EXCEEDS 0.578 INCH IN LENGTH AND IS OUT OF LIMITS. (C-CHECK RO 08/09/2025)REMOVED AND REPLACED THE RH OUTBOARD FLAP TRACK #3 I/B REF. AMM 57-57-33. ASSET#: TC1-604 CAL: 03/06/26, ASSET#: TC2-10468 CAL: 10/07/25SDR SWAA2025081293720Fitting · crackedCRACK SERVICE DOOR FITTING LOC LOWER AFT CORNER AT FWD GALLEY AREA. REPLACED FITTING 1(E/A) AND FASTENERS LOCATED ON SERVICE DOOR LOWER AFT CORNER AT FWD GALLEY AREA IAW 51-40-02-0G-0 AND DWG 141A6535; SHEET 1, REV B, AND DWG 141A6516; SHEET 95; REV -.SDR IXXA20250812002Skin Panel · corrodedAREA OF CORROSION COMMON TO THE LH WING UPPER SKIN PANEL UNDER TE PANEL AT STA 430SDR IPXA2025080534561Skin · corrodedAPU INLET DOOR AFT STRAP AT STA 1826 FROM STR 3R TO STR 6R HAS EXFOLIATION CORROSION. ACCOMPLISH REPAIR PER EO-94632-REQ1 AND VT-MAE EA 757-5380-27-A4072, REV-,SDR SWIA2025081100721Seat Track · gougedMAIN CABIN LEFT OUTBOARD SEAT TRACK SECTION 34/43 - 59 HAS GOUGING AT FRS 45, 48, 50, 55, 57 AND 59. (C-CHECK RO 08/09/2025)REMOVED AND REPLACED MAIN CABIN LEFT OUTBOARD (LATERAL) SEAT TRACK SECTION FR43 - 59. REF. EMB SRM 51-40-08. RESTORED SURFACE PROTECTIOSDR IPXA2025080234761Angle · corrodedAPU INLET DOOR UPPER ANGLE FROM STA 1787.45 TO STA 1826 AT STR 3R HAS CORROSION. INSTALLED NEW UPPER ANGLE IAW B757-200PF SRM 51-40-02-0G-0.SDR IPXA2025080234656Angle · corrodedAPU INLET DOOR LOWER ANGLE FROM STA 1787.45 TO STA 1826 AT STR 6R HAS EXFOLIATION CORROSION. INSTALLED 1EA LOWER ANGLE IAW B757-200PF SRM 51-40-02-0G-0.SDR JJBA20250811029Floor Support · crackedCF3 LH OMEGA AT FR 36 FLANGE IB CRACKED. CF3 LH OMEGA BEAM FR 36 CUTOUT PERFORMED. CF2 LH OMEGA BEAM FR 36 DOUBLER AND FILLER FABRICATED. CF3 LH OMEGA BEAM FR 36 DOUBLER REPAIR INSTALLEDSDR JJBA20250808022Floor Support · crackedLH OMEGA BEAM FR27 FLANGE IB CRACKED. REPAIR DOUBLER ON CFII LH OMEGA BEAM ON INBD VERTICAL FLANGE AT FR 27SDR IPXA2025080337337Tee Angle · corrodedEVIDENCE OF CORROSION ON T-CHORD UPPER R/H SECTION STA 1200. REMOVED CORROSION ON T-CHORD ORIGINAL MEASURES THICKNESS: 0.063''. AFTER BLENDED FOUND FOLLOWING MEASUREMENTS: L:2.5, W:1.4, DEPTH: 0.018'', REMAINING MAT.: 0.045'', %DAMAGE:28.6%. REMOVED UPPER R