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 SWAA083372Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083373Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083374Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083375Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083376Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083377Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083389Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083379Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083388Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083381Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083382Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083383Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083384Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083385Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083386Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083378Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083165Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 7L CRACKED AT BS 1013. REPAIRED STRINGER PER SRM.SDR SWAA081735Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA081734Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 910, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA081733Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA081732Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 510B, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA081731Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 400, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA081594Light · inoperativeDURING SCHEDULED MV4 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA081189Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA080999Slat · crackedDURING SCHEDULED SPV CHECK, FOUND RIGHT WING NR 4 L/E SLAT CRACKED AT LOWER OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA080994Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENA CUTOUT BS 410, BL 0. REPAIRED SKIN PER EA.SDR SWAA080995Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA080996Skin · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT AFT UPPER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA080998Slat · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 3 L/E SLAT CRACKED AT LOWER OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA081000Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA081001Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS BS 747C, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA081002Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND KEEL BEAM CORRODED AT BS 538, RBL 6.5. REPAIRED KEEL BEAM PER SRM.SDR SWAA080997Slat · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT LOWER OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA080961Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 27L CORRODED AT BS 445. REPAIRED STRINGER PER SRM.SDR SWAA080962Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 26L. REPAIRED FRAME PER SRM.SDR SWAA080963Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 27L. REPAIRED FRAME PER SRM.SDR SWAA080887Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER SRM.SDR SWAA080824Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR AFT FRAME CRACKED AT BS 847, STR 25R. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA080639Window · arcedFLIGHT DECK L1 WINDOW ARCED. REMOVED AND REPLACED WINDOW HEAT CONTROLLER AND WINDOW PER MM.SDR SWAA080359Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 510B, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA080007Battery · dischargedDURING SCHEDULED MV1 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA076512Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 733, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA076435Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA075493Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 408, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA075492Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 416, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA074706Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA074655Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA073027Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 395, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA073028Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA072884Tire · separatedNR 4 MAIN TIRE LOST TREAD DURING TAKEOFF. REMOVED AND REPLACED NR 4 MAIN WHEEL AND TIRE ASSY PER MM. REPAIRED MID AND AFT FLAPS AND LANDING GEAR DOOR PER SRM.
Back to N309SW, cancelled May 22, 2017