Registered aircraft · 17

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 = 'NC' AND g.registrant_city = 'CHERRYVILLE' 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 = 'NC' AND g.registrant_city = 'CHERRYVILLE'
  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 = 'NC' AND g.registrant_city = 'CHERRYVILLE'
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.

N11RARobinson Helicopter R44 · S/N 1951Monkey Biziness LLC N1691FCessna 172H · S/N 17255086Built 1966 · Vess Joel W N169TBMarrone Vincent Q2 · S/N 2222Built 1991 · Vess Joel W N2072EAxelrod Dana Philip RENEGADE · S/N 119PBuilt 1990 · Black James M N2298FCessna 310L · S/N 310L-0098Built 1967 · Tarheel Aviation LLC N35468Piper J3C-65 · S/N 6372Built 1941 · Vess Joel W N3882QCessna 172L · S/N 17259982Built 1971 · Riddle Kenneth G N402PBBolenbaugh Phillip William RANS S-6ES · S/N 06061751-ESBuilt 2007 · Peeler James K N5QLQuasar Acft 214SL · S/N 005Built 2007 · Peeler James K N61107Flightstar II FIX WING · S/N 21553Built 2000 · Peeler James K N6205CCoggins Charles RANS S-12XL · S/N 0102940Peeler James K N6312VStroms Stefan RV-6 · S/N 24068Built 1998 · Moss Lake Ski Club LLC N677NCFlightstar Sportplanes FLIGHTSTAR II · S/N 271Built 2000 · Peeler James K N7090JRobinson Helicopter R44 II · S/N 13915Built 2015 · Jk Air LLC N755WBBlack James M FLIGHTSTAR II SL · S/N 135Built 1996 · Black James M N80538Sorrell SNS-9 · S/N 21-1Built 1994 · Peeler James K N8073CBallard M Eugene CHALLENGER II · S/N CH2-0298-CW-1709Built 1998 · Peeler James K

Back to Cherryville, NC