OpenAirDocs.org
Berrien Springs, MI

Registered aircraft · 25

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 = 'BERRIEN SPRINGS'
  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.

N1019TPiper PA-44-180 · S/N 4496232Built 2006 · Andrew UniversityN1407TPiper PA-34-200 · S/N 34-7250311Built 1972 · Andrews UniversityN15610Piper PA-28-180 · S/N 28-7305097Built 1972 · Stull Christopher HN18554Cessna 150L · S/N 15073938Built 1972 · Lavelle Jonathan AN2261QPiper PA-28-181 · S/N 28-7790386Built 1977 · Andrews UniversityN23018Cessna 150H · S/N 15068681Built 1968 · Andrews UniversityN25979Cessna 152 · S/N 15280892Andrews UniversityN25NYGates Learjet 25D · S/N 304Built 1980 · Andrews UniversityN27AUPiper PA-28-181 · S/N 2843768Built 2014 · Andrews UniversityN28AUPiper PA-28-181 · S/N 2843781Built 2014 · Andrews UniversityN2921JCessna 150G · S/N 15065721Built 1966 · Andrews UniversityN3461EAeronca 11AC · S/N 11AC-1762Built 1947 · Young Barry NN4338MPiper PA-28-181 · S/N 28-8490048Andrews UniversityN47NFCessna 310E · S/N 60-6047Andrews UniversityN480MDEnstrom Helicopter 480B · S/N 5115Built 2007 · J&H Aicraft Leasing LLCN4946LPiper PA-28-180 · S/N 28-4315Built 1967 · Andrews UniversityN6057QMooney M20E · S/N 892Built 1966 · Kennedy Kyle RN615ADPiper PA-12 · S/N 12-229Built 1946 · Hill Douglas LN704DBCessna 150M · S/N 15078519Built 1976 · Andrews UniversityN704WFCessna 150M · S/N 15078926Built 1976 · Foxtrot Flight Training LLCN75146Piper PA-28-140 · S/N 28-7625203Built 1976 · Gaiser Richard MarkN8871VBellanca 17-30A · S/N 30427Built 1972 · Lavelle Aircraft LLCN9719UGrumman American Avn. AA-5A · S/N AA5A-0119Built 1976 · Butler Jon MN975Beech 95-B55 (T42A) · S/N TC-2056Built 1977 · J&H Aircraft Leasing LLCN99ECessna 150G · S/N 15066141Built 1967 · Andrews University
Back to Berrien Springs, MI