Milwaukee, WI

Registered aircraft · 151

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

N363JVCessna A185F · S/N 18502991Built 1976 · Read Andrew RN366MQShort Bros SHORTS SD3-60 · S/N SH 3639Acc Integrated Services IncN367ACShort Bros SD3-60 · S/N SH3626Built 1983 · Acc Integrated Services IncN367MQShort Bros SD3-60 · S/N SH 3640Built 1982 · Acc Integrated Services IncN368ACShort Bros. & Harland SD-3-60-200 · S/N SH3651Built 1984 · Acc Integrated Services IncN3732XShort Bros SD3-60 VARIANT 200 · S/N 3732Built 1987 · Acc Integrated Services IncN376ACShort Bros SD3-60 VARIANT 200 · S/N SH-3736Built 1988 · Acc Integrated Services IncN377MQShort Bros SD3-60 · S/N SH3699Built 1986 · Acc Integrated Services IncN3784BBeech C-50 · S/N CH-200Built 1955 · Ogorek Peter JN378MQShort Bros SD3-60 · S/N SH3700Built 1986 · Air Cargo Carriers LLCN381MQShort Bros SD3-60 · S/N SH3703Acc Integrated Services IncN382MQShort Bros SD3-60 · S/N SH3704Acc Integrated Services IncN383MQShort Bros SD3-60 · S/N SH3706Acc Integrated Services IncN385MQShort Bros SD3-60 · S/N SH3707Acc Integrated Services IncN390WPiper PA-39 · S/N 39-39Built 1970 · Walter Paul FN391BTAviat A-1C-200 · S/N 3405Built 2023 · Husky Tailwinds LLCN393ACShort Bros C23A SHERPA · S/N SH-3111Acc Intergrated Services IncN399CZBeech 99 · S/N U-91Built 1969 · N399cz LLCN3XKKeller Frederick H DEFIANT (KELLER) · S/N 002Built 1983 · Driscoll David Delory JrN402SUmbaugh James F STARDUSTER TOO · S/N 1980 JFUBejvan David EN409SDMasters Gregory L QUICKSILVER GT 500 · S/N 0057Built 1992 · Jones Scott DN4214EAeronca 11CC · S/N 11CC-106Andrew Louis J JrN4257DBeech G35 · S/N D-4485Peterson Duane TN4264KRyan NAVION · S/N NAV-4-1264Built 1948 · Bejvan David EN426SJCirrus Design SF50 · S/N 0148Built 2019 · Mag Aviation LLCN427PEShort Bros SD3-60 · S/N SH3692Built 1984 · Acc Integrated Services IncN4304APiper PA-22-150 · S/N 22-3655Built 1956 · Guslick Michael MN4308JPiper PA-28-140 · S/N 28-22680Built 1967 · Buresh George WN442FMCessna 414A · S/N 414A0303Built 1979 · Hogan Quinn H TrusteeN4498YShort Bros SHORTS SD3-60 · S/N SH3625Built 1983 · Acc Integrated Services IncN45EZThorsen George E LONG EZ · S/N 1235Built 2001 · Thorsen Matthew GN4660DBeech H35 · S/N D-4885Sale reportedBuilt 1956N476RWShort Bros SHORTS SD3-60 · S/N SH3610Built 1983 · Acc Integrated ServicesN4784VBoeing A75L3 · S/N 755434Built 1944 · Flying Acres Flyboys LLCN484CJTextron 525B · S/N 525B-0484Built 2016 · Atstm LLCN4854GCessna 172N · S/N 17273401Built 1979 · Milwaukee Aero LLCN499CZBeech 99A · S/N U-81Built 1969 · N499cz LLCN49SVAviat A-1C-200 · S/N 3423Built 2023 · Walnut Grove Aero LLCN5009ACessna 172 · S/N 28009Built 1955 · Ogorek Peter JN518EEQuicksilver MXL-II-VANT · S/N 001Built 1990 · Cassavant Corey SN526HBeech 35-B33 · S/N CD-636Built 1963 · Hausch LLCN52938Mooney M20K · S/N 25-1197Built 1988 · Fermata Aero IncN536FRSaab SAAB 2000 · S/N 2000-036Freight Runners Express IncN5432ECessna 172N · S/N 17271860Built 1978 · Milwaukee Aero LLCN564ACShort Bros SD3-60 VARIANT 200 · S/N SH3620Built 1983 · Acc Integrated Services IncN564SWEmbraer EMB-120 · S/N 120339Built 1998 · Freight Runners Express IncN567ACShort Bros SHORTS SD3-60 · S/N SH3622Built 1983 · Acc Integrated Services IncN5685LAmerican AA-1 · S/N AA1-0085Built 1969 · Fritz Frank MN57ABBombardier CL-600-2B16(CL-604) · S/N 5981Built 2014 · Rockwell Automation IncN5809QMooney M20E · S/N 770Spicer Larry E
Back to Milwaukee, WI