Skip to content

Cancelled registrations · 19

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 = 'TN' AND d.registrant_city = 'BOLIVAR' 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 = 'TN' AND d.registrant_city = 'BOLIVAR'
  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 = 'TN' AND d.registrant_city = 'BOLIVAR'
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.

N570KRAerostar International RAVEN S57-A · S/N S57A-3169Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1995 · Noyce Benjamin J N674KDDJI PHANTOM 3 PROFESSION · S/N P76DCK02A26603Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Williamson Robert K N389AMooney M-18L · S/N 50Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1949 · Humphreys John A N2443KPiper PA-38-112 · S/N 38-79A0637Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1979 · Bolivar Aircraft Sales Inc DBA N25503Cessna 152 · S/N 15280699Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1977 · Bolivar Aircraft Sales Inc DBA N2405DPiper PA-38-112 · S/N 38-79A0295Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1978 · Bolivar Aircraft Sales Inc N2437KPiper PA-38-112 · S/N 38-79A0634Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1979 · Bolivar Aircraft Sales Inc N2302WBeech A23A · S/N M-903Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1965 · Bolivar Aircraft Sales DBA N93472Cessna 152 · S/N 15285497Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1982 · Whitehurst T A N9324TPiper PA-38-112 · S/N 38-78A0032Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1978 · Bolivar Aircraft Sales Inc DBA N45970Cessna 152 · S/N 15282968Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1978 · Whitehurst T A DBA N1361PPiper PA-23 · S/N 23-410Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1956 · Bolivar Aircraft Sales DBA N24252Cessna 152 · S/N 15280175Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1977 · Bolivar Aircraft Sales Inc DBA N2409KPiper PA-38-112 · S/N 3879A0620Cancelled May 13, 1991 · Bolivar Aircraft Sales Inc N6534ECessna 172N · S/N 172-72031Cancelled Sep 17, 1981 · Exported to Australia · T A Whitehurst DBA Bolivar Aircraft Sales N5106YCessna 210N · S/N 21064075Cancelled Mar 9, 1981 · Exported to Canada · T A Whitehurst DBA Bolivar Aircraft Sales N46932Cessna 152 · S/N 15283144Cancelled May 23, 1980 · Exported to United Kingdom · Whitehurst T A N67901Cessna 152 · S/N 15282086Cancelled May 8, 1980 · Exported to Canada · T A Whitehurst DBA Bolivar Aircraft Sales N8700SCessna 150F · S/N 15062000Cancelled Jun 29, 1976 · Exported to Canada · Anderson John V Jr

Back to Bolivar, TN