Seattle, WA

Cancelled registrations · 1,563

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'WA' AND d.registrant_city = 'SEATTLE'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N10683Bunting John F BUNTING A · S/N 1Cancelled Sep 1, 1937 · Ruebush Paul A & Frank EverlineN463MDetroit SEA ROVER E-2 · S/N 7Cancelled Jul 1, 1936 · Goret Air Transport IncN232MBoeing 80-A1 · S/N 1090Cancelled Jun 15, 1936 · Built 1929 · National Air Tours IncN630YWaco RNF · S/N 3341Cancelled May 12, 1936 · Graybill JayN838YFletcher PRIMARY GLIDER · S/N 13Cancelled Apr 15, 1936 · Built 1930 · Fletcher James EN13372Boeing 299 · S/N 1963Cancelled Oct 30, 1935 · Built 1935 · Boeing Aircraft Co IncN11608Pitcairn PCA2 · S/N B-26Cancelled Sep 15, 1935 · Bailey R HN337YBuhl LA-1 · S/N 126Cancelled Aug 8, 1935 · Graybill JayN5355Command-Aire 3C-3 · S/N 502Cancelled Apr 15, 1935 · Piercy EN288Boeing 40B · S/N 899Cancelled Feb 27, 1935 · Built 1927 · Boeing Air Transport IncN131HLoening Aeronautical Engrg AMPHIBIAN BIPLANE · S/N 228Cancelled Feb 1, 1935 · Gorst Air Transport IncN3817Breese 5 · S/N 6Cancelled Nov 4, 1934 · Built 1927 · Randall Norman BN974HLockheed VEGA 5B · S/N 94Cancelled Oct 10, 1934 · Alaska Southern Airways IncN12719Morrison Howard PRIMARY GLIDER · S/N M-1Cancelled Aug 31, 1934 · Built 1932 · Morrison HowardN165NBellanca CH300 PACEMAKER · S/N 172Cancelled Aug 22, 1934 · Call E EstolN12715Karlberg Jack KARLBERG GLIDER · S/N 100Cancelled May 16, 1934 · Built 1932 · Karlberg JackN837MBoeing 40-B-4 · S/N 1162Cancelled Mar 24, 1934 · Exported to Peru · Boeing Airplane CoN9324Arrow Aircraft & Motors ARROW SPORT · S/N 340Cancelled Feb 24, 1934 · William A OsborneN12741Vieweg Otto C O V S GLIDER · S/N S-1Cancelled Jan 8, 1934 · Built 1931 · Vieweg Otto CN9728Loening Aeronautical Engrg AMPHIBIAN BIPLANE · S/N 216Cancelled Nov 15, 1933 · Built 1929 · Gorst Air Transport IncN12734Richmond Henry T RICHMOND GLIDER · S/N 1Cancelled Jun 17, 1933 · Built 1932 · Richmond Henry TN66MRay Hunt HUNT M F · S/N 0800Cancelled Feb 11, 1933 · T MaedaN388WContinental 3000 · S/N 3001Cancelled Feb 8, 1933 · Continental Aviation CorpN10647Jensen Volmer VOLMER GLIDER · S/N J-5Cancelled Jan 12, 1933 · Jensen VolmerN9028Travel Air 2000 · S/N 829Cancelled Dec 7, 1932 · Coast Airlines IncN12714Field K G FIELD A · S/N L-1Cancelled Oct 4, 1932 · Built 1932 · Field K LN410Travel Air Mfg 2000 · S/N 162Cancelled Jun 27, 1932 · Built 1927 · Sulak A GN5389Boeing 40-B-4 · S/N 1042Cancelled May 24, 1932 · Built 1928 · Pacific Air Transport IncN128WRyan B-5 · S/N 208Cancelled Nov 3, 1931 · John R BlumN66WBoeing 218 · S/N 1260Cancelled Oct 1, 1931 · Boeing Airplane CoN113HIreland N 2 B · S/N 39Cancelled Sep 4, 1931 · Harry H LynchN5390Boeing 40-B-4 · S/N 1044Cancelled May 11, 1931 · Pacific Air Transport IncN6498Stearman C3-B · S/N 196Cancelled May 9, 1931 · Stimson Thomas DN216VMoth 60-GM · S/N 142Cancelled May 6, 1931 · Built 1930 · Coast Airlines IncN5388Waco GXE · S/N G-1904Cancelled Feb 1, 1931 · Collector Of CustomsN9025Travel Air 2000 · S/N 827Cancelled Jan 5, 1931 · Coast Airlines IncN103WLockheed VEGA 5B · S/N 120Cancelled Dec 30, 1930 · Alaska Washington Airways IncN533VNorthwest Aircraft & Motor Cor MODEL A · S/N 102Cancelled Oct 11, 1930 · Exported to Canada · Northwest Aircraft & Motor CorpN102WLockheed VEGA 5B · S/N 119Cancelled Sep 19, 1930 · Alaska Washington Airways IncN976HBoeing 203-B · S/N 203ACancelled Aug 8, 1930 · Boeing Schoolof AeroN115EBoeing B1E · S/N 1074Cancelled Jul 24, 1930 · Gorst Air Transport IncN5792Curtiss MODEL F FLYING BOAT · S/N 400Cancelled Jul 15, 1930 · Barnes & Gorst Airlines IncN874HBeech 100 · S/N 1145Cancelled Jul 3, 1930 · Exported to Japan · Boeing Aircraft CoN740KBoeing 40-B-4 · S/N 1147Cancelled May 9, 1930 · Pacific Air TransportN2623Curtiss JN4D · S/N 47360Cancelled May 7, 1930 · Hoople Shelton GeorgeN312Curtiss Aeroplane & Motor CURTISS JN-4D · S/N 001Cancelled May 3, 1930 · Built 1918N4523Eaglerock LONG WING EAGLEROCK · S/N 468Cancelled Apr 11, 1930 · Universal Aviation Corp Of WashingtonN322NAmerican Aeronautical SAVOIA MARCHETTI S56 · S/N 6Cancelled Mar 20, 1930 · Northwest Air Service IncN7478Crawford A-1 · S/N 3-14Cancelled Mar 14, 1930 · Built 1928 · Sulak Anton FN5371American Eagle A-1 · S/N 172Cancelled Feb 7, 1930 · Howard K Rugh
Back to Seattle, WA