Oxford, MI
Registered aircraft · 35
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 = 'OXFORD' 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 = 'OXFORD' 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.
N11ZMDiamond Aircraft Ind DA 40 · S/N 40.460N1593VCessna 172M · S/N 17263687N20035Firefly Balloons FIREFLY 9B-15 · S/N F9B-2014N21349Firefly Balloons FIREFLY 8B-15 · S/N F8B-2082N2183CCessna 177B · S/N 17702750N2192SFirefly Balloons FIREFLY 8B-15 · S/N F8B-2060N24BBAero Commander 112 · S/N 157N2584LBalloon Works FIREFLY 8B-15 · S/N F8B-435N2588UBalloon Works FIREFLY 8B-15 · S/N F8B-483N25967Balloon Works FIREFLY 7-15 · S/N F7-860N3017SFirefly Balloons 2010 FIREFLY 9B-15 · S/N F9B2023N3173KBalloon Works FIREFLY 9B-15 · S/N F9B-013N3183JCessna 150G · S/N 15065883N3185TBalloon Works FIREFLY 9B-15 · S/N F9B-017N3702BBalloon Works FIREFLY 7 · S/N F7-207N382CRCessna T303 · S/N T30300096N4202SFirefly Balloons 2010 FIREFLY 8B-15 · S/N F8B-2125N47728Piper PA-28R-201T · S/N 28R-7803006N52161O'Dea James D VANS RV9A · S/N 90046N542DRDonald B Reinholm RANS-D2 · S/N 111500132N56363Piper PA-28-140 · S/N 28-73-25618N5663YMaule MX-7-235 · S/N 10031CN58HHDiamond Aircraft Ind DA20-C1 · S/N C0666N636ATDiamond Aircraft Ind DA 40 · S/N 40.588N650KNDiamond Aircraft Ind DA20-C1 · S/N C0683N67RVCessna 172H · S/N 17255157N697MMPiper PA46R-350T · S/N 4692097N7090UBalloon Works FIREFLY 9B-15 · S/N F9B-024N7104RBalloon Works FIREFLY 8B · S/N F8B-093N7106RBalloon Works FIREFLY 7 · S/N F7-387N7112YBalloon Works FIREFLY 8-24 · S/N F8-118N7407KBalloon Works FIREFLY 7-B · S/N F7B-118N7714FCessna 150F · S/N 15063814Registration pendingN910NZCameron Balloons ZL-84 · S/N 6673N93611Ercoupe 415-C · S/N 934
Back to Oxford, MI