Cancelled registrations · 28

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 = 'KS' AND d.registrant_city = 'EMPORIA' 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 = 'KS' AND d.registrant_city = 'EMPORIA'
  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 = 'KS' AND d.registrant_city = 'EMPORIA'
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.

N90009Stephens Road Runner 3A · S/N 3ACancelled Mar 23, 2024 · Sale reported, canceled · Built 1970 N54WDWilson Douglas E PEGAZAIR SP 150 · S/N 001Cancelled Aug 24, 2016 · First renewal notice · Built 1999 · Wilson Douglas E N90455Tevis Don SPACEWALKER II · S/N 202Cancelled May 7, 2015 · Built 2005 · Tevis Don N65272Bush BD-4 · S/N 642Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1977 · Bush Jesse B N75264Golden Circle Air T-BIRD · S/N TA-19Cancelled Sep 12, 2012 · Registration pending, canceled N93791Fisher Bryan L PCHUTE · S/N 01Cancelled Jan 21, 2012 · First renewal notice · Fisher Bryan L N6282GCessna 150K · S/N 15071782Cancelled Mar 14, 2011 · Expired dealer · Built 1970 · Kansas Flying Service & Sales Inc N5065URans S-12XL · S/N TA-13Cancelled Jun 19, 2008 · Exported to Mexico · Built 2002 · Tevis Donald E N5289HPiper PA-16 · S/N 16-93Cancelled Dec 23, 2004 · Triennial form not returned · Built 1949 · Farthing Harold B N704BFCessna 150M · S/N 15078476Cancelled Jan 11, 2002 · Triennial form not returned · Built 1976 · Tevis Aviation Inc N305RJMooney M20K · S/N 250602Cancelled Mar 22, 2001 · Triennial form not returned · Cripps Rick E N194JPPrevatt David R RV-6 · S/N 21752Cancelled Jan 22, 1997 · Prevatt David R N20428Cessna 172M · S/N 17261281Cancelled Jun 3, 1991 · Westwind Aviation Inc N76448Cessna 140 · S/N 10880Cancelled Nov 17, 1983 · Traylor Wayne B N104YSickler-Lewis B · S/N 1Cancelled Apr 15, 1982 · Administratively canceled · Sickler Fred H N8496HBartram Ralph Dean MUSTANG-II · S/N 879Cancelled Sep 10, 1981 · Bartram Ralph D N16009Cessna 150L · S/N 15073407Cancelled Sep 26, 1975 · Built 1972 · Holy Toledo Flying Service N60410Cessna 150J · S/N 15070288Cancelled Oct 15, 1973 · Kansas Flying Service And Sales Inc N50450Cessna 150J · S/N 15069310Cancelled Mar 9, 1972 · Kansas Flying Service & Sales Inc N36542Aeronca 65-LB · S/N LB16181Cancelled Apr 4, 1971 · Marshall Jerry N7862FCessna 150F · S/N 15063962Cancelled Jun 29, 1970 · Rogers Flying Service N4960PPiper PA-23-235 · S/N 27-561Cancelled Jun 23, 1970 · Donald A Glaser N59555Cessna T-50 · S/N 3749Cancelled May 21, 1960 · Weaver A Marvin N87186Ercoupe 415-C · S/N 359Cancelled Feb 24, 1956 · Hudson Frank N1958EAeronca 7AC · S/N 7AC-5525Cancelled Jan 26, 1951 · Place Chas A N22179Aeronca 50-F · S/N F-2839Cancelled Jun 11, 1948 · Built 1939 · Stafford Leonard A N15452Porterfield 35-70 · S/N 152Cancelled Oct 11, 1936 · Built 1935 · Mood C M N808MSaul 1000 · S/N 1001Cancelled Aug 1, 1936 · Mood C M

Back to Emporia, KS