Registered aircraft · 17

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'HOLMEN' ORDER BY g.n_number

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 = 'HOLMEN'
  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 = 'HOLMEN'
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.

N1322DGeorge Richard VANS RV-4 · S/N 1322George Richard A N226ABAlliant XLT 582 · S/N 4C0610Built 2009 · Anderson Clayton A N272GHXag P100 PRO · S/N 8219343C61N3Sturtz Ag LLC N29LKCessna 177RG · S/N 177RG0736Gibbons David N363ELGeorge Richard A SEAREY LSX · S/N 1DK363CGeorge Richard A N4359XPiper PA-28-140 · S/N 28-7525281Built 1975 · Wiedenbeck Thomas N5084YDestiny DESTINY 2000 · S/N 1B0196Built 2007 · Meyers Steven C N530TWKlos Keith L WITTMAN TAILWIND W10 · S/N 001Built 2016 · Klos Keith L N59TJVans RV-12IS · S/N 121207Built 2025 · Wiedenbeck Thomas J N601VBAircraft Mfg & Development CH 601XL SLSA · S/N 601-017SBuilt 2006 · Lowe William N72885Cessna 140 · S/N 10079Built 1946 · George Richard N734DECessna 172N · S/N 17268767Built 1977 · Schneider Paul W N778GGiffen Trane STARDUSTER TOO · S/N 77Farwell Joseph W N7807XCessna 172B · S/N 17248307Built 1961 · Farwell Joseph W N816GBeech D95A · S/N TD-562Built 1964 · Holland Travel Air LLC N8206XFred R Bauer JR ROTORWAY EXEC 162F · S/N 6985Built 2017 · Jet-Copter LLC N9692EAeronca 11AC · S/N 11AC-1323Built 1946 · Seever James J

Back to Holmen, WI