OpenAirDocs.org
Birmingham, MI

Registered aircraft · 44

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

N121PZEmbraer-Empresa Brasileira De EMB-500 · S/N 50000153Built 2010 · Aero One LLCN129LBLindstrand Balloons 90A · S/N 5102Built 1999 · Mckenzie Dawn RN13239Cessna 172M · S/N 17262600Built 1973 · Gusto Air LLCN139TBAero Vodochody L-39 · S/N 432919Built 1984 · Brig Air 5 LLCN140MPMalcolm S Pond VANS AIRCRAFT RV-14 · S/N 140414Built 2019 · Cds Worldwide Consultants PllcN1422HAeronca 15AC · S/N 15AC484Registration revokedBuilt 1950 · Nedley A LloydN17PZPiper PA-28-181 · S/N 28-8190255Built 1981 · Pro-Air Of Oakland IncN192JRCessna A185F · S/N 18502286Cessna 185 LLCN19TGGauthier Ted HOT AIR BALLOON · S/N 001Built 1998 · Mckenzie Dawn RN211CCCessna 680 · S/N 680-0034Built 2005 · Orchard Aviation LLCN220UMPiper PA46-500TP · S/N 4697183Built 2004 · 3k Aviation LLCN23WSBeech B200 · S/N BB-1143Dovey Air IncN258SPSocata TBM 700 · S/N 561Built 2010 · Astro Aviation LLCN25HUAviat A-1C-200 · S/N 3459Built 2025 · Fly 248 LLCN2DFGulfstream Aerospace GIV-X · S/N 4096Suburban Properties 3 LLCN32082Piper PA-28-151 · S/N 28-7515065Built 1974 · 7550g LLCN320MMAmerican Champion 7GCBC · S/N 1231-97Built 1997 · Explorer Aviation LLCN327BSGulfstream Aerospace GVII-G500 · S/N 72060Built 2020 · Ehc Holdings IV LLCN327SCEmbraer Executive EMB-505 · S/N 50500737Built 2023 · Ehc Holdings V LLCN3437MPiper PA-28-181 · S/N 28-7890301Built 1977 · 7550g LLCN365ACBeech B36TC · S/N EA-479Built 1988 · Evalidate LLCN38WRCessna T182T · S/N T18209058Built 2012 · Cds Worldwide Consultants PllcN4126SBeech 95-B55 (T42A) · S/N TC-1848Built 1975 · Av Advantage LLCN430SACessna 650 · S/N 650-7041Built 1994 · Lks Aviation LLCN4888CCessna T210N · S/N 21063656Built 1979 · Goflight IncN511WYCirrus Design SR22T · S/N 8735Built 2022 · Peak Air LLCN515EVCessna 525A · S/N 525A0211Built 2004 · Brig Air 4 LLCN551CZCessna 550 · S/N 550-0028Built 1978 · Brig Air 2 LLCN5559CCessna 170A · S/N 19612Built 1950 · Fereday Clinton J JrN5581RCessna 172F · S/N 17253180Cousins Aviation IncN558BFCessna 421C · S/N 421C0845Matrix Aviation LLCN5813MCirrus Design SR22T · S/N 2414Built 2021 · Mehta Aviation LLCN608JRCessna 560XL · S/N 560-5171Built 2001 · Excel Aviation LLCN61XTCameron Balloons U S XT-60 · S/N 6993Built 2023 · Mckenzie DawnN704JBBombardier BD-100-1A10 · S/N 20376Built 2012 · Jimmie Johnson Racing II IncN737CMBoeing 737-7BC · S/N 30327Built 1999 · Wren Acquisitions LLCN739XACessna 172N · S/N 172708787550g LLCN7550GCessna 172L · S/N 17259250Built 1970 · 7550g LLCN7934GCessna 172L · S/N 17259634Built 1970 · 7550g LLCN857SSDassault FALCON 2000EX · S/N 192Simon Aviation LLCN892HMCessna 501 · S/N 501-0320Built 1983 · Brig Air LLCN92214Cessna 182N · S/N 18260094Built 1969 · Sfh Aviation LLCN92BSGulfstream Aerospace G-IV · S/N 1502Built 2003 · S&E Aviation LLCN935EFTextron 680A · S/N 680A-0075Built 2017 · Troy Aviation LLC
Back to Birmingham, MI