OpenAirDocs.org
Flushing, MI

Registered aircraft · 26

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

N147SMBell 47G-2 · S/N 1461Built 1956 · Mazar Stephen MN2202KLuscombe 8A · S/N 4929Built 1947 · Denkins Wayne LN2237NCessna 140 · S/N 12473Built 1947 · Loucks Gregory BN2531MPiper PA-12 · S/N 12-1022Built 1946 · Curtis Kevin RN3124DCessna 180 · S/N 31922Built 1955 · Burch David CN3559ECessna 182T · S/N 18281010Greater Flint Pilots Association IncN3755JBell 47G-2 · S/N 1537Built 1958 · Spinney Jeffrey JamesN4145JPiper PA-28-140 · S/N 28-22469Built 1966 · Dyka Samuel MN4383LCessna 172G · S/N 17254462Hasman Robert BN5091FAlliant DESTINY XLT · S/N 1C0209Built 2006 · Colosky Kelly AN518SPCessna 172S · S/N 172S8379Built 2000 · Greater Flint Pilots Associations IncN5920RCessna 172G · S/N 17253589Built 1965 · American Eagle Aviation LLCN6001FBeech S35 · S/N D-7794Built 1965 · 2120 Limited LLCN60KTBeech A35 · S/N D-1912Built 1948 · Talhelm Timothy AN6294TCessna R182 · S/N R18201962Built 1983 · Greater Flint Pilots AssociationN6621YPiper PA-23-250 · S/N 27-4397Built 1969 · Dyka Samuel MN714FLPiper PA-28-140 · S/N 28-7225349Built 1972 · Father John 77 Flying Club IncN72856Cessna 140 · S/N 10043Built 1946 · Orme John Robert IIN736MLCessna R172K · S/N R1722634Built 1977 · H & L Acquisitions LLCN758EGCessna R172K · S/N R1723032Built 1978 · Payne James MelvinN7797TCessna 172A · S/N 47397Built 1960 · Danforth Lawrence PN77FJTaylorcraft BC12-65 · S/N 2808Built 1941 · Experimental Aircraft Assn Flint Area Chapter #77N80235Cameron Balloons Z-90 · S/N 6292Web Influence LLCN818CDPiper PA-28-181 · S/N 2843110Built 1997 · Greater Flint Pilots Association IncN8663WPiper PA-28-235 · S/N 28-10188Built 1963 · Rush Lake Holding Company LLCN916MGGoulet Michael C RV-7A · S/N 73730Goulet Michael C
Back to Flushing, MI