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

N12731Dehavilland TIGER MOTH DH 82A · S/N A17-491Built 1942 · Whelchel Leon N2249URockwell International S-2R · S/N 1871RBuilt 1974 · Noe Aviation LLC N2748GChampion 7GCAA · S/N 152Noe Aviation LLC N39660Piper PA-32RT-300T · S/N 32R-7887142Built 1978 · Your Mission LLC N4478HDJI AGRAS T50 · S/N 1581F6BUB236U001003AHappel Bros Fertilizer LLC N468RGCessna R182 · S/N R18201057Built 1979 · Myers Michael J N578QWBentley C.P.750-BERYL · S/N 13Built 1978 · Whelchel Leon N62964Bellanca 7ACA · S/N 52-72Built 1972 · Phelps Larry D N7044FCessna 150F · S/N 15063644Built 1966 · Hanson Mike D N711LWBeech P35 · S/N D-6984Built 1962 · Whelchel Leon N731CECessna A188B · S/N 18802785TBuilt 1976 · Noe Aviation LLC N76735Cessna 140 · S/N 11167Built 1946 · Bergen Daniel J N84972Champion 7AC · S/N 7AC-3697Built 1946 · Hanson Mike N85291Aeronca 7AC · S/N 7AC-4029Built 1946 · Phelps Lawrence D N915KHillis T L SPACEWALKER · S/N 001Phelps Lawrence D N97902Cessna 182Q · S/N 18267242Built 1979 · Hanson Mike D

Back to Vinton, IA