Oro Valley, AZ
Registered aircraft · 114
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 = 'AZ' AND g.registrant_city = 'ORO VALLEY' 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 = 'AZ' AND g.registrant_city = 'ORO VALLEY' 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.
N1056Ryan M-2 · S/N 18N1058Ryan M-2 · S/N 19N1120MBeech V35B · S/N D-9346N118NLBeech B100 · S/N BE-111N121RHRobinson Helicopter R44 II · S/N 14615N126UKLittleton JR Ulay W RV-10 · S/N 41900N139GGriffith-Thorp T-18 · S/N 375N156CAngel 444 CCX-2000 · S/N CCX-2000-0174N17480Aeronca LC · S/N 2059N1852NDamico Michael J KITFOX SERIES 7 · S/N S60111-074N18EXThomas Mel Jordan PA18EXP · S/N JA003N2006HEngineering & Research ERCOUPE 415-C · S/N 2629N2157AThomas Mel Jordan RV7A · S/N 72562N227GEclipse EA500 · S/N 000124N22LTDarwin 022 LANCAIR EVOLUTION · S/N EVO-022N233CAAaron Burton CAVALON · S/N V00359N2483KPiper PA-38-112 · S/N 38-79A0660N252ACMooney M20K · S/N 25-1159N2555NCessna 140 · S/N 12811N25WMStits SA3B · S/N T0-452N262HNew Standard D-25 · S/N 136N2656ZBellanca 8KCAB · S/N 360-78N284NAmerican Eagle E-430 · S/N 904N28BAAngell Aviation Group JA35 SUPERSTOL · S/N JA 584-04-20N2941VBeech 35R · S/N D-329R12N2953UPiper PA-28-181 · S/N 28-7990582N300DMBeech F90 · S/N LA-165N301JGInteravia E-3 · S/N 0204N303RPPugh Robert A RV-8 · S/N 83024N310TWCessna T310R · S/N 310R1264N313HNew Standard D-25 · S/N 130N314AHRearwin 2000-CO · S/N 104N3179LCessna 310J · S/N 310J0179N333HZDJI PHANTOM 3 PROFESSION · S/N P76DCE07013956First renewal noticeN34AZAlexander Schleicher AS 34 ME · S/N 34032N35625Piper J3C-65 · S/N 6487N36049Piper PA-34-200T · S/N 34-7870287N3778DCessna 182A · S/N 34478N381PAeropro CZ S R O A240 · S/N 420 14N3891GCessna TU206B · S/N U206-0891N399EAPipistrel D O O ALPHA TRAINER · S/N AT162A0007N402CLFretwell Charles B RV-7 · S/N 72694N4030DCessna 182A · S/N 34730N4155RPiper PA-18-150 · S/N 1809061N427AEAlexander COMBINATION EAGLEROC · S/N 467N44176Piper PA-28-151 · S/N 28-7415596N4426WWaco PBF · S/N 3649N446RBeech V35 · S/N D-8474N44JLJose A Lins JR VANS RV7 · S/N 72279N4561QPiper PA-32R-300 · S/N 32R-7780334
Back to Oro Valley, AZ