OpenAirDocs.org
Medford, WI

Registered aircraft · 28

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

N1228BLuscombe 8A · S/N 5855Built 1947 · Erl Don LN1555BSilvaire LUSCOMBE 8E · S/N 6182Built 1948 · Lee Robert EN2026BLuscombe 8A · S/N 6453Built 1948 · Lee Robert EN2426XCessna 182H · S/N 18256326Built 1965 · Colwell Patrick R JrN250DRDJI AGRAS T50 · S/N 1581F6BUB246L00172VHDr Drone LLCN256DRDJI AGRAS T40 · S/N 1581F574B2385001008EDr Drone LLCN2993KLuscombe 8E · S/N 5720Built 1947 · Lee Robert EN31126Piper J3C-85 · S/N 5346Built 1940 · Krug Gene GN34BHHall William A SLING 2 · S/N 291KBuilt 2019 · Hall William AN3789KUniversal GLOBE GC-1B · S/N 1482Lee Robert EN38686Piper J3L-65 · S/N 7194Jones Gordon BN3869RCessna 172H · S/N 17255369Built 1966 · Erl Don LN4349BCessna 170B · S/N 26693Built 1955 · Lee Robert EN438JEEngle John E SR RANS S-6S · S/N 11041621Built 2007 · Machon BrettN448PSTalos Drones T60X · S/N 2104F7EZW255P0015N2ABam Agricultural Spraying And Services LLCN45628Luscombe 8A · S/N 2155Erl Don LN50484Cessna 172M · S/N 17264205Built 1974 · Freudenthal Jack JN5282TPiper PA-28R-200 · S/N 28R-7235215Built 1972 · Mehlberg Jerry LN6104FMader Allen J CHALLENGER II · S/N 1933Built 2000 · Mader Allen JosephN6376ECessna 172 · S/N 46476Built 1959 · Zawacki William MN6516SCessna 150H · S/N 15067316Lee Robert EN65RKGKW Club HATZ CB-1 · S/N 75Built 1989 · Lee Robert EN71275Luscombe 8A · S/N 2702Built 1946 · Lee Robert EN7552EChampion 7FC · S/N 7FC-253Built 1958 · Bouchard Scott AN8292TPiper PA-32R-301T · S/N 32R-8329001Built 1982 · James Peterson Sons IncN843MWDJI AGRAS T50 · S/N 63YBM6J002006BSale reportedN85774Aeronca 7AC · S/N 7AC-4523Built 1963 · Peterson Jeffery JohnN9023TCessna 182C · S/N 52923Built 1960 · Bauer John P
Back to Medford, WI