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 = 'OH' AND g.registrant_city = 'JAMESTOWN' 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 = 'OH' AND g.registrant_city = 'JAMESTOWN'
  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 = 'OH' AND g.registrant_city = 'JAMESTOWN'
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.

N103TSDegraff Irwin KOLB MK III · S/N M3/003Built 1992 · Kilbarger Shawn R N1157MCessna 182P · S/N 18264235Built 1975 · Whf Aviation LLC N33444Piper PA-28-180 · S/N 28-7505146Built 1975 · Mossbarger Beverly Jo N3585EAeronca 7AC · S/N 7AC-6926Built 1947 · Davenport Dewey D N455NCurtiss Wright TRAVEL AIR D-4000 · S/N 1361Triple D Aviation LLC N45790Mcpherson VARI-EZE · S/N 559Kilbarger Shawn N46343Miller Robert SUPER QUICKIE Q1 · S/N RWM-SQ1Built 2005 · Kilbarger Shawn R N6223FRussell A Turner SOPWITH CAMEL · S/N F6223Turner Russell A N6260DJI AGRAS T40 · S/N 64TBKAF00200GDAero Ag Command LLC N637DCDJI T40 · S/N 1581F574B239100100F2Thompson Grain Farm Gp N639DCDJI T40 · S/N 1581F574B239600100LWThompson Grain Farm Gp N6490DJI AGRAS T40 · S/N 64TBKAA001018DAero Ag Command LLC N67ACDJI T20P · S/N 64UBL5P002006LAero Ag Command LLC N8715HNorth American NAVION · S/N NAV-4-715Built 1947 · Combs Gardner J N928VWhite NEW STANDARD D-25 · S/N 154Built 1929 · Triple D Aviation LLC N937SKKilbarger Shawn SPRINT II · S/N 9955Built 2003 · Kilbarger Shawn

Back to Jamestown, OH