Williston, FL
Registered aircraft · 18
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 = 'WILLISTON' 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 = 'WILLISTON' 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.
N105VWAmerican Blimp A-1-70 · S/N 105N1259RPowrachute AIRWOLF 912ULS · S/N A430ULSN151ABAmerican Blimp A-1-70 · S/N 101N154ZPAmerican Blimp A-1-70 · S/N 104N156LGAmerican Blimp A-1-70 · S/N 106N18590Cessna 150L · S/N 15073968N1919GAmerican Legend AL18 · S/N AL-1189N3420NMooney M20F · S/N 680047N460LGAmerican Blimp A-60+ · S/N 04N503WWAeros SPYDER · S/N 7594N55XTST Clair David L TANGO 2 · S/N T-022N612LGAmerican Blimp A-60+ · S/N 012N6424LAmerican AA-1A · S/N AA1A-0424N6943KPiper PA-20 · S/N 20-52N862Cessna/Weaver 305E · S/N WA862N8916HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1613N900RSCessna 172B · S/N 17248585N9909WPiper PA-28-140 · S/N 28-23429
Back to Williston, FL