Winter Haven, FL
Registered aircraft · 128
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 HAVEN' 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 HAVEN' 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.
N103EMCessna 310R · S/N 310R0083N104UCCessna 152 · S/N 15284673N10510Piper J3C-65 · S/N 45-4942AN105TLCessna T182T · S/N T18208213N109BSSteer R W CH 601HD · S/N 6-3983N109SKRainbow Skyreach BUSHCAT · S/N CH287CN11540Cessna 150L · S/N 15075502N12WJWeber John Hunt RANS S-12 · S/N 0794503N1430VCessna 172M · S/N 17263572N164EDAmerican Legend AL3 · S/N AL-1181N172JECessna 172R · S/N 17280289N177RBBritts SEAREY LSX · S/N 1LK619CN1912TPiper PA-28R-200 · S/N 28R-7135130N193CPPiper PA-18-150 · S/N 18-7709063N193TMAerofab LAKE LA-250 · S/N 84N195MMCessna 195B · S/N 16032N200DFPiper PA-23-250 · S/N 27-4080N201HBMooney M20J · S/N 24-0209N209SMLindstrand Balloons 120A · S/N 5380N20SWAlexander Schleicher ASH 31 MI · S/N 31160N210MYCessna 210M · S/N 21061763N211SLRobinson Helicopter R66 · S/N 1025N2188LHostler Howard Kevin XA-650 · S/N B2A-035-000N227DJAdrion Advisors VANS RV-7 · S/N 72696N2357PPiper PA-38-112 · S/N 38-79A0961N250CHPayne/Foster GLASAIR · S/N 250N255BLDiamond Aircraft Ind DA20-C1 · S/N C0741N2586HEngineering & Research 415-D · S/N 3211N258BLDiamond Aircraft Ind DA20-C1 · S/N C0742N272DWRobinson Helicopter R44 II · S/N 12107N2732AM Squared SPRINT 1000 · S/N 000592N282BLPiper PA-28-181 · S/N 2881674N2856HPiper PA-28-161 · S/N 28-7916482N292CXHarold Mccollum THATCHER CX-4 · S/N 292N296ARPiper PA-32-300 · S/N 32-7840063N3053Fairchild PT-26A · S/N FV711N32898Piper PA-28-140 · S/N 28-7525126N3371RRobinson Helicopter R22 BETA · S/N 3371N34273Cessna 177B · S/N 17701741N3470KPiper J3C-65 · S/N 22162N35JSSlay Jack E KITFOX CLASSIC IV SP · S/N C9402-0006N37425Fairchild M-62C(PT-23A) · S/N 4043AEN3751FGreat Lakes 2T-1A-2 · S/N 0756N38999Piper PA-32R-300 · S/N 32R-7780497N38BSPiper PA-18-150 · S/N 18-8505N401AFQuicksilver MXL SPORT II · S/N 000655N4057Mooney M-18C · S/N 249N4065WPiper PA-32-300 · S/N 32-40099N4105ZPiper PA-18-150 · S/N 18-8126N422BLDiamond Aircraft Ind DA 42 NG · S/N 42.N350
Back to Winter Haven, FL