OpenAirDocs.org
Chisago City, 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 = 'CHISAGO CITY'
  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.

N1023ZPlante Matthew L HIGHLANDER · S/N JA509-01-17Built 2020 · Jdjh LLCN1103XPiper PA-28-151 · S/N 28-7515388Built 1975 · Holmgren Joel AN121KACessna 172M · S/N 17263836Air Ally Asset Management LLCN12588Cessna 172M · S/N 17262097Built 1973 · Air Ally Asset Management LLCN12NVPilatus PC-12/47E · S/N 1801Built 2018 · Air Ally LLCN13095Cessna 172M · S/N 17262489Built 1973 · Air Ally Asset Management LLCN169WWMaule M-4-210C · S/N 1057CBuilt 1967 · Pro Aire IncN189UGerman Mark W RANS S-7S · S/N 0406432First renewal noticeGerman Mark WN2335HErcoupe 415-C · S/N 2960Built 1946 · Rosenquist Susan LN268EARaytheon A36 · S/N E-3476Air Ally Asset Management LLCN30935Cessna 177B · S/N 17701552Built 1970 · Peterson Air LLCN39457Piper PA-28R-201 · S/N 28R-7837297Built 1978 · Pro-Aire IncN41389Piper PA-28-151 · S/N 28-7415197Built 1974 · Johnson David CN4401BCessna 170B · S/N 26745Built 1955 · Johnson Timothy AN514ZHIversen Rolf E MARINER · S/N 1993IBoo Steven RN6681HPiper J3C-65 · S/N 19886Built 1946 · Johnson David CN770BDMcginty Edwin R RV ATOR RV-10 · S/N 004First renewal noticeBuilt 2005 · J/D Aviation LLCN7766GCessna 172L · S/N 17259466Air Ally Asset Management LLCN8137YPiper PA-30 · S/N 30-1248Sale reportedBuilt 1966N8163YPiper PA-28-181 · S/N 28-8090254Built 1980 · Bachman David RN8258YPiper PA-30 · S/N 30-1384Built 1966 · Johnson David CN825ECRaytheon A36 · S/N E-3272Built 1999 · Peterson Air LLCN8796BCessna 172 · S/N 36496Tetrault Phil HN8982RChampion AERONCA 7GCB · S/N 7GCB-15Built 1960 · Boo Steven RN9691PPiper PA-18-150 · S/N 18-7709040Peterson Air LLCN9709BCessna 172RG · S/N 172RG0982Built 1981 · Peterson Air LLCN991TCessna T206H · S/N T20608065Built 1999 · Peterson Air LLC
Back to Chisago City, MN