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 = 'IN' AND g.registrant_city = 'ROANOKE' 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 = 'IN' AND g.registrant_city = 'ROANOKE'
  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 = 'IN' AND g.registrant_city = 'ROANOKE'
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.

N118BDScottish SERIES 100 MDL 101 · S/N 118Built 1971 · Kortokrax Steven D N177KZCessna 177B · S/N 17702580Built 1976 · Bolinger Randy S N2210MPiper J3C-65 · S/N 21001Built 1946 · Meal Gary R N351CSCameron Balloons US ZL-70 · S/N 6626Built 2011 · Smart Christopher T N37923Piper J3C-65 · S/N 6706Kortokrax Steven D N3985JCessna 150G · S/N 15065285S & S Aviation LLC N453CSCameron Balloons US C-100 · S/N 6683Built 2012 · Smart Chris T N4655ACessna 180 · S/N 32252Built 1956 · Masten Kirk E N62503Cessna 172P · S/N 17275285Built 1981 · Back Forty Flying Club Inc N62854Beech A36 · S/N E-2008Built 1982 · High Flight Connections LLC N7152NBeech D55 · S/N TE-512Built 1968 · Chilian Cort N853ACCessna 560 · S/N 560-0774Built 2007 · Swihart Properties LLC N8807NPiper PA-28-140 · S/N 28-25653Built 1969 · Truax James D N8926TCessna 182C · S/N 52826Built 1960 · Bowlin George E N9033GCessna 182N · S/N 18260573Hillside Air Service LLC N9258CPiper PA-28-181 · S/N 2843002Built 1995 · Back Forty Flying Club Inc

Back to Roanoke, IN