OpenAirDocs.org
Bemidji, MN

Registered aircraft · 110

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

N1001Howard DGA-15P · S/N 980Built 1947 · Hokuf Erik LN100BABeech 99 · S/N U12Built 1968 · Bemidji Aviation Services IncN101EGBeech L-23F · S/N LF-33Bemidji Aviation Services IncN103BABeech 65-B80 · S/N LD-435Built 1971 · Bemidji Aviation Services IncN104BABeech 65-A80-8800 · S/N LD-235Built 1965 · Bemidji Aviation Services IncN106BABeech 65-B80 · S/N LD-409Built 1969 · Bemidji Aviation Services IncN1086LCessna 180B · S/N 50564Built 1959 · Lade Burton GN108BABeech 99 · S/N U-40Bemidji Aviation Services IncN110BABeech 65-B80 · S/N LD-279Built 1966 · Bemidji Aviation Services IncN1261QCessna 150L · S/N 15072561Built 1971 · Leas Michael AN12805Cessna 172M · S/N 17262275Built 1973 · Bemidji Aviation Services IncN12871Cessna 172M · S/N 17262330Built 1973 · Bemidji Aviation Services IncN130BABeech 99 · S/N U-80Built 1969 · Bemidji Aviation Services IncN131BABeech 65-B80 · S/N LD-297Built 1966 · Bemidji Aviation Svcs IncN132BABeech 65-B80 · S/N LD-331Bemidji Aviation Services IncN1340APiper PA-18 · S/N 18-11544031 Aviation IncN134BABeech 65-A80-8800 · S/N LD-202Built 1964 · Bemidji Aviation Svc IncN135BABeech 65-80 · S/N LD-68Built 1962 · Bemidji Aviation Services IncN137BABeech 99A · S/N U137Built 1970 · Bemidji Aviation Services IncN1568MGary A Motz VANS RV-7A · S/N 72249Built 2012 · Motz Gary AN158MCFairchild SA227-AC · S/N AC-726BBuilt 1988 · Bemidji Aviation Services IncN17057Cessna C-37 · S/N 345Heuer Qumn KN17090Cessna C-37 · S/N 350Built 1937 · Heuer Qumn KN172EEBeech C-99 · S/N U-172Built 1981 · Bemidji Aviation Services IncN175EEBeech C-99 · S/N U-175Built 1981 · Bemidji Aviation Services IncN18035Cessna C-37 · S/N 361Heuer Quinn KN184BABeech 65 (LF-23F) · S/N LF-68Built 1962 · Bemidji Aviation Services IncN186CDCirrus Design SR20 · S/N 1094Built 2000 · Jw Aviation LLCN2005ETaylorcraft F21 · S/N F-1015Built 1981 · Shaw Brian WN2028KLuscombe 8E · S/N 4755Built 1947 · Hokuf Erik LN2150BPiper PA-32RT-300T · S/N 32R-7987031Built 1979 · Green Head Flight Services LLCN223CABeech C-99 · S/N U-200Built 1983 · Bemidji Aviation Services IncN227LCFairchild SA227-AC · S/N AC-707BBuilt 1988 · Bemidji Aviation Services IncN22WFPiper PA-31T · S/N 31T-7920007Built 1978 · Bemidji Aviation Services IncN2459DCessna 170B · S/N 20611Shaw Brian WN25483Cessna C-165 · S/N 578Heuer Qumn KN259WBBrown William G SONEX 3300 · S/N 642Built 2004 · Mangelsen Joseph SN26959Fairchild SA227-AC · S/N AC-662BBuilt 1986 · Bemidji Aviation Services IncN306DBeech 65-B80 · S/N LD-439Bemidji Aviation Services IncN3116NFairchild SA227-AC · S/N AC-596Built 1984 · Bemidji Aviation Services IncN3467CCessna 170B · S/N 26510Shaw Brian WN3553JCessna 150E · S/N 15061253Built 1965 · Lade Burton GN366AEFairchild SA227-AC · S/N AC-681BBuilt 1987 · Bemidji Aviation Services IncN441MCBeech 65 (LF-23F) · S/N LF 45Bemidji Aviation Services IncN4493RCessna 172M · S/N 17263235Built 1974 · Barnstormers IncN47428Cessna A185E · S/N 185-1196Built 1966 · Nei Jeffrey GN4749XCessna 150G · S/N 15064799Built 1966 · Flaat Stephen CN47BLLade Burton G LWCUB · S/N 003Built 2010 · Lade Burton GN488MTTisler Mark VANS RV-8 · S/N 81744Built 2009 · Tisler Mark RN5078EBeech 65 · S/N LF-76Built 1963 · Bemidji Aviation Services Inc
Back to Bemidji, MN