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

N174KCessna 310N · S/N 310N-0143Built 1968 · Blueskies Aviation Services LLC N210RPCessna P210N · S/N P21000014Registration pendingBuilt 1978 N2397APiper PA-38-112 · S/N 38-78A0668Kinkade Leslie D N3166KPhoenix SKY-TRIKE · S/N 5004Built 2004 · Turner Richard N456SPCessna 172S · S/N 172S8320Built 1999 · Ac Aviation LLC N46EFCessna 182T · S/N 18280992Pringle Dan N491BLBRM Aero S R O BRISTELL LSA · S/N 491/2020Built 2020 · Ac Aviation LLC N5006WPiper PA-28 · S/N 28-7Built 1961 · Wright Stephan T N5511MAero Commander 200D · S/N 382Built 1967 · Soodoo Mark A N5821HPiper PA-16 · S/N 16-437Fifer Lucas J Trustee N70LGCubcrafters CC11-160 · S/N CC11-00245Built 2012 · Drysdale Donald J N710GGBRM Aero S R O BRISTELL LSA · S/N 364/2018Built 2018 · Ac Aviation LLC N72HARaytheon HAWKER 800XP · S/N 258503Built 2000 · Mcn Aviation Partners LLC N730JBJoseph Barbera QUICKSILVER SPRINT 2 · S/N 63231Barbera Joseph A N7855ZCirrus Design SR22 · S/N 1629Built 2005 · Roskowski David N815USGeorge Stone KIT FOX MODEL 3 · S/N 815Stone George R N8419HPiper PA-28-181 · S/N 28-8190291Built 1981 · Hoke William Jr N9909QCessna 172M · S/N 17265853Built 1975 · Ck Aviation LLC N99928Ercoupe 415-C · S/N 2551Kinker Christopher C

Back to Charlestown, IN