OpenAirDocs.org
Saint Joseph, MI

Registered aircraft · 33

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 = 'SAINT JOSEPH'
  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.

N10WRBeech S35 · S/N D-7689Built 1964 · Wilson KeithN1337YCessna 172C · S/N 17249037Built 1961 · Gaipa Aircraft IncN140JKGerald F Kalin RV-14 · S/N 140601Gfk Investments LLCN18594Cessna 150L · S/N 15073970Built 1972 · Robinson Ronald WN201EBMooney M20J · S/N 24-0112First renewal noticeBuilt 1977 · Israel RajN205CSMooney M20J · S/N 24-0223Built 1977 · Fillwock Bryan TN2662UCessna 172D · S/N 17250262Built 1963 · Deal Sarah MN276JKPiper PA 46-350P · S/N 4636520Gfk Investments LLCN287RLPiper PA46-500TP · S/N 4697342Built 2008 · Southshore Aviation LLCN30TJPiper PA-30 · S/N 30-762Built 1965 · Fiskars Equipment CoN315MSMark Stone SONEX B · S/N SNB 0036Built 2025 · Stone Mark EN31HPHonda HA-420 · S/N 42000225Built 2022 · Tyl Leasing LLCN325UCessna 150M · S/N 15076531Built 1974 · Kilo Fox Aviation LLCN37HPDunker Dennis L AIR CAM · S/N AC067Built 1999 · Tyl Holdings LLCN38HPZohar Krivorot AIR-CAM · S/N AC250Built 2018 · Tyl Holdings LLCN404SEPiper PA-28R-200 · S/N 28R-7435223Built 1974 · Baird Jonathan DN4970YYamokoski William GLASTAR · S/N 5377Built 2002 · Yamokoski WilliamN529HPCessna T240 · S/N T24002054Built 2014 · Tyl Holdings LLCN5848HPiper PA-16 · S/N 16-467Built 1949 · White Terry WN62724North American SNJ-5 · S/N 43724Built 1958 · Gaipa Aircraft IncN6759HPiper J3C-65 · S/N 19972Gaipa Aircraft IncN71016Cessna 182M · S/N 18259459Built 1968 · Fiesbeck Kirt EN73116Cessna 172M · S/N 17267272Built 1976 · Taildraggers Flyers IncN733ZPCessna 172N · S/N 17268681Built 1977 · Fruit Belt Flyers IncN7609SCessna 182Q · S/N 18265257Built 1976 · Butzbaugh Elden W JrN76871Cessna 140 · S/N 11305Built 1946 · Gaipa TimN7919BDJI PHANTOM 4 · S/N 07DDD770B10071Vosburg Judson P JrN8448ZPiper PA-32R-301T · S/N 32R-8129112Built 1981 · Bliss Air LLCN845SCirrus Design SR22T · S/N 10558Built 2025 · Stanage Daniel LN8492YPiper PA-30 · S/N 30-1655Built 1967 · Gaipa Timothy AN94114Engineering & Research 415-C · S/N 1437Built 1946 · Sprunger Gary EN95192Piper PA-28-140 · S/N 28-25837Built 1969 · Kilo Fox Aviation LLCN9795KStinson 108-2 · S/N 108-2795Built 1947 · Godfrey Jay D
Back to Saint Joseph, MI