N303SW, cancelled Oct 26, 2017
Service difficulty reports · 391
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 = 'N303SW' AND deregistration_id = 'N303SW-2017-10-26' 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 = 'N303SW' AND deregistration_id = 'N303SW-2017-10-26' 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 SWAA076419Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076418Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076417Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076416Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076415Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076421Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076429Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA076414Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076422Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076423Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076424Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076425Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076426Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076413Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076428Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076406Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076427Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076405Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076400Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076401Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076402Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076408Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076404Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076412Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076407Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076430Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA076409Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076410Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076411Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076403Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076269Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076270Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076268Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076272Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076271Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076198Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076154Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076153Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076152Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076151Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076099Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076098Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076097Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076096Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075871Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 384, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA075537Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 270, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA075538Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 475, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA074551Slide · out of adjustDURING SCHEDULED RON CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074493Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA074494Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 790, STR 20L. REPAIRED SKIN PER SWA EA.
Back to N303SW, cancelled Oct 26, 2017