Newberg, OR
Registered aircraft · 72
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 = 'NEWBERG' 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 = 'NEWBERG' 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.
N119CRCessna T182T · S/N T18208766N1258EAeronca 7AC · S/N 7AC-4816N1271PPiper PA-23 · S/N 23-301N1457APiper PA-22 · S/N 22-357N1474APiper PA-22 · S/N 22-385N150KSPiper PA-20 · S/N 20-678N1523RGrumman American Avn. AA-5B · S/N AA5B-0023N154MAEstumkeda Ltd DBA Micco Acft MAC-145B · S/N 260008N1678RCessna A185F · S/N 18502401N17136Cessna 150L · S/N 15073635N20033Cessna 172M · S/N 17260948N2207JCessna 150G · S/N 15065407N22USCirrus Design SR22T · S/N 8692N23078Cessna 172M · S/N 17264080N24PCPilatus PC-24 · S/N 185N2576WMooney M20E · S/N 935N27EKHelicopteres Guimbal CABRI G2 · S/N 1311N287AWStenger Doug HARMON ROCKET II · S/N 155N33460Piper PA-28-180 · S/N 28-7505147N3364ABeech E33A · S/N CE-287N3521YCessna 182E · S/N 18254421N3524PPiper PA-22-150 · S/N 22-3279N3574QPiper PA-28RT-201T · S/N 28R-8031040N366PAHelicopteres Guimbal CABRI G2 · S/N 1264N369TRHughes Helicopters HUGHES 369D · S/N 570141DN3962XPiper PA-34-200T · S/N 34-7670007N401CStinson 108 · S/N 108-3401N4359YPiper PA-28-181 · S/N 28-8490073N443JGPessel Garnett H RV6 · S/N 60177N4594ZPiper PA-22-108 · S/N 22-8104N4611ZPiper PA-22-108 · S/N 22-8125N4612DCessna 172N · S/N 17272315N4827ZPiper PA-22-108 · S/N 22-8399N484EHelicopteres Guimbal CABRI G2 · S/N 1321N487DCAeronca 7DC · S/N 7DC 146N49FLWallace E A/Wallace F W SR XS MONOWHEEL · S/N A049N510TTNorth American F-51D · S/N 4474008N5284ZPiper PA-22-108 · S/N 22-8980N55720North American-Kalashian T-6G · S/N 49-2920N56720Piper PA-28R-200 · S/N 28R-7435034N6155WKroger William A JR VARI EZE · S/N WAK2001HHN62606Piper PA-18-150 · S/N 18-7809099N6404MCessna 140 · S/N 8591N6741BPiper PA-22-150 · S/N 22-4074N6992KPiper PA-20 · S/N 20-99N699WSeabourn Scott R F-1 ROCKET · S/N 18N70616Cessna 182M · S/N 18259326N7095WPiper PA-28-180 · S/N 28-882N719LLCirrus Design SR22T · S/N 1421N73694Boeing PT-27 · S/N 75-3802
Back to Newberg, OR