Registered aircraft · 24

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 = 'IA' AND g.registrant_city = 'CORNING' 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 = 'IA' AND g.registrant_city = 'CORNING'
  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 = 'IA' AND g.registrant_city = 'CORNING'
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.

N1034Chad C Wille NIEUPORT 12 · S/N 19Wille Chad C N107JCStarduster Too SA-300 · S/N 90Thomas Brian D N10962Curtiss Wright JR CW1 · S/N 1140Built 1931 · Wille Chad C N111KGSchempp-Hirth NIMBUS 3 · S/N 26Built 1982 · Wille Chad C N26KPJihlavan Airplanes Sro KP 5 ASA · S/N 5116134 KBuilt 2006 · Graf Robert A Trustee N29BWEiriavion PIK 20E · S/N 20297Wille Chad C N327FPDJI AGRAS T50 · S/N 1581F6BUB23AG0011E4PPatriot Aeronautics LLC N32TYDJI AGRAS T40 · S/N 1581F574B226H00103GVOgburn Tyler N3319APiper PA-22 · S/N 22-1595Built 1953 · Thomas Brian D N453Wille Chad C BLERIOT XI · S/N 21Built 2011 · Wille Chad C N4653TBrown Wallace CHEROKEE II · S/N WB-1Built 1964 · Wille Chad C N5560TCessna 172E · S/N 17251460Built 1964 · Thomas Brian D N5563VSlingsby TYPE 43 SERIES 3F · S/N 1028Built 1960 · Wille Chad C N5570Chad C. Wille TRAVEL AIR SPECIAL · S/N 14Wille Chad N604WTDJI AGRAS T50 · S/N 8GHBMCL00100D6Ogburn Tyler A N604YTDJI AGRAS T50 · S/N 8GHBMCL001003HOgburn Tyler A N6446Vliegtuigbouw SAGITTA-013 · S/N 008Built 1963 · Wille Chad C N64GAer-Pegaso M-100S · S/N 33Built 1962 · Wille Chad C N6959Glasflugel BS-1 · S/N 8Wille Chad C N717LVAmerican Champion 8KCAB · S/N 970-2004Built 2004 · Page Wayne N N732CXCessna T210L · S/N 21061420Built 1976 · Evans Terry W N8529Waco GXE · S/N 1869Built 1929 · Wille Chad C N8890RDowner BELLANCA 14-19-3A · S/N 4252Built 1965 · Wille Chad C N99345Engineering & Research ERCOUPE 415-C · S/N 1968Built 1946 · Porter Steven B

Back to Corning, IA