OpenAirDocs.org
Hartford, WI

Registered aircraft · 40

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

N101XMCirrus Design SR22 · S/N 1226Built 2004 · Maier GerardN1232VEpic E1000 · S/N K082Built 2025 · Lee John DN1454WWeber Wayne H J 3 · S/N 343Built 1990 · Weber Jacob HN172SACessna 172K · S/N 17258302Built 1969 · Halbauer PeterN19520Cessna 150L · S/N 15074465Ag Avventures LLCN2499QPiper PA-28-140 · S/N 28-7725197Built 1977 · Land Phillip RN280CFSiai-Marchetti S 211 · S/N 030/02-028Built 1985 · 280 LLCN2890NCessna 120 · S/N 13151Built 1947 · Druskins Christina MN2903MPiper PA-12 · S/N 12-1327Built 1946 · Krog Steven LN31178Piper J-3 · S/N 5388Built 1940 · Budinich Jason HN33731Aeronca 65-CA · S/N CA13251Built 1941 · Bieser John PN3386MPiper PA-12 · S/N 12-2057Coffey Daniel JN37979Brown PIETENPOL AIRCAMPER · S/N 61921Built 1982 · Brown Thomas LN3935KPiper PA-28-140 · S/N 28-23809Built 1967 · Krog Steven LN397THHegy Thomas R H-4000 · S/N 1318Built 1995 · Hegy Thomas RN40089Spirit Engineering SE-1 · S/N 009Built 2025 · Brown ThomasN41167Piper J3C-65 · S/N 7789Built 1941 · Krog Steven LN41967Piper PA-28-151 · S/N 28-7415370Built 1974 · Krog Steven LN42522Piper J3C-65 · S/N 14795Krog Sharon AN428RJames W Miles PITTS S-1C · S/N 244-HBuilt 1971 · Hegy Thomas RN4392WRobinson Helicopter R44 II · S/N 12857Built 2010 · Lee John DN4439URobinson Helicopter R44 II · S/N 12890Built 2009 · Lee Robert AN45680Luscombe 8A · S/N 2207Built 1946 · Brown Thomas LN466JSPowrachute PEGASUS · S/N A409PEGBuilt 2005 · Ohearn Paul WN505LTCessna 421C · S/N 421C0617Built 1978 · Laufer Air IncN52KPHanna L K/Mick R S MICK HANNA · S/N 1994Built 1995 · Krog Steven LN62SBPiper PA-28-236 · S/N 28-8111071Built 1981 · Lee Robert AN6432PPiper PA-24-250 · S/N 24-1542Built 1959 · Alvarez FrankN6488GCessna 150K · S/N 15071988Built 1970 · Krog Steven LN6731HPiper J3C-65 · S/N 19942Built 1946 · Krog Steven LN70186Piper J3C-65 · S/N 17171Built 1946 · Krog Steven LN7341MCessna 175 · S/N 55641Built 1958 · Sobczyk Scott RN776VBCessna 172S · S/N 172S8508Built 2000 · 40ac LLCN78581Piper PA-12 · S/N 12-3967Weber Jacob HN8071UTaylor Merwyn ROSE PARAKEET · S/N T106Built 1995 · Brown Thomas LN82395Aeronca 7AC · S/N 7AC-1028Built 1946 · Alvarez FrankN87953Piper J3C-65 · S/N 15571Built 1946 · Coffey Daniel JN9040BChampion 7FC · S/N 7FC-129Krog Steven LN937RMLuscombe 8F · S/N 6056Built 1948 · Coffey Daniel JN9721YPiper-Harris J3C-65 · S/N 2451Krog Steven L
Back to Hartford, WI