OpenAirDocs.org
White City, OR

Registered aircraft · 61

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 = 'OR' AND g.registrant_city = 'WHITE CITY'
  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.

N1043TSikorsky S-61A · S/N 61083Built 1961 · Croman CorpN1048YSikorsky S-61A · S/N 61161Built 1961 · Croman CorpN113WKSikorsky SH-3H · S/N 152113Croman CorpN1185MCessna 172K · S/N 17258685Built 1969 · Owen SteveN123MBCessna R172K · S/N R1722836Spinner Family LpN231UMooney M20K · S/N 25-0384Built 1980 · Bosia Acres LLCN2919ZPiper PA-22-150 · S/N 22-6889Pankonin Steve BN314MFVictor M Gobel JUST ACFT HIGHLANDER · S/N JA5980920Built 2023 · Gobel Victor MN3200GPiper PA-22 · S/N 22-4042Built 1956 · Spinner Family Limited PartnershipN3452HErcoupe 415-CD · S/N 4077Built 1947 · Duddy Donald PatrickN3796APiper PA-18-135 · S/N 18-3063Built 1953 · Spinner Family Limited PartnershipN3805PPiper PA-22-150 · S/N 22-3494Built 1955 · Spinner Family LpN3879DCessna 182A · S/N 34579Built 1957 · Holberton George LN397FDDJI PHANTOM 3 PROFESSION · S/N P76DCH30A20613Jackson County Fire District #3N408FSSikorsky S-61N · S/N 61361Built 1966 · Croman CorpN408UDSikorsky S-61N · S/N 61772Built 1974 · Croman CorpN408WCSikorsky S-61N · S/N 61764Built 1977 · Croman CorpN410GHSikorsky S-61N · S/N 61749Built 1975 · Croman CorpN4263ASikorsky S-61R · S/N 61551Built 1966 · Croman CorpN43WCMcfarland William C KIT FOX II · S/N 46-2687Cawein Michael A JrN500CVHughes 369HS · S/N 240561SParadise Air LLCN501CDCessna 501 · S/N 501-0066Built 1978 · Croman CorpN60602Cessna 150J · S/N 15070437Built 1969 · Ratcliff Philip AN611CKCroman SH-3H · S/N 148966Built 1961 · Croman CorpN612CKCroman SH-3H · S/N 149713Built 1962 · Croman CorpN613CKCroman SH-3H · S/N 152109Built 1965 · Croman CorpN614CKSikorsky S-61N · S/N 61715Built 1974 · Croman CorpN6165ECessna 172 · S/N 46265Built 1958 · Bailey Frank WN617CKSikorsky S-61N · S/N 61164Built 1962 · Croman CorpN618CKSikorsky S-61NM · S/N 61454Croman CorpN619CKSikorsky S-61N · S/N 61808First renewal noticeCroman CorpN61NHSikorsky S-61N · S/N 61474Built 1970 · Croman CorpN620CKSikorsky S-61L · S/N 61362Croman CorpN621CKSikorsky S-61N · S/N 61364Croman CorpN623CKSikorsky S-61N · S/N 61762Built 1977 · Croman CorpN624CKSikorsky S-61A · S/N 61272Built 1964 · Croman CorpN6259CBell 206B · S/N 703Croman CorpN625CKSikorsky S-61N · S/N 61-216Built 1963 · Croman CorpN626CKSikorsky S-61N · S/N 61220Built 1963 · Croman CorpN628CKCroman SH-3H · S/N 152707Built 1966 · Croman CorpN629CKSikorsky S-61N · S/N 61751Built 1975 · Croman CorpN631CKSikorsky S-61N · S/N 61753Croman CorpN635CKCroman SH-3H · S/N 149702Built 1962 · Croman CorpN703WKSikorsky SH-3H · S/N 152703Croman CorpN7149MCessna 175 · S/N 55449Built 1958 · Barton Danny B TrusteeN7166TCessna 172A · S/N 46766Built 1959 · Central Aviation LLCN72982Cessna 140 · S/N 10183First renewal noticeBuilt 1946 · Burrill Donald MN732DKCessna T210L · S/N 21061432Built 1976 · Mckay Donald EN73909Bell 47G-3B-1 · S/N 2797Built 1962 · Dsm IncN7451ECessna 210 · S/N 57151Built 1960 · Tucker Charles M
Back to White City, OR