OpenAirDocs.org
Estero, FL

Registered aircraft · 28

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 = 'ESTERO'
  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.

N123YTAlan H Hasbrouck JR SEA REY · S/N 1LK566CBuilt 2014 · Jam Amusements LLCN210AZCessna T210L · S/N 21059678Built 1972 · Aerialtraders LLCN21WDSmith AEROSTAR 600 · S/N 60-0197-087Built 1975 · Mullens Aviation LLCN223CSCessna T240 · S/N T24002017Built 2013 · Bpc Aircraft Leasing LLCN22EEPiper AEROSTAR 602P · S/N 62P09228165046Built 1981 · Mullen James JN258SNBoeing 747-47UF · S/N 29258Built 1999 · B29258 LLCN2ECEclipse EA500 · S/N 000220Built 2008 · Captainrgaviation LLCN3020NCessna 140 · S/N 13278Built 1947 · Shuster David MN30483Piper PA-28-181 · S/N 28-7890454Built 1978 · Yates MatthewN31MVCirrus Design SR22 · S/N 8588Built 2022 · Cypress Air Charter LLCN3435CCessna 170B · S/N 26478Built 1954 · Harter Scott WN398MAPiper AEROSTAR 601P · S/N 61P-0529-223Built 1978 · Mullens Aviation LLCN412SNMcdonnell Douglas MD-11F · S/N 48412Built 1990 · M48412 LLCN414PGCessna 414A · S/N 414A0811Built 1982 · 89 Galileo Aviation LLCN4182SBeech A36 · S/N E-668Sassine AlainN42760Piper J3C-65 · S/N 15069Built 1945 · Brown David KN468DRAmerican Champion 8GCBC · S/N 579-2016Built 2016 · Brantley JamesN522RDehavilland TIGER MOTH DH 82A · S/N T-7602Built 1935 · Welch Robert EN601DJPiper AEROSTAR 601P · S/N 61P07798063392Built 1980 · Mullen James JN6051SBeech B-60 · S/N P-372Built 1975 · Cya Aviation LLCN630SNMcdonnell Douglas MD-11 · S/N 48630Mobility Air LLCN6416YPiper PA-23-250 · S/N 27-3708Built 1967 · Mcm Aviation LLCN666XBeech A60 · S/N P-234Built 1973 · Golden Eagle LLCN6830RCessna T210G · S/N T210-0230Built 1967 · Elizalde Carla ZankizN7223MCessna 175 · S/N 55523Built 1958 · Moosehead Enterprises LLCN796NEDJI PHANTOM 4 · S/N 07DDD730B10443Estero Fire RescueN79WVCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 145Muyres DouglasN955CCCessna 172K · S/N 17258826Built 1969 · N955cc LLC
Back to Estero, FL