OpenAirDocs.org
Pullman, WA

Registered aircraft · 29

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
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 = 'PULLMAN'
  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.

N1225YYoung Boyd W KOLB MARK III · S/N B1YBuilt 2000 · Nichols Robert WN2122SCessna T210L · S/N 21061084Built 1975 · Bobo Construction LLCN260BDMaule M-7-260 · S/N 26016CBuilt 2005 · Stratte Eric JN266ZADJI AGRAS T50 · S/N 1581F6BU000000000000Zakarison LLCN273WADJI AGRAS T20P · S/N 64UBL81002006BAlpine Aerials LLCN281MWIai GULFSTREAM G280 · S/N 2209Built 2020 · Schweitzer Aircraft Leasing IncN284MWIai GULFSTREAM G280 · S/N 2210Built 2020 · Schweitzer Aircraft Leasing IncN3290JCessna 150G · S/N 15065990Built 1966 · Fitzgerald Jacob JN33LYNeely Buddy NEELY SPORTSMAN · S/N 001Built 2001 · Bobo Robert AN3411DCessna 170B · S/N 26954Built 1955 · Box 4-S Ranch IncN3631CCessna 180 · S/N 31129Built 1954 · Clark Mark RN4100ZPiper PA-18-150 · S/N 18-8114Mountain Escape LLCN49GLCessna 180C · S/N 50705Built 1960 · Bobo Robert AN50DVHelio H-700 · S/N H-12Built 1984 · Mountain Escape LLCN518GMPiper PA-18-135 · S/N 18-2643Built 1953 · Mountain Escape LLCN552MWGulfstream Aerospace GV-SP (G550) · S/N 5615Built 2020 · Schweitzer Aircraft Leasing IncN5658ACessna 172 · S/N 28258Built 1956 · Ewartsville Flyers LLCN56718Buckeye Powered Parachutes DREAM MACHINE · S/N 4821Built 1999 · Brown Larry EN6340VHelio H-295 · S/N 1232Built 1967 · Turbine Motor Conversions LLCN6441DCessna 172N · S/N 17272802Built 1979 · Inter State Aviation IncN669TDTimothy J Diestel SR 3500 · S/N 171 SR-1Built 2023 · Turbine Motor Conversions LLCN6776MCessna 182P · S/N 18263831Built 1975 · Schweitzer Laura LN6831ACessna 172 · S/N 28931Sale reportedN7574PPiper PA-18-150 · S/N 18-7793Built 1962 · Matark CorpN7792MMooney M20E · S/N 21-0037Built 1974 · Schwam Andrew MN79848Mooney M20E · S/N 652Warren J JN88016Cessna 185 · S/N 185-0225Mark Cochran Leasing LLCN89SJCessna 180H · S/N 18051923Built 1968 · Mountain Escape LLCN9927QCessna 172M · S/N 17265871Built 1975 · Andrus Shane
Back to Pullman, WA