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 SWAA080320Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 634, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080319Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080332Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 22R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080299Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080294Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080295Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727D, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080296Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080298Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080297Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 23R CORRODED AT BS 436 TO BS 439. REPAIRED STRINGER PER SRM.SDR SWAA080285Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080286Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080287Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080229Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 9L CRACKED AT BS 727B. REPAIRED STRINGER PER SRM.SDR SWAA080228Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080227Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, STR 25R. REPAIRED SHEAR TIE PER SRM.SDR SWAA080203Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 21R CRACKED AT BS 355. REPAIRED STRINGER PER SRM.SDR SWAA080204Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 8R CRACKED AT BS 727E. REPAIRED STRINGER PER SRM.SDR SWAA080186Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080185Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080184Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080183Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080182Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080159Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080123Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080122Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080151Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080124Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080125Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 16L CRACKED AT BS 400. REPAIRED STRINGER PER SRM.SDR SWAA080075Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080076Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080074Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080073Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080072Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080071Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080070Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080069Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080068Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080067Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080066Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080065Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080064Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080063Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080062Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080077Stringer Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 540, STR 10L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA076500Hook · looseDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA076502Cable · frayedDURING SCHEDULED 24Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA076503Cable · frayedDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA076501Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076432Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 400 STR 14L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA076420Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N303SW, cancelled Oct 26, 2017