OpenAirDocs.org
West Bloomfield, MI

Registered aircraft · 41

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

N113EJPiper PA-28-151 · S/N 28-7715075Built 1976 · Ixi LLCN123SXAir Fly Balonisimo E Inflaveis AF-SS-40 · S/N LP2018-02Built 2018 · Mastis Linas VN13KGCessna 340A · S/N 340A0215Carroll Jeffrey PN1689HPiper PA-28-181 · S/N 28-7790333Ixi LLCN1748ZCessna 210-5 · S/N 205-0047Built 1962 · Ranz Douglas RN17WNRaytheon A36 · S/N E-3536Kadans Air LLCN181SHAir Fly Balonisimo E Inflaves AF-SS-09 · S/N LP2010-01Built 2010 · Mastis Linas VN184ERBeech 76 · S/N ME-267Built 1979 · Ixi LLCN1915ZCessna 150C · S/N 15059715Built 1962 · Gruskin Zachary QN24019Beech C23 · S/N M-1924Built 1977 · Orr Stevan JN26LFCessna 421C · S/N 421C0710Forte PaulN2885BPiper PA-28-161 · S/N 28-7916513Ixi LLCN3553MPiper PA-28-181 · S/N 28-7890314Built 1978 · Ixi LLCN3897BBeech F35 · S/N D-4304Built 1955 · Diamond Stephen CN406FDAgusta F.260D · S/N 771Built 1990 · Fitzsimons Raymond J IIIN411AMAerostar International RAVEN S-60S · S/N S60S3004Built 2000 · Mastis Raminta IN4210AKennedy H F Ken SAG 1000 · S/N KY1Built 1991 · Mastis Linas VN42845Ray Gary Allen ZODIAC 601XL · S/N 6-5356Built 2006 · Ray Gary AN5031SPiper PA-28R-200 · S/N 28R-35790Built 1970 · Brodowsky ThomasN5337FPiper PA-28-181 · S/N 28-7790092Built 1976 · Ixi LLCN558JTPiper PA46R-350T · S/N 4692051Built 2008 · R2jm Leasing LLCN55EMPiper PA-28-151 · S/N 28-7415328Built 1974 · Ixi LLCN619MJCirrus Design SR22T · S/N 9494Built 2023 · Vision Transport LLCN6288JPiper PA-28-181 · S/N 28-7690393Built 1976 · Ixi LLCN70ALMckinnon G21G · S/N 1226Built 1970 · Killa Katchka IncN71FLPiper PA-23-250 · S/N 27-3969Built 1968 · West Transportation LLCN7477ECessna 210 · S/N 57177Bravo 70 LLCN7930FPiper PA-28-151 · S/N 28-7715248Built 1976 · Ixi LLCN796LMBeech 35-C33 · S/N CD-951Built 1965 · N796lm LLCN8239VPiper PA-28-236 · S/N 28-8011124Built 1980 · Mitten Adventures LLCN828MBCirrus Design SR22T · S/N 8655Built 2022 · Bel Aviation LLCN840PNGulfstream AM Corp Comm Div 690C · S/N 11679Built 1981 · West Transportation LLCN85251Aeronca 7AC · S/N 7AC-3985Built 1946 · Baeder Ryan MN8570FPiper PA-28-181 · S/N 28-7790258Built 1976 · Ixi LLCN875DSPiper PA-28-235 · S/N 28-7410102Hall Christopher LN9067ZNorth American T-6G · S/N 49-3001Built 1949 · Killa Katchka IncN909SCLuiz Paulo Gnecco Rodrigues De AF-SS-14 · S/N LP-2013-01Built 2013 · Mastis Linas VN9174YComstock Bruce P TRAVEL-80 · S/N 001Mastis Linas VN950LMCameron Balloons CAMERON SAUCER-80 · S/N 1641Magical Adventures LLCN969SRCirrus Design SR22 · S/N 2111Built 2006 · Hull Michael DN97CJCessna 525A · S/N 525A-0097Built 2002 · Starr Aircraft LLC
Back to West Bloomfield, MI