OpenAirDocs.org
Brookings, OR

Registered aircraft · 48

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

N10195Hiller UH-12B · S/N 562Deuchar HillaryN1049FThunder Balloons AX7-77Z · S/N 182Built 1979 · Bissonette Harle EN11CZYakovlev YAK-11 · S/N 171706Kalmar IstvanN128JCNorth American T-28C · S/N 140549Built 1956 · Dk Air LLCN190FCessna 172 · S/N 46366Built 1958 · Cook James HN1944DNorth American SNJ-5 · S/N 91040Built 1944 · Macleod William LN203YAYakovlev YAK-55M · S/N 961006Built 1996 · Martin Guy EN269CCessna 421C · S/N 421C0170Gold Beach Lumber Yard IncN33230Cessna 177RG · S/N 177RG0930Built 1976 · Alaska Air Service LLCN332JSRaytheon B200 · S/N BB-1938Built 2006 · South Coast Lumber LLCN340DWCessna 340A · S/N 340A-0497Built 1978 · Silver David ScottN373BRShort Brothers S312 TUCANO T MK1 · S/N T116Built 1992 · Td 1 LLCN382ASRobinson Helicopter R22 BETA · S/N 2902Built 1998 · Aero LeasingN3981GCessna 340A · S/N 340A0253Silver David SN400WDCessna 525A · S/N 525A0002Built 2000 · Pacific Coast Aviation IncN4377XRobinson Helicopter R44 II · S/N 12838Built 2009 · Dk Air LLCN49MHAero Vodochody L-39 · S/N 834558Kalmar IstvanN501DDCessna 501 · S/N 501-0035Built 1977 · Dk Air LLCN5020GGary Lake JODEL D-11 · S/N 5302Built 1979 · Baum Karl BradleyN5316SCessna TR182 · S/N R18201545Built 1980 · Dk Air LLCN540GMNorth American SNJ-4 · S/N 88-9141Built 1944 · Martin Guy EN617MMRaytheon C90A · S/N LJ-1587Built 2000 · Cal-Ore Life Flight LLCN6604MStinson 108-3 · S/N 108-4604Built 1948 · Alaska Air Service LLCN6612QGrumman Acft ENG Cor-Schweizer G-164B · S/N 163BAlaska Air Service LLCN6717QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1711Alaska Air Service LLCN675JZCessna 208 · S/N 20800570Built 2015 · Mercer Fraser CoN721SGCessna 206 · S/N 206-0265Built 1964 · Alaska Air Service LLCN727KPRobinson Helicopter R44 · S/N 1416Built 2004 · Aero Leasing IncN736EHCessna R172K · S/N R1722465Garvin Lee EN738DECessna 172N · S/N 17269889Built 1977 · Brookings Flying Club IncN738HPCessna 172N · S/N 17269992Built 1977 · Nidiffer Alan WN75588Cessna 172N · S/N 17267831Built 1976 · Emry Scott DN7812TCessna 172 · S/N 47412Curzon John RN799ZMaule MX-7-180B · S/N 22024CBuilt 2008 · Beckley Michael JN8087HNorth American T-28A · S/N 51-7803NAlaska Air Service LLCN814RACirrus Design SR20 · S/N 1663Built 2006 · Flanderka PeterN821SHRobinson Helicopter R22 BETA · S/N 3774Built 2005 · Aero Leasing IncN8341KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 35CAlaska Air Service LLCN8435ECessna 172N · S/N 17272200Built 1979 · Zeller Ray GN8448KGrumman Acft ENG Cor-Schweizer G-164B · S/N 698BAlaska Air Service LLCN84PLLippiatt Paul LIPPIATT LANCAIR IV · S/N LIV-084Built 1996 · Macleod William LN858GFRaytheon B200 · S/N BB-1858Cal-Ore Life Flight LLCN91053Cessna 340A · S/N 340A1039Garvin Lee EN912AFApollo FOX · S/N 00002Built 2007 · Silver David SN914DKBeech C90A · S/N LJ-1445Built 1996 · Cal-Ore Life Flight LLCN982SBRaytheon C90A · S/N LJ-1518Built 1998 · Cal-Ore Life Flight LLCN991GTRaytheon C90GT · S/N LJ1805Cal-Ore Life Flight LLCN9EJBeech D-45 · S/N BG168Built 1956 · Dk Air LLC
Back to Brookings, OR