Skip to content

Lake Stevens, WA

Cancelled registrations · 22

Query with SQL

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 = 'LAKE STEVENS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'LAKE STEVENS'
  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.

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 = 'LAKE STEVENS'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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.

N25BEPew John Glenn ACRO 1 · S/N 011Cancelled Feb 19, 2025 · Built 2001 · Ekstrand Marshall C N2588CAeronca 7BCM · S/N 7BCM-85Cancelled Mar 22, 2023 · Bouchard Lionel B N525SGCapes Greg R MURPHY MOOSE · S/N 300Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2019 · Capes Greg R N990APiper PA-22 · S/N 22-309Cancelled Apr 8, 2022 · Registration expired, pending cancellation · Built 1951 · Jenkins James L DBA N6577KDowner REPUBLIC RC-3 · S/N 850Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1947 · Brooke Robert J N9551TCessna 210 · S/N 57351Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1960 · Henry Donald R N8529GCessna 150F · S/N 15062629Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1965 · Smith Stephen L N56THBeech G35 · S/N D4571Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Macdonald Hillary T N74050Commonwealth 185 · S/N 1865Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1946 · Lamantia James P N25BZMccornack John S-1C · S/N 3113Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 2004 · Henry Donald R N9790Bell-Snohomish Co Sheriffs OFF 47G-3B · S/N 2986Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1963 · Taylor John L N9877SSorensen Gerald P SEAREY · S/N 1DK175Cancelled Jan 18, 2013 · Built 2005 · Sorensen Gerald P N46692Cessna 172K · S/N 17257432Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1968 · Pacific Aircraft Rental'S N3TRamsome PITTS SPECIAL S-1C · S/N JDR-1Cancelled Feb 8, 2012 · Sale reported, pending cancellation · Built 1966 N623AMNelson Miguel MURPHY SR3500 MOOSE · S/N SR123Cancelled Apr 26, 2011 · Triennial form not returned · Built 2006 · Nelson Miguel E N9422Glasflugel STANDARD LIBELLE · S/N 228Cancelled Jul 23, 2007 · Sale reported · Built 1971 N642DMHamilton Clyde & Maxine VARI EZE · S/N 134Cancelled Dec 20, 2005 · Exported to Canada · Built 1982 · Whitaker Eric J N3385VCessna 150M · S/N 15076485Cancelled Apr 28, 2003 · Mission Aviation Training Academy N7582MCessna 175 · S/N 55882Cancelled Feb 16, 2000 · Sale reported N6167KRepublic RC-3 · S/N 355Cancelled Mar 13, 1998 · Exported to Canada · Polly Inc N9649TCessna T303 · S/N T30300034Cancelled Feb 28, 1997 · Exported to Australia · Wair Inc N4451Grumman G-44A · S/N 33Cancelled Aug 30, 1982 · Built 1967 · Johnston John Dh

Back to Lake Stevens, WA