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