Registered aircraft · 23

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

N103DDXag P100 PRO 2023 · S/N 8219418T96Y6Gaylord Micah C N1525NPiper J3C-65 · S/N 23057Built 1947 · 88 Charlies Inc N185ABeech 58 · S/N TH-332Built 1973 · Rortvedt Robert S N1879BPoint Jeffrey M RLU 1 · S/N 3Built 2017 · Point Jeffrey M N187CFPoint Jeffrey M VANS RV-6 · S/N 25728Built 2004 · Point Jeffrey M N2137MPiper J3C-65 · S/N 20923Built 1946 · Zewiske Joseph P N30302Cessna 177A · S/N 17701180Built 1968 · Kamenar Service LLC N3276DCessna 180 · S/N 32074Built 1955 · Farkas Jonathan N3738MPiper PA-32RT-300 · S/N 32R-7885013Ansell Nathan D N4221LCessna 172G · S/N 17254290Built 1966 · Schram Ted K N44188Wangerin Arnold FALCON XP · S/N 600108Schneider Daryl Lee N4669BCessna 180 · S/N 31567Built 1955 · Dunbar Timothy C N602SPCessna P337H · S/N P3370324Built 1978 · Putlitz Richard A N6068ACessna 172 · S/N 28668Built 1956 · Willerscheidt Thomas H N6127TCessna 150E · S/N 15060827Van Hammers Gary C N6441JPiper PA-28-180 · S/N 28-4859Built 1968 · Ansell Nathan D N6459PPiper PA-24-250 · S/N 241574Jaeger Timothy S N66DADesotel W L/Allen D F CP-311 · S/N 1A1Built 1988 · Rosman Michael J N7XJAviat A-1 · S/N 1387Built 1997 · Average Joe Flying Services LLC N851Piper J3C-65 · S/N 9851Zewiske Joseph P N88249Piper J3C-65 · S/N 15864Built 1946 · Rosman Michael J N8893HNorth American NAVION · S/N NAV-4-893Built 1947 · Mac-Mor Ltd N896JPPowrachute PEGASUS · S/N A287PEGVan Hammers Gary C

Back to Mukwonago, WI