Lake Oswego, OR
Registered aircraft · 68
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 = 'LAKE OSWEGO' 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 = 'LAKE OSWEGO' 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.
N100YTextron 525C · S/N 525C0204N1018EBellanca 8GCBC · S/N 245-77N122BGGush William J MONNETT MONI · S/N 00117N1734BBoeing E75 · S/N 75-5987N2133NCessna 140 · S/N 12369N21612Mooney M20S · S/N 30-0045N226DMCessna 177RG · S/N 177RG0929N231MUMooney M20K · S/N 25-0314N236PSIai GULFSTREAM 200 · S/N 236N239CPPowers BD-4 · S/N 239N248ECRaytheon HAWKER 800XP · S/N 258368N2652Dassault FALCON 2000EX · S/N 414N2787DRaven S-60A · S/N S60A-361N294TWPiper PA-28-160 · S/N 28-2202N3093XCessna 150F · S/N 15064493N3111SCessna 182G · S/N 18255611N3235TBeech B36TC · S/N EA-577N333KKQuest KODIAK 100 · S/N 100-0084N3368XMooney M20E · S/N 1087N345GBGame Composites GB1 GAMEBIRD · S/N 0055N3563UCessna 182F · S/N 18254963N35RLLogston Richard E STARDUSTER SA100DL · S/N SA100DL-1N3618JCessna 150G · S/N 15064918N412BWCessna T182T · S/N T18208476N4YMMooney M20TN · S/N 31-0039N50QMCirrus Design SF50 · S/N 0451N537ABCirrus Design SR22 · S/N 4332N53UBCessna 560XL · S/N 560-6159N544PBPiper PA-32R-301T · S/N 3257238N57405Bellanca 7KCAB · S/N 371-73N612TBeech J35 · S/N D-5438N614CTCirrus Design SR22T · S/N 9988N63YHCirrus Design SR22T · S/N 1350N64FAFunnell Augustus H FUNNELL VANS RV6 · S/N 24539N6536MCessna 182P · S/N 18263745N6635MStinson 108-3 · S/N 108-4635N691WCessna 172P · S/N 17275576N6945VMooney M20F · S/N 22-1318N699CMAndrew Manilla RV-14 · S/N 141501N711PZBeech 95-B55 (T42A) · S/N TC-1491N7148QCessna 182S · S/N 18280553N728TKRobinson Helicopter R22 BETA · S/N 4936N730MNMichael Newcomb RV-10 · S/N 42004N737FHCessna 172N · S/N 17269381N739MRCessna 172N · S/N 17270654N777FWCessna 210L · S/N 21060167N777LCCarstens BD-4 · S/N 349N7979MBeech V35 · S/N D-8270N810TFVans RV-12IS · S/N 121589N818ADCirrus Design SF50 · S/N 0549
Back to Lake Oswego, OR