Grand Blanc, MI

Registered aircraft · 31

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 BLANC'
  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.

N12SNMooney M20TN · S/N 31-0019Built 2007 · Nechvatal Equipment Leasing LLCN19712Cessna 177B · S/N 17702586Humble Lewis NN2000DSchweizer SGS 1-35C · S/N 84Built 1977 · Mcallister Samuel MN218KBLund Steven R HATZ KB1 · S/N 218Built 1990 · Lund Deborah AN2995MCameron Balloons US N-105 · S/N 5139Dennis Chad WN3032PPiper PA-23 · S/N 23-943Built 1957 · Menard Charles HN309RRPelegrin TARRAGON · S/N TR202309036Built 2023 · Pjd Holdings LLCN31961Piper PA-32RT-300T · S/N 32R-7887017Built 1978 · Duncanson Scott AlexanderN331VNValmet VALMET L70 VINKA · S/N 21Built 1982 · Yokosawa Kenneth EinoN3388UCessna 182F · S/N 18254788Built 1963 · Menard Charles HN34800Rearwin 8135 · S/N 871Built 1941 · Heckman Phillip JN3614Rees BREEZY · S/N 001Built 1971 · Yokosawa Kenneth EinoN56413Piper PA-34-200 · S/N 34-7350329Built 1973 · Hupert Jason MN57280Mooney M20J · S/N 24-1438Built 1984 · Conklin Michael LN5902QMooney M20E · S/N 817Built 1965 · Yow Franklin SN597BARaytheon B200 · S/N BB1851Built 2004 · Mca-Plane LLCN59KYKenneth Eino Yokosawa RLU-1 · S/N 001Yokosawa Kenneth EinoN63RRThunder Balloons AX8-90 · S/N 732Dennis Sean MN6851FCessna 150F · S/N 15063451Built 1966 · Carr Thomas WN7018XCessna 150A · S/N 15059118Built 1961 · Menard Charles HN7075RPiper PA-28-140 · S/N 28-21776Built 1966 · Youngs William RN7166LCirrus Design SF50 · S/N 0750Built 2026 · Pjd Holdings LLCN720AMRaytheon B200 · S/N BB-1663Built 1999 · King Eagle II LLCN72610Cessna 120 · S/N 9786Built 1946 · Hupert Jason MN728SADiamond Aircraft Ind DA20-C1 · S/N C0788Mca-Plane LLCN72980Cessna 140 · S/N 10181Built 1946 · Kraemer Todd RN768TAmerican Champion 7GCBC · S/N 1488-2025Built 2025 · Pjd Holdings LLCN780YBeech 58 · S/N TH-935Built 1978 · Pack Larry LN7817PPiper PA-24 · S/N 24-3037Built 1962 · Goff Mark AN984ZSCameron Balloons Z-90 · S/N 6203Chad DennisN99226Ercoupe 415-C · S/N 1849Built 1946 · Mcclellan Fred
Back to Grand Blanc, MI