Saginaw, MI
Registered aircraft · 30
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 = 'SAGINAW' 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 = 'SAGINAW' 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.
N1414LBeech A23 · S/N M-806N15571Piper PA-28-140 · S/N 28-7325102N1973GPiper PA-28-180 · S/N 28-7305358N29305Piper PA-28RT-201 · S/N 28R-7918134N302RLDJI AGRAS T50 · S/N 1581F6BUB24B20017FZ9N327GBeech A36 · S/N E-2910N3955WXag P150 · S/N 186324P18223449U666NN41CLLukas Charles L RAF 2000 GTX SE · S/N H2-96-7-264N427DDPiper PA-31T · S/N 31T-7820029N432NCPiper PA-32RT-300 · S/N 32R-7885090N45409Grumman American Avn. AA-5B · S/N AA5B1316N48102Taylorcraft DC-65 · S/N 4974N548JSOstrander Jimmie L HONEY BEE G2 · S/N OJL001N551ZTGteex Revolution INDEPENDENCE 19 · S/N 212985300C850N5665VPiper PA-28-181 · S/N 28-7790491N569LMCessna 560 · S/N 560-0068N5882FPiper PA-28-181 · S/N 28-7790140N6181CCessna 310R · S/N 310R1320N6269NCessna 340A · S/N 340A0454N666QDJeffrey G Davison CHALLENGER CH I · S/N 0810-0805N702TPPerry Brian F RV-14A · S/N 140588N705MCHylio AG 230 · S/N 100395N788ACGteex Revolution INDEPENDENCE 19 · S/N 212985300C70EN7967XCessna 172B · S/N 17248467N8452RPiper PA-28-161 · S/N 28-8216041N915TBeech 35-33 · S/N CD-115N91791Cessna 182M · S/N 18259909N925PTCessna 182T · S/N 18281217N927KGTextron 525C · S/N 525C0213N9784MMooney M20F · S/N 680201
Back to Saginaw, MI