Registered aircraft · 18

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 = 'WA' AND g.registrant_city = 'VALLEYFORD' 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 = 'WA' AND g.registrant_city = 'VALLEYFORD'
  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 = 'WA' AND g.registrant_city = 'VALLEYFORD'
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.

N1103WWilliam A Wakker AX-5 42.000 CUF · S/N 001Built 2023 · Wakker William A N1730BBoeing E75N1 · S/N 75-5876Pemberton Ryan A N2207YNorth American T-28B · S/N 137764Goldbach Charles H N335JFNorth American T-28C · S/N 140615Goldbach Charles H N36349Bellanca 7ECA · S/N 967-73Built 1973 · Richardson Thomas R N427WTravel Air 4000 · S/N 1418Pemberton Ryan A N48235Ryan Aeronautical ST3KR · S/N 1903Built 1942 · Tataryn Roderick W N6848Boeing B75N1 · S/N 75-6848Built 1942 · Tataryn Roderick W N68567Bellanca 7GCBC · S/N 395-72Built 1972 · Goldbach Charles H N7121HPiper J3C-65 · S/N 20373Built 1946 · Tataryn Roderick W N715JYPiper PA-20 · S/N 20-595Built 1951 · Airspace Aviation LLC N83526Aeronca 7AC · S/N 7AC-2199Built 1946 · Mccord Mark Harlan N8776QCessna A185F · S/N 18503771Built 1979 · Richardson Thomas R N88567Piper J3C-65 · S/N 16192Built 1946 · Pemberton Taryn B N9022NNorth American T-28C · S/N 140666Built 1956 · Goldbach Charles H N9178RAerostar International RX-7 · S/N RX7-3290Built 1994 · Wakker William A N9834XCessna 185 · S/N 185-0034Built 1961 · Pemberton Ryan A N99395North American T-28A · S/N 49-1540ABuilt 1945 · Goldbach Charles H

Back to Valleyford, WA