OpenAirDocs.org
Kalamazoo, MI

Registered aircraft · 118

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

N101SLPiper PA-23-160 · S/N 23-1832Built 1959 · Sweet Potato Flying Club LLCN10319Beech D-45 · S/N BG-318Built 1957 · Battle Creek Aero Club IncN104RPCessna 750 · S/N 750-0284Built 2008 · Speedbird X LLCN106DFXag P150 · S/N 186324P182234495XA27Drobny Farms LLCN1087EAeronca 7AC · S/N 7AC-4640Brindley MatthewN10945Cessna 150L · S/N 15075156Built 1973 · Ganton Aviation LLCN114MVAndrew C Millin MILLIN VELOCITY · S/N 1Built 2012 · Millin AndrewN120DDSimko Tom M KITFOX · S/N 120Murray Dale RN12KNCessna 421 · S/N 421-0130Built 1968 · Jane Air LLCN172LRCessna 172A · S/N 47607Built 1960 · Devillers Daniel RN177SHCessna 177B · S/N 17702294Built 1975 · Adams Richard DN1813GChampion 7ECA · S/N 596Built 1968 · Senior Flyers LLCN1822CCessna 182P · S/N 18262981Built 1974 · Brouwer Aviation LLCN20862Cessna 182P · S/N 18261267Built 1972 · Barrington Aviation LLCN214RDCessna 182G · S/N 18255546Built 1964 · Aardvark Aircraft LLCN235RSMaule M-7-235B · S/N 23044CBuilt 1998 · Flyboy71 LLCN241BWButcher J L/Butcher H L EUROPA XS · S/N A185Built 2005 · Butcher James L TrusteeN247BWWilson William C RV-7A · S/N 74032Built 2019 · 7bw LLCN252PCirrus Design SR22 · S/N 1002Built 2004 · Deck Air LLCN2552SPhantom PHANTOM X-1 · S/N 602Built 1984 · Wilkins Peter EN2747QCessna 182K · S/N 18257947Built 1967 · Mosier Michael JN29JBJohn Balkema JOHN DOE · S/N 007Built 2012 · Balkema JohnN29WDRobert A Smith GLASTAR GS-1 · S/N 5907Built 2023 · Smith Robert AN2AASteiner Russell C LANCAIR LEGACY · S/N L2K-251Built 2009 · Sapphire Skies LLCN303FWMooney M20K · S/N 25-0549Woodruff Peter MN3168EAeronca 11AC · S/N 11AC-1508Built 1946 · Kroll Richard LN338BARobert John Aardema AARDEMA SPACEWALKER · S/N 1Built 2018 · Aardema Robert JN34469Cessna 177B · S/N 17701826Built 1972 · Kroll Richard LN3573FCessna 182J · S/N 18257573Built 1966 · Lutke Michael TN35MVBeech V35A · S/N D-8617Built 1967 · Weaver KibweN373RSDassault FALCON 900 EX · S/N 291Built 2015 · Kalamazoo Group II LLCN3938JCessna 150G · S/N 15065238Built 1966 · Plainwell Aviation And Stem AcademyN39DBChampion 7GCBC · S/N 153Built 1969 · Kwasinski Mark WN3HPSocata TBM 700 · S/N 1019Built 2014 · One Golf Tango LLCN4048UCessna 150E · S/N 15061448Built 1965 · Oshtemo Flyers LLCN416AMDiamond Aircraft Ind DA 40 · S/N 40.543Built 2005 · Ganton Aviation LLCN4178EAeronca 11CC · S/N 11CC-80Built 1947 · West Michigan Aviation IncN4493EAeronca 7DC · S/N 7DC-108Built 1948 · Fnf Aviation LLCN44XXPiper AEROSTAR 601P · S/N 61P07398063362Built 1979 · Flyboy71 LLCN46396Cessna 172K · S/N 17257239Built 1968 · Kpa LLCN48PNNewberg Phillip Jon KITFOX IV 1200 · S/N HBS042May John PN50077Wasatch Wings MU 532 · S/N 0353Smith Clark WN514NSCourter Michael S RV-14A · S/N 140099Built 2026 · Courter Michael SN527JACanadair CL-600-2B16 · S/N 5058Built 1989 · Fg&N Plane Partners LLCN5421RCessna 172F · S/N 17252965Built 1965 · Aviation Design LLCN5435BCessna 182 · S/N 33435Built 1956 · Macomber Gregory SN5506MBellanca 7GCBC · S/N 1040-78Built 1978 · Cloud Kicker Aviation LLCN5724ZPiper PA-22-108 · S/N 22-9563Kpa LLCN5AZBell Textron Canada 429 · S/N 57468Built 2022 · Jetco LLCN604AMAircraft Mfg & Development CH 2000 · S/N 20-1010Toktay Omer K
Back to Kalamazoo, MI