Registered aircraft · 16

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

N255ARHylio AG-122 · S/N 010240Rock River Seed & Chemical LLC N272LAAir Tractor AT-502B · S/N 502B-3145Built 2018 · B & D Aircraft Leasing LLC N292FAHylio AG-122 · S/N 010220Rock River Seed & Chemical LLC N3158XRobinson Helicopter R44 II · S/N 11487Built 2006 · Jims Helicopter LLC N3301MBuckeye DREAM MACHINE · S/N 6073Built 2001 · Schmidt Jeffrey E N44284Taylorcraft BC12-D1 · S/N 10084Built 1946 · Welch Perry M N5104HHylio HYL-150 · S/N 17906110511Registration pending N60362Air Tractor AT-502B · S/N 502B-0326Built 1995 · 502 Leasing LLC N735WRCessna 182Q · S/N 18265747Huizenga Bruce A N802GAir Tractor AT-802A · S/N 802A-0699Built 2017 · B&D Aircraft Leasing LLC N8074LEarth Star ODYSSEY · S/N 100339Built 2002 · Leyh Joel P N8165DPiper PA-18-150 · S/N 18-6146Built 1957 · Reabe Robert E N8183DPiper PA-18-150 · S/N 18-6118Built 1957 · Reabe Robert E N85JTLarry D Odell/David F Fortuna RANS S-19 VENTERRA · S/N 061100103Built 2019 · Derksen Ross J N8734LPiper PA-25-260 · S/N 25-5197Built 1970 · Dairyland Aviation Inc N904RRHylio AG-122 · S/N 010219Rock River Seed & Chemical LLC

Back to Waupun, WI