OpenAirDocs.org
Blaine, MN

Registered aircraft · 107

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

N10528Bellanca 31-55A · S/N 809Built 1935 · Harker James PN105NBCessna A185F · S/N 18503732Built 1984 · Northcentral Aircraft LLCN113CBDehavilland DHC-2 · S/N 1491Built 1961 · C And P Aviation IncN130DPOptica Industries OA7 OPTICA · S/N 003Built 1987 · Plane@Work LLCN134AARobinson Helicopter R44 II · S/N 11086Mn Helicopters IncN134AWGrumman OV-1C · S/N 68-15936Built 1969 · American Wings Air MuseumN1377BStinson/Stratton L-1F · S/N 41-19031Built 1941 · Harker James PN142AMNorth American F82E · S/N 144-38142Harker James PN1459NPiper J3C-65 · S/N 22995Built 1947 · Tilbury Mitchell AN14YLPiper L-14 · S/N 5-3005Built 1945 · Harker James PN151DMNorth American F-51D · S/N 44-13250Built 1944 · Flying Pig P-51 LLCN17210Cessna 150L · S/N 15073666Built 1972 · Babler Paul WN2185GPiper PA-32RT-300 · S/N 32R-7985044Built 1978 · Gateway Flying Club IncN224PTCessna 182Q · S/N 18265572Lee Mark WN242SPCessna 172S · S/N 172S8226Built 1999 · 242sp LLCN25607Sky Craft Industries 446 · S/N 1000American Aviation Heritage Foundation IncN285DBNorth American T-28B · S/N 138216Built 1950 · Ranheim Richard JN31351Dehavilland CHIPMUNK T.10 MK-22 · S/N C1-0868Built 1953 · Guillaume GirardN313SKCessna 182P · S/N 18262630Built 1973 · Johnson ScottN320WAPilatus PC-12/47E · S/N 1320Built 2011 · Indy Air LLCN34808Cessna 177B · S/N 17702016Built 1973 · Barber Jeffrey AN351LLAgustawestland Philadelphia AW119MKII · S/N 14819Built 2014 · Critical Care Services Inc DBAN352LLAgustawestland Philadelphia AW119MKII · S/N 14820Built 2014 · Critical Care Services Inc DBAN353LLAgustawestland Philadelphia AW119MKII · S/N 14821Built 2014 · Critical Care Services Inc DBAN354LLAgustawestland Philadelphia AW119MKII · S/N 14822Built 2014 · Critical Care Services Inc DBAN355LLAgustawestland Philadelphia AW119MKII · S/N 14823Built 2014 · Critical Care Services Inc DBAN356LLAgustawestland Philadelphia AW119MKII · S/N 14824Built 2014 · Critical Care Services Inc DBAN358LLAgustawestland Philadelphia AW119MKII · S/N 14902Built 2016 · Critical Care Services Inc DBAN359LLAgustawestland Philadelphia AW119MKII · S/N 14934Built 2017 · Critical Care Services Inc DBAN360LLAgustawestland Philadelphia AW119MKII · S/N 14948Built 2018 · Critical Care Services Inc DBAN365LLAgustawestland Philadelphia AW119MKII · S/N 14812Built 2013 · Critical Care Services Inc DBAN367LLAgustawestland Philadelphia AW119MKII · S/N 14832Built 2015 · Critical Care Services Inc DBAN368LLAgustawestland Philadelphia AW119MKII · S/N 14833Built 2015 · Critical Care Services Inc DBAN369BTConsolidated Vultee BT-13A · S/N 2379Cargill James R IIN371LLPilatus PC-12/47E · S/N 1240Built 2010 · Critical Care Services Inc DBAN3724GNorth American SNJ-5 · S/N 90837Built 1959 · C & P Aviation Services IncN4101Mooney M-18C · S/N 276Connolly Luke AN4118XHanson Lonn AVID AMPHIBIAN · S/N 117ABuilt 1994 · Connolly Luke AN425YLBoeing YL-15 · S/N 2-0005Harker James PN427YLBoeing YL-15 · S/N 47-427Harker James PN433XCOrchard Richard W AIR CAM · S/N AC068Harker James PN4445BCessna 170B · S/N 26789Built 1955 · Fassett Barry JN45132Cessna 150M · S/N 15076747Jamesweathers Robi JN451XLBoeing L-15 · S/N 20002Harker James PN4537KRyan NAVION · S/N NAV-4-1537Built 1948 · Girard GuillaumeN454KGGary J Laurich SONEX · S/N 0312Built 2011 · Laurich Gary JN4723NCessna 182Q · S/N 18267312Built 1979 · North Central Aircraft LLCN4747JBeech A23A · S/N M-1019Built 1967 · Kavie Andrew JN4770CBoeing YL-15 · S/N 47-432L-13 LLCN49262Aeronca L-3B · S/N 12533Built 1943 · Harker James P
Back to Blaine, MN