Marshfield, WI
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 = 'WI' AND g.registrant_city = 'MARSHFIELD' 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 = 'WI' AND g.registrant_city = 'MARSHFIELD' 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.
N156BZShambeau Brian K ZENITH ZODIAC XL · S/N 65202N2417MPiper PA-32R-300 · S/N 32R-7880064N2589Maguire William J RAVEN · S/N 08N266MECessna 182S · S/N 18280772N30HVBeech 300 · S/N FA-173N42512Piper J3C-65 · S/N 14784N4355REa Vision EA J100 · S/N 85651N4548APiper PA-22-150 · S/N 22-3857N477RTBombardier BD-100-1A10 · S/N 21039N612SLPiper PA 46-350P · S/N 4636842N716CCCessna 441 · S/N 441-0213N74MHPiper PA-28-151 · S/N 28-7415465N7936WPiper PA-28-180 · S/N 28-1978N8336MCessna A150K · S/N A1500036N84003Aeronca 7AC · S/N 7AC-2691N89249Cessna 140 · S/N 8269N90438Siverling Leon F SPIRIT XL · S/N 2874N9591BCessna 172RG · S/N 172RG0904
Back to Marshfield, WI