Registered aircraft · 19

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'FL' AND g.registrant_city = 'KEYSTONE HEIGHTS' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'FL' AND g.registrant_city = 'KEYSTONE HEIGHTS'
  ORDER BY g.n_number"

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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'FL' AND g.registrant_city = 'KEYSTONE HEIGHTS'
ORDER BY g.n_number

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.

N108AVPiper PA-28-151 · S/N 28-7415573Built 1974 · Davis Robert S N10903Cessna 150L · S/N 15075123Built 1973 · Forty Two J Aviation Inc N148GWTimothy R Huggins AR-1 · S/N 0022Built 2018 · College Of Missionary Aviation Inc N2277FCessna 310 · S/N 35352Built 1956 · Eagle Mission LLC N2846YPiper PA-28RT-201 · S/N 28R-7918171Dasher Richard Allan N301GWCessna 150K · S/N 15071678Built 1969 · College Of Missionary Aviation Inc N306GWCessna 172E · S/N 17250714College Of Missionary Aviation Inc N3224FMooney M20E · S/N 670017Registration pendingBuilt 1967 N3570PBeech A23 · S/N M-751Built 1965 · Timbie John E N44534Piper PA-28-140 · S/N 28-7425423Sale reported, pending cancellationBuilt 1974 N5683GCessna 150K · S/N 15071183College Of Missionary Aviation Inc N61EFForisch Edward BUSHBY MUSTANG M II · S/N M-II-1019Built 1989 · Mission Aviation Resources LLC N64455Cessna 172M · S/N 17265242Built 1975 · Sales Eric D N67306Cessna 152 · S/N 15281738Built 1978 · Dagenais David W N8065XCessna 172B · S/N 17248565Built 1961 · College Of Missionary Aviation Inc N8860ABeech B35 · S/N D-2515Built 1950 · Wilmoth Todd N914NMStanfill Michael O THUNDER GULL J20 · S/N 1968Built 2007 · Rogero Joseph F N951DZVans RV-12 · S/N 120121Built 2016 · Welch John D N9729DPiper PA-22-160 · S/N 22-6641Built 1959 · Burr Industries Inc

Back to Keystone Heights, FL