Baker City, 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 = 'BAKER CITY' 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 = 'BAKER CITY' 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.
N11VCessna 175 · S/N 55819N132BBDJI AGRAS T40 · S/N 64TBKAF002009MN1577Garlick Helicopters UH-1H · S/N 65-09577N1896FRiley Joseph L WAG-AERO TRAINER · S/N 00226N2455QCessna 182K · S/N 18257655N246CKBeech C90 · S/N LJ694N2708QCessna 182K · S/N 18257908N273PLSikorsky UH-60L · S/N 88-26030N274PLSikorsky UH-60L · S/N 94-26587N279WYAviat A-1C-180 · S/N 3279N3119JCessna 150G · S/N 15065819N313SABeech 300 · S/N FA-5N32ABJacobson Neal D VANS RV-8A · S/N 81962N3502PMD Helicopters 369FF · S/N 0346FFN3596JCessna 150E · S/N 15061296N3869FRockwell International 690A · S/N 11141N407TDBell 407 · S/N 53764N412KKBell Helicopter Textron 206L-1 · S/N 45277N418BSPiper PA-12 · S/N 12-2831N4361RRobinson Helicopter R44 II · S/N 12816N442WMRobinson Helicopter R44 II · S/N 11555N458CCWilliams Helicopter UH-1H · S/N 67-17678N462BARobinson Helicopter R44 II · S/N 12265N4900EVyff Randy RANS S-12XL · S/N 05960711N5089QCasler Scott CX-4 · S/N 95N5100BGlover E R MINI-MAX · S/N 789N511PLDavid M Mccarty CCK-2000 · S/N CCK-2000-0133N5369XHuey Wayne M/Shotwell Steve KITFOX MODEL IV · S/N 1650N600BCAmerican Champion 8GCBC · S/N 563-2014N651CJCessna 525 · S/N 525-0365N655ACAmerican Champion 8GCBC · S/N 391-98N66TDDavis Terry KOLB FIRESTAR · S/N FS01-1-00058N675RY3D Robotics SOLO · S/N S111A5606047N6906VMooney M20C · S/N 20-1176N736NZCessna R172K · S/N R1722670N7470PPiper PA-24-250 · S/N 24-2661N750RHAngus Watt ZENAIR STOLCH 750 · S/N 75-7832N7577GCessna 172L · S/N 17259277N77VMCessna 182P · S/N 18264121N7890HPiper PA-12 · S/N 12-794N8480GCessna 150F · S/N 15062580N8598UCessna 172F · S/N 17252498N8PQAero Commander 690A · S/N 11243N90109Infinity Powered Parachutes LL 2004 · S/N IPP4-249N9033CCessna 180 · S/N 31081N914SKRobinson Helicopter R44 II · S/N 11250N9448KStinson 108-2 · S/N 108-2448N99929Ercoupe 415-C · S/N 2552
Back to Baker City, OR