Cancelled registrations · 27

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 = 'CA' AND d.registrant_city = 'BELMONT' 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 = 'CA' AND d.registrant_city = 'BELMONT'
  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 = 'CA' AND d.registrant_city = 'BELMONT'
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.

N6230AHeard Lee Roy KR-2 · S/N 8385Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1993 · Bailey Charles S N2716HErcoupe 415-C · S/N 3341Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Built 1946 · Fallar Otto J N2102QCessna 177RG · S/N 177RG0502Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1974 · Rebholtz Mike A N7387VBellanca 17-31 · S/N 32-8Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Fullerton Gaylord Leland N8006FCessna 150F · S/N 15064106Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1966 · Holmes George T N6065TCessna 150D · S/N 15060765Cancelled Apr 10, 2013 · Revoked, canceled · Built 1964 · Colby Leonard H N24DFFelicio David M DRAGONFLY · S/N 144Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1987 · Bradbury John S N68294Cessna T-50 · S/N 4279Cancelled Sep 6, 2012 · Revoked, canceled · Built 1942 · Moore Early J N832BBeech 65 · S/N LC-112Cancelled Jan 31, 2011 · Registration pending · Built 1961 N56626Piper PA-28-235 · S/N 28-7410016Cancelled Nov 4, 2010 · First renewal notice · Built 1973 · Huber Oskar W N19403Cessna 150L · S/N 15074398Cancelled Jan 14, 2010 · Exported to Philippines · Built 1973 · Paratore Frank N9249WPiper PA-28-235 · S/N 28-10920Cancelled Apr 17, 2009 · Triennial form not returned · Built 1967 · Flying Veterans Club Of San Francisc N39DWRolladen-Schneider LS-4 · S/N 4180Cancelled Apr 3, 2007 · Exported to Argentina · Built 1981 · Beuttler Deborah B N6394YSinger Steven D SPORTCOPTER LIGHTING · S/N 049Cancelled Jul 26, 2005 · Registration pending N104PHolmes-Hartman-Rickon-Owens VARI-EZE · S/N 1Cancelled Nov 22, 2002 · Second triennial mailing, no response · Built 1978 · Holmes George T N7208NErcoupe 415-D · S/N 2955Cancelled Mar 29, 2002 · Built 1947 · Maxham Kenneth M N4982TCessna 411 · S/N 4110182Cancelled Jul 15, 1987 · Built 1966 · Westmoreland Ernest O N8474FPiper PA-28-181 · S/N 28-7790248Cancelled Jan 24, 1978 · Built 1976 · Weitz Fred Wesley N2366TNavion NAVION G · S/N NAV-4-2366Cancelled Jun 25, 1973 · Peterson Fred Drew N9902ZBeech C-45H · S/N AF 291Cancelled Apr 15, 1963 · Exported to Germany · Chartair Ltd N34579Aeronca 65-TC · S/N C10181TCancelled Sep 2, 1948 · Stinson Flying Corporation N34604Stinson 10A · S/N 8004Cancelled Sep 2, 1948 · Stinson Flying Corporation N49157Taylorcraft DCO-65 · S/N L-5291Cancelled May 12, 1948 · Norton John A N13793Security National Acft S1-A · S/N 15Cancelled Apr 19, 1948 · Built 1934 · Stinson Flying Corp N36804Aeronca 65-TAF · S/N F1511TACancelled Oct 20, 1942 · Stinson Flying Corp N36800Aeronca 65-TAF · S/N F1471TACancelled Sep 24, 1942 · Stinson Flying Corp N69073Cessna AT 17B · S/N 3150Cancellation date not recorded · Built 1942 · Moore Early J

Back to Belmont, CA