Summerland Key, FL
Registered aircraft · 35
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 = 'SUMMERLAND KEY' 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 = 'SUMMERLAND KEY' 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.
N1017MMooney M20K · S/N 25-0564N1352CPiper PA-18A-135 · S/N 18-2515N1816HCessna 310C · S/N 35916N184MBBeech E-55 · S/N TE-1075N19469Cessna 150L · S/N 15074433Registration pendingN208JKCessna 208 · S/N 20800281N2096RCessna 182G · S/N 18255296N2376VCessna 182S · S/N 18280432N2399BTemco GC-1B · S/N 3699N2429GCessna 182B · S/N 51729N3000APiper PA-32RT-300T · S/N 32R-7887287N308BBBeech 95-B55 (T42A) · S/N TC-1886N330DSSteele Dennis A GLASAIR III · S/N 3097N35080Polaris Flying Inflatable Boat POLARIS · S/N 013932N397PCPiper PA-24-250 · S/N 24-3189N421LKCessna 421C · S/N 421C1017N458SMShark Aero S R O SHARK 600T · S/N 172N5764QMooney M20C · S/N 3084N609VRDavid Ordun RV-14A · S/N 140906N6173JPiper PA-32R-300 · S/N 32R-7680324N6287ACessna 182 · S/N 33087N6501YCessna 210N · S/N 21064412N66585Beech B36TC · S/N EA-353N7164ACessna 172 · S/N 29264N7206LPiper PA-22-150 · S/N 22-5030N7223RGoff Larry GLASAIR · S/N 2052N7694EChampion 7FC · S/N 7FC-289N80JVWaco Classic 2T-1A-2 · S/N 1207N8111TCessna 175B · S/N 17556811N8514MBeech P35 · S/N D-7182N862SPScoda Aeronautica Ltda SUPER PETREL LS · S/N S0357N8640TCessna 182C · S/N 52540N8984XCessna 182D · S/N 18253384N900TXBellanca 7GCBC · S/N 938-76N9180ZCessna 172 · S/N 28142
Back to Summerland Key, FL