Registered aircraft · 19

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 = 'SHELBY' 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 = 'SHELBY'
  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 = 'SHELBY'
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.

N2084TPiper PA-28R-200 · S/N 28R-7135028Built 1970 · Heiss Bryan G N2331WBeech A23A · S/N M-928Built 1965 · Empire Contractors N2404KSilvaire LUSCOMBE 8E · S/N 5131Built 1947 · Studer Rodney J N2559JCessna T188C · S/N T18803482TBuilt 1979 · Studer Alfred C N3650KPiper J3C-65 · S/N 22344Mladonicky Jospeh R N3834HErcoupe 415-D · S/N 4535Studer Rodney J N4660JCessna T188C · S/N T18803759TBuilt 1980 · Studer Al C N5324ADJI AGRAS T100 · S/N 1581F8ZLC258K002N0X5Better View Farm LLC N5327BDJI AGRAS T100 · S/N 1581F8ZLC258K002HVXXBetter View Farm LLC N5367DCessna 180A · S/N 50265Built 1958 · Bandrowicz Leon A N62983Cessna 150F · S/N 15063618Studer Rodney J N7066ZPiper PA-25-235 · S/N 25-2848Built 1964 · Studer Alfred C N7506ZPiper PA-25-235 · S/N 25-3538Built 1965 · Studer Al C N8095PPiper PA-24-250 · S/N 24-3344Built 1962 · Gramas Illya W N82059Aeronca 7AC · S/N 7AC-685Built 1946 · Studer Rod J N83600Aeronca 7DC · S/N 7AC-2276Built 1946 · Studer Pat N8876MBeech A23 · S/N M-618Built 1964 · Lohman Curtis N9083RCessna A188B · S/N 18802104TBuilt 1975 · Studer Alfred C N9540PPiper PA-25-235 · S/N 25-7405628Built 1974 · Studer Al C

Back to Shelby, MI