OpenAirDocs.org
Ann Arbor, MI

Registered aircraft · 162

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 = 'ANN ARBOR'
  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.

N1010HAeronca 15AC · S/N 15AC-347Built 1949 · A2 Aero LLCN1047ZSchleicher Alexander K 7 · S/N 7147Built 1964 · Dyer Evan HN119MSCessna 210J · S/N 21059121Built 1969 · Aeronorth LLCN120WECessna 182T · S/N 18281117Built 2002 · Harbor Air IncN1240SCook Grant A ONEX · S/N 0NX0124Cook Grant AN132PBeech C23 · S/N M-2194A2 Supersonic LLCN1377SCessna 172S · S/N 172S9840Built 2005 · University Of Michigan Flyers IncN1378HAeronca 15AC · S/N 15AC-427Built 1949 · Pinsky Harold MN142CBCameron Balloons O-84 · S/N 408Aerostatica Inc DBAN155UMEurocopter EC 155 B1 · S/N 6934Built 2011 · Regents Of The University Of MichiganN156UMEurocopter EC 155 B1 · S/N 6935Built 2011 · Regents Of The University Of MichiganN157UMEurocopter EC 155 B1 · S/N 6933Built 2011 · Regents Of The University Of MichiganN158CRRobinson Helicopter R44 · S/N 2466Built 2017 · A2heli LLCN15RWWilliams BRYAN ACFT RS-15 · S/N 16Built 1974 · Domeier JoachimN16XTCameron Balloons US XT-65 · S/N 6946Built 2021 · Aerostatica Inc DBAN177MCessna 177RG · S/N 177RG1356Midwest Aviators LLCN181BMSmith-Dwight BIRDMAN TL-1A · S/N 181Smith Dwight SN191DZlin 142C · S/N 0555Built 1993 · Loomis John JrN19384Cessna 150L · S/N 15074381Built 1973 · Armstrong Thomas JN1962NCessna 140 · S/N 12198Built 1947 · Powell Kenneth WN2035XCameron Balloons US A-105 · S/N 6564Aerostatica Inc DBAN203GTCessna 172N · S/N 17272403Built 1979 · University Of Michigan Flyers IncN2057KLuscombe 8E · S/N 4784Built 1947 · Moghadam JackN205DSDiamond Aircraft Ind DA 40 · S/N 40.205Built 2002 · University Of Michigan Flyers IncN2064EAeronca 7AC · S/N 7AC-5634Built 1946 · Pinsky Harold MN22487Cessna 150H · S/N 15068312Built 1968 · Skyguard Instruction LLCN248SSchleicher AS-K13 · S/N 13003Dyer Evan HN253CDCirrus Design SR22 · S/N 0448Built 2003 · Angell John CN260EZMurphy John F LONG EZ · S/N 260Built 1991 · Murphy John FN262ASPiper PA-31 · S/N 31-7712102Built 1977 · Aerodata LLCN26ENCameron Balloons US Z-105 · S/N 7052Built 2026 · Aerostatica Inc DBAN26XTCameron Balloons U S XT-60 · S/N 7050Built 2026 · Aerostatica Inc DBAN2727CCessna 170B · S/N 26271Built 1954 · Wennersten Donald AN276MMCameron Balloons U S Z-315 · S/N 7055Aerostatica Inc DBAN28143Piper J5A · S/N 5-116Built 1940 · Powell Kenneth WN2873UPiper PA-32-300 · S/N 32-7940171Baker Douglas RN29777Cameron Balloons N-77 · S/N 629Aerostatica Inc DBAN2991QCameron Balloons US N-105 · S/N 5219Aerostatica Inc DBAN3025WCameron Balloons U S A-90 · S/N 6884Aerostatica Inc DBAN3065YCameron Balloons US C-80 · S/N 6062Built 1996 · Aerostatica Inc DBAN315BGDoug Gross KALLITHEA · S/N K0033Built 2023 · Mclaren Investments Partners LLCN32292Piper PA-28-151 · S/N 28-7515115Built 1974 · Mdr Rental CorpN331CSBeech P35 · S/N D-7126Bauer MatthiasN333UMCessna 152 · S/N 15284751Built 1980 · University Of Michigan Flyers IncN33UMCessna 525B · S/N 525B0020Built 2005 · First Charter Service CorpN3543NPiper J3C-65 · S/N 22776Built 1947 · Onstep LLCN356CPiper PA-28-140 · S/N 28-20995Built 1965 · Winkler Noel AN358PVCameron Balloons US Z-105 · S/N 7043Built 2026 · Aerostatica Inc DBAN36AXBeech A36 · S/N E-2579Built 1990 · North Flight Air LLCN3732DCessna 182A · S/N 34432Built 1957 · Clark William M
Back to Ann Arbor, MI