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

N212LKLithuanian Factory Of LAK-12 · S/N 6202Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1994 · Konle Hans N7521SCameron Balloons US N-105 · S/N 5780Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1992 · Robinson Eleanor W N223PMM-Squared BREESE 2 · S/N 000600Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 2005 · Barretto Ron N8430PPiper PA-24-250 · S/N 24-3677Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1964 · Hankison Rodney S N40665SZD PZL Bielsko SZD-37 JANTAR 17 · S/N X-112Cancelled May 8, 2015 · Registration expired, pending cancellation · Konle Hans Peter N3244UBrooks Francis A KR-2 · S/N PLANS-1792Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1983 · Brooks Francis A N1032BCameron Balloons Z-90 · S/N 6370Cancelled Jun 17, 2014 · Exported to Taiwan · Built 2004 · Robinson David E N658KKinsey James D LONG EZE · S/N 1617Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Kinsey James D N9086Enstrom F-28A · S/N 219Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1974 · Jenkins Nevin C N2316JBeech 23 · S/N M-266Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1963 N3602LCessna 172G · S/N 17253771Cancelled Jun 17, 2013 · Sale reported, canceled · Built 1965 N66WKCessna 150F · S/N 15062887Cancelled Nov 29, 2012 · Exported to Bolivia · Built 1966 · Alvis Michael E N55624Piper PA-28R-200 · S/N 28R-7335260Cancelled Apr 30, 2010 · Exported to South Africa · Built 1973 · Sandberg Eric F N6044PPlumstead Lawrence P CAPELLA · S/N FW2C80TD121365Cancelled Sep 12, 2006 · Triennial form undeliverable · Plumstead Lawrence P N74724Mooney M20B · S/N 1724Cancelled Jul 22, 1997 · Triennial form not returned · Quearry Carlos G N1379PPiper PA-23 · S/N 23429Cancelled Apr 29, 1993 · Gignac Edward C N545AALedbetter Hunter FALCON XP · S/N 600168Cancelled Aug 7, 1991 · Second triennial mailing, no response · Ledbetter Hunter L N2459QPiper PA-28-161 · S/N 28-7716105Cancelled Jun 9, 1981 · Exported to United Kingdom · Built 1977 · Enz Charles J N6434Hummel JEANIES TEENIE · S/N HH-1Cancelled Jun 15, 1970 · Hummel Harold E

Back to Seminole, FL