OpenAirDocs.org
Troy, MI

Registered aircraft · 37

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

N1030RMooney M20R · S/N 29-0278Built 2001 · Thomas Leasing Enterprise LLCN114KLRockwell International 114 · S/N 14427Built 1978 · Karuppannan VenkatachalamN116KAHawker Beechcraft B200GT · S/N BY-116Built 2011 · P & L Real Estate Management IncN182GHCessna 182S · S/N 18280003Built 1998 · Troy-Oakland Pilots Flying Club IncN19854Cessna 172M · S/N 17260807Built 1972 · Boris Jeffrey AN201WGMooney M20J · S/N 24-0250Built 1977 · Wolf Dirk RN2115MCessna 177B · S/N 177-01703Built 1972 · Redman Company LLCN21CNBeech D35 · S/N D-3459Built 1953 · V-Tail Aero LLCN220KCPiper PA-34-220T · S/N 3433137Built 1989 · Avanti Air CoN2213FPiper PA-28-236 · S/N 28-7911050Built 1978 · J & M Airways LLCN2969BBeech D35 · S/N D-3610Built 1953 · Blaszak Benjamin DN305AHGulfstream Aerospace GV-SP (G550) · S/N 5264Built 2009 · Nf Air Ventures II LLCN3077ZBeech 58 · S/N TH-1516Built 1987 · Bravo Air LLCN31080Arbc Inc DBA Lindstrand 69X · S/N 5599Built 2016 · Re/Max Broker Service CenterN310TDEubanks Larry PULSAR · S/N 310Built 2003 · Fults Ronald CN3562GPiper PA-28-181 · S/N 28-8090186Built 1979 · Troy Oakland Pilots Flying Club IncN4338PPiper PA-28-181 · S/N 28-8490050Built 1984 · Troy Oakland Pilots Flying Club IncN4453TTaylor William S MIDGET MUSTANG MM-I · S/N M-1-1101Pathfinder Air IncN466CPPiper PA46-500TP · S/N 4697419Built 2009 · Redman Company LLCN4713TMaule M-4 · S/N 56Built 1964 · Michigan Air Service CorpN48TGCirrus Design SR20 · S/N 1637Built 2006 · Plane Sales LLCN515GAPiper PA-31T1 · S/N 31T-8104050Built 1981 · Framalin LeonardN5198TCessna 206H · S/N 20608178Built 2002 · Black Dog Aviation LLCN52219Cessna 172P · S/N 17274443Built 1980 · Warren Flying Club IncN526BLCessna 182S · S/N 18280132Built 1998 · Warren Flying Club IncN5510VPiper PA-32R-300 · S/N 32R-7780336Forest Aviation LLCN56584Piper PA-28-235 · S/N 28-7410012Built 1973 · Pathfinder Air IncN6508KCessna 172P · S/N 17274205Built 1980 · Troy Oakland Pilots Flying Club IncN6896FCessna 150F · S/N 15063496Built 1966 · Landmesser Avis CN719MPCessna 525C · S/N 525C0041Built 2011 · Cj4 Equipment Leasing LLCN7244LBeech A36 · S/N E-2260Built 1985 · Framalin LeonardN7289JPiper PA-28-140 · S/N 28-24641Built 1968 · Valdez Jose CN737HUCessna TR182 · S/N R18200832Built 1978 · Berry William JN7718PPiper PA-24 · S/N 24-2931Built 1961 · Van Develde Robert KN777NHCessna 340A · S/N 340A-0415Built 1978 · S And S AirlinkN9359HCessna 172M · S/N 17266115Built 1975 · Warren Flying ClubN9885MCessna 182P · S/N 18264783Built 1976 · Troy Oakland Pilots Flying Club Inc
Back to Troy, MI