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 SWAA084207Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR FRAME CRACKED AT PULLEY BRACKET. REPAIRED PER SRM.SDR SWAA084206Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA084205Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA084210Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 460, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084170Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 503C, STR 16L. REPAIRED SPLICE PER SRM.SDR SWAA084169Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 460, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084168Torque Tube · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR TORQUE TUBE CRACKED. REMOVED AND REPLACED TORQUE TUBE PER BOEING DRAWING AND SRM.SDR SWAA084167Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 27R CORRODED AT BS 1006 TO BS 1016. REPAIRED STRINGER PER SRM.SDR SWAA084075Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 25L CRACKED AT BS 929. REPAIRED STRINGER PER SRM.SDR SWAA083993Frame · crackedDURING SCHEDULED SPV CHECK, FOUND STUB FRAME CRACKED AT BS 291, STR 18R. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA083992Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 987, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083991Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084010Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084011Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084012Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083963Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 400, STR 16R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083957Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083949Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 947, LBL 54. REPAIRED CHORD PER ER.SDR SWAA083950Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1 AND STR 2R. REPAIRED FRAME PER SRM.SDR SWAA083951Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083952Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083953Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083954Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083964Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 16R. R&R STRINGER CLIP PER SRM.SDR SWAA083956Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. R&R STRINGER CLIP PER SRM.SDR SWAA083958Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7L. R&R STRINGER CLIP PER SRM.SDR SWAA083959Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 8L. R&R STRINGER CLIP PER SRM.SDR SWAA083960Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7L. R&R STRINGER CLIP PER SRM.SDR SWAA083961Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 8L. R&R STRINGER CLIP PER SRM.SDR SWAA083962Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 10L. R&R STRINGER CLIP PER SRM.SDR SWAA083955Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 9L. R&R STRINGER CLIP PER SRM.SDR SWAA083804Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 380, STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083808Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083803Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727D, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083805Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 480, STR 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083807Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083809Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 14R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083801Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083806Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, STR 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083775Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083769Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083770Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083771Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083772Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083773Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083774Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083783Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083768Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 8R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083788Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA083787Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.
Back to N309SW, cancelled May 22, 2017