Registered aircraft · 20

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

N2020EAeronca 7AC · S/N 7AC-5590Built 1946 · Elsea Asa J N230MBBell 206B · S/N 5219Built 1995 · Flyin Time LLC N26058Piper J3L-65 · S/N 6612Built 1941 · Clifton Ronald L N263CBeech 70 · S/N LB28Norpoth Robert L N2648CDJI AGRAS T40 · S/N 64TBL6C002007AT&M Aerial Ag Services LLC N26538Taylorcraft BC-65 · S/N 1879Built 1940 · Kurtz Daniel N35327Piper J3F-65 · S/N 6293Built 1941 · Kurtz Daniel N3618XAero Commander 100-180 · S/N 5095Built 1968 · Hildenbrand Casey E N428Taylorcraft BL-65 · S/N 1907Built 1940 · Kurtz Daniel N4314VPiper PA-28-236 · S/N 28-8411001Built 1983 · Hill Thomas M N4698EChampion 7EC · S/N 7EC-45Built 1950 · Cook Bruce F N48WHGlobe GC-1B · S/N 3503Elsea Incorporated N5145SPiper PA-28R-200 · S/N 28R-7135165Built 1971 · Elsea Inc N5297MCessna 152 · S/N 15284518Allard John R N5666ACessna 172 · S/N 28266Built 1956 · Ronshausen Steven A N582JLJames M Leon DREAM MACHINE · S/N 23-1472Built 2023 · Litz Mark N588AGDJI AGRAS T40 · S/N 1581F574B226H00104M5Wolford Nick N6742SBeech A36 · S/N E-1635Built 1979 · Powers Benjamin N957QADJI AGRAS T30 · S/N 3U5BJ6L001003JT&M Aerial Ag Services LLC N96406Taylorcraft BC12-D · S/N 8706Built 1946 · Kurtz Daniel

Back to Circleville, OH