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

N9695WDavid Fisher MURPHY MOOSE · S/N 299 SRCancelled Mar 21, 2026 · Built 2013 · Warren Jason N6295HCessna 207A · S/N 20700471Cancelled Apr 5, 2024 · Exported to Mexico · Built 1978 · Alaska Aircraft Leasing LLC N9641MCessna 207A · S/N 20700714Cancelled Apr 5, 2024 · Exported to Mexico · Built 1981 · Alaska Aircraft Leasing LLC N583BSDJI PHANTOM 4 PRO+ · S/N 189CF1KBA20363Cancelled Jun 17, 2020 · Submarine Group 9 N10840Ian P Mcfall VANS AIRCRAFT RV10 · S/N 41560Cancelled Oct 12, 2016 · Exported to South Africa · Mcfall Ian P N39AACessna 150L · S/N 15075465Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Warren Jerry Michael N2024DBeech C35 · S/N D-3375Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1952 · Bernert Charles H N3863PPiper PA-22-150 · S/N 22-3552Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1955 · White Robert T N7285RBeech A36 · S/N E-636Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1975 · Wilee Corporation N1682UCessna 207 · S/N 20700282Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1974 N888YBeech J35 · S/N D-5547Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1958 · Bernert Charles H N5963ECessna 150 · S/N 17463Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1959 · Brophy David D N51286Cessna 150J · S/N 15069896Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1968 · Brophy David D N191CBBernert Charles H V6 STOL · S/N 001Cancelled Aug 24, 2012 · Registration expired, pending cancellation · Built 1997 · Bernert Charles H N200TZMenefee Michael O RAF VARI-EZE · S/N 98383Cancelled Dec 9, 2008 · Triennial form not returned · Built 2003 · Menefee Michael O N9945MCessna 207A · S/N 20700153Cancelled Feb 13, 2004 · Triennial form not returned · Built 1970 · Alaska Aircraft Leasing LLC N44HAAnderson Hubert A STARDUSTER TOO SA300 · S/N HA1490Cancelled Mar 13, 1997 · Triennial form not returned · Anderson Hubert A N276JFFraisure Jeffrey J. OSPREY-2 · S/N 276Cancelled Mar 8, 1983 · Built 1980 · Fraisure Jeffrey J N1074PPiper PA-23 · S/N 23-71Cancelled Jul 11, 1980 · Snell Glen A N2833WSiai-Marchetti S.205/22R · S/N 4190Cancelled Apr 28, 1977 · Exported to Canada · Built 1969 · Snell Glen Allan N49156Taylorcraft DCO-65 · S/N 5221Cancelled Mar 18, 1977 · Walker Ralph Elliott N313LNorth American NAVION · S/N NAV-4-125Cancelled Feb 11, 1977 · Hogan Leo D

Back to Silverdale, WA