Grand Haven, MI
Registered aircraft · 44
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 HAVEN' 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 HAVEN' 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.
N1367Baby Great Lakes JGM-1 · S/N M-10N140BGBurkhart Grob G 103 TWIN II · S/N 33902-K-140N15CTBeech 65-A90 · S/N LJ-192N1618BBuckeye DREAM MACHINE 582 · S/N 3691N1621DCessna 170A · S/N 20263N22177Cessna 177B · S/N 177-02323N2259LBeech C23 · S/N M-1898N2305VCessna 140 · S/N 14541N2515UPiper PA-28-161 · S/N 28-8016026N256BColonial C-1 · S/N 16N266WBBell W Douglas RV-8 · S/N 80889N2790JCessna A150M · S/N A1500602N2910EAeronca 7AC · S/N 7AC-6493N301KAPiper PA-32R-301 · S/N 32R8113020N316KGDiamond Aircraft Ind DA 62 · S/N 62.C039N320BGGreene Brian R RV-7 · S/N 73988N333CRPiper PA-30 · S/N 30-1671N36037Taylorcraft BF12-65 · S/N 3001N3965DBurnis Marcus G CYGNET SF2A · S/N 131N40400Piper PA-23-250 · S/N 27-7305164N406DELake LA-4-200 · S/N 487N4244KRyan NAVION · S/N NAV-4-1244N43686Taylorcraft BC12-D · S/N 7345N52738Mcintyre Patrick W SONERAI-I · S/N 00126N5773YPiper PA-23-250 · S/N 27-2902N700TDScott Terry LANCAIR IV P · S/N LIV-343N704PWCessna 150M · S/N 15078775N7107ACessna 172 · S/N 29207N7143FPiper PA-28-151 · S/N 28-7715199N737MBBeech N35 · S/N D-6764N7581EChampion 7FC · S/N 7FC-269N764AFSchweizer SGM2-37 · S/N 12N7837RBeech D55 · S/N TE-675N7XFMoore Alva L GLASAIR III · S/N 3235N80483Cessna 172M · S/N 17266611N84GMSchlater Augustus T VANS ACFT RV-9A · S/N 90358N85NUHonda HA-420 · S/N 42000135N8795BCessna 172 · S/N 36495N88010Piper J3C-65 · S/N 15628N946JJPilatus PC-12 · S/N 115N9618UGrumman American Avn. AA-5 · S/N AA5-0818N9662EAeronca 11AC · S/N 11AC-1305N96899Taylorcraft BC12-D · S/N 9199N977QBeech P35 · S/N D-6923
Back to Grand Haven, MI