N686SW, cancelled Feb 16, 2018
Service difficulty reports · 388
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 = 'N686SW' AND deregistration_id = 'N686SW-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 = 'N686SW' AND deregistration_id = 'N686SW-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 SWAA086378Shear Tie · damagedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE DAMAGED AT BS 500D, BETWEEN STR 16R TO STR 17R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086377Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086376Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086375Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086374Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086373Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086372Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 867B, BETWEEN RBL 1 TO RBL 4. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086371Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 727B, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086370Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 727A, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085895Wedge · delaminatedDURING SCHEDULED SPV CHECK, FOUND NR 2 SLAT T/E WEDGE DELAMINATED AT UPPER SURFACE. REPAIRED WEDGE PER SRM.SDR SWAA085894Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 25R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA085879Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085878Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085877Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085876Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085875Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085874Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085873Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085872Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085871Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085870Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085869Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085868Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085867Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085866Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085865Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085864Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085711Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA084742Battery Pack · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084685Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA084684Battery Pack · dischargedDURING SCHEDULED MV3 CHECK, FOUND LT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084639Battery Pack · dischargedDURING SCHEDULED MV3 CHECK, FOUND LT FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084637Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA084638Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA084636Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA084635Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA084048Mec · faultyDURING DESCENT NR 1 ENGINE HANG UP AT 50% FOR TWO TO THREE MINUTES, THEN ROLLS BACK. R&R NR 1 MEC PER MM.SDR SWAA081770Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081771Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081213Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 773, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA081026Battery · inoperativeDURING SCHEDULED MV2 CHECK, RT FWD CABIN EMERGENCY BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA080788Connector · dirtyDURING SCHEDULED MV3 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INTERMITTENT. FOUND LIGHT ASSY CONNECTOR DIRTY. CLEANED CONNECTOR PER MM.SDR SWAA080789Connector · dirtyDURING SCHEDULED MV3 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INTERMITTENT. FOUND LIGHT ASSY CONNECTOR DIRTY. CLEANED CONNECTOR PER MM.SDR SWAA076483Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA074737Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 8 DEF. REPAIRED LIGHT ASSY PER MM.SDR SWAA074736Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 5 DEF. REPAIRED LIGHT ASSY PER MM.SDR SWAA074735Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 1 DEF. REPAIRED LIGHT ASSY PER MM.SDR SWAA074698Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074696Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074695Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND FWD RIGHT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.
Back to N686SW, cancelled Feb 16, 2018