Skip to content

Keystone Heights, FL

Cancelled registrations · 21

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 = 'KEYSTONE HEIGHTS' 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 = 'KEYSTONE HEIGHTS'
  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 = 'KEYSTONE HEIGHTS'
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.

N975WMDuane Weis SEAREY CLASSIC · S/N 1DK300CCancelled Feb 14, 2026 · Sale reported, canceled N44471Fly Products MAX 130 · S/N DLS070547Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2008 · College Of Missionary Aviation Inc N652DKKirkland David J F II B · S/N 00-2B004Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2006 · Carroll Charles K N95495Hughes Aero PREDATOR "C" · S/N PC010853P402Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2009 · Baker Shane N26033Howland Aero Designs H-2 HONEY BEE · S/N 9113Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Carroll Kenneth N956BBeech 65 · S/N LC-107Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1961 · Cam Aircraft Service Inc N5623DBeech F50 · S/N FH-75Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1957 · Cam Aircraft Service Inc N4303DBeech D-50 · S/N DH-54Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1956 · Cam Aircraft Service Inc N66071Cessna 150M · S/N 15075813Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1974 · Keystone Aero Club Inc N4120XDrehen Robert Mack LM-2X-2P-W-1019 · S/N 1019Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Dreher Robert Mark N8199PPiper PA-24-250 · S/N 24-3394Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1963 · Royal Jones And Associates N7719RBeech 65 · S/N LC-190Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1965 · Davis Joseph H N3232JCessna 150G · S/N 15065932Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1966 · R C Aircraft Inc N91658Cessna 182M · S/N 18259859Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1969 N111HBBomer EVANS VP-2 · S/N 1758Cancelled Jul 20, 2011 · Sale reported, canceled · Built 1976 N676CABeech D50B · S/N DH207Cancelled Nov 4, 1996 · Triennial form not returned · Cam Aircraft Inc N8144FCessna 150F · S/N 15064244Cancelled Dec 17, 1981 · Marshall Marvin H Jr N524Beech D50A · S/N DH185Cancelled Oct 3, 1979 · Exported to Venezuela · Cam Aircraft Service Inc N10GREnstrom F-28A · S/N 207Cancelled May 12, 1976 · Executive Helicopters Inc N4168PPiper PA-23-160 · S/N 23-1655Cancelled Aug 1, 1974 · Sale reported · Built 1959 N49857Fairchild M-62A · S/N T43-7311Cancelled May 25, 1965 · Florida Aviation Academy

Back to Keystone Heights, FL