Winter Garden, FL
Registered aircraft · 56
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 GARDEN' 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 GARDEN' 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.
N10086Cessna 150L · S/N 15074782N106WBMox Air Drifter 582 FLOUTS · S/N 1972N111LERobinson Helicopter R44 · S/N 2817N1384MCirrus Design SR22T · S/N 9178N15554Piper PA-32-300 · S/N 32-7340014N162CGJose Carlos R Guarilha RW162T · S/N 6858N174TXSpray Joel D/Vans RV-7 · S/N 72277N207TNCostruzioni Aeronautiche Tecna ASTORE · S/N 030N227BSCessna 182T · S/N 18281943N2667BBellanca 17-30A · S/N 89-301002N275LERobinson Helicopter R44 · S/N 2858N32348Piper PA-32-300 · S/N 32-7540032N333LERobinson Helicopter R44 · S/N 2666N337LACessna 337 · S/N 337-0134N3402Robinson Helicopter R44 II · S/N 14675N3404Cirrus Design SR22T · S/N 2155N3464Quicksilver SPORT 2S · S/N 0002N3527YCessna 182F · S/N 18254427N35KJBeech V35B · S/N D-9326N399LMPiper PA-32-300 · S/N 32-7540023N4417RLindsey Larry C RV-4 · S/N 2456N441WTCessna 441 · S/N 441-0313N47326Piper PA-28-181 · S/N 28-7890052N474LERobinson Helicopter R44 · S/N 2831N487HPBeech F33A · S/N CE-1333N50022Boeing A75N1 · S/N 75-965N503EMFaulkner Dane MAXAIR DRIFTER XP503 · S/N 0001N512LERobinson Helicopter R44 · S/N 2774N518JJCessna 208B · S/N 208B0878N52944Cessna 177RG · S/N 177RG1315N52JXCessna 152 · S/N 15281088N536DBJames E Box JR SR3500 · S/N 219SRN555ZPiper L-21A · S/N 18-913N575KHMoyes DRAGONFLY · S/N 1RWTN5890LAmerican AA-5 · S/N AA5-0240N6013LAmerican AA-5 · S/N AA5-0113N60HGJose Carlos Guarilha SUPER SPORT · S/N H2 60 2022N612DACirrus Design SR20 · S/N 1849N621MPProgressive Aerodyne SEAREY LSA · S/N 1094N62665Piper PA-23-250 · S/N 27-7654129N65328Cessna 182T · S/N 18281462N6XTPiper PA-34-220T · S/N 348233144N702VPCessna 172E · S/N 17251373N703VPCessna 172E · S/N 17250823N70452Piper J3C-65 · S/N 17451N737XZCessna 172N · S/N 17269766N751WWPiper PA-30 · S/N 30-1449N7815YPiper PA-30 · S/N 30-747N7SBCessna 750 · S/N 750-0209N812WMPiper PA-32-300 · S/N 32-7740076
Back to Winter Garden, FL