Ashland, OR
Registered aircraft · 69
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 = 'ASHLAND' 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 = 'ASHLAND' 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.
N102UMAerospatiale AS-355E TWIN STAR · S/N 5075N119AYFinley Lg/Campbell Ja RV-9A · S/N CF-1N128GTiburon BEARHAWK FIVE · S/N M562-112/123N12PVHawker Beechcraft G36 · S/N E-3799N137UHDJI INSPIRE 1 · S/N W13DCA16020183N138UHDJI S900 · S/N 0370064727N139UHDJI S1000 · S/N 03P0014878N1467BLuscombe 8E · S/N 6094N151MSMichael Schipper RV-10 · S/N 40576N1771Sportavia-Putzer FOURNIER R.F.4.D · S/N 4057N1883Nielsen Jeff S RV6 · S/N 20060N1955SSenft O/Senft M LANCAIR · S/N 220N198ARCessna 172N · S/N 17273560N249THBell Helicopter Textron 206L-1 · S/N 45459N28502Grumman American Avn. AA-5B · S/N AA5B0643N30270Piper J5A · S/N 5-162N3197TCessna 177 · S/N 17700497N321AYCessna 182P · S/N 18261756N321RZCessna 182Q · S/N 18267199N355THAerospatiale AS 355F1 · S/N 5111N366PSBeech E-55 · S/N TE-971N39252Mooney M20K · S/N 25-1200N398PCessna 320D · S/N 320D0106N400ENExtra Flugzeugbau EA-400 · S/N 28N42325Cessna 182L · S/N 18258967N43455Piper PA-28-161 · S/N 28-8416055N43RRPipistrel Italia S R L ALPHA TRAINER · S/N 1105 AT 912 LSAN44NFAviat A-1C-180 · S/N 3151N450ADBoeing B75N1 · S/N 75-7702N4537FPiper PA-32R-300 · S/N 32R-7680458N4736LPiper PA-28-180 · S/N 28-4062N5000GBell Helicopter Textron 206L-1 · S/N 45163N526APPaxhia Alan J MURPHY SR3500 · S/N 026SRN5373UBell 206B · S/N 4011N60BKMcdonnell Douglas Helicopter 600N · S/N RN028N6570ACessna 180 · S/N 32467N658DKAeroprakt America A-22 LS · S/N 056N65GYPipistrel Italia S R L ALPHA TRAINER · S/N 1021 AT 912 LSAN6624VBellanca 17-31ATC · S/N 31008N669KBTamarack Helicopters TH-1F · S/N 66-1229N671BLBryan Mckinney EVOLUTION · S/N EVO-0071N689PWindward Performance SPARROW HAWK · S/N 006N690WYCessna 501 · S/N 501-0222N7118Beech H35 · S/N D-5099N717XBeech C90 · S/N LJ-581N7194PPipistrel Italia S R L ALPHA TRAINER · S/N 968 AT 912 LSAN723ZGDJI PHANTOM 2 · S/N BG152055539697N745MBMD Helicopters 600N · S/N RN067N777FLIsrael Aircraft Industries GULFSTREAM G150 · S/N 214N77RZCessna 208 · S/N 20800512
Back to Ashland, OR