OpenAirDocs.org
Shoreview, MN

Registered aircraft · 27

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 = 'MN' AND g.registrant_city = 'SHOREVIEW'
  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.

N1701Cessna 172F · S/N 17252418Built 1964 · Rolston Charles WN2172SDJI AIR 2S · S/N 1581F3YT7L82003P4240City Of ShoreviewN242SECirrus Design SR22 · S/N 9019Built 2022 · Sanco EnterprisesN25185Fairchild 24W-40 · S/N 108Built 1940 · Bruggeman Steven SN344PTNelson Garrett T SONEX · S/N 1634Built 2016 · Nelson Garrett TN4381APiper PA-18A · S/N 18-4787N4381a IncN4456XPiper PA-28R-200 · S/N 28R-7635050Built 1975 · Fly By Knight CorpN4647CCessna 170B · S/N 25591Built 1953 · Concolor LLCN52813Boeing A75N1(PT17) · S/N 75-394Built 1940 · Tischer William DN5694HBeech 95 · S/N TD-243Built 1965 · Tischer William DN5842BCessna 182 · S/N 33842Built 1956 · Pietrs MichaelN5942RCessna 172G · S/N 17253611Built 1965 · L&L LtdN6021EBeech K35 · S/N D-5919Built 1959 · Merhar Timothy JN7175TCessna 172A · S/N 46775Built 1959 · Tischer William DN734HZCessna 172N · S/N 17268878Built 1977 · Aster Labs IncN7492BChampion 7EC · S/N 7EC-558Built 1957 · Benson Airport Association IncN771MBeech A36 · S/N E-293Built 1971 · Ags Leasing Services LLCN789BPiper PA-18-150 · S/N 18-7709171Built 1977 · Nelson Brett RN80869Globe GC-1B · S/N 272Built 1946 · Bailey Robert LN8187VCessna A150M · S/N A1500559Built 1974 · Nelson Brett RN8353RPiper PA-28-140 · S/N 28-22228Built 1966 · Schrandt Mark LN8432LCessna 172I · S/N 17256632Built 1968 · Aster Labs IncN86AZJimi Holdings KITFOX S7 SUPER SPRT · S/N KA14787283Built 2019 · Eggen Mark AllenN88PYPiper PA-18-150 · S/N 18-7425Built 1960 · Segler Max DN8958KStinson 108-1 · S/N 108-1958Built 1947 · Christopherson Mark AN95JJConnell Joseph T CONNELL RV-9A · S/N 90216Built 2010 · Horrigan Patrick BN970TMDJI AIR 2S · S/N 1581F3YT7L82003P424City Of Shoreview
Back to Shoreview, MN