OpenAirDocs.org
Forks, WA

Cancelled registrations · 16

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 = 'FORKS'
  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.

N31808Roberts BENSEN B-8M · S/N 2001Cancelled Mar 16, 2018 · Revoked, canceled · Built 1972 · Roberts Robert EN1096LHughes Helicopters HUGHES 369D · S/N 800789DCancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1980 · Fairlane Helicopters IncN778ESSpringer Ernest R KITFOX MKIV-1200 · S/N 1815Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Springer Ernest RN54591Sud SA 318C ALOUETTE AST · S/N 2194Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1972 · Aero Jet Helicopters IncN5234YHughes Helicopters 369E · S/N 0167ECancelled Oct 29, 2012 · Third renewal notice · Fairlane Helicopters IncN5687FAlon A2 · S/N A-187Cancelled May 22, 2012 · Built 1966 · Robinson David EN10966Hughes Helicopters HUGHES 369D · S/N 1000818DCancelled Jul 29, 2003 · Second triennial mailing, no response · Built 1980 · Olympic Air IncN9203FHughes 369HS · S/N 440584SCancelled Mar 29, 2001 · Exported to Canada · Heli-Logistics IncN9163FHughes Helicopters HUGHES 369D · S/N 690540DCancelled Mar 14, 1998 · Triennial form not returned · Eagle Air Helicopters IncN59362S N I A S SA 318C ALOUETTE AST · S/N 2222Cancelled Sep 25, 1980 · Exported to Canada · Aero Jet Helicopters IncN670DBeech A35 · S/N D-15001Cancelled Jul 14, 1977 · Northwest Oil CoN84388Cessna 172K · S/N 17258455Cancelled Jul 11, 1974 · Exported to Canada · Gunter Shake IncN773DBeech C35 · S/N D-3043Cancelled Jun 17, 1970 · Ulins IncN1450BLuscombe 8F · S/N 6077Cancelled Apr 2, 1965 · Exported to Canada · Built 1948 · Spoelstra Brothers IncN9479KPiper PA-32R-300 · S/N 108-2479Cancelled Oct 11, 1956 · Exported to Canada · Spoelstra BrosN7444KPiper PA-20 · S/N 20-355Cancelled Feb 15, 1956 · Ulin Wilmer W
Back to Forks, WA