Grand Rapids, MI

Registered aircraft · 154

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 = 'GRAND RAPIDS'
  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.

N1219MTextron 680A · S/N 680A0192Built 2019 · Meijer Distribution IncN1226GSchweizer SGS 2-33A · S/N 397West Michigan Aviation AcademyN122KSCessna 172H · S/N 17255255Built 1966 · Pt Arts LLCN1270TPiper PA-28-180 · S/N 28-7205274Built 1972 · Tubman Wilbur CN147DKD Swanson / K Swanson SEAREY LSX · S/N 1LK568CBuilt 2013 · Specialty Aerospace LLCN15RGCirrus Design SF50 · S/N 0277Built 2021 · N15rg LLCN17098Cessna 150L · S/N 15073622Built 1972 · Lake Michigan Asset Management LLCN172PJCessna 172H · S/N 17255099Built 1966 · Slykhouse Gary BN1755WBeech A36 · S/N E-374Built 1972 · Ais Construction Equip CorpN176AMSikorsky S-76C · S/N 760665Built 2007 · Spectrum Health HospitalsN17971Schweizer SGS 2-33A · S/N 271Built 1973 · West Michigan Aviation AcademyN184QBeech K35 · S/N D-5954Built 1959 · Schmuker David JosephN186ABSix Chuter SIX CHUTER SR5 · S/N 98 2002 SR5XPBuilt 1998 · Steffens Edward CN1907MTextron 560XL · S/N 560-6201Built 2015 · Meijer Distribution IncN1933NBombardier BD-100-1A10 · S/N 20133Built 2006 · Northern Jet Management IncN1934FTextron 680A · S/N 680A0448Built 2025 · Meijer Distribution IncN19GGGoodier BOWERS FLY BABY · S/N 67-1Built 1978 · Krzciok MichaelN2022LLearjet 45 · S/N 609Built 2022 · Bravo Holding LLCN221DEPilatus PC-12/47E · S/N 2077Built 2021 · Otter Air Services LLCN222DEPilatus PC-12/47E · S/N 2173Built 2022 · Otter Air Services LLCN222JYBeech 400A · S/N RK-4Built 1990 · Higher Cause Too LLCN222NELearjet 45 · S/N 110Built 2000 · Higher Cause LLCN22328Huff George R AVID FLYER · S/N 637Built 1990 · Bawtinheimer Kris JN223DEAirbus Helicopters EC 130 T2 · S/N 8693Built 2019 · Cdv Se Properties LLCN224DEPilatus PC-24 · S/N 313Built 2023 · Otter Air Services LLCN225DEPilatus PC-24 · S/N 334Built 2023 · Otter Air Services LLCN2387GCessna 182B · S/N 51687Built 1959 · Pitsch Air ServiceN2411JCessna 150G · S/N 15065511Built 1966 · Kenney Jason MN2419JCessna 150G · S/N 15065519Built 1966 · Scheller Dwain AN24UGTextron 525B · S/N 525B0577Built 2019 · Northern Jet Management IncN251DVGulfstream Aerospace GVII-G600 · S/N 73114Built 2023 · 600 Aviation LLCN252DVGulfstream Aerospace GV-SP (G550) · S/N 5463Built 2014 · G550 Aviation LLCN254DVEmbraer EMB-550 · S/N 55020146Built 2021 · 600 Aviation LLCN255DVEmbraer EMB-550 · S/N 55020147Built 2021 · 600 Aviation LLCN255FPTextron 750 · S/N 750-0527Built 2017 · Ufp Industries IncN256DVCessna 525C · S/N 525C0049Built 2011 · Rdv Aviation LLCN257DVCessna 525C · S/N 525C0052Built 2011 · Rdv Aviation LLCN258DVEmbraer EMB-550 · S/N 55020180Built 2023 · 600 Aviation LLCN259DVAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21019Built 2021 · Rdv Leasing LLCN2626CDJI FLYCART 30 · S/N 1581F7C6B243E001U8S6Registration pendingN2656CCessna R182 · S/N R18200196Built 1978 · Hgta Partners LLCN2659YBauer Lawrence PA-18 REPLICA · S/N LB-15Built 2003 · Bauer Lawrence LN268RBGulfstream Aerospace GVII-G600 · S/N 73120Built 2023 · Gaby N268rb LLCN272BCBombardier BD-100-1A10 · S/N 20862Built 2020 · Bissell IncN274EJCirrus Design SR22T · S/N 9524Built 2023 · Jab23 LLCN29200Wilder BD-4 · S/N 241First renewal noticeBuilt 1976 · Dream Aircraft IncN3029TCessna 320C · S/N 320C-0029Built 1964 · Consolidated Resource Imaging LLCN30691Cessna 177B · S/N 17701407Built 1969 · Hayden BoyceN316VAGulfstream Aerospace GV-SP (G550) · S/N 5530Built 2015 · Avation LLCN327DWTextron B200GT · S/N BY-327Built 2018 · North Flight Aero Med
Back to Grand Rapids, MI