Haines City, FL
Registered aircraft · 17
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 = 'HAINES 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 = 'HAINES 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.
N13384Cessna 172M · S/N 17262719N282DFJD Enterprises MURPHY REBEL · S/N 062N36781Piper PA-32RT-300 · S/N 32R-7885208N404APiper PA-31-350 · S/N 31-8252004N4209AB & M Manufacturing SEA REY · S/N 1MK367CN43SYTaylorcraft BC-65 · S/N 1465N46699Taylorcraft DCO-65 · S/N 4820N5398LPiper PA-28-180 · S/N 28-4707N6082NBeech B23 · S/N M-1175N68AVEvolution REVOLT · S/N 001008N6969SMontaer Ltda MONTAER MC01 · S/N 072N701SDCessna R182 · S/N R18201548N8052WPiper PA-28-180 · S/N 28-2125N825SPCessna 441 · S/N 441-0127N8675BCessna 172 · S/N 36375N88192Piper J3C-65 · S/N 15808N912LJames David Ledford KITFOX 5 · S/N S97100127
Back to Haines City, FL