Skip to content

Cancelled registrations · 25

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 = 'FL' AND d.registrant_city = 'INVERNESS' 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 = 'FL' AND d.registrant_city = 'INVERNESS'
  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 = 'FL' AND d.registrant_city = 'INVERNESS'
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.

N8647BCessna 172 · S/N 36347Cancelled Jun 15, 2024 · Revoked, canceled · Built 1957 · Flegel Martin J N6106ZPiper PA-25 · S/N 25-123Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1960 · Eagle Vistas LLC N4120Piel Emeraude CP-301 · S/N 81926Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1980 · Dobbelaere Dustin A N473SDHughes 369A · S/N 1091305Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Citrus County Sheriffs Department N9505WPiper PA-28-140 · S/N 28-22928Cancelled May 21, 2018 · Revoked, canceled · Built 1967 · Moore Robert L N1QZDavid L Millikan PIETENPOL AIR CAMPER · S/N 012Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Millikan David L N474SDHughes 369A · S/N 291048Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Citrus County Sheriffs Department N2015HErcoupe 415-C · S/N 2638Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1946 · Simon Hedwig N1856PSport Flight TALON XP · S/N XP067Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2005 · Wolfe James Jerome N134ZXZ Gull Z GULL II · S/N RH001Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 2005 · Wolfe James J N2680RKemmeries TUKAN II · S/N KT251Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2005 · Roberts Geoffrey N2684RQuicksilver SPORT II · S/N QS051Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Wolfe James Jerome N892CPSchweizer 269C · S/N S1423Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1989 · Owens Air Service Inc N8353Mccollam KR-1 · S/N F0573365Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Mccollam Robert N95414Piper PA-28-140 · S/N 28-25933Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1969 · Runyon Bruce N40930Raven Industries RALLY RX7 · S/N RX7-302Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1983 · Jacobson William D N5565YRaven Industries RALLY RX7 · S/N RX7-179Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1979 · Duvall William G N9017FHughes 269A · S/N 46-0509Cancelled Feb 20, 2013 · Sale reported, pending cancellation N4647ZPiper PA-22-108 · S/N 22-8169Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1961 · Verka Albert James N35FDCessna 152 · S/N 15283048Cancelled Oct 27, 2006 · Triennial form not returned · Built 1978 · Barber George W N6233TCessna 150E · S/N 15060933Cancelled Nov 29, 2000 · Abbruzze Michael J III N5312SCessna 337A · S/N 3370412Cancelled Nov 23, 1983 · Welch Oraldine R N39544Ercoupe 415-CD · S/N 4655Cancelled Jul 23, 1982 · Built 1947 · Matthews Ronald H N1428LBeech A23 · S/N M822Cancelled Jul 23, 1978 · Built 1965 · Heffron John N & Poole Harold J N2919PPiper PA-22-150 · S/N 22-3187Cancelled May 19, 1965 · Cecil G Berry

Back to Inverness, FL