OpenAirDocs.org
Rochester, MN

Registered aircraft · 78

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

N111CJCessna 182P · S/N 18262621Built 1973 · Regan Dennis WN12XKVans RV-12 · S/N 120518Built 2012 · Sorochak BarbaraN1393QCessna 150L · S/N 15072693Built 1971 · Beitel Ronald LeeN149GTPilatus PC-12/47E · S/N 2428Built 2024 · Tenmile1 LLCN14CCBalloon Works FIREFLY 7-15 · S/N F7-1096Built 2000 · Cloud 9 Enterprises IncN1575HCessna 177RG · S/N 177RG0749Cardinal Shares IncN163KAeropro CZ S R O A240 · S/N 68123Built 2023 · Klees ToddN1665LPhoenix LIBERTY · S/N 0546Built 2006 · Schmitt Steven AN167CCFirefly Balloons 2010 FIREFLY 7-15 · S/N F7-2073Cloud 9 Enterprises IncN1713HCirrus Design SR22T · S/N 0944Built 2014 · Gay JamesN177VCessna 177 · S/N 17700406Built 1967 · Anglin RobertN181TKPiper PA-28-181 · S/N 28-7890193Built 1977 · Anderson Brad AN20623DJI AGRAS T50 · S/N 1581F6BUB246H001675TBuchheit Drone Service LLCN2091MPiper PA-28-161 · S/N 28-7816249Great Planes Aviation IncN2139HEngineering & Research ERCOUPE 415-C · S/N 2762Built 1946 · Ray Paul DN214SQCirrus Design SR20 · S/N 2527Built 2019 · Sawque LLCN2196NPiper PA-32-300 · S/N 32-7940037Built 1979 · Thompson Kurt CN2224Piper PA-18-150 · S/N 18-8651Built 1968 · N2224 Dnr IncN252YEMooney M20K · S/N 25-1081Built 1986 · Mayaire Inc.N2836NPiper PA-28-161 · S/N 28-7916461Built 1979 · Great Planes Aviation IncN283HADJI AGRAS T40 · S/N 1581F574B237700100HTAgridrone Solutions LLCN2877BPiper PA-28-181 · S/N 2843402Built 2000 · Great Planes Aviation IncN330LDBombardier CL-600-2B16 · S/N 5816Built 2009 · Ss Leasing LLCN339RPVans RV-12 · S/N 120 411Hawkins MichaelN350MCBeechcraft B300C · S/N FM-60Built 2015 · Mayo ClinicN4091WAerostar International S53A · S/N S53A-3032Lesmeister Michael AN40EBBenjamin John W LONG-EZ · S/N 984Built 1985 · Wegman Jacob LN4148YBellanca 8KCAB · S/N 280-76Built 1976 · Tailwheel Flying LLCN4480RCessna 172M · S/N 17263222Built 1974 · Southeastern Minnesota Flying Club IncN45246Cessna 150M · S/N 15076803Built 1975 · Carlsen Brent RN45JFBeech E35 · S/N D-3901Built 1954 · Fischer Jason EdwardN47955Piper PA-28-181 · S/N 28-7890159Built 1977 · Southeastern Minnesota Flying Club IncN4848RSteven Shae MXLII SPORT · S/N 0951Built 2012 · Shae Steven DN484VShae Steven D S-20 · S/N 03150038Built 2019 · Shae Steven DN493MAPiper PA-28-181 · S/N 2843486Built 2001 · Great Planes Aviation IncN4956TMacrafic Richard W RV-7A · S/N 71953Built 2017 · Macrafic Richard WN50637Piper PA-28-181 · S/N 2843419Built 2001 · Great Planes Aviation IncN508RFPiper PA-28-181 · S/N 28-8190281Built 1981 · Fugate Richard DeeN5236RAerostar International S53A · S/N S53A-3091Built 2005 · Lesmeister Michael AN5278TAerostar International S53A · S/N S53A-3077Built 2002 · Liberty Bell Project IncN5280LAerostar International S-57A · S/N S57A-3222Built 2000 · Newkirk Rodney AN52965Aerostar International S-57A · S/N S57A-3230Built 2001 · Dreams AloftN5551USocata TB-20 TRINIDAD · S/N 1277Built 1991 · Briese MathewN5614SBeech 35-C33A · S/N CE-48Built 1966 · Shaughnessy WilliamN57030Aerostar International S-60A · S/N S60A-3180Lesmeister Michael AN577CGOwens James M SONEX · S/N 1372Built 2018 · Owens James MN601ADEa Vision J-150 · S/N JMZKJ150UAV602595126Agridrone Solutions LLCN619RDBeech A36 · S/N E-2830Hunt Aviation LLCN6285DMikoyan Gurevich MIG 21 · S/N 1108Chase Kenneth Charles JrN668SLCommander 114-B · S/N 14668S L Contracting Inc
Back to Rochester, MN