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 SWAA081084Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 400, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081083Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA080973Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND RT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080972Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 721 AND BS 727, LBL 8. REMOVED AND REPLACED KEEL BEAM PER ER.SDR SWAA080872Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 406 AND BS 414, LBL 2 AND LBL 4. REPAIRED SKIN PER ER.SDR SWAA080823Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STR 13R. REPAIRED SKIN PER ER.SDR SWAA080792Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 680, STR 10L. REPAIRED SKIN PER ER.SDR SWAA080793Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 25L CORRODED AT BS 889. REPAIRED STRINGER PER SRM.SDR SWAA080711Bear Strap · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED BETWEEN BS 301 AND BS 331, STR 17R. REPAIRED SKIN PER ER.SDR SWAA080710Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080686Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 25L CORRODED AT BS 927. REPAIRED STRINGER PER SRM.SDR SWAA080687Bear Strap · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 331, STR 17R. REPAIRED SKIN PER ER.SDR SWAA080647Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA080632Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA080631Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA080578Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 17R CRACKED AT BS 638. REPAIRED STRINGER PER SRM.SDR SWAA080577Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080529Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 278, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA080504Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 25R. REPAIRED SHEAR TIE PER SRM.SDR SWAA080511Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 18R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080510Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 27L CORRODED AT BS 500D. REPAIRED STRINGER PER SRM.SDR SWAA080509Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080508Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080507Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080506Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080505Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080435Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 847, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080436Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080437Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080406Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080415Web · crackedDURING SCHEDULED 24Y CHECK, FOUND NLG W/W RT CEILING PANEL CUTOUT WEB CRACKED AT LOWER OUTBOARD END. REPAIRED WEB PER ACO.SDR SWAA080414Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 251 TO BS 277, BL 0. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080413Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 23R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080412Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080411Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080410Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 908, STR 22R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080409Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080416Web · crackedDURING SCHEDULED 24Y CHECK, FOUND NLG W/W LT CEILING PANEL CUTOUT WEB CRACKED AT LOWER INBOARD END. REPAIRED WEB PER ACO.SDR SWAA080407Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 907, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080405Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080408Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080374Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080347Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 360, STR 15R. REPAIRED SKIN PER ER.SDR SWAA080348Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 16R CRACKED AT BS 291. REPAIRED STRINGER PER SRM.SDR SWAA080336Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 807, STR 18L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080330Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080333Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 25R CORRODED AT BS 410 TO BS 420. REPAIRED STRINGER PER SRM.SDR SWAA080331Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 23R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080318Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080321Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 618, RBL 70. REMOVED AND REPLACED WEB PER SRM.
Back to N303SW, cancelled Oct 26, 2017