N314SW, cancelled May 18, 2012

Service difficulty reports · 412

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 = 'N314SW' AND deregistration_id = 'N314SW-2012-05-18'
  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 SWAA083969Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 767, STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.Jul 16, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083968Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 21R. REPAIRED FRAME PER SRM.Jul 16, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083967Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13R. REPAIRED FRAME PER SWA EA.Jul 16, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083966Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14R. REPAIRED FRAME PER SWA EA.Jul 16, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083919Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500A, STR 13R. REPAIRED SHEAR TIE PER SRM.Jul 15, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083918Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727B, STR 13L. REPAIRED SHEAR TIE PER SRM.Jul 15, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083920Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 847, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 15, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083915Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 13R. REPAIRED FRAME PER SWA EA.Jul 15, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083917Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 13R. REPAIRED FRAME PER SWA EA.Jul 15, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083916Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13R. REPAIRED FRAME PER SWA EA.Jul 15, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083889Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083882Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500A, STR 13R. REPAIRED SHEAR TIE PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083883Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727B, STR 13L. REPAIRED SHEAR TIE PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083884Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083885Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 767, STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083886Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083887Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083888Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083881Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 13R. REPAIRED FRAME PER SWA EA.Jul 14, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083802Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 460, STR 14L. REPAIRED SHEAR TIE PER SRM.Jul 13, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083722Stringer · damagedDURING SCHEDULED SPV CHECK, FOUND STRINGER 17L DAMAGED AT BS 360 TO BS 380. REPAIRED STR PER SRM.Jul 5, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA083696Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 15R. REPAIRED FRAME PER SRM.Jul 4, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083691Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 13L. REPAIRED FRAME PER ACO & EA.Jul 4, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083692Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SWA EA.Jul 4, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083693Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500B, STR 16L. REMOVED AND REPLACED CLIP PER SRM.Jul 4, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083695Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 25L. REPAIRED FRAME PER SRM..Jul 4, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083694Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 13R. REPAIRED FRAME PER SWA EA.Jul 4, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA083669Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083663Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, STR 24R. REMOVED AND REPLACED SHEAR TIE PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083668Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083667Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083666Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083665Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 21R. REMOVED AND REPLACED SHEAR TIE PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083664Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 21L. REMOVED AND REPLACED SHEAR TIE PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA083670Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 22R CRACKED AT BS 496. REPAIRED STRINGER PER SRM.Jul 2, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA083549Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 23R CRACKED AT BS 359. REPAIRED STRINGER PER SRM.Jun 26, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA083548Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259.5, STR 24R. REPAIRED SKIN PER SRM.Jun 26, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA083500Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083496Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083497Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083510Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 8R CRACKED AT BS 400. REPAIRED STRINGER PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA083499Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083501Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083502Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083503Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 9L AND STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083505Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L AND STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083506Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083507Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083508Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA083509Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.Jun 25, 2008 · N314SW · Boeing 7373H4 · Fuselage Main, Attach Fittings
Back to N314SW, cancelled May 18, 2012