OpenAirDocs.org
Crookston, MN

Registered aircraft · 29

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

N1627PPiper PA-22-150 · S/N 22-2441Built 1954 · Miller Wesley MN207WCAircraft Mfg & Development CH601XL SLSA · S/N 601-044SBuilt 2007 · Capistran Wayne AN2082NCessna 140 · S/N 12318Built 1947 · Hoppe Farms IncN250BCRainbow Sky Reach BUSHCAT · S/N CH138BBuilt 2013 · Tollefson Todd AN278QHDJI AGRAS T40 · S/N 5X5BLMN0030JJ3Helios Drone Solutions LLCN3041APiper PA-28-161 · S/N 28-7916105Miller Aircraft Services IncN3134WMaule MX-7-160 · S/N 19027CDans Flying Service IncN31941Ayres S2R-T45 · S/N T45-008Built 1995 · Gasper Air Spray IncN351DHVans RV-12 · S/N 120351Built 2012 · Carlson Blake AN40016Piper PA-28-161 · S/N 28-7716320Built 1977 · Miller Aircraft Services IncN416RPPiper PA-28-151 · S/N 28-7415310Built 1974 · Miller Aircraft Services IncN4238EAeronca 11CC · S/N 11CC-125Built 1947 · Leake Larry WN4709EAeronca 7EC · S/N 7EC-52Built 1950 · Miller Aircraft Services IncN47665Taylorcraft BC12-65 · S/N 2835Built 1941 · Carlson Blake AN502MKAir Tractor AT-502B · S/N 502B-0356Built 1996 · Geist Daniel CN502RBAir Tractor AT-502B · S/N 502B-2702Built 2010 · Dans Flying Service IncN52871Cessna 177RG · S/N 177RG1294Built 1977 · North Cardinal LLCN6189GCessna 150K · S/N 15071689Built 1969 · Brule Alan RN6249GCessna 150K · S/N 15071749Built 1970 · Miller Aircraft Services IncN6622QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1689Gasper Air Spray IncN66409Beech V35B · S/N D-10261Built 1979 · Dans Flying Service IncN66NDPiper PA-18-150 · S/N 1809046Built 1989 · Miller Aircraft Services IncN75090Schweizer G164B-34T · S/N 831BBuilt 1992 · Gasper Air Spray IncN805KJAir Tractor AT-502B · S/N 502B-2805Dan'S Flying Service IncN8128KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 575BBuilt 1979 · Gasper Air Spray IncN8312VChampion 7ECA · S/N 458Built 1966 · Pester Mark CN9332TCessna 180C · S/N 50832Built 1960 · Miller Aircraft Services IncN944PMCessna 182R · S/N 18268344Built 1983 · Gasper Air Spray IncN9957NCessna 180J · S/N 18052612Built 1975 · Gasper Air Spray Inc
Back to Crookston, MN