Hudsonville, MI
Registered aircraft · 36
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 = 'HUDSONVILLE' 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 = 'HUDSONVILLE' 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.
N1170CMooney M20J · S/N 24-1313N119DKKoster Michael J MK-1 · S/N 001N119HHDJI AGRAS T50 · S/N 1581F6BUB23AM0015T65N120HHDJI AGRAS T100 · S/N 1581F8ZLC25B300217LCN18074Rearwin 9000-L · S/N 560-DN19402Rearwin 6000M · S/N 304N203CBQuad City Ultralight CHALLENGER II · S/N CH20987B0271N219BLFisher Flying Products DAKOTA HAWK · S/N 9252N2277XQuad City Ultralights CHALLENGER II · S/N CH2-0800-1992N2451UCessna 182S · S/N 18280943N25455Rearwin 8125 · S/N 810N25TACessna 340A · S/N 340A1538N282NQDJI T40 · S/N 1581F574B239600100NEN284HBPiper PA-31-325 · S/N 31-7912099N311UHDJI AGRAS T50 · S/N 1581F6BUB236S001006FN3395MPiper PA-12 · S/N 12-2237N37787Rearwin 8135 · S/N 896N4036LDestiny Powered Parachutes DESTINY 2000 · S/N 1C0227N41666Rearwin 8135 · S/N 915N428PBWilliam L Vander Molen WAG-AERO 2+2 · S/N 6N453SARaytheon A36 · S/N E-3453N4734JBeech A23-24 · S/N MA-172N521PCirrus Design SR22T · S/N 1841N5596JPiper PA-32-260 · S/N 32-1037N6143VBeech 35-C33 · S/N CD-866N622MCirrus Design SR22T · S/N 9787N6425LAmerican AA-5 · S/N AA5-0227Registration pendingN6611UMooney M20D · S/N 106N71824Luscombe 8A · S/N 3251N737KWCessna 172N · S/N 17269486N83791Aeronca 7AC · S/N 7AC-2469N90520Bell-Shippey BELL 47G · S/N WHL-61N9386GDJI AGRAS T30 · S/N 455LJ9120100BRN9515KPiper PA-28-151 · S/N 28-7615209N97606Stinson 108 · S/N 108-606N97666Stinson 108 · S/N 108-666
Back to Hudsonville, MI