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 SWAA072091Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 370, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA072047Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA072046Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514A, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA071586Flashlight · inoperativeFWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA070732Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 6 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA070029Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 365, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA070028Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA070027Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 464, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA064524Centering Unit · wornWHEN MOVING YOKE FORE AND AFT ELEVATOR FEEL IS LOOSE. REMOVED AND REPLACED ELEVATOR FEEL AND CENTERING UNIT PER MM.SDR SWAA064486Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND LT MLG WALKING BEAM HANGER FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA064485Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND RIGHT MLG WALKING BEAM HANGER FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA063392Battery · inoperativeFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA063215Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063210Bear Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT AFT CARGO DOOR CUTOUT UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA063209Girt Bar · looseDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FWD GIRT BAR FITTING PER MM.SDR SWAA063208Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 500C, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA063207Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 507B, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA063206Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506A, STR 16R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA063205Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 500D, STR 28L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA063170Hinge · crackedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 5 SPOILER, NR 3 HINGE CRACKED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA063169Lens · missingDURING SCHEDULED 20Y CHECK, FOUND EMERGENCY EXIT LIGHT LENS MISSING AT L1 DOOR. INSTALLED LIGHT LENS PER MM.SDR SWAA063168Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 11L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063167Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 435, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA063166Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 372, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA063165Bushing · wornDURING SCHEDULED 20Y CHECK, RT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT TAB NR 3 HINGE BUSHING PER MM.SDR SWAA063154Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER 25R CORRODED AT BS 380. REPAIRED STRINGER SECTION PER SRM.SDR SWAA063153Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 520, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA063152Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER 27L CORRODED AT BS 967. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA063131Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA063113Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063104Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED SHEAR TIE PER ER.SDR SWAA063103Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 2 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063102Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA063101Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME WEB CORRODED AT BS 500B, STR 26L TO STR 26R. REPAIRED FRAME SECTION PER SRM.SDR SWAA063100Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063099Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 395, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA063098Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063022Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 21R. REPAIRED FRAME SECTION PER SRM.SDR SWAA063021Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 27L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063020Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 21R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062897Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD R1 DOOR SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA062866Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 440, STR 16L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA062850Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 27R AND STR 27L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062826Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA062478Fitting · looseDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED EVAC SLIDE FITTING PER MM.SDR SWAA062477Fitting · looseDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED EVAC SLIDE FITTING PER MM.SDR SWAA062404Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC PER MM.SDR SWAA062114Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA062113Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA062112Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N309SW, cancelled May 22, 2017