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 SWAA087187Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA087186Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA087122Slide · out of positionDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA087121Battery · dischargedDURING SCHEDULED SPV CHECK, FOUND AFT CABIN EMERGNECY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA087055Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 950, STR 27R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA087054Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA087053Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 291, WL 259 RT SIDE. REPAIRED SKIN PER ER.SDR SWAA086825Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086824Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CRACKED AT BS 617, STR 17R. REPAIRED BEAM PER SRM.SDR SWAA086823Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086822Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CRACKED AT BETWEEN BS 616 TO BS 639, RBL 65, WL 208. REPAIRED WEB PER SRM.SDR SWAA086821Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED BETWEEN BS 360 TO BS 440, STR 22R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA086820Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED BETWEEN BS 360 TO BS 440, STR 21R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA086819Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 10R. REPAIRED STRINGER PER SRM.SDR SWAA086818Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086817Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086753Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 23L TO STR 24L. REPAIRED SHEAR TIE PER SRM.SDR SWAA086752Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 520, STR 23L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA086751Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BETWEEN BS 360 TO BS 440, STR 24R. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA086750Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BETWEEN BS 360 TO BS 440, STR 23R. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA086749Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086748Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 460, BETWEEN STR 14R TO STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA086747Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086746Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086745Web · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL WEB CRACKED AT BS 227, BL 0. REPAIRED WEB PER PAE DWG.SDR SWAA086744Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 26L TO 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA086743Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BETWEEN BS 967 TO BS 987, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA086742Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 914, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA086714Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 767, RBL 3, WL 149. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086725Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086724Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086723Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086722Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086721Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086720Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086719Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086718Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 986, STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086717Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086716Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086715Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086429Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STR 26L CORRODED AT BS 980. REPAIRED STRINGER PER SRM.SDR SWAA086428Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STR 25L CORRODED AT BS 985. REPAIRED STRINGER PER SRM.SDR SWAA086427Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STR 26L CORRODED AT BS 936. REPAIRED STRINGER PER SRM.SDR SWAA086385Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BETWEEN STR 15R TO 16R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086384Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 947, BETWEEN STR 26R TO 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086383Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 947, BETWEEN STR 27L TO 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086382Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 986, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA086381Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 987, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086380Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 23R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086379Shear Tie · damagedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE DAMAGED AT BS 520, BETWEEN STR 16R TO STR 17R. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to N686SW, cancelled Feb 16, 2018