Fort Myers, FL
Registered aircraft · 432
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 = 'FORT MYERS' 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 = 'FORT MYERS' 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.
N1045Piper PA-28-181 · S/N 28020177N1075Brown Steven M RV-9A · S/N 91524N110DPDon A Pfeiffer VANS RV10 · S/N 40673N114SLRockwell International 112 · S/N 122N1163ZMooney M20J · S/N 24-1285N1169GSorensen Gary E LANCAIR ES · S/N ES-063-FBN11ZSGrumman American Avn. AA-5A · S/N AA5A-0403First renewal noticeN120GXMooney M20R · S/N 29-0459N120MGPiper PA-28-181 · S/N 28020071N122EKDanny Kelly TITANIUM EXPLORER · S/N TX008N12323Curtiss Wright TRAVEL AIR A-14-D · S/N 2008N1237QCessna 150L · S/N 15072537N1241QCessna 150L · S/N 15072541N124CFTwo Way Traffic EXEC 162F · S/N 6165N126RYTexas Aircraft Mfg COLT 100 · S/N TXA002First renewal noticeN128EDNew Piper PA-46-350P · S/N 4636258N12HFPiper PA-28-181 · S/N 28020131N1358KLuscombe 8A · S/N 4085N136GRBeech A36 · S/N E2115N1387FCessna 172G · S/N 17254882N1397SCessna 182P · S/N 18264958N14089Piper PA-23-250 · S/N 27-4687N14201Kinner SPORTSTER B. · S/N 122N1439YCessna 172C · S/N 17249139N144BBCzech Sport Aircraft A S SPORTCRUISER · S/N 09SC263N1465Canadian Car & Foundry HARVARD MK IV · S/N CCF4-39N146BPBeech F33A · S/N CE-1775N148APiper PA-28-181 · S/N 28020203N150PFPiper PA-44-180 · S/N 4496545N151DGDean R Grover MUSTANG II · S/N M-II-2349First renewal noticeN15214Waco UKC-S · S/N 3981N154PAPiper PA-28-181 · S/N 28020012N156BFBombardier CL-600-2B16 · S/N 5912N1598EAeronca 7AC · S/N 7AC-5163N15CZDanila Charles S SR COZY · S/N 72N15QAPiper PA-24 · S/N 24-2388N1606WBeech 95-B55 (T42A) · S/N TC-1467N160MAEstumkeda Ltd DBA Micco Acft MAC-145B · S/N 260009N1616PPiper PA-22 · S/N 22-2430N1627ECessna 172N · S/N 17271070N162BWPiper PA-34-200T · S/N 34-7570147N1668Piper PA-28-181 · S/N 28020178N166DARockwell International 114 · S/N 14166N16CJCessna U206F · S/N U20602501N16EDCessna 172RG · S/N 172RG1189N16RJPiper PA-28-181 · S/N 28020193N16WPHughes TH-55A · S/N 67-16861N170SUCessna 152 · S/N 152-83248N172AKCessna 172H · S/N 17255914N17360Ryan Aeronautical ST-A SPECIAL · S/N 184
Back to Fort Myers, FL