OpenAirDocs.org
Ripon, WI

Registered aircraft · 31

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

N10XSPiper J3C-65 · S/N 22366Built 1946 · Wittman Flying ServiceN131HBellanca 14-19-2 · S/N 4041Built 1957 · Prentice Robert DN2083HErcoupe 415-C · S/N 2706Built 1946 · Hatcher Joe WN3024PPiper PA-23 · S/N 23-935Built 1957 · Prentice Robert DN3049GAircoupe F-1A · S/N 5749Built 1961 · Prentice Robert DN333GRRowe Jay F VANS RV-10 · S/N 40301Built 2009 · Schulz JonathanN3439MPiper PA-12 · S/N 12-2279Built 1947 · Retzlaff ChrisN40609Piper J3C-65 · S/N 7362Built 1941 · Prentice Robert DN4384HPiper PA-15 · S/N 15-169Built 1948 · Miller Rodney MN5346MCessna 680 · S/N 680-0292Built 2010 · Alliance Laundry Systems LLCN539DBResen David E ESQUAL VM-1 · S/N 61Built 2005 · Resen David EN56387Piper PA-28-180 · S/N 287305584Built 1973 · Prentice Robert DN623KCzech Sport Aircraft A S SPORTCRUISER · S/N C0564Built 2016 · Fly Now LLCN650MSchroeder Mark RV-6 · S/N 20964Par 21 LLCN75329Bellanca 14-13-2 · S/N 1371Built 1947 · Prentice Robert DN755DMSocata TBM 700 · S/N 101Built 1994 · Mdst Aircraft Leasing LLCN7641EDowner BELLANCA 14-19-3 · S/N 4143Built 1959 · Prentice Robert DN76FWWalker PIEL EMERAUDE CP305 · S/N 1398Schram CoreyN780FAAir Tractor AT-802A · S/N 802A-0807Built 2019 · Md Aircraft Leasing LLCN8229LCessna 172H · S/N 17256429Built 1967 · Wuest Steven DN83031Aeronca 7AC · S/N 7AC-1687Built 1946 · Par 21 LLCN8534RBellanca 14-19-3 · S/N 4296Built 1966 · A F K CorpN8599SCessna 182J · S/N 18256699Built 1966 · Mcclung Malcolm JN8657DPiper PA-22-160 · S/N 22-5865Built 1958 · Parks John TN8670CPiper PA-18-150 · S/N 18-2814Built 1953 · Reabe Damon PN87896Piper J3C-65 · S/N 15514Built 1946 · Reabe Damon PN93939Engineering & Research ERCOUPE 415-C · S/N 1262Built 1946 · Prentice Robert DN974FNWillett John N QUICKSILVER MXLII · S/N M6352830Willett John NN9812SRockwell International 695 · S/N 95060Afk Leasing Services LLCN991BDAero Commander 680FL P · S/N 1483-8Afk CorpN99216Ercoupe 415-C · S/N 1839Built 1946 · Prentice Robert D
Back to Ripon, WI