Skip to content

Cancelled registrations · 50

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

N1486WBell 47G-3B-2 · S/N 6730Cancelled Apr 9, 2026 · Built 1969 · Porter Robert A N5160BBell 47G-2 · S/N 1978Cancelled Apr 9, 2026 · Built 1957 · Porter Robert A N6602KRepublic RC-3 · S/N 875Cancelled Apr 9, 2026 · Porter Robert A N88771Bell 47K · S/N 2123Cancelled Apr 9, 2026 · Porter Robert A N9571Bell 47G-4A · S/N 7504Cancelled Apr 9, 2026 · Porter Robert A N2667ASemco Balloon T · S/N SEM28Cancelled Mar 9, 2025 · Porter Robert A N1165FCessna 172G · S/N 17254760Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1966 · Sturgeon Edward J N4697CCessna 170B · S/N 25641Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1953 · Aircraft Remanufacturing Company Inc N8126ACessna 170B · S/N 20978Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Aircraft Remanufacturing Co Inc N754RSChampion 7FC · S/N 7FC-249Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1958 · Fandango Ranch Operating Co Inc N5018DCessna 182A · S/N 51118Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Spectron Corp N375DFFowler Douglas D GAW SPECIAL · S/N 002Cancelled Feb 24, 2021 · Built 2014 · Fowler Douglas D N189DHHadley Dale R RUTAN LONG EZE · S/N 1894LCancelled Jan 9, 2021 · Registration expired, pending cancellation · Hadley Dale R N249PWKenneth A Berger SEAREY LSX · S/N 1LK485CCancelled Feb 5, 2019 · Registration expired, pending cancellation · Built 2013 · Hadley Dale R N168BBeech G35 · S/N D-4453Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1956 · Becker Larry N91041Cessna 207 · S/N 20700028Cancelled Oct 12, 2018 · Revoked, canceled · Built 1969 · Island Air Incorporated N41009Luscombe 8A · S/N 1768Cancelled May 30, 2018 · Sale reported, canceled · Built 1941 N8071FAeros 912 Velocity 912 VELOCITY · S/N MDP0308048Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 2003 · Hill Randall R N2276ECessna 172N · S/N 17271216Cancelled Aug 8, 2014 · Exported to Canada · Built 1978 · Echo Aircraft LLC N6627VBellanca 17-30A · S/N 30290Cancelled Sep 25, 2013 · Revoked, canceled · Built 1970 · Otten Byron D N296KSKohler Karl E VANS RV-7A · S/N 70261Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Kohler Karl E N9240WWoodley Donald E ZODIAC 601HD · S/N 6-3393Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1997 N13324Cessna 172M · S/N 17262669Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1973 · Ray L Sizemores Cimarron Enterprises Inc N277TSSturgeon Thomas E STUR001 · S/N 001Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1986 · Sturgeon Thomas E N202JNNorman John W PIETENPOL AIRCAMPER · S/N 2Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1988 · Becker Lawrence D N87917Becker BENSEN B8M · S/N 283-40-3647Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1976 · Becker Lawrence D N54016Cessna 172P · S/N 17274846Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1981 · Hayes Thomas W N118ALReach Albert G SEAWIND 300 · S/N 0075Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1998 · Hsueh Thomas N66BWBeech A24R · S/N MC-5Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1970 N5880RCessna 172G · S/N 17253549Cancelled Feb 7, 2013 · Third renewal notice · Built 1965 · Land & Sea Aircraft Sales & Leasing LLC N2425QCessna 182J · S/N 18257625Cancelled Nov 13, 2012 · Exported to Canada · Built 1966 · Metcalf Richard A N8281DBeech J35 · S/N D-5402Cancelled May 4, 2012 · First renewal notice · Built 1957 · Becker Lawrence D N2170DCessna 182T · S/N 18281919Cancelled Jun 15, 2010 · Exported to Australia · Built 2007 · Young David R N124JHHill Jimmy LANCAIR 235 · S/N 001Cancelled Oct 26, 2007 · Triennial form not returned · Built 1995 · Thompson James G N911EVKingston Kurt CHALLENGER 2 · S/N CH2-0100-1939Cancelled Aug 28, 2007 · Exported to Canada · Built 2002 · Kingston Kurt R N712TSDehavilland DHC-2 MK. I(L20A) · S/N 948Cancelled May 15, 2006 · Triennial form not returned · Munich Hans W N5030BBeech F35 · S/N D-4297Cancelled Apr 26, 2006 · Triennial form not returned · Built 1955 · Ajeman Robert W N443DCCampbell David H RV-8A · S/N 001Cancelled May 19, 2004 · Campbell David H N5347XCessna U206G · S/N U20605663Cancelled Mar 5, 2004 · Exported to Mexico · Built 1980 · Palsson Jon P N17044Cessna 150L · S/N 15073601Cancelled Oct 16, 2003 · Exported to Czech Republic · Built 1972 N66520Cessna 150M · S/N 15076096Cancelled Jan 15, 2003 · Exported to Canada · Built 1974 · Goodrich D E N7337BBeech E35 · S/N D-3800Cancelled Nov 2, 2001 · Triennial form not returned · Built 1954 · Becker Lawrence D N6588Becker Lawrence D BECKER VP-2 · S/N 100Cancelled Apr 2, 2001 · Triennial form not returned · Becker Lawrence D N737BZCessna 172N · S/N 17269303Cancelled Jun 11, 1992 · Exported to New Zealand · Lambly John A N5062QCessna 310N · S/N 310N-0162Cancelled Sep 19, 1983 · Exported to Canada · Built 1968 · Carabba S.A.N1814XCessna 182H · S/N 18255914Cancelled Mar 1, 1974 · Built 1964 · Island Air Inc N1248HAeronca 15AC · S/N 15AC-260Cancelled May 11, 1964 · Skylines Air Service N1981KLuscombe 8E · S/N 4708Cancelled Oct 9, 1959 · Exported to Canada · Wiseman Paul N1468BLuscombe 8E · S/N 6095Cancelled Jul 11, 1958 · Exported to Canada · Wiseman Paul N70309Piper J3C-65 · S/N 17286Cancelled Mar 5, 1956 · Flying Juanderers

Back to Anacortes, WA