OpenAirDocs.org
Bay City, MI

Registered aircraft · 51

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 = 'BAY CITY'
  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.

N1003HAeronca 15AC · S/N 15AC-5Built 1948 · Light Winds Aviation LLCN122MSStaudacher Mark W VJ-22MS SPORTSMAN · S/N 845Built 2023 · Staudacher Mark WN132MSMark W Staudacher ACRO SPORT 1 · S/N 202601Staudacher Mark WN135JDDugger Joey D VOLMER VJ 22 · S/N 106Built 1988 · Morris Edward JN144MGCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 041Built 2005 · A-Z Aviation LLCN150BGCessna 310R · S/N 310R-0635Mbw Aviation LLCN17014Cessna 150L · S/N 15073581Alcorn Paul WN1889QCessna 177RG · S/N 177RG0289Built 1972 · Ruff Randall NN1973UCessna TU206F · S/N U20602316Built 1974 · Silver Fox Aviation LLCN22GDBeech 35-B33 · S/N CD-783Built 1964 · Magafly LLCN25NPAmerican Legend AL11 · S/N TX-1025Built 2013 · A-Z Aviation LLCN2846FCessna 182J · S/N 18256946A-Z Aviation LLCN29157Piper PA-32-300 · S/N 32-7940130Built 1979 · Midwest Aero IncN292KMBoyce Preece II HELICYCLE · S/N 5-03Built 2010 · Brocke Rodney AN3284HOgle Jack T RANS S6ES COYOTE II · S/N 09041606Built 2006 · A-Z Aviation LLCN340CLCessna 340A · S/N 340A-0105Built 1976 · Magafly LLCN340GBCessna 340A · S/N 340A0618Mbw Aviation LLCN362SHRockwell International 690A · S/N 11316Built 1976 · Flight-Plan One LLCN3705SCessna 172E · S/N 17250905Built 1963 · Gra Flying Club LLCN3847TPiper PA-28R-180 · S/N 28R-30168Built 1967 · Bay Air IncN3904UCessna 150E · S/N 15061304Kunkel Keith RN3911TPiper PA-28R-180 · S/N 28R-30246Martin Aviation Services LLCN421VACessna 421C · S/N 421C0219Built 1977 · Magafly LLCN427MCCessna 560 · S/N 560-0787Built 2008 · N427mc LLCN43093Taylorcraft BC12-D · S/N 6752Built 1946 · Kryzanowicz SusanN43178Taylorcraft BC12-D · S/N 6837Built 1946 · Barnstormers Aviation Club LLCN43500Taylorcraft BC12-D · S/N 7159Built 1946 · Staudacher Mark WN4460TPiper PA-28-140 · S/N 28-7225147Built 1972 · Ruff Randall NN470RVCessna 182M · S/N 18259314Built 1968 · Flyguys Aviation LLCN4896TPiper PA-28-140 · S/N 28-7225233Built 1972 · Vosler Dean SN5055MEdward James Morris DH2 · S/N 001Morris Edward JN550ABCessna 550 · S/N 550-0633Built 1990 · Abt Aviation LLCN553PGAviat A-1B · S/N 2318Built 2005 · Anderson Adam ZN567ECChampion 7EC · S/N 7EC-483Built 1956 · Staudacher Mark WN65819Destiny Powered Parachute 2000 · S/N IC0255Clark Douglas MN6610FCessna 150F · S/N 15063210Built 1966 · Cabala Nicholas CN6816WPiper PA-28-140 · S/N 28-20954Built 1965 · Cabala Dennis GN7085PPiper PA-24-250 · S/N 24-2238Built 1961 · Flyum LLCN75884Piper PA-20 · S/N 20-811Built 1956 · A-Z Aviation LLCN77HXEnstrom F-28C · S/N 4702Built 1979 · Appold Dave JN8166MCessna 310I · S/N 310I0166Magafly LLCN8214DBeech H35 · S/N D-5308Built 1957 · Staudacher Mark WN8273PCessna 180H · S/N 18051901Built 1967 · A-Z Aviation LLCN849CJJablonski Jaron C RV-8 · S/N 83849Built 2024 · Jablonski Jaron CN8835DPiper PA-22-160 · S/N 22-6005Built 1958 · Brocke Rodney AN9033LChampion 7GCBC · S/N 260-70Built 1970 · Bickmore David LN9082TCessna 182C · S/N 52982Built 1960 · Fly By Knights Aero Club IncN911VPStaudacher Mark W VP-1F · S/N 1Built 1997 · Staudacher Mark WN9123LChampion 7ECA · S/N 804-71Built 1970 · Appold Dave JN913STAviat PITTS S-2B · S/N 5258Built 1992 · Ruff Randall N
Back to Bay City, MI