Traverse City, MI
Registered aircraft · 111
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 = 'TRAVERSE CITY' 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 = 'TRAVERSE CITY' 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.
N10816Piper PA-24-260 · S/N 244753N1304UCessna 172M · S/N 17266996N138QBeech 95-B55 (T42A) · S/N TC-612N14CXPiper PA-46-310P · S/N 4608107N157KCCessna 172S · S/N 172S11037N157PHBombardier BD-100-1A10 · S/N 20715N15861Piper PA-28-180 · S/N 28-7305167Registration pending, pending cancellationN159MCFairchild SA227-AC · S/N AC-728BN1726MWsk-Pzl Mielec MIG 17F (LIM 5) · S/N C017-26N172FACessna 172S · S/N 172S11167N17GMTextron 172S · S/N 172S12769N17MVTextron 172S · S/N 172S12598N182NWCessna 172S · S/N 172S11043N183NWCessna 172S · S/N 172S11083N184NWCessna 172S · S/N 172S11085N1856QCessna 177RG · S/N 177RG0256N1926WBeech B19 · S/N MB-587N195NWCessna 172S · S/N 172S11095N21377Aeronca 65-C · S/N C-1948N2231JPiper PA-32RT-300 · S/N 32R-7985053N2272DCessna T206H · S/N T20608743N228NWDJI AGRAS T20P · S/N 64UBL85002001VN2298TCessna R182 · S/N R18200023N241TNPiper PA-23-250 · S/N 27-7954110N2483FCessna 180H · S/N 18051685N2493PAirborne XT 582 · S/N XT-582-04-CZ-017N263GWVans RV-12IS · S/N 12105N264GWVans RV-12IS · S/N 12130N27MVTextron 172S · S/N 172S12599N296NWCessna 172S · S/N 172S11096N300VSHedekin Thomas S BUCCANEER II · S/N B2A-072-582N3056SPiper PA-28RT-201 · S/N 28R-7918058N3057VPiper PA-34-200T · S/N 34-7970168N3064ZPiper PA-22-160 · S/N 22-7019N3071MPiper PA-12 · S/N 12-1757N3108BSwearingen SA227-AC · S/N AC509N3207PPiper PA-23-150 · S/N 23-1147N3218XRaytheon A36 · S/N E-3358N3250UCessna 182F · S/N 18254650N3327RCessna 182L · S/N 18258627N3341APiper PA-22-135 · S/N 22-1507N345HGBombardier BD-100-1A10 · S/N 20431N360TKJim Kimball Enterprises 12 · S/N 272N3926Alisport SILENT 2 · S/N 2002N401HKEvolution REVO · S/N 000623N404CHPiper PA-23-250 · S/N 27-7654191N418SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0523N4195RCessna 182S · S/N 18280364N43018Taylorcraft BCS12-D · S/N 6677N430MAFairchild SA227-AC · S/N AC-710B
Back to Traverse City, MI