OpenAirDocs.org
Bloomfield Hills, MI

Registered aircraft · 65

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 = 'BLOOMFIELD HILLS'
  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.

N103ERCirrus Design SR20 · S/N 2321Built 2016 · R & J Aviation LLCN112BJBeech 400A · S/N RK-112Built 1996 · Dg Group Aviation LLCN114NCPiper PA-31-350 · S/N 31-8252009Fair Air IncN1157PMooney M20K · S/N 25-0647First renewal noticePourcho William SN1318AHawker Beechcraft HAWKER 900XP · S/N HA-0078Built 2008 · Ansaki Aviation LLCN13HECessna LC41-550FG · S/N 411075Built 2008 · Vam LLCN174CAPiper PA-32R-301 · S/N 3213080Built 1994 · Vy Aeroventure LLCN17769Beech A36 · S/N E-1027Built 1977 · Jmk Engineering IncN185CJCessna A185F · S/N 18502802Built 1975 · Dg Air LLCN205SEMooney M20J · S/N 24-3051Recreation Activity Club IncN242KTMooney International M20V · S/N 330006Built 2018 · Ethereal Sky LLCN247REHawker Beechcraft HAWKER 900XP · S/N HA-0066Built 2008 · 724 Aviation LLCN248TVCirrus Design SF50 · S/N 0364Built 2022 · Early Departures LLCN260ERAgusta F260D · S/N 789Michigan Marchetti LLCN280MKIai GULFSTREAM G280 · S/N 2127Built 2017 · Kojaian Aviation Management LLCN285GAIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 285Built 2009 · Pfc Holdings LLCN30100Piper PA-34-200T · S/N 34-7870463Built 1978 · Jetstream Cowboys LLCN312NCCessna 550 · S/N 550-0290Built 1981 · Diva Air LLCN313STDassault FALCON 900EX · S/N 121Built 2004 · Iota Aviation LLCN3168FDouglas A Anderson AIRBORNE EDGE 582 · S/N 582-746Built 2002 · Weinberg Scott GlennN318JGCanadair CL-600-2B16 · S/N 5137Built 1993 · Juliet Golf LLCN3206YBeech A36 · S/N E-2903Built 1994 · N3206y Aviation LLCN337DECessna 337H · S/N 33701943Built 1980 · Airbermz LLCN344SKCirrus Design SR22 · S/N 2657Built 2007 · Driver Aviation LLCN35470Cessna 172I · S/N 17256787Built 1968 · Lombardi Michael JN3556ZCessna T182T · S/N T18208060Built 2001 · Johnson Paul A TrusteeN3594PPiper PA-18-150 · S/N 18-4552Built 1955 · Pourcho William SN36482Piper PA-34-200T · S/N 34-7870335Built 1978 · Fair Air IncN371JSCirrus Design SR20 · S/N 9970Built 2024 · V2j LLCN39KTRaytheon G58 · S/N TH2140Ecojiva Air LLCN4133GPiper PA 46-350P · S/N 4636186Built 1998 · Amsg Transport LLCN4163PPiper PA 46-350P · S/N 4636274Built 2000 · Malibu Aviation LLCN427LLBeech F33A · S/N CE-679Built 1977 · Forrest Jeffrey HN442DPPohl David R VANS RV7A · S/N 70583Built 2005 · Pohl David RN443CLBeech E-90 · S/N LW-318Built 1979 · Skiing Aircraft Co LLCN450ZGulfstream Aerospace GIV-X (G450) · S/N 4012Built 2005 · G650 LLCN4556FPiper PA-32-260 · S/N 32-7600022Built 1976 · Reindeer Aviation LLCN4918YCessna 210N · S/N 21064046Built 1980 · Grathwohl Air LLCN500CKGulfstream Aerospace GVII-G500 · S/N 72061Built 2020 · Kojaian Aviation III LLCN501PRBombardier CL-600-2B19 · S/N 7584Penske CorpN531JDDassault FALCON 2000EX · S/N 135Built 2007 · Ronin Tori Leasing LLCN555WLCessna 560 · S/N 560-0488Built 1998 · Golf Air IncN55FVGulfstream Aerospace G-V · S/N 533Built 1997 · Ish Flight LLCN561PSBritish Aerospace HS 125-700A · S/N NA-0262Built 1980 · Tlc Aviation LLCN585EPCessna 525A · S/N 525A0346Built 2007 · Songbird LLCN58954Cessna 182P · S/N 18262424Built 1973 · Musheinesh Issa AN58ERTextron 525 · S/N 525-1157Built 2023 · Personnel Aviation Services LLCN616VJCirrus Design SR20 · S/N 9860Built 2024 · V2j LLCN6205APiper PA-38-112 · S/N 38-78A0343Built 1978 · Dorbzeldge Air Service LLCN63ERTextron 525B · S/N 525B0910Built 2026 · Personnel Aviation Services LLC
Back to Bloomfield Hills, MI