White Lake, MI
Registered aircraft · 40
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 = 'WHITE LAKE' 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 = 'WHITE LAKE' 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.
N1193DAmerican General Acft AG5B · S/N 10055N12031Maule M-4 · S/N 41N127DGSchempp-Hirth VENTUS-2B · S/N 170N144JWPiper PA-22-160 · S/N 22-7286N14588Freebairn WITT'S V · S/N 38N1786TPiper PA-28-140 · S/N 28-7125101N1828MCessna 182S · S/N 18280893N182GSCessna 182K · S/N 18258101N2031PBeech A36 · S/N E-1349N206SCD Cybulski MURPHY REBEL · S/N 044RN21169Stinson HW75 · S/N 7028N223SCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC067N228CJCessna 172N · S/N 17269610N22LJVan Slooten EAA BIPLANE · S/N LJVS10565N2451QCessna 182K · S/N 18257651N26439Stinson 10 · S/N 7617N3069DCessna 310 · S/N 35269N310KTCessna 310A · S/N 38122N3523MPiper PA-12 · S/N 12-2369N370WEGregory T Hedderly PJ260 SENIOR AERO SP · S/N 179-00-01First renewal noticeN4144QCessna 310N · S/N 310N-0044N424RKAero Commander 560-A · S/N 238N4634CCessna 170B · S/N 25578N51BGPiper PA-24-250 · S/N 24-3017N51FACessna 172D · S/N 17249754N5445TCessna 172E · S/N 17251345N5813ZPiper PA-22-108 · S/N 22-9670N615RHEclipse EA500 · S/N 000068N68206Cessna 152 · S/N 15282184N736NNCessna R172K · S/N R1722659N738ERCessna TR182 · S/N R18200918N797BHQuicksilver MX II SPRINT 582 · S/N 0659N80088Cessna 172M · S/N 17266361N8215XCessna 172B · S/N 17248715N825MCBellanca 7ECA · S/N 1154-76N89252Cessna 140 · S/N 8272N89690Cessna 120 · S/N 8738N9473MCessna 210K · S/N 21059373N969MJAllen James S ACROSPORT 1 · S/N 798First renewal noticeN97156Cessna 182Q · S/N 18266996
Back to White Lake, MI