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.
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
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.
N363JVCessna A185F · S/N 18502991N366MQShort Bros SHORTS SD3-60 · S/N SH 3639N367ACShort Bros SD3-60 · S/N SH3626N367MQShort Bros SD3-60 · S/N SH 3640N368ACShort Bros. & Harland SD-3-60-200 · S/N SH3651N3732XShort Bros SD3-60 VARIANT 200 · S/N 3732N376ACShort Bros SD3-60 VARIANT 200 · S/N SH-3736N377MQShort Bros SD3-60 · S/N SH3699N3784BBeech C-50 · S/N CH-200N378MQShort Bros SD3-60 · S/N SH3700N381MQShort Bros SD3-60 · S/N SH3703N382MQShort Bros SD3-60 · S/N SH3704N383MQShort Bros SD3-60 · S/N SH3706N385MQShort Bros SD3-60 · S/N SH3707N390WPiper PA-39 · S/N 39-39N391BTAviat A-1C-200 · S/N 3405N393ACShort Bros C23A SHERPA · S/N SH-3111N399CZBeech 99 · S/N U-91N3XKKeller Frederick H DEFIANT (KELLER) · S/N 002N402SUmbaugh James F STARDUSTER TOO · S/N 1980 JFUN409SDMasters Gregory L QUICKSILVER GT 500 · S/N 0057N4214EAeronca 11CC · S/N 11CC-106N4257DBeech G35 · S/N D-4485N4264KRyan NAVION · S/N NAV-4-1264N426SJCirrus Design SF50 · S/N 0148N427PEShort Bros SD3-60 · S/N SH3692N4304APiper PA-22-150 · S/N 22-3655N4308JPiper PA-28-140 · S/N 28-22680N442FMCessna 414A · S/N 414A0303N4498YShort Bros SHORTS SD3-60 · S/N SH3625N45EZThorsen George E LONG EZ · S/N 1235N4660DBeech H35 · S/N D-4885Sale reportedN476RWShort Bros SHORTS SD3-60 · S/N SH3610N4784VBoeing A75L3 · S/N 755434N484CJTextron 525B · S/N 525B-0484N4854GCessna 172N · S/N 17273401N499CZBeech 99A · S/N U-81N49SVAviat A-1C-200 · S/N 3423N5009ACessna 172 · S/N 28009N518EEQuicksilver MXL-II-VANT · S/N 001N526HBeech 35-B33 · S/N CD-636N52938Mooney M20K · S/N 25-1197N536FRSaab SAAB 2000 · S/N 2000-036N5432ECessna 172N · S/N 17271860N564ACShort Bros SD3-60 VARIANT 200 · S/N SH3620N564SWEmbraer EMB-120 · S/N 120339N567ACShort Bros SHORTS SD3-60 · S/N SH3622N5685LAmerican AA-1 · S/N AA1-0085N57ABBombardier CL-600-2B16(CL-604) · S/N 5981N5809QMooney M20E · S/N 770
Back to Milwaukee, WI