Winter Springs, FL
Registered aircraft · 18
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 = 'WINTER SPRINGS' 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 = 'WINTER SPRINGS' 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.
N2326VPiper PA-28-181 · S/N 28-8590067N283GTPiper PA-31-350 · S/N 31-7952139N309CQQuest KODIAK 100 · S/N 100-0260N3909UCessna 150E · S/N 15061309N3964Glasflugel STANDARD LIBELLE · S/N 187N446XTurner Douglas D VANS RV-7 · S/N 70853N4969GCessna 172N · S/N 17273516N50532Cessna 150J · S/N 15069378N55CTCirrus Design SR22 · S/N 9193N561DDFurr William E SEAREY · S/N 1LK492CN609CQDassault FALCON 900EX · S/N 265N6236YBeech B-55 · S/N TC-2436N731JHCirrus Design SR22 · S/N 5027N733MUCessna 172N · S/N 17268404N739FYCessna 172N · S/N 17270519N739SWCessna 172N · S/N 17270778N81991Piper PA-32-301 · S/N 32-8006044N8957CPiper PA-28-140 · S/N 28-7625137
Back to Winter Springs, FL