Marco Island, FL
Registered aircraft · 34
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 = 'MARCO ISLAND' 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 = 'MARCO ISLAND' 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.
N1085CMooney M20K · S/N 25-1228N1154UMooney M20J · S/N 24-1242N132ATAirtime CYGNET · S/N 117N14103North American T-28B · S/N 51-3570N158TBBeech 58 · S/N TH-826N163ATAirtime CYGNET · S/N 00106N1850MLearjet 45 · S/N 475N21ZMBoyle Dan C RV-14A · S/N 140752N22293Piper PA-32RT-300T · S/N 32R-7887253N22VSHawker Beechcraft HAWKER 900XP · S/N HA-0047N26GBPiper PA-18-150 · S/N 18-8209004N2850YPiper PA-32-300 · S/N 32-7940157N288JREclipse Aerospace EA500 · S/N 550-0274N2993LMooney M20F · S/N 670352N3078PBeech A36 · S/N E-2342N3121WBeech 58 · S/N TH-410N3317RCessna 182L · S/N 18258617N331DPBeech 35-C33 · S/N CD-954N35224Piper J3L-65 · S/N 6223N412GHTextron G58 · S/N TH2518N4313NPiper PA-32R-301 · S/N 32R-8313026N44PYCessna 172S · S/N 172S8543N48YPiper PA-23-250 · S/N 27-8154022N54381Cessna 172P · S/N 17274968N5605PPiper PA-24-180 · S/N 24-673N6670DAero Commander 100 · S/N 032First renewal noticeN720GBCessna 560XL · S/N 560-6058N756HUCessna TU206G · S/N U20604111N75VKTextron 525 · S/N 525-1042N7868FPiper PA-32R-300 · S/N 32R-7780085N801WZEmbraer Executive EMB-505 · S/N 50500144N928PBPiper PA46-500TP · S/N 4697227N977WWhite Kenneth D ZENITH CH 650 · S/N 65-10544N990UCessna 210E · S/N 21058690
Back to Marco Island, FL