Fort Walton Beach, FL
Registered aircraft · 69
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 WALTON BEACH' 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 WALTON BEACH' 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.
N121TRPiper PA46-500TP · S/N 4697669N155ATAirtime CYGNET · S/N 121N168FLSix Chuter SR7 XL · S/N 1001N171CRAmerican Champion 8KCAB · S/N 1053-2007N175ATAirtime CYGNET · S/N 115N202MSShiver James H CAVALIER SA102 · S/N JS004N2102NCessna 140 · S/N 12338N2327FCessna 210E · S/N 21058527N2330DPiper PA-38-112 · S/N 38-79A0276N241HTQuad City CHALLENGER 2 · S/N 1981First renewal noticeN2427Cessna R172E · S/N R172-0235N242PMPiper PA46R-350T · S/N 4692053N2661FKrucker Manufacturing CYGNET · S/N H20034N2725EChampion 7AC · S/N 7AC-6306N28HYAviat A-1B · S/N 2034N31004Piper J3C-65 · S/N 13085N3956YCessna 210D · S/N 21058456N395PMPiper PA 46-350P · S/N 4622195N39TXKremp Stan RV-7A · S/N 70323N41091Sea-Bow International B-4 · S/N SB-012K218N41093Sea-Bow International B-4 · S/N SB-032K113First renewal noticeN41097Sea-Bow International B-4 · S/N SB-2K217N4315VPiper PA-28-181 · S/N 28-8390088N4373LCessna 172G · S/N 17254450N444JGCessna 172I · S/N 17257013N471PJChitwood Dennis C POLARIS MOTOR FIB · S/N US027777N4864YCessna 210N · S/N 21064021N501GZUnmanned Aero Systems Uas GOZO · S/N 001N502GZUnmanned Aero Systems Uas GOZO · S/N 002N503GZUnmanned Aero Systems Uas GOZO · S/N 003N5126LPiper PA-28-180 · S/N 28-4409N51360Johnston Ronavin E J&J TUKAN · S/N 29644N5220ACessna 182T · S/N 18281149N52350Aeronca L-3C · S/N 058B6712N5504SBellanca 8GCBC · S/N 277-78N5505PPiper PA-24-250 · S/N 24-568N5694CCessna 140A · S/N 15654N572ABBlack Larry L BLACK FALCO F8 · S/N 572SFN5779JCessna 210K · S/N 21059479N60396Piper J3C-65 · S/N 13185N63079Cessna 150M · S/N 15077087N6472MStinson 108-3 · S/N 108-4472N6545GCessna 150L · S/N 15072045N65JHSocata TB-20 TRINIDAD · S/N 477N6675ZPiper PA-25-235 · S/N 25-2280N6970ZPiper PA-25-235 · S/N 25-2717N700RJBeavers Air SLING TSI · S/N 332SKN704TECirrus Design SR22T · S/N 1027N72ATAirtime CYGNET · S/N 00100N73306Cessna 172M · S/N 17267361
Back to Fort Walton Beach, FL