Hillsboro, OR
Registered aircraft · 371
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 = 'HILLSBORO' 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 = 'HILLSBORO' 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.
N101LATextron 172S · S/N 172S13119N101PCPilatus PC-7 · S/N 101N1028VMosher PAZMANY PL-1A · S/N 132N1036JAero Commander 112 · S/N 36N104TFLockheed TF-104G · S/N 665926N10782Cessna T206H · S/N T20608773N108JNGates Learjet 35A · S/N 35A-358N115HWKeller H T/Sudekum W J SR GLASTAR · S/N 5015N116AACessna 525B · S/N 525B-0194N117AACanadair CL-600-2B16 · S/N 5060N117JCPiper PA-32-301 · S/N 32-8006032N11CJPiper J3F-60 · S/N 3322N1228MCessna 182P · S/N 18264247N1231PPiper PA-23 · S/N 23-251N125CLAirbus Helicopters AS350B3 · S/N 7987N125MGPiper PA-44-180 · S/N 4496152N12683Cessna 172M · S/N 17262173Sale reported, pending cancellationN130JACessna 172S · S/N 172S9165N1360TPiper PA-28R-200 · S/N 28R-7235269N1426DMikoyan-Gurevich MIG-17F · S/N 1C1426N1456CPiper PA-18A · S/N 18-2654N145HAAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21193N149LATextron 172S · S/N 172S13125N149PRCloudbase Flyers RV-7A · S/N 70149N149WWCessna 525B · S/N 525B0175N14SKCessna 152 · S/N 15283422N150CQCessna 150F · S/N 15061671N152BTCessna P210N · S/N P21000486N152GBCessna 152 · S/N 15279546N15835Beech C17R · S/N 74N16058Cessna 150L · S/N 15073448N160CTTaylor Clinton A RV-14A · S/N 140628N1636BOlson Lance E RV-4 · S/N 2700N164YFPiper PA-23-180 · S/N 23-1234N1659JPiper PA-28-140 · S/N 28-24056N169RVHawkins Allen A RV-9A · S/N 90574N171AACessna 510 · S/N 510-0412N17351Ryan Aeronautical ST-A · S/N 154N17462Waco YKS-7 · S/N 4604N174AACessna 525B · S/N 525B0196N175AACessna 525B · S/N 525B0068N177BDCessna 152 · S/N 15281660N1796North American AT-6A · S/N 78-6632N17BJJohnson Brenden L VANS ACFT INC RV-7 · S/N 74163N180EZCrouch Stephen P LONG EZ · S/N 081945N1844ZCessna 210-5 · S/N 205-0044N18ACCessna 172S · S/N 172S9737N18VSLange E1 ANTARES · S/N 47E42N190CFFocke Wulf Flugzeugbau FW 190D-9 · S/N 210096N190DCPiper PA-44-180 · S/N 4496103
Back to Hillsboro, OR