Palmetto, FL
Registered aircraft · 32
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 = 'PALMETTO' 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 = 'PALMETTO' 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.
N117HSStock Jeffrey A STOCK-CUB · S/N 1999N1369EChampion 7AC · S/N 7AC-4930N166JVashon RANGER R7 · S/N 10196N17371Cessna 150L · S/N 15073714N190DBAir Creation GTE 582 · S/N T03060N1951DDave Brubaker AVENTURA II · S/N AA2A0192N201WMMooney M20J · S/N 24-0195N211WGDassault MYSTERE FALCON 900 · S/N 142N2249NPiper PA-28RT-201T · S/N 28R-7931053N2967KLuscombe 8A · S/N 5694N307PCDavies Charles J RENEGADE SPIRIT · S/N 0307N311WGSikorsky S-76C · S/N 760457N374VRVashon RANGER R7 · S/N 10229N410DPDouglas W Peterson RV-10 · S/N 41135N410PGGuy Pessina VANS RV-10 · S/N 40100N4479EAeronca 7DC · S/N 7DC101N4569VWhittaker Charles R BAKENG DOUBLE DUCE · S/N 112N4EKSchneider Mike PRGRSV ARDYN SEAREY · S/N 1DK214N517WCessna 140A · S/N 15255N53FMAmerican Legend AL11 · S/N TX-1038N54XPYakovlev YAK-54 · S/N 01N5598GBeech B36TC · S/N EA-503N5995PPiper PA-24-250 · S/N 24-1089N6991HCessna 172M · S/N 17265683N711DSSikorsky S-76C · S/N 760473N746JJabiru USA Sport J230-SP · S/N 797N7716SSchweizer SGS 1-26D · S/N 416N78314Temco GC-1B · S/N 2314N793LRAmerican Legend AL11C-100 · S/N AL-1028N85753Aeronca 7AC · S/N 7AC-4502N92525Elliott Carlton Price SR MUSTANG II · S/N M-11-1095Sale reportedN9670GMooney M20E · S/N 581
Back to Palmetto, FL