Portland, OR
Registered aircraft · 546
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 = 'PORTLAND' 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 = 'PORTLAND' 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.
N9441MCessna 182P · S/N 18264759N94539Cessna 182Q · S/N 18266437N9467SBeech V35 · S/N D-8054N9481YBeech N35 · S/N D-6660N94DZZachary David L RV-9A · S/N 90718N94SEAlisport SILENT 2 ELECTRO · S/N 2094N951CRRoberg Charles YG-1 · S/N 951CRN9530XCessna 210A · S/N 21057830N953DYGrumman American Avn. AA-5A · S/N AA5A0012N953MHCirrus Design SR22T · S/N 2349N9540RBeech K35 · S/N D-6103N9547DPiper PA-22-160 · S/N 22-6464N95722Cessna 152 · S/N 15285962N95740Cessna 182Q · S/N 18266615N95893Taylorcraft BC12-D · S/N 8193N958STCessna T206H · S/N T20608798N9596DPiper PA-22-160 · S/N 22-6504N95TECessna 680 · S/N 680-0021N95UTRaytheon B200 · S/N BB-1759N960PDCompagnie Daher TBM 700 · S/N 1562N963RVRoberts Jim RV-4 · S/N 001N9642TCessna 210 · S/N 57442N9699GCessna 182P · S/N 18263434N96CJChristopher W Jones/Cecil W Jo RV-6A · S/N 21577N96FPCessna 525A · S/N 525A-0219N9717XCessna 210B · S/N 21058017N9743HCessna T182 · S/N 18267990N9777NAvilez Donald L JR CHALLENGER II · S/N CH20586R0197N977RTLeonardo AW139 · S/N 31977N978RTLeonardo AW139 · S/N 31978N97KGSchempp-Hirth DISCUS-2B · S/N 13N980AKRockwell International 690C · S/N 11636N9842KStinson 108-2 · S/N 108-2842N985GWCessna 182R · S/N 18268535N9937Sport Flight TALON XP · S/N 9303N9943CCirrus Design SR22T · S/N 0904N9944Sport Flight TALON MAGNUM · S/N 9602N997NGlasair Aviation USA SPORTSMAN GS-2 · S/N 7470N99895Mooney M20K · S/N 25-0551N999TASocata TBM 700 · S/N 611N99BPPoling J H Brad WESTFALL · S/N 2N99CBBlake P H/Casey T J RV-4 · S/N 0625N99VWAmerican Champion 7GCAA · S/N 459-2001N9DLBroussard EAA SUPER ACRO SPORT · S/N 12N9PDCessna 180H · S/N 18052062N9VRVanraden Fred F 2 SRG · S/N 2090VR
Back to Portland, OR