Cancelled registrations · 18

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 = 'UT' AND d.registrant_city = 'PAROWAN' 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 = 'UT' AND d.registrant_city = 'PAROWAN'
  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 = 'UT' AND d.registrant_city = 'PAROWAN'
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.

N78764Les Air AIRCOMMAND 582-2 · S/N AC 5822001Cancelled Feb 17, 2022 · Second renewal notice · Haynie Dan W N43522Six Chuter SR7X1 · S/N 2704Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 2001 · Stowell Kip D N91890Schweizer SGU-1-19 · S/N 35Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1956 · Batt Richard O N9465VMooney M20E · S/N 700037Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1970 · Miller James R N47121Batt HWP 40-1 · S/N BJ001Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1975 · Batt Richard O N9925Grumman Acft ENG Cor-Schweizer G-164A · S/N 1331Cancelled Jun 14, 2011 · Registration pending, pending cancellation · Built 1974 N24JBeech E18S · S/N BA-362Cancelled Oct 9, 2009 · Registration revoked · Built 1958 · Summers George N4097VSix Chuter SR7X1 · S/N SR7X1-2704Cancelled Jun 24, 2008 · Stowell Kip D N88048Eagle EAGLE DW-1 · S/N DW-1-0033-81Cancelled Jun 29, 2006 · Triennial form not returned · Parowan Crop Dusting Service Inc N8805DEagle EAGLE DW-1 · S/N DW-1-0034-81Cancelled Feb 11, 2005 · Triennial form not returned · Built 1981 · Thornton Michael R N8803HEagle EAGLE DW-1 · S/N DW-1-0023-81Cancelled Aug 1, 2001 · Triennial form not returned · Parowan Crop Dusting Services Inc N7660VAero Commander CALLAIR A-9B · S/N 1388Cancelled Mar 23, 1998 · Triennial form not returned · Parowan Crop Dusting Service Inc N7923VAero Commander CALLAIR A-9B · S/N 1562Cancelled Mar 23, 1998 · Triennial form not returned · Parowan Crop Dusting Service N5079Grumman Acft ENG Cor-Schweizer G-164A · S/N 1113Cancelled Oct 1, 1992 · Exported to Mexico · Parowan Crop Dusting Service Inc N8333FHughes Helicopters HUGHES 369D · S/N 1160038DCancelled Jun 19, 1979 · Exported to Canada · Glantz Richard L N10BESzybowcowy Zaklad Doswiadczaln SZD-38A JANTAR-1 · S/N B677Cancelled Oct 26, 1977 · Exported to Poland · Built 1975 · Katinszky Elemer A N55JHSportavia Putzer RF5B SPERBER · S/N 51056Cancelled Jun 4, 1976 · Paul Philip I N61895Cessna 172M · S/N 17264875Cancelled Feb 24, 1976 · Freeborn Leland F

Back to Parowan, UT