N697SW, cancelled Oct 5, 2019

Service difficulty reports · 430

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

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'
  WHERE n_number = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05'
  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.

SDR SWAA080056Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 364 TO BS 376, RBL 70. REMOVED AND REPLACED WEB PER SRM.Jan 1, 2008 · N697SW · Boeing 7373TO · Fuselage Main, StructureSDR SWAA080054Skin · debondedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 4 L/E SLAT OUTBOARD UPPER T/E SURFACE DISBONDED. REPAIRED SLAT PER SRM.Jan 1, 2008 · N697SW · Boeing 7373TO · Leading Edge DevicesSDR SWAA076304Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Longeron/StringerSDR SWAA076305Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REPAIRED FLAP PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Trailing Edge FlapsSDR SWAA076300Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 700, RBL 70. REMOVED AND REPLACED WEB PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, StructureSDR SWAA076306Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076307Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076308Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076309Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076303Control Rod · wornDURING SCHEDULED 20Y CHECK, RT WING AILERON FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT AILERON CONTROL ROD PER MM.Dec 17, 2007 · N697SW · Boeing 7373TO · AileronsSDR SWAA076287Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076286Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076288Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076285Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 17, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076216Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076204Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076205Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076206Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076207Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076208Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076209Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076210Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076211Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076203Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076215Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076212Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076217Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076218Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076219Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076220Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076221Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 752, LBL 70. REPAIRED WEB PER SRM.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, StructureSDR SWAA076237Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 480, STR 28L. REPAIRED SKIN PER SRM.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Plate/SkinSDR SWAA076238Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 907, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Internal Mounting StructureSDR SWAA076213Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076201Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076202Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076214Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.Dec 13, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076194Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STABILIZER FWD AND AFT LUG FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.Dec 13, 2007 · N697SW · Boeing 7373TO · Horizontal Stabilizer, Attach FittingsSDR SWAA076164Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076177Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 22R. REPAIRED SKIN PER SRM.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Plate/SkinSDR SWAA076176Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076175Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076174Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076173Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076165Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.Dec 11, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076104Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.Dec 10, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA076092Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 9, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076091Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Dec 9, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Attach FittingsSDR SWAA076055Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.Dec 9, 2007 · N697SW · Boeing 7373TO · Fuselage Main, FrameSDR SWAA075006Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740D, STR 18R. REPAIRED SKIN PER SWA EA.Oct 7, 2007 · N697SW · Boeing 7373TO · Fuselage Main, Plate/Skin
Back to N697SW, cancelled Oct 5, 2019