OpenAirDocs.org
New Richmond, WI

Registered aircraft · 61

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 = 'NEW RICHMOND'
  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.

N10604Cessna 150L · S/N 15074922Built 1973 · Bittner Vernon JN122AMCessna 310Q · S/N 310Q0943Built 1973 · Harper DavidN143AHPeter R Hall CCK-2000 · S/N CCK-2000-0026Built 2025 · Hall Peter RN18GPPiper PA-18-150 · S/N 18-7542Built 1961 · Dreger Douglas J TrusteeN20246Cessna 172M · S/N 17261127Built 1972 · Olek BradN2039XMooney M20M · S/N 27-0224Built 1996 · Meister James EmmettN21055Cessna 182P · S/N 18261385Built 1972 · Harty Timothy LN212HFCessna 560XL · S/N 560-6190Built 2015 · Gopher Air LLCN2220APiper PA-22-135 · S/N 22-638Built 1952 · Nelson David R TrusteeN2268YPiper PA-30 · S/N 30-544Built 1964 · Mohr Marcia L DBAN2354APiper PA-22-135 · S/N 22-724Nelson David RN2411Beech F35 · S/N D-4282Built 1955 · Custom Flight RnhN2429XCessna 182H · S/N 18256329Built 1965 · Montpetit Steven WN2562CAeronca 7CCM · S/N 7CCM-75Derrick Jeffery RN2708YCessna 335 · S/N 335-0035Built 1979 · Wings Aircraft LLCN2880ECessna 172N · S/N 17271358Built 1978 · Demulling Michael CN315KAHawker Beechcraft B300 · S/N FL-823Built 2012 · Gopher Air LLCN3521CBuccaneer BUCCANEER SX · S/N 258DEBuilt 2000 · Mohr John RN373PSCirrus Design SR22 · S/N 0173Built 2002 · Engineered Propulsion Systems IncN3746LCessna 172G · S/N 17253915Built 1965 · Bygd Sherman ON3941RCessna 172H · S/N 17255441Built 1966 · Demulling Michael CN40022Piaggio P.136-L1 · S/N 200Built 1956 · AerolynN4124FCessna 172 · S/N 46024Built 1958 · Nelson David R Co-TrusteeN426DSSpangler David G SPANGLER MINICOUPE · S/N 001Spangler David GN426MBCessna A185F · S/N 18504420Built 1984 · Timothy HartyN456PWLackey Stephen LANCAIR 4P · S/N 1IV-446Built 2003 · Milnar GregN4919BBeech F35 · S/N D-4257Kirvida James MitchellN49739Boeing A75N1(PT17) · S/N 75-4462Built 1943 · Mohr John RN5027ECessna 180A · S/N 50327Built 1958 · Meister James EN5710ZPiper PA-22-108 · S/N 22-9549Built 1962 · Spangler David GN600JPMccormick James JABIRU J-250 · S/N 045Built 2004 · Graf David RN601WMMetzger William M ZODIAC 601XLB · S/N 6-5531Perkins Robert AN61409Fischer Roger AVID AMPHIBIAN RF-01 · S/N 108AMcmillan James AN63394Champion 7EC · S/N 694Perkins Robert AN6562HPiper J3C-65 · S/N 19754Built 1946 · Meister James AN67458Howard DGA-15P · S/N 1774Built 1920 · Walker Dale PN6943ECessna 175A · S/N 56443Built 1959 · Lasky Robert CN70472Piper J3C-65 · S/N 17471Built 1946 · Mohr John RN7254YPiper PA-30 · S/N 30-280Built 1964 · Spldkd LLCN726SMMcintosh Verlin MCINTOSH CRSTN EAGLE · S/N 00Built 2001 · Tallarita Peter DN7331LPiper PA-31P · S/N 31P-7400210Built 1974 · Stibolt Paul EN750BACessna 560XL · S/N 560-5002Built 1998 · Bklavi LLCN752MFCessna 150M · S/N 15075977Built 1974 · Epperly David JN7693UCessna 150M · S/N 15077819Perkins Robert AN77FPPiper PA-60-602P · S/N 60-8265047Registration pendingN7878MPiper PA-12 · S/N 12-3144Wings Aircraft LLCN8112XCessna 172B · S/N 17248612Built 1961 · Peterson Michael DN83877Aeronca 7AC · S/N 7AC-2557Built 1946 · Walker Dale PN8483BSwenson Alan P SWENSON · S/N APS-1Banitz Lucian VN85647Aeronca 7AC · S/N 7AC-4391Perkins Robert A
Back to New Richmond, WI