N309SW, cancelled May 22, 2017
Service difficulty reports · 454
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 = 'N309SW' AND deregistration_id = 'N309SW-2017-05-22' 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 = 'N309SW' AND deregistration_id = 'N309SW-2017-05-22' 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 SWAA083786Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083784Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083785Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 460, STR 16R TO STR 17R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083782Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 10L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083776Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083777Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083778Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083779Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083780Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083781Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083690Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 380, STR 15R. REPAIRED STR PER SRM.SDR SWAA083655Flap · debondedDURING SCHEDULED SPV CHECK, FOUND RT WING INBOARD FORE FLAP DISBONDED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA083656Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 2. REPAIRED FLOORBEAM PER SRM.SDR SWAA083657Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503C, STR 8L. REPAIRED SKIN PER ER.SDR SWAA083658Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 986, STR 19L. REMOVED AND REPAIRED STRINGER CLIP PER SRM.SDR SWAA083659Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 927, STR 23L TO STR 23R. REPAIRED FRAME PER SRM.SDR SWAA083660Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 908, STR 24L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA083662Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 480, STR 17R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083661Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 480, STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083632Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 908, STR 24L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA083652Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 986, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083631Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083545Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R AND STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083544Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R AND STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083546Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083543Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083495Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083490Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083491Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083492Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083493Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083494Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083412Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083413Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083414Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083415Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083416Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083417Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083419Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083418Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083387Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 4L. R&R STRINGER CLIP PER SRM.SDR SWAA083396Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 3L. R&R STRINGER CLIP PER SRM.SDR SWAA083395Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. R&R STRINGER CLIP PER SRM.SDR SWAA083394Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083393Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083392Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083391Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083390Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083380Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083371Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 968, RBL 28 TO RBL 45. REPAIRED FLOORBEAM PER SRM.
Back to N309SW, cancelled May 22, 2017