OpenAirDocs.org
Canby, MN

Registered aircraft · 36

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

N1000NCessna 310H · S/N 310H0104Built 1963 · Anderson Aerial Spraying Service IncN135RJPiper PA-31-310 · S/N 31-52Built 1967 · Kontz Gary LeeN14028Piper PA-23-250 · S/N 27-4689Stoks Derek RN1481CHylio AG-272 · S/N 070228Canby ImplementN148TCHylio AG-272 · S/N 070229Canby ImplementN1588MCessna A188A · S/N 18800688Built 1970 · Anderson Aerial Spraying Service IncN2122UCessna A188A · S/N 18800672Built 1970 · Anderson Aerial Spraying Service IncN2752PPiper PA-22-150 · S/N 22-3059Built 1955 · Anderson Aerial Spraying Service IncN296BBDJI AGRAS T40 · S/N 1581F574B23AM001006DBeachmark Drainage Survey Design LLCN296LBDJI AGRAS T40 · S/N 1581F574B2383001000RBenchmark Drainage Survey And Design LLCN34SLLewis-Strine PITTS S-1C · S/N LE001Anderson Aerial Spraying Service IncN365JBCessna 170B · S/N 25419Built 1952 · Hentges DaveN4268BBeech F35 · S/N D-4241Built 1955 · Kallhoff MarkN4399PPiper PA-23-160 · S/N 23-1911Built 1960 · Schrunk Lloyd EN4442DBeech G35 · S/N D-4534Hentges AnthonyN4702JBeech A23A · S/N M-1009Built 1966 · Goplen Tyler GaryN5040XRockwell International S-2R · S/N 5070RBuilt 1975 · Anderson Aerial Spraying Svc IncN53211Cessna A188B · S/N 18801688TAnderson Aerial Spraying Service IncN5367EBeech K35 · S/N D-5846Built 1959 · Hentges AnthonyN560DBPiper PA-23-250 · S/N 27-2722Built 1964 · Anderson Aerial Spraying Svc IncN5685JCessna A188A · S/N 18800635Built 1970 · Anderson Aerial Spraying ServiceN5688JCessna A188A · S/N 18800638Built 1970 · Anderson Aerial Spraying Service IncN606CAPiper PA-23-250 · S/N 27-4853Built 1972 · Cv Wings LLCN65662Lake LA-4-200 · S/N 594Built 1974 · Kontz Gary LeeN6571HCessna 172M · S/N 17265493Built 1975 · Hentges DaveN6601HCessna 172M · S/N 17265503Built 1975 · Canby Pilots Club IncN6772XCessna 310F · S/N 310-0072Built 1961 · Kallhoff Mark R DBAN8092YPiper PA-30 · S/N 30-1210Built 1966 · Stoks Gary RN82291Piper PA-28RT-201T · S/N 28R-8031116Bdas LLCN8271SCessna 150F · S/N 15061871Built 1965 · Kontz Gary LeeN8673WPiper PA-28-235 · S/N 28-10202Built 1963 · Leibel Chad JN90072Cessna 140 · S/N 9133Epple Jason EN91919Cessna A188B · S/N 18802053TAnderson Aerial Spraying Service IncN91MMMitsubishi MU-2B-20 · S/N 198Built 1970 · Anderson Aerial Spraying Service IncN9486RCessna A188B · S/N 18802295TBuilt 1975 · Anderson Aerial Spraying Serv IncN9725VCessna 188 · S/N 188-0175Built 1966 · Anderson Aerial Spraying Service Inc
Back to Canby, MN