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

N22707Piper J3L-65 · S/N 2680Built 1938 · Seppala Matthew T N2309APiper PA-22-135 · S/N 22-698Plitt Benjamin T N2518WHarmening HIGHFLYER · S/N HHF 5848Built 1997 · Heidger Roy E N329PWHarvey Robert C VANS RV-10 · S/N 40729Built 2010 · Harvey Robert C N3736APiper PA-22-135 · S/N 22-1979First renewal noticePlitt Benjamin T N403SSSausen Michael C RV-10 · S/N 40352Built 2026 · Sausen Michael C N40835Piper J3C-65 · S/N 7538Built 1941 · Hauk Loren H N43GDDeem Gary B DEEM STARLET · S/N 003Novak David J N4684HPiper PA-15 · S/N 15-377Built 1948 · Harvey Robert C N4FWWallamn Sport Plane WSP-1 · S/N 1Built 1975 · Douma Todd D N7499XCessna 172B · S/N 17247999Built 1960 · Vintage Aircraft Ltd N797TKRandel Tom L VANS ACFT RV-7 · S/N 73599Built 2020 · Randel Tom L N88NXRoberts John T SKYOTE · S/N 088Built 2015 · Novak David J N9297SHarker Edward W SKYOTE · S/N 037Built 1996 · Novak David J N9713ACessna 170A · S/N 19403Built 1950 · Rueckl Randall L N9753WPiper PA-28-140 · S/N 28-23236Seppala Matthew T N97800Stinson 108-1 · S/N 108-800Harvey Robert C

Back to Hortonville, WI