N676SW, cancelled Oct 26, 2017
Service difficulty reports · 282
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 = 'N676SW' AND deregistration_id = 'N676SW-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 = 'N676SW' AND deregistration_id = 'N676SW-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 SWAA080943Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA080244Battery · dischargedAFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA080148Battery · dischargedFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA076089Pressure Panel · crackedDURING SCHEDULED MV2 CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 663, LBL 33 TO LBL 36. REPAIRED PRESSURE WEB PER SWA EA.SDR SWAA076088Hinge Fitting · brokenDURING SCHEDULED MV2 CHECK, FOUND LT WING NR 2 GROUND SPOILER INBOARD HINGE FITTING BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075748Engine · failedAIR TURNBACK / DECLARED EMERGENCY. IN FLIGHT SHUTDOWN EN ROUTE AT ABOUT 25,000 FT, AIRCRAFT BEGAN VIBRATING THEN HEARD EXPLOSION. SECURED NR 2 ENGINE. NR 2 ENGINE REPLACEMENT IN PROGRESS PER MM.SDR SWAA075713Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075712Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA075685Window Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND L1 WINDOW UPPER FRAME CRACKED AT OUTBOARD END. REPAIRED FRAME PER SRM.SDR SWAA075695Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075694Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075693Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND KEEL BEAM CHORD CORRODED AT BS 500D, STR 28R. REPAIRED CHORD PER SRM.SDR SWAA075686Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075657Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 517D, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA075624Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA075609Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 406, RBL 3. REPAIRED SKIN PER ER.SDR SWAA075610Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 426 AND BS 446, LBL 3 AND BL 0. REPAIRED SKIN PER ER.SDR SWAA075612Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075613Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075611Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 783, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA075557Slide · out of adjustDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075552Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075551Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 783, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA075459Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 867, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075460Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075461Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075462Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075463Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075466Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075464Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075458Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 804, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA075465Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075441Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA075440Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA075388Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 26L CORRODED AT BS 947. REPAIRED STRINGER PER SRM.SDR SWAA075381Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 13R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075383Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075384Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075387Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075382Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075385Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075386Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075380Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA075341Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075342Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075344Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075345Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075346Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075343Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075255Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 794, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N676SW, cancelled Oct 26, 2017