Dade City, FL
Registered aircraft · 25
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'DADE CITY' 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 = 'DADE CITY' 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.
N113MKKendry Mark R AVENTURA II · S/N AA2A0113N154RGregory A Spicola AR-1 · S/N 0044N1970SBeech 95-B55 (T42A) · S/N TC-1302N205ARGregory A Spicola AR-1 · S/N 0019N20TUMooney M20E · S/N 159N25885Piper J3C-65 · S/N 3840N279JRRathbun Jay H ROTORWAY 162F · S/N 6697N293RXDarren Douglas Mcdowell WOLVERINE · S/N AC0023N329RSAero Commander 500-B · S/N 1303-118N35NAHelicopters International LIGHTNING · S/N 0001N3751EAeronca 11AC · S/N 11AC-S2N3846CAero Commander 560-E · S/N 709N4701DCessna 182A · S/N 34801N481XMorris O Pearson ONEX · S/N ONX 0128N4GTCirrus Design SF50 · S/N 0426N50ZXHouston Peter John PH1 · S/N 001N5674TCessna 172E · S/N 17251574N5829BCessna 182 · S/N 33829N609SFFoster Stan SPARROWHAWK · S/N 001N68527Bellanca 7ECA · S/N 870-72N830BKenneth J Ramsey SPORTCOPTER II · S/N SC006N85329Aeronca 7AC · S/N 7AC-4068N92125Cessna 182M · S/N 18260055First renewal noticeN9678Alan J Colburn BD-4 · S/N 001N9UKJoseph Lanzillo GEM · S/N 2011
Back to Dade City, FL