OpenAirDocs.org
Colville, WA

Registered aircraft · 58

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 = 'COLVILLE'
  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.

N1111Boeing A75N1(PT17) · S/N 75-4684Built 1942 · Johnson Lawrence FN1344MBoeing E75 · S/N 758325Built 1943 · Johnson Lawrence FN13943Cessna 172M · S/N 17263046Tell Christopher AN139TABeech V35B · S/N D-9652Built 1974 · Tell Christopher AN141DTAeropro CZ EUROFOX · S/N 23307Built 2007 · Thompson William RN20554Cessna 172M · S/N 17261389Built 1973 · Danekas IncN2341BUniversal GLOBE GC-1B · S/N 3641Howell Harley LN30830Piper J3C-65 · S/N 5152Built 1940 · Johnson Martha GN3176TThompson William R SIX CHUTER SR-5 · S/N 98-2091-SR-5Built 1998 · Thompson William RN3308KGlobe GC-1B · S/N 1301Built 1946 · Howell Harley L JrN3320KUniversal GLOBE GC-1B · S/N 1313Built 1946 · Zema Monte LN335MMooney M-18C · S/N 216Built 1950 · Cabbage David AN3536LCessna 150F · S/N 15062336Built 1965 · Pnw Sky Trekking LLCN3817VCessna R172K · S/N R1722265Built 1977 · Floener Michael AN4431DCessna L-19E · S/N 24555Thompson Minard D JrN4489CCessna 195B · S/N 16073Inabnit Shon GN45493Luscombe 8A · S/N 2020Built 1946 · Garringer David AN4597EAeronca 7CCM · S/N 7CCM-166Built 1949 · Gormon Michael LN4811VBoeing E75 · S/N 75-5469Built 1950 · Johnson Lawrence FN49323Boeing A75N1(PT17) · S/N 75-3587Built 1942 · Johnson Lawrence FN49647Boeing IB75A · S/N 75-4504Built 1943 · Johnson Lawrence FN4994ACessna 180 · S/N 32391Built 1956 · Rose Carey VN5001VBoeing A75N1(PT17) · S/N 75-7732Built 1945 · Johnson Lawrence FN5050VBoeing A75N1(PT17) · S/N 75-6499Built 1942 · Johnson Lawrence FN5105RBeech B19 · S/N MB-639Sale reportedBuilt 1974N5173XChampion 7ECA · S/N 680Built 1969 · Inabnit Michael SN52549Boeing A75L3 · S/N 75-2080Johnson Lawrence FN5268BMooney M20 · S/N 1131Built 1957 · Cabbage David AN53180Boeing A75N1(PT17) · S/N 75-3883Built 1941 · Johnson Lawrence FN531MMMumau Mickey L EXEC 162 F · S/N 6257Built 2000 · Tiger Trucking IncN54039Boeing A75N1(PT17) · S/N 75-3878Built 1942 · Johnson Lawrence FN55570Boeing A75N1(PT17) · S/N 75-1563Built 1941 · Johnson Lawrence FN55703Boeing/Johnson A75N1 · S/N 75-4940-N2S-4Johnson Lawrence FN55959Boeing A75N1(PT17) · S/N 75-4476Johnson Lawrence FN58226Boeing A75 · S/N 75076Built 1937 · Johnson Lawrence FN5852BCessna 182A · S/N 33852Built 1956 · Shaw David VN6126RCessna T210F · S/N T210-0026Kelley KalN627ECChampion 7EC · S/N 7EC 767Gormon Michael LN6352ECessna 172 · S/N 46452Built 1959 · Rotter Dale HN64090Boeing A75N1(PT17) · S/N 75-3583Built 1942 · Johnson Lawrence FN645JJabiru USA Sport J250-SP · S/N 544Built 2008 · Warner RyanN65900Boeing E75N1 · S/N 75-5986Built 1945 · Johnson Lawrence FN66299Boeing A75N1(PT17) · S/N 75-7988Built 1943 · Johnson Lawrence FN6711PPiper PA-24-250 · S/N 24-1837Built 1960 · Pietroburgo Stephen MN6947ECessna 175A · S/N 56447Built 1959 · Firestone Bradley WN69568Boeing A75N1(PT17) · S/N 75-3695Johnson Lawrence FN72058Luscombe 8A · S/N 3485Built 1946 · Gorst Wayne RN75686Boeing E75N1 · S/N 75-5191Johnson LawrenceN75694Boeing E75N1 · S/N 75-8751Johnson Lawrence FN75800Boeing A75N1(PT17) · S/N 75-3557Built 1942 · Johnson Lawrence F
Back to Colville, WA