Lehigh Acres, FL
Registered aircraft · 38
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 = 'LEHIGH ACRES' 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 = 'LEHIGH ACRES' 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.
N109AGAgusta A109C · S/N 7602N130BHBell 206B II · S/N 1776N198RDDouglas DC3 · S/N 33024N3558PPiper PA-22-150 · S/N 22-3314N355RAeronca 11BC · S/N 259N3627XAero Commander 100 · S/N 355N36426Raven S-60A · S/N S60A-3153N380EHHylio HYL-150 · S/N 17906110310N4231MPiper PA-12 · S/N 12-3129N484MCBeech C90 · S/N LJ-807N488RDMooney M20E · S/N 1300N5052HBell 206B · S/N 4115N5446ZPiper PA-22-108 · S/N 22-9223N5798LAmerican AA-5 · S/N AA5-0207N597VFHawker Beechcraft B200GT · S/N BY-139N621MXDJI PHANTOM 1 · S/N PH635219335N6407SAerostar International RX-7 · S/N RX7-3034N6524GCessna 150L · S/N 15072024N7277SCessna 150H · S/N 15067977N7619PPiper PA-24-250 · S/N 24-2830N763MCBeechcraft TC-12B · S/N 161194N7649FPiper PA-32R-300 · S/N 32R-7780072N764MCAirbus Helicopters AS350B3 · S/N 8411N765MCAirbus Helicopters AS350B3 · S/N 8423N766MCAirbus Helicopters AS350B3 · S/N 8428N8550EChampion 7FC · S/N 7FC-351N866MCAirbus Helicopters AS350B3 · S/N 8436N867MCAirbus Helicopters AS350B3 · S/N 8443N868MCAirbus Helicopters AS350B3 · S/N 8448N869MCAirbus Helicopters AS350B3 · S/N 9762N875JHawker Beechcraft B200GT · S/N BY-158N9061SHughes 269A · S/N 76-0609N928MCDouglas DC3 · S/N 32897N9339LAmerican AA-1A · S/N AA1A-0039N942MCFreefly Systems ALTA X · S/N AX570743N943MCLeading Edge Aerial Tech PV40X · S/N 11372N944MCLeading Edge Aerial Tech PV40X · S/N 11418N9821CCessna 182M · S/N 18259988First renewal notice
Back to Lehigh Acres, FL