Skip to content

College Place, WA

Registered aircraft · 35

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 = 'COLLEGE PLACE' 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 = 'COLLEGE PLACE'
  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 = 'COLLEGE PLACE'
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.

N143SCMaas Douglas W LEGEND XL · S/N 3051Built 2007 · Merritt Geoffrey T N165RRCummings David Clair ROTORWAY EXEC 90 · S/N 5147Ragenovich Michael J N17481Grumman G-44 · S/N 1360Built 1944 · Ball Fred E N202AMCessna 172M · S/N 17266213Built 1975 · Walla Walla University N20323Cessna 172M · S/N 17261190Built 1972 · Walla Walla University N20544Cessna 172M · S/N 17261381Built 1973 · Walla Walla University N2591DCessna 170B · S/N 20743Rootvik Dennis L N2895PPiper PA-18A 150 · S/N 18-4493Built 1955 · Dawes Donald E N30AEBeech J50 · S/N JH-167Built 1962 · Ketting Case H N335WBDJI AGRAS T50 · S/N 1581F6BUB245R001P1YHLarson Jeffrey S N36024Piper PA-28R-201 · S/N 28R-7837262Built 1978 · Walla Walla University N42RRBeech 76 · S/N ME-84Walla Walla University N43527Piper PA-32-300 · S/N 32-7440131Built 1974 · Ball Fred E N47ZRPiper PA-28-180 · S/N 28-4974Built 1968 · Zira 2x Alw LLC N4805UCessna 210-5(205) · S/N 205-0505Built 1963 · Rice Gary B N4908JPiper PA-28R-180 · S/N 28R-30626Built 1968 · Holm R Stan N490TSDiamond Aircraft Ind DA 42 · S/N 42.AC090Built 2007 · Vories Dennis L Pe N49256Boeing A75N1(PT17) · S/N 75-1063Built 1942 · Bais Donald H N5437KRyan NAVION B · S/N NAV-4-2337BBuilt 1951 · Stahlheber Billy P N555SMCessna 172M · S/N 17261805Built 1973 · Walla Walla University N55696Piper PA-28R-200 · S/N 28R-7335274Built 1973 · Walla Walla University N5739CCessna 170A · S/N 19693Built 1950 · Hellie Andrew B N64233Cessna 172M · S/N 17265109Built 1975 · Walla Walla University N758WBCessna R172K · S/N R17203409Built 1980 · Finity Engineering LLC N774ALPayne Allan Raymond VANS RV-7 · S/N 71127Built 2004 · Payne Allan Raymond N8004YBashforth Bruce A MINI MASTER · S/N MM-100Comstock Marty M N80137Cessna 172M · S/N 17266397Built 1975 · Walla Walla University N8071LPiper PA-16 · S/N 16-550Built 1959 · Rogers Jonathan T N8363SCessna 182H · S/N 18256463Hellie Andrew Bryant N8877CPiper PA-20-135 · S/N 20-1025Built 1953 · Ball Fred N9045STaylorcraft DCO-65 · S/N L-5302Bais Donald H N955LBBrown Larry A DRAGONFLY · S/N 1955Built 1987 · Pinson Mark W N9676MMooney M20C · S/N 670012Built 1967 · Roberts Eric N9677MMooney M20C · S/N 670013Roberts Eric N971WTDiamond Aircraft Ind DA 62 · S/N 62.211Registration pendingBuilt 2022

Back to College Place, WA