N335SW, cancelled Jan 3, 2018
Service difficulty reports · 389
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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 SWAA096467Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727E, BETWEEN STR 17R TO STR 18R. REPAIRED SHEAR TIE PER SRM.SDR SWAA096427Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096404Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA096403Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096402Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096401Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096378ASkin · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA096377AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096376AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096375AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096400Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096399Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096398AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096397Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096396Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 619, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096395AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096394AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096393Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096392AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096391Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, LBL 25. REPAIRED WEB PER ER.SDR SWAA096383Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 994, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096382Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 994, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096381Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 294, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA096380Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 291.5, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096374AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096373AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096372AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096371AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096370AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 619, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096369AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096368Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096367Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096366AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA096365AFloorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, LBL 25. REPAIRED WEB PER ER.SDR SWAA096357AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 994, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096356AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 994, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096355AFrame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 294, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA096354AStringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 291.5, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096276Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED BETWEEN BS 908 TO BS 987, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA096211Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 312, RBL 24. REPAIRED BEAM PER SRM.SDR SWAA096210Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 50. REPAIRED BEAM PER SRM.SDR SWAA096209Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 994, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096208Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING I/B FORE FLAP SKIN DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096207Fitting · wornDURING SCHEDULED SPV CHECK, FOUND LT WING NR 4 SPOILER ACTUATOR BOLTS LOOSE ON FITTING. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA096206Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095419Rod End · defectiveDECLARED EMERGENCY - L/E FLAP TRANSIT AMBER WARNING ON APPROACH - NR 5 SLAT INDICATOR NOT FULLY EXTENDED AT FLAPS 15 DEGREES, NO ROLL NOTED, SLAT VISUALLY VERIFIED FULLY EXTENDED. REMOVED AND REPLACED NR 5 SLAT ROD END PER MM.SDR SWAA095300Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 503D TO BS 515D, BETWEEN STR 18R TO STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA093685Gasper Fan · faultyREPORTED HOT RUBBER ODOR IN CABIN. FOUND GASPER FAN BEARINGS BAD. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA093375Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 310, WL 235.1. REPAIRED SKIN PER SRM.SDR SWAA092458Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727E + 10, STR 18L. REPAIRED SKIN PER SRM.
Back to N335SW, cancelled Jan 3, 2018