OpenAirDocs.org
Hastings, MN

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

N13748Cessna 172M · S/N 17262989Ries Farms LLCN137TPiper PA-18 105 · S/N 18-2251Built 1953 · Monno Joseph PN18110Cessna 150L · S/N 15073793Built 1972 · Radke Steven HN33240Piper J3F-65 · S/N 5915Built 1940 · Weber Stephen JN33945Taylorcraft BC12-65 · S/N 2795Weber Paul WN3673APiper PA-22-135 · S/N 22-1932Built 1953 · Krehbiel David EN368VBeech 36 · S/N E-21Built 1968 · Kranz DanielN429FHDG Flugzeugbau DG 1000S · S/N 10-12S12Built 2002 · Aviation Dynamics LLCN46362OMF OMF-100-160 · S/N 0018Built 2001 · Weber ScottN4694HPiper PA-17 · S/N 17-92Weber Stephen JN46SJTaylorcraft BC12-D · S/N 8317Built 1946 · Johnston Robert JamesN505PWWeber W/Weber P RV-6 · S/N 23590Built 2003 · Weber Paul WN5250NCessna 182Q · S/N 18267599Built 1980 · Caturia James JN53SJPiper PA-18-135 · S/N 18-3003Built 1953 · Johnston Robert JN5678WPiper PA-28-160 · S/N 28-913Built 1963 · Mckinney Douglas AndrewN58620Cessna 182P · S/N 18262179Built 1973 · Ries Farms LLCN74WFPiper PA-18-150 · S/N 18-8302Built 1965 · Weber Stephen JN7503PPiper PA-24-250 · S/N 24-2704Built 1961 · Houseth Timothy CN8014BCessna 172 · S/N 29814Built 1957 · Heinrich George F JrN829ECKranz Edward J RV-10 · S/N 41347Built 2015 · Adventure Machine LLCN90931Piper PA-18-150 · S/N 18-8109048Built 1981 · Davies Donald KN94872Cessna 182Q · S/N 18266527Built 1978 · Weber Brian TN9488ACessna 140A · S/N 15309Built 1949 · Radke HarlowN9545VMooney M10 · S/N 700035Built 1970 · Weber Stephen JN9617SChampion 7ECA · S/N 366Built 1966 · Anderson David RN970VXDJI AGRAS T40 · S/N 5X5BKGF0010073Ries Farms LLCN987TRDJI MAVIC 3 · S/N 1581FKD22CK00C3640Ries Farms LLCN993KJCaturia Joseph P JAVRON SUPERCUB · S/N JA1008064Caturia Joseph P
Back to Hastings, MN