Cancelled registrations · 35

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

N256MFMightyfly MVP · S/N 1Cancelled Jul 8, 2023 · Non-citizen corporation, flight hours not reported · Built 2020 · Mightyfly Inc N9791KStinson 108-2 · S/N 108-2791Cancelled Jun 17, 2023 · Revoked, canceled · Built 1947 · Ronald Bombardier N300JSCessna T210M · S/N 21062717Cancelled Jul 30, 2021 · Exported to Mexico · Built 1978 · Nor Cal Perlite Inc N316EVNatilus EVE · S/N 001Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Natilus Inc N3009NCessna 140 · S/N 13267Cancelled Sep 20, 2018 · Revoked, canceled · Built 1947 · Smith Thomas J N68015Kier TAYLOR MONOPLANE · S/N 1001Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1983 · Minshew Paul J N82955Aeronca 7AC · S/N 7AC1606Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Mangels Harold R N919EDova Aircraft Sro DV-1 SKYLARK · S/N 06/15Cancelled Oct 20, 2015 · Built 2007 · Brown David A N8GHenderson VARIEZE · S/N 145Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Henderson Ernest W N95256Piper PA-28-140 · S/N 28-25864Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1969 · Quarry Products Inc N6572HCessna 172M · S/N 17265494Cancelled Jul 25, 2013 · Exported to Philippines · Built 1975 · Sipkins Samuel N7486CLockheed PV-2 · S/N 15-1385Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1957 · Quarry Products Inc N88971Jodel D-9 · S/N F3168Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1967 · Duncan Donald W N56145Consolidated Vultee BT-13A · S/N 11843Cancelled Nov 13, 2012 · Revoked, canceled · Built 1941 · Duke Robert H N2061HErcoupe 415-C · S/N 2684Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1946 N147VMcewan M-2-153 · S/N 1Cancelled Jun 30, 2009 · Registration revoked · Built 1968 · Jones Robert G N8038XBlanchard Everett J. BD4 AMPHIBIAN · S/N 658Cancelled Nov 29, 2005 · France Ken A N2221XRobinette Richard Gordon ULTRA PUP · S/N U.P.0062Cancelled Jan 23, 2004 · Built 1994 · Mccurdy Gregg Lowell N2779KLuscombe 8E · S/N 5506Cancelled Dec 18, 1981 · Built 1947 · Yearwood Leslie G N423MBDouglas DC3C · S/N 27079Cancelled Sep 4, 1980 · Exported to Colombia · Built 1945 · Bottoms William F N5958BCessna 182A · S/N 33958Cancelled Aug 14, 1975 · Gorrell Roger N8510GCessna 150F · S/N 15062610Cancelled Aug 14, 1974 · Built 1965 · Jones Frank B N9637FHughes 269C · S/N 1000055Cancelled Mar 13, 1974 · Exported to New Zealand · Built 1970 · City Of Richmond N2872DNorth American F-51D · S/N 45-11620Cancelled Oct 1, 1973 · American Air Museum N93621Ercoupe 415-C · S/N 944Cancelled Sep 16, 1970 · Johnson Ronald I James G Hancock N8156KStinson 108 · S/N 108-1156Cancelled Mar 17, 1966 · Hefley Eugene N64144Boeing A75N1 · S/N 75-3465Cancelled May 20, 1965 · United-Heckathorn N8638ABeech A35 · S/N D-2048Cancelled May 20, 1965 · Henery A Smith N68918Timm N2T-1 · S/N 266Cancelled Feb 17, 1956 · Griggs James N1587KLuscombe 8A · S/N 4314Cancelled Oct 18, 1955 · Built 1946 · Martin E V N4259Travel Air 2000 · S/N 359Cancelled Feb 21, 1955 · Harvey Robert Mason N77900Luscombe 8A · S/N 3627Cancelled Jun 3, 1949 · Eugene V Martin N152MNew Standard STANDARD D-29A · S/N 1004Cancelled May 12, 1948 · Built 1929 · Rader Roy N14414Beech B17L · S/N B17L-27Cancelled Mar 11, 1940 · Doney D T N12706Glafke Glen H GLAFKE P T · S/N 1Cancelled Mar 1, 1935 · Lowery Lorrill L

Back to Richmond, CA