Cancelled registrations · 17

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

N514MKoo Carlos Chang HELI-SPORT CH-7 · S/N 59Cancelled Mar 21, 2024 · Built 2002 · Koo Carlos C N750GLLampert Gary Mitchel REVOLUTION HELI M500 · S/N 0062Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Lampert Gary M N2011ASchweizer 269C-1 · S/N 0016Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1995 · Quadrus Inc N800GLLampert Gary Mitchel REVOLUTION HELI M500 · S/N 0087Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1996 · Lampert Gary Mitchel N793Luscombe 8E · S/N 2697Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Mazzocco Bert F Jr N252EECessna 210E · S/N 21058526Cancelled May 3, 2007 · Exported to Australia · Built 1964 · Bates Lyman Jr N326HPPiper PA-32R-301T · S/N 3257150Cancelled Apr 5, 2006 · Exported to Australia · Built 2000 · Itech Ice LLC N781BSAlthoff James C BUCCANEER SX · S/N B1B507532Cancelled Jun 29, 1995 · Triennial form not returned · Althoff James C N9887YCessna T210N · S/N 21064627Cancelled Jul 26, 1994 · Triennial form not returned · Rosati Mario M N7697MCessna 175 · S/N 55997Cancelled Oct 10, 1991 · Triennial form not returned · Foshay Laird G N1486Addems-Pfeifer NIEUPORT 11 · S/N 102Cancelled Mar 15, 1983 · Administratively canceled · Addems Walter J Trustee N1914SSavage-James STEEN SKYBOLT · S/N 1Cancelled Nov 6, 1982 · Administratively canceled · Savage James L N22377Cessna T210L · S/N 21059738Cancelled Mar 22, 1982 · Built 1972 · Kerwin Melvin C Et Al N969Cessna A185E · S/N 18501669Cancelled Jul 18, 1979 · Exported to Bolivia · Norris Newcomb Everett N1262ZBeech 95-55 · S/N TC-82Cancelled Nov 15, 1972 · Allen Steve DBA Allen Electronic Laboratories N6118YPiper PA-23-250 · S/N 27-3328Cancelled Feb 25, 1972 · Burton W Blackwell N1849GChampion 7KCAB · S/N 80Cancelled Aug 5, 1968 · Built 1968 · Gibbs Johnson K

Back to Atherton, CA