N339SW, cancelled Feb 16, 2018
Service difficulty reports · 323
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 = 'N339SW' AND deregistration_id = 'N339SW-2018-02-16' 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 = 'N339SW' AND deregistration_id = 'N339SW-2018-02-16' 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 SWAA085462Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085461Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085460Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085366Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085365Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, RBL 42. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA085364Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR LOWER OPENING CREASE BEAM CORRODED. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA085304Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 947.5, RBL 2 TO LBL 4. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA085347Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 360, STR 15L. REPAIRED SKIN PER AAR EA.SDR SWAA085303Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 390, LBL 4. REPAIRED SKIN PER AAR EA.SDR SWAA085302Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 430, RBL 2. REPAIRED SKIN PER AAR EA.SDR SWAA085301Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 410, RBL 2. REPAIRED SKIN PER AAR EA.SDR SWAA085277Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR AFT CUTOUT FRAME CRACKED AT SECOND STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA085218Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 L-ANGLE STRINGER FWD OF GALLEY SERVICE DOOR CRACKED AT BS 294.5, STRINGER 17R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA085087Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085086Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 23R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085073Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, RBL 65. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085072Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085041Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085040Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085039Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085038Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827 STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085001Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 24L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084962Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084937Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 23R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084936Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084935Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084934Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084933Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084932Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084893Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084892Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083673Stringer · crackedDURING SCHEDULED C2 CHECK, FOUND STRINGER 16L CRACKED AT BS 517. REPAIRED STRINGER PER SRM.SDR SWAA082075Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA082074Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 445, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA081570Bushing · wornDURING SCHEDULED C1 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BUSHING PER SWA EA.SDR SWAA081571Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA080261Battery Pack · dischargedDURING SCHEDULED A1 CHECK, FOUND RT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA076017Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075999Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 760, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA075998Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA075997Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075190Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RIGHT WING NR 9 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075187Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RIGHT WING NR 6 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075188Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RIGHT WING NR 7 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075189Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RIGHT WING NR 8 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075191Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND LEFT WING 0 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075192Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND LT WING NR 1 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075193Spoiler · delaminatedDURING SCHEDULED A2 CHECK, FOUND LT WING NR 2 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075194Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND LT WING NR 3 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075186Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RT WING NR 5 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.
Back to N339SW, cancelled Feb 16, 2018