OpenAirDocs.org
Hartland, WI

Registered aircraft · 39

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

N100XZCirrus Design SR20 · S/N 10040Built 2024 · Jjk Aviation LLCN112WTLarson Greg LARSON 11 · S/N 001Larson Greg AN114WTLarson Greg A KITFOX CLASSIC IV · S/N C9812 0227Built 2011 · Larson Greg AN116WTLarson Greg A LARSON 12 · S/N 001Larson Greg AN1198MCessna 172K · S/N 17258698Built 1969 · Goeke Christine A TrusteeN16387Piper PA-28-235 · S/N 28-7310093Built 1973 · Anderson Jeffrey JN2008NNational Ballooning 858 · S/N 138Built 2001 · Nollen Ronald CjrN21516Cessna 182P · S/N 18261683Built 1973 · Reinders Craig TN2231HEngineering & Research 415-D · S/N 2854Horn Patricia AN28717Schweizer SGS 2-8 · S/N 38Van Roo Jon DN310BNCessna 680 · S/N 6800516Built 2013 · Bcwings LLCN361WMMensink William VANS RV-8 · S/N 81402Built 2005 · Groth William PN3794NMooney M20F · S/N 680120Lc Aviation LLCN3973TPiper PA-28R-180 · S/N 28R-30322Built 1967 · Meissner Edward TN4555CCessna 170B · S/N 25499Built 1953 · Van Roo Jon DN47217Canadian Car & Foundry HARVARD MK IV · S/N CCF4-8Stottlemyer Victor RN48BKKrebs Brian G RV 8 · S/N 82136Built 2012 · Krebs Brian GN514PGCirrus Design SR20 · S/N 1981Built 2008 · Heinzelman BrianN516CRCirrus Design SR22 · S/N 1309Built 2005 · 516 Ontario Capital Holdings LLCN5272APiper PA-23-160 · S/N 23-2019Built 1961 · Welch Kevin RN5342DCessna 172N · S/N 17272531Cornell Timothy RN5622Cessna 150G · S/N 15065525Built 1966 · Nichols Stephen SN574RKCirrus Design SR22 · S/N 4423Built 2016 · Horn Aviation LLCN626BSHawker Beechcraft HAWKER 750 · S/N HB-2Built 2007 · Cpav LLCN629RMPiper PA-31-350 · S/N 31-8052197Built 1980 · W J Halberstadt Transportation IncN650PTCessna 650 · S/N 650-0169Built 1989 · Burkim LLCN701VBSpanaus Patrick J ZENITH 701 · S/N 7-5647Built 2008 · Spanaus Patrick JN77132Cessna 120 · S/N 11590Stamsta Marc JN774PDCessna 177A · S/N 17701281Built 1968 · Tump ChristopherN7798NCessna TU206G · S/N U20603718Built 1977 · Gebhard John MN78194Globe GC-1B · S/N 2194Built 1946 · Kolstad AnnaN7891XFerri Randy P ONEX · S/N ONX0161Ferri Randy PN8208GCessna 177RG · S/N 177RG0108Built 1971 · Aerialscapes IncN861TZCirrus Design SR22 · S/N 0877Built 2004 · Oneill Aviation LLCN894WPDehavilland DHC-1 CHIPMUNK · S/N C1-0679/663Stottlemyer Victor RN89523Cessna 140 · S/N 8559Built 1946 · Gramann Steven GN928JRLindstrand Balloons 56X · S/N 5343Built 2006 · Nollen Ronald CN960MWCompagnie Daher TBM 700 · S/N 1473Built 2023 · Fleet Aircraft Holding LLCN980CKDaher TBM 700 · S/N 1644As Aviation LLC
Back to Hartland, WI