OpenAirDocs.org
Dexter, MI

Registered aircraft · 18

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

N1052MCessna 182P · S/N 18264216Built 1975 · Fendt Alan D TrusteeN1075APiper PA-18-125 · S/N 18-667Built 1951 · Bates Hobart CN200SBPiper PA-34-200T · S/N 34-7870399Built 1978 · Soaring Hawk Aviation LLCN202DHHiggins David M MULTICRUISER · S/N 002Higgins David MatthewN265RGCessna 421C · S/N 421C0833Herron Aviation Group LLCN319SVEvektor - Aerotechnik A S SPORTSTAR MAX · S/N 20070916Built 2007 · Barnes David MhN33HDPiper J3C-65 · S/N 9770Built 1942 · Bates Hobert CN4853HPiper PA-15 · S/N 15-385Built 1948 · Hubbard David RN48TMMetty Tom BD-4 · S/N 315Built 1998 · Metty TomN5042NBellanca 8GCBC · S/N 299-79Bates Hobart CN569PACessna 414A · S/N 414A0461Herron Aviation Group LLCN5706RCessna 182F · S/N 18254793Built 1963 · Graham Charles ArbeN598JJabiru USA Sport J250-SP · S/N 426Built 2007 · Lindholm Jeffery LN600DCCessna 421C · S/N 421C1007Herron Aviation Group LLCN606JRPiper/Mckinney J3C-65 · S/N 14411Built 1986 · Bates Hobart CN6338MHiggins David Matthew MERLIN GT · S/N DMH01Higgins DavidN9306YBeech M35 · S/N D-6515Built 1960 · Tff IncN9631BCessna 172RG · S/N 172RG0930Built 1981 · Percy Flyers LLC
Back to Dexter, MI