OpenAirDocs.org
Franklin, WI

Registered aircraft · 34

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

N1187VStinson VULTEE V-77 · S/N 77-142Built 1943 · Gores Thomas JN119LSCessna 182T · S/N 18281119Built 2002 · Marsair LLCN124EECessna 172N · S/N 172-68996Wisconsin Fox River Flyers IncN1254HPiper PA-28R-201T · S/N 28R-7703018Built 1976 · Sherer ScottN142SVMoravan N P Ortrokovice Z142 · S/N 0388Built 1983 · Esterle Miroslav MN195JCessna 195B · S/N 16123Built 1954 · Gores Thomas JN21060Aeronca K · S/N K-335Built 1938 · Gores Thomas JN2156XColeman Terry L SKY RANGER · S/N SKR05.01556Built 2005 · Freidmark Donald TN2247DPiper PA-28-181 · S/N 28-7990168Sky Venture IncN22777Dehavilland DHC-1 · S/N C1-0105Built 1950 · Whyte EricN22TKPiper PA-24-250 · S/N 24-3541Built 1963 · Green Theodore GN2368MPiper PA-12 · S/N 12-1500Built 1946 · Oconnor Sarah AN313LAAeronca 65-LB · S/N LB-10520Gores Thomas JN31807Aeronca 65-CA · S/N C11220Gores Thomas JN31895Aeronca 65-CA · S/N C11671Built 1941 · Gores Thomas JN31954Aeronca 65-CA · S/N CA12321Built 1940 · Gores Thomas JN33858Aeronca 65-CA · S/N CA14001Gores Thomas JN34379Meyers MAC-145 · S/N 222Built 1956 · Gores ThomasN3812ASchweizer SGS 1-26B · S/N 83Built 1958 · Oconnor Sarah AN3958QCessna 172L · S/N 17260058Built 1971 · Fisher Gregory SN4624VCessna 172RG · S/N 172RG0342Fisher Gregory SN569LCAerovodochody L-29 DELFIN · S/N 093816Esterle Miroslav MN6323ECessna 172 · S/N 46423Built 1959 · Swedish Flying Couching LLCN6721ACessna 172 · S/N 28821Rogers Jeffery DN71126Cessna 182M · S/N 18259505Built 1968 · Overturf AndrewN7195Bensen B-8M · S/N D7471215Built 1971 · Doers Douglas AN80600Globe GC-1B · S/N 1005Built 1946 · Gores Thomas JN822TWCirrus Design SR22 · S/N 1066Built 2004 · Woods Douglas AN8375PPiper PA-24-250 · S/N 24-3633Built 1964 · Gores Thomas JN85790Aeronca 7AC · S/N 7AC-4540Built 1946 · Konstantakis George CN8770PPiper PA-24-260 · S/N 24-4220Gores Thomas JN90DVDoers Douglas A VELOCITY RG · S/N 81DVBuilt 1991 · Doers Douglas AN926GChan Chui S RV-10 · S/N 41141Built 2017 · G2 Aviation LLCN958EGHughes 269C · S/N 960547Built 1976 · Gores Thomas J
Back to Franklin, WI