OpenAirDocs.org
Canton, MI

Registered aircraft · 45

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 = 'MI' AND g.registrant_city = 'CANTON'
  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.

N102SDDhall Sanjay Q-200 · S/N 001Built 2011 · Dhall SanjayN106RTSobota Thomas J RV6-A · S/N 23187Built 2001 · Sobota Thomas JN107JDDooley James H VELOCITY · S/N DM062Built 1991 · Dhall SanjayN112SDDhall Sanjay WD-2 · S/N 002Built 2024 · Dhall SanjayN139ZXLeza-Lockwood SUPER DRIFTER · S/N 55555Campbell Mark MN1654NFunk B85C · S/N 438Built 1948 · Maxfield John ON16DRMooney M20E · S/N 416Built 1964 · Hibner Christopher JN1712EChampion AERONCA 7AC · S/N 7AC-5277Crooks Sean PN2047ZCessna 150C · S/N 15059847Built 1963 · Dhall SanjayN26396Grumman American Avn. AA-5A · S/N AA5A0561Built 1978 · Vergona John TN26424Grumman American Avn. AA-5A · S/N AA5A0584Built 1978 · Ormanian AustinN2893LPiper PA-28-161 · S/N 28-7916520Built 1979 · Khalaf MaherN291PPark Denny R LONGEZE · S/N 291Built 1982 · Farmer AidanN340CStinson 108-2 · S/N 108-3340Built 1947 · Lindvig Rachel RN3738LCessna 172G · S/N 17253907Built 1965 · Tran Tuan MN400HPPiper PA-24-400 · S/N 26-16Built 1964 · Morgan David WN4069CUniversal Stinson 108-3 · S/N 108-5069Built 1950 · Morgan David WN4099CSchleicher KA 6 CR · S/N 6058Pasquantonio RaymondN422CSRaytheon Corporate Jets BAE 125-800A · S/N 258110Built 1988 · Business Jet Managers IncN430AGBell 430 · S/N 49045Built 1998 · Mcmahon Helicopter Services IncN430NYBell 430 · S/N 49068Built 2000 · Mcmahon Helicopter Services IncN431SLBell 430 · S/N 49023Built 1997 · Mcmahon Helicopter Services IncN4333JPiper PA-28-140 · S/N 28-22708Built 1967 · Haengel Marci MN527RHRobinson Helicopter R22 BETA · S/N 1527Arrow Helicopter LLCN529ADCessna P210N · S/N P21000603Built 1980 · Dcm Air LLCN545STCessna P210N · S/N P21000553Business Jet Managers IncN556UHBell 430 · S/N 49117Built 2006 · Mcmahon Helicopter Services IncN59GRPiper PA-32-301 · S/N 32-8106093Built 1981 · Tkaczyk Gary JN6023XMooney M20A · S/N 1611Built 1960 · Sytsma Douglas AN603SAStaudacher S600 F · S/N 30Built 2004 · Buescher Wayne FN6122SCessna R182 · S/N R18201619Built 1980 · Business Jet Managers IncN66NMDJI INSPIRE 1 · S/N W13DCA15020462Mcmahon Helicopter Services IncN6902TPryor M/Pryor C VANS RV-7A · S/N 71544Built 2009 · Pryor Martin DN703NCBeech 58 · S/N TH-224Built 1972 · Nunn BryantN7093ACessna 172 · S/N 29193Built 1956 · Valle Daniel JN738YZCessna 172N · S/N 17270354Built 1978 · Hotton Ralph AN767ALNicholas Otterback LIGHTNING CLASSIC · S/N 201Built 2022 · Secor AustinN801RMBritish Aerospace BAE 125 SERIES 800A · S/N 258011Built 1984 · Blue Skies Hawker LLCN84769Aeronca 7AC · S/N 7AC-3488Crooks Sean PN85393Aeronca 7AC · S/N 7AC-4133Crooks Sean PN868AADassault FALCON 900EX · S/N 315Built 2018 · Dcco Aviation II LLCN868EMDassault FALCON 900EX · S/N 161Built 2006 · Dcco Aviation II LLCN88551Piper J3C-65 · S/N 16176Folgmann Andrew GN9669Tucker Mitchel C H-13 · S/N T-3Built 2005 · Baden Robert EN99MQBeech D55 · S/N TE-527Built 1968 · Placide Aircraft LLC
Back to Canton, MI