OpenAirDocs.org
Rosemount, MN

Registered aircraft · 19

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

N1392ZBeech N35 · S/N D-6822Built 1961 · Rautiola Charles AN22AEStegmaier David J RV-8 · S/N 82804Built 2011 · Stegmaier David JN30856Cessna 177B · S/N 17701507Built 1970 · Groothius Duane AN360WCClayton S Adams PA-12 REPLICA · S/N JA1804118Built 2023 · Adams Clayton SN42VMStegmaier David John ONEX · S/N ONEX 0188Built 2017 · Stegmaier DavidN52852Cessna 182P · S/N 18262897Built 1974 · Hultin RonaldN5359NBoeing E75 · S/N 75-5522Quy Matthew DN536FLSling SLING LSA · S/N 430ABuilt 2025 · Propel Air Aviation LLCN6199MStinson 108-3 · S/N 108-4199Built 1948 · Borning Jeffrey MN644CLLeckie Charles RV-4 · S/N 1834Built 1997 · Leckie Charles WN7003LNational Ballooning 858 · S/N 127Ness Christopher JN7435HPiper J3C-65 · S/N 20701Built 1946 · Adams Clayton SN754CStinson 108-3 · S/N 108-3754Borning Jeffrey MN758DHCessna R172K · S/N R1723009Built 1978 · Quy MatthewN8175UCessna 172F · S/N 17252075N8175u LLCN8551CPiper PA-18 · S/N 18-2709Rautiola Charles AN900DCPiper PA-39 · S/N 39-20Built 1970 · Rognerud Edward JN9033EAeronca 11AC · S/N 11AC-664Built 1946 · Schindeldecker Jennifer LN9439UCessna 150M · S/N 15078387Rautiola Patricia H
Back to Rosemount, MN