Registered aircraft · 22

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

N11787Monocoupe 90A · S/N A-712Sale reportedBuilt 1935 N1299ZBeech B95A · S/N TD-467Wojdac David E N1347DHarvey J Draheim BACKC SUPER CRUISER · S/N BC31407008Built 2026 · Draheim Jason D N1682JPiper PA-28-140 · S/N 28-24083Built 1967 · Beatty Gary A N182ZMCessna 182M · S/N 18260033Built 1969 · Unerti Michael J N201LJMooney M20J · S/N 24-0224Built 1977 · Houting Thomas Vernon N204VWGrassl Joseph R JUST ARCRFT ESCAPADE · S/N 20Built 2010 · Grassl Joseph R N247LTGulfstream Aerospace GVII-G600 · S/N 73191Built 2025 · Productivity Advantage Inc N327MYankaitis Michael J RANS S-21 OUTBOUND · S/N 09190062Built 2022 · Yankaitis Michael J N34PHEnsley-Pietenpol AIR CAMPER · S/N E1Built 1971 · Ulrich Kenneth B N365LTDassault FALCON 2000EX · S/N 405Built 2023 · Productivity Advantage Inc N379PZTalos Drones T60X · S/N 2104F7EZW25990018K85Mm Ag Drone Services LLC N379RZDJI AGRAS T30 · S/N 1581F446LK3E303012KOMm Ag Drone Services LLC N4085RPiper PA-32-300 · S/N 32-40402Wojdac David E N415YMickey Whittenburg WHITCRAFT · S/N 006Built 2013 · Ulrich Kenneth B N611PMBrannon F Paul JR LANCAIR ES · S/N ES-117Built 2005 · Yankaitis Michael J N654CFFallos Charles L RANS S-7S · S/N 0803348Fallos Charles L N88456Piper J3C-65 · S/N 16079Built 1946 · Mcmahan C Merrill N9263EAeronca 11AC · S/N 11AC-898Wojdac David E N929TMCirrus Design SR20 · S/N 1568Built 2005 · Mathson Timothy R Trustee N95889Taylorcraft BC12-D · S/N 8189Built 1946 · Coleman James L N984APiper PA-22 · S/N 22-296Built 1951 · Ulrich Kenneth B

Back to Mosinee, WI