N689SW, cancelled Mar 16, 2018
Service difficulty reports · 360
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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-16' 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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-16' 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 SWAA072491Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072490Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072489Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072488Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072487Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072494Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 987, STR 23R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072375Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072378Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072377Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072376Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA072374Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440 ,STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072327Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072338Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072337Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072336Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072335Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072334Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072333Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072332Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072331Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072330Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072328Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072325Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072326Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072329Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 10L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072339Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA072274Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072273Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072275Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072276Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072277Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072278Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072279Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072280Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072272Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072271Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072241Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072240Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072239Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072238Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072237Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA071599Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16L. REPAIRED SKIN PER SRM & EA.SDR SWAA071416Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071415Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 827, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071417Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071434Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 763, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA070576Light · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE AT ROW 8 ABC. SECURED STRIP PER MM.SDR SWAA070293Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 290, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA065115Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA065116Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 485, STR 16R. REPAIRED SKIN PER SRM.
Back to N689SW, cancelled Mar 16, 2018