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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N12SNMooney M20TN · S/N 31-0019N19712Cessna 177B · S/N 17702586N2000DSchweizer SGS 1-35C · S/N 84N218KBLund Steven R HATZ KB1 · S/N 218N2995MCameron Balloons US N-105 · S/N 5139N3032PPiper PA-23 · S/N 23-943N309RRPelegrin TARRAGON · S/N TR202309036N31961Piper PA-32RT-300T · S/N 32R-7887017N331VNValmet VALMET L70 VINKA · S/N 21N3388UCessna 182F · S/N 18254788N34800Rearwin 8135 · S/N 871N3614Rees BREEZY · S/N 001N56413Piper PA-34-200 · S/N 34-7350329N57280Mooney M20J · S/N 24-1438N5902QMooney M20E · S/N 817N597BARaytheon B200 · S/N BB1851N59KYKenneth Eino Yokosawa RLU-1 · S/N 001N63RRThunder Balloons AX8-90 · S/N 732N6851FCessna 150F · S/N 15063451N7018XCessna 150A · S/N 15059118N7075RPiper PA-28-140 · S/N 28-21776N7166LCirrus Design SF50 · S/N 0750N720AMRaytheon B200 · S/N BB-1663N72610Cessna 120 · S/N 9786N728SADiamond Aircraft Ind DA20-C1 · S/N C0788N72980Cessna 140 · S/N 10181N768TAmerican Champion 7GCBC · S/N 1488-2025N780YBeech 58 · S/N TH-935N7817PPiper PA-24 · S/N 24-3037N984ZSCameron Balloons Z-90 · S/N 6203N99226Ercoupe 415-C · S/N 1849
Back to Grand Blanc, MI