OpenAirDocs.org
New Berlin, WI

Registered aircraft · 25

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

Query with SQL
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 = 'NEW BERLIN'
  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.

N104RTBell 206L-3 · S/N 51364Built 1990 · Back Nine Aerial LLCN1347HPiper PA-28R-201T · S/N 28R-7703023Kapp Dean RN20316Bell Helicopter Textron 206L-1 · S/N 45687Built 1981 · Back Nine Aerial LLCN2809UCessna 172D · S/N 17250409Built 1963 · Bleskan Erick JN38885Bell Helicopter Textron 206L-1 · S/N 45726Built 1981 · Back Nine Aerial LLCN4332HPiper PA-15 · S/N 15-122Built 1948 · Mcchesney Corey DN44ULDavid Schardt MERLIN · S/N 308-MERL-34-251Schardt David MN4681HPiper PA-17 · S/N 17-80Built 1948 · Bohrman Robert CN4801HPiper PA-17 · S/N 17-99Built 1948 · Mcchesney CoreyN5695NAlliant DESTINY XLT · S/N 4C0604Krush Paul RN6085MCessna 152 · S/N 15284616Built 1980 · Wood Mark D TrusteeN6232JGriswold Dennis PROTECH PT2 · S/N PT1109Steinhiser Scott CN6802ECessna 175A · S/N 56302Built 1959 · Mcchesney Corey ON7121DPiper PA-22-150 · S/N 22-4981Built 1957 · Bohrman Robert CN7150SCessna R182 · S/N R18201699Built 1981 · Gabrial Aviation LLCN735RTCessna 182Q · S/N 18265631Built 1977 · N735rt LLCN7450KPiper PA-20 · S/N 20-361Built 1950 · Matelski Mark TN7578RPiper PA-28-140 · S/N 28-22145Built 1966 · Steinhiser Scott CN77EYCirrus Design SR22T · S/N 1923Built 2019 · Mile 6 Aeronautics LLCN8046HSlipstream International REVELATION · S/N 98 002Lablanc Jerome JN8750WPiper PA-28-235 · S/N 28-10290Built 1964 · Finn KalynN88PWWormley Peter T FALCON XP · S/N 600231Wormley Peter TN89DNNorth American P-51K · S/N 44-12481Nelson Brian RN9130HCessna 182R · S/N 18267925Built 1981 · Stockhausen Andrew J JrN95CFBeech F33A · S/N CE-1291Built 1988 · Ues Bluesky Aviation LLC
Back to New Berlin, WI