Tecumseh, MI
Registered aircraft · 48
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 = 'TECUMSEH' 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 = 'TECUMSEH' 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.
N127HMGrow SKYRAIDER · S/N 1N1593LBeech F33A · S/N CE-637N1759VCessna 172M · S/N 17263741N2156GCessna 182A · S/N 51456N227CStinson 108-2 · S/N 108-3227N2386ECessna 172N · S/N 17271261N24JLAerotek PITTS S-2A · S/N 2011N250WTShultz Robert G KITFOX II · S/N 322N2876HErcoupe 415-C · S/N 3501N3045BCessna 195B · S/N 7928N3108JCessna 150G · S/N 15065808N3122SCessna 182G · S/N 18255622N34360Meyers MAC-145 · S/N 203N3784KPiper PA-28-140 · S/N 28-23729N4571XPiper PA-28-181 · S/N 28-7690039N498CMGay John K RV 8 · S/N 82208N5006ACessna 172 · S/N 28006N5052JPowrachute PEGASUS · S/N A074ULSN52022Boeing A75N1(PT17) · S/N 75-4273N551FMDJI INSPIRE 1 · S/N W13DCA23020804N6066KKilcer John S EUROPA XS · S/N A127N606CCCub Crafters CC11-100 · S/N CC11-00039N6142ECessna 172 · S/N 46242N618KVDJI INSPIRE 1 · S/N W13DCA31020152N644WZDJI PHANTOM 3 PROFESSION · S/N 03Z0012547N645YBDJI PHANTOM 3 PROFESSION · S/N 03Z0030009N6840GCessna 150L · S/N 15072340N713HDehavilland DHC-1 T.MK. 10 · S/N WB690N73801Commonwealth 185 · S/N 1861N7393XCessna 150B · S/N 15059493N747SSSmokovitz Joseph M SMOKOVITZ-SPORT · S/N 1001N747XSmokovitz FLYBABY · S/N 19340N7807ZCessna 150C · S/N 15059907N8128SCessna 150F · S/N 15061728N82881Champion 7AC · S/N 7AC-1531N83426Aeronca 7AC · S/N 7AC-2093N83987Aeronca 7AC · S/N 7AC-2673N85480Champion AERONCA 7AC · S/N 7AC-4220N85996Dehavilland TIGER MOTH DH82 · S/N MPFC-TM1N8696RCorben Baby Ace D · S/N 1N87040Ercoupe 415-C · S/N 213N8830GCessna 150F · S/N 15062930N902GPPowrachute AIRWOLF 912ULS · S/N A364ULSN925WStinson SM-8A · S/N 4094N9508RBeech K35 · S/N D-6087N96018Taylorcraft BC12-D · S/N 8318N98157Piper J3C-65 · S/N 18319N98208Piper PA-28-140 · S/N 28-26105
Back to Tecumseh, MI