Cancelled registrations · 33

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 = 'DODGE CITY' 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 = 'DODGE CITY'
  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 = 'DODGE CITY'
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.

N100UHRobinson Helicopter R22 · S/N 4633Cancelled Dec 10, 2018 · Exported to Australia · Built 2014 · Universal Helicopters N123UHRobinson Helicopter R22 BETA · S/N 4652Cancelled Dec 10, 2018 · Exported to Australia · Built 2014 · Alba Leasing Services N48UHRobinson Helicopter R22 · S/N 4724Cancelled Sep 19, 2018 · Exported to Australia · Built 2017 · Alba Leasing Services N50FBCessna 421C · S/N 421C0477Cancelled Aug 18, 2018 · Registration pending, canceled · Built 1977 N22UHRobinson Helicopter R22 · S/N 4676Cancelled May 16, 2018 · Third renewal notice · Built 2015 · Alba Leasing Services LLC N914JMCessna 172P · S/N 17274971Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1981 N3865XAero Commander 100 · S/N 154Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1967 N8852PPiper PA-24-260 · S/N 24-4308Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1965 · Dodge City Farm & Industrial Oil N6140Mauch D-8 · S/N 1Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1969 · Mauch Glenn E N8981SCessna 150F · S/N 15062281Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1965 N983TBeech 35-33 · S/N CD-190Cancelled May 19, 2007 · Built 1960 · Crotts Aircraft Service Inc N4570JPiper PA-28R-180 · S/N 28R-30433Cancelled Jul 28, 2005 · Exported to Canada · Built 1968 · Webb Brian C N2888JCessna T188C · S/N T18803563TCancelled Mar 29, 2005 · Exported to Brazil · Erhart Aerial Spraying Inc N3891PBarackman J D/Barackman Z A VANS ACFT RV-6 · S/N 23736Cancelled Mar 13, 2003 · Triennial form not returned · Built 1998 · Crotts Aircraft Service Inc N9224XPiper PA-32R-301 · S/N 3213055Cancelled May 21, 2002 · Built 1994 · Saratoga LLC N3074CBeech K35 · S/N D5738Cancelled Apr 23, 1998 · Triennial form not returned · Crotts Aircraft Service Inc N756BMCessna U206G · S/N U20603960Cancelled May 24, 1995 · Triennial form not returned · Broce Construction Co Inc N7240MCessna 175 · S/N 55540Cancelled Aug 5, 1987 · Hemphill Gary A N5298SPiper PA-28-140 · S/N 2826946Cancelled Aug 13, 1980 · Hyplains Dressed Beef Inc N8917GCessna 182N · S/N 18260457Cancelled Mar 16, 1979 · Exported to Canada · Four Season Flying Serivce Inc N6160DPiper PA-22-150 · S/N 22-4807Cancelled Dec 5, 1977 · Perkins Dwaine R N371MKennedy-Watson K-W · S/N 1Cancelled Sep 12, 1975 · Built 1957 · Kennedy Harold Et Al N8234ACessna 170B · S/N 25086Cancelled Jan 22, 1973 · Exported to Canada · Rudd Roger L N6427BCessna 172 · S/N 29627Cancelled Jan 14, 1972 · Exported to Canada · James D Hinerman N7416JPiper PA-28R-180 · S/N 28R-30758Cancelled Sep 14, 1971 · Sherrid C L N5148LPiper PA-28-180 · S/N 28-4433Cancelled Oct 11, 1968 · Mahon Roy O N50555Taylorcraft BC12-65 · S/N 3389Cancelled Dec 30, 1949 · Houser Leslie & Chester Karnes N8163KStinson 108-1 · S/N 108-1-1163Cancelled Jun 6, 1949 · Dodge City Air Service Inc N92596Piper PA-12 · S/N 12-127Cancelled Apr 29, 1949 · R O Mahon DBA Mahons Boot Hill Flying Service N47678Aeronca 65-TAC · S/N 2311Cancelled May 27, 1947 · Fowler Fowler F N4332Aircraft Mechanics COMB EAGLEROCK 3POLB · S/N 411Cancelled Oct 15, 1940 · Built 1928 · Tedford Gene W N127VSullivan K-3 · S/N 3Cancelled May 1, 1939 · Built 1930 · Olive W P N195VCessna CG-2 · S/N 67Cancelled Feb 2, 1931 · Built 1930 · Willis A L

Back to Dodge City, KS