Oconomowoc, WI
Registered aircraft · 59
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 = 'OCONOMOWOC' 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 = 'OCONOMOWOC' 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.
N1154ATiffany John R HANNAFORD D-1 · S/N 001N11LHHarmening CASSUTT SPECIAL · S/N 111N140DLEvans Walter B PIETENPOL AIR CAMPER · S/N 737678N1661GChampion 7ECA · S/N 636N191Ryan NAVION A · S/N NAV-4-2033N2065GCessna 182A · S/N 51365N255GPiper PA-32RT-300T · S/N 32R-7887180N2662RHorrex John DENTECH 1 · S/N 1985IN27343Aeronca 65-TL · S/N L1550TN29498Aeronca 65-LB · S/N L10390N301MASocata TBM 700 · S/N 1169N310AFCessna 310Q · S/N 310Q1121N310JMRobinson Helicopter R66 · S/N 0779N339NAAero Vodochody L39C · S/N 332514N3461KPiper J3C-65 · S/N 22150N34CXBeech T-34A · S/N CG-223N377KGGardetto Paul R RV-7A · S/N 73266N38109Piper J3L-65 · S/N 6806N3993JCessna 150G · S/N 15065293N4072BRandy J Bornhorst VANS RV-14A · S/N 140532N4233CRundell Lanny GLASAIR III · S/N 3161N433RDCanadair CT-133 · S/N 21579N448ESCessna 182S · S/N 18280203N44GACessna 414A · S/N 414A0036N44WXCirrus Design SR22 · S/N 1258N4540APiper PA-22-150 · S/N 22-3849N4592EAeronca 7AC · S/N 7DC155N4638XCessna 150G · S/N 15064688N4978BCessna 152 · S/N 15283736N49WGHughes 269A · S/N 760616N504BVYakovlev YAK-50 · S/N 832510N50CJCanadair F-86E MK.6 · S/N 381N5166Smith Miniplane DSA-1 · S/N JB-1N5296VNorth American AT-6G · S/N 49-3057N52QTCessna 414 · S/N 414-0480N5401WPiper PA-28-160 · S/N 28-469N541MAExtra Flugzeugproduktions UND EXTRA NG · S/N NG085N5549WPiper PA-28-160 · S/N 28-640N5628JCessna 182P · S/N 18263476N5678UPiper PA-28-140 · S/N 28-26475N600MFNorth American SNJ-5 · S/N 88-16305N61807Taylorcraft DCO-65 · S/N 5760N626DBCessna T206H · S/N T20608503N6706SCessna 150H · S/N 15067506N696Morris John STAAKEN FLUGZEUGBAU · S/N D696N708GRDJI AGRAS T50 · S/N 1581F6BUB249200197K3N71150Aerostar International RX-7 · S/N RX7-3309N7121NBeech V35A · S/N D-8674N712HFCompagnie Daher TBM 700 · S/N 1481N739KFCessna 172N · S/N 17270598
Back to Oconomowoc, WI