Beaverton, OR
Registered aircraft · 113
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 = 'BEAVERTON' 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 = 'OR' AND g.registrant_city = 'BEAVERTON' 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.
N4767NCessna 182Q · S/N 18267350N47DARepublic P-47D · S/N 38955616N4998VGrumman F6F-5 · S/N 94204N500MLEmbraer S A EMB-545 · S/N 55010058N5185TChampion 7KCAB · S/N 15N520CARockwell International 112TCA · S/N 13187N5254LDouglas A-24 · S/N 42-60817N5487KCessna 172P · S/N 17274153N54ZGZane R Gard JR BD-5 · S/N 00520N551DNorth American/Aero Classics P-51D · S/N 44-14826N551GTGulfstream Aerospace G-V · S/N 5008N55NXPenridge CCX-2300 · S/N CCX-2300-0048N56VDouglas DC3 · S/N 33153N574RWVans RV-12 · S/N 120574N579SCMahoney Steven BD-4 · S/N 579N580XExtra Flugzeugproduktions EA 300/SC · S/N SC053N580XAExtra Flugzeugproduktions EA 300/SC · S/N SC024N58918Grumman FM-2 · S/N 86754N5940PPiper PA-24-180 · S/N 24-1030N601LZLangley James H ZODIAC · S/N 6-3088N627GEEnglish Gregory A VANS ACFT INC RV-9A · S/N 90867N6332TCessna R182 · S/N R18201984N65727Boeing A75N1(PT17) · S/N 75-4405N6596XLamb Clifford RV-4 · S/N 693N666BDRider Scott Millhoff BD-5B · S/N 666N666RMCessna 182P · S/N 18263853N6782ZPiper PA-25-235 · S/N 25-2418N7149EAerovodochody L-29 DELFIN · S/N 591328N7163MMartin AM-1 MAULER · S/N 22275N71GCessna 510 · S/N 510-0042N737TBCessna TR182 · S/N R18200881N73CFPitts S-2A · S/N 2215N741FAAerosport IKARUS C42E · S/N 0605-6815N74714Mooney M20B · S/N 1714N74797Mooney M20B · S/N 1797N76MZMoravan ZLIN 42M · S/N 0076First renewal noticeN7866ECessna 150 · S/N 17666N7903ZCessna 150C · S/N 15060003N7911PPipistrel Lsa S R L SINUS 912 LSA · S/N 766SFM 912 LSAN800HGrumman F8F-2 · S/N 121752N8033ACessna 170B · S/N 20885N80YYPriester Austin PITTS S1-SS ULTIMATE · S/N 2009N8118MCessna 310I · S/N 310I0118N8195HNorth American TB-25N · S/N 44-30748AN8382GCessna 150F · S/N 15062482N83LLockheed PV-2 · S/N 151501N8732VBellanca 7GCBC · S/N 846-75N8745FPiper PA-28-151 · S/N 28-7715288N886DTSchempp Hirth Flugzeugbau ARCUS M · S/N 99N887DTSchempp-Hirth Flugzeugbau ARCUS · S/N 20
Back to Beaverton, OR