Registered aircraft · 16

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'BYRON CENTER' ORDER BY g.n_number

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 = 'BYRON CENTER'
  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 = 'BYRON CENTER'
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.

N158MRHawker Beechcraft G58 · S/N TH-2312Built 2011 · T-Bird LLC N1714GBeech 35-B33 · S/N CD-482Bull Rises LLC N1989QCessna 177RG · S/N 177RG0389Built 1973 · Delta Bravo Aviation N222JEDassault FALCON 2000EX · S/N 173Built 2008 · Higher Cause LLC N309CJCessna 525A · S/N 525A0309Built 2006 · Je Air LLC N373YPPowrachute PEGASUS · S/N A521PEGBuilt 2025 · Svabic Shimo N39GDTiger AG-5B · S/N 10250November Sierra Romeo LLC N5083ZPiper PA-22-108 · S/N 22-8714Built 1961 · Morell Patrick J N612DPCessna 182T · S/N 18281953Built 2007 · Carlson Glenn Alan N6561CCessna 414A · S/N 414A0014Built 1977 · Trtc Aviation LLC N680MKCessna 680 · S/N 680-0348Built 2013 · Mike Kilo Aviation LLC N756MHCessna R182 · S/N R18201111Built 1979 · Klingel Jeffery S N795SCCirrus Design SR22T · S/N 2053Built 2020 · N795sc LLC N7970UCessna 172F · S/N 17251970Built 1964 · Chard Robert L N831AKVoss Albert GLASAIR I · S/N 772Built 1994 · Jablonski Francis R III N9235TMaule M-7-235 · S/N 4126CMv Aviation LLC

Back to Byron Center, MI