Paradise Valley, AZ
Registered aircraft · 49
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 = 'PARADISE 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 = 'PARADISE 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.
N102GKEpic E1000 · S/N K119Registration pendingN110TACirrus Design SR22 · S/N 2015N1122PBeech V35B · S/N D-10120N112MFBeech 65-88 · S/N LP-37N125ARBeech A36TC · S/N EA-169N1365MCessna 182P · S/N 18264299N139MSAero Vodochody L39C · S/N 031611N143PTMoravan Z143L · S/N 0044N15040Piper PA-32-300 · S/N 327240137N17ENHawker Beechcraft HAWKER 900XP · S/N HA-0102N188Beech 65 · S/N LC70First renewal noticeN2085PPiper PA-28-236 · S/N 28-7911102N2145VBritish BAC 167 STRIKEMASTER · S/N 1924N243SFCessna 560 · S/N 560-0593N259MSCub Crafters CC19-215 · S/N CC19-0109N268JMCirrus Design SF50 · S/N 0173N300JVJanzen Leasing CCX-2000 · S/N CCX-2000-0126N3089ZBeech A36 · S/N E-2402N31XDTheodore Dodson William Dodson XENOS · S/N XNS 0031N323LMBeech 58 · S/N TH-1667N32SLConsolidated Aeronautics LAKE LA-4-200 · S/N 789N3601MBalloon Works FIREFLY 7-B · S/N F7B-044N3775BBeech C-50 · S/N CH-187N41LLBeech A36 · S/N E-1644N434JDay Jack D JACK DAY LONG EZE · S/N JD-4N496TMHawker Beechcraft 400A · S/N RK-561N499LBeech 65 · S/N LC-87N502GSGulfstream Aerospace GVII-G500 · S/N 72002N525MLTextron 525C · S/N 525C0437N5463NCessna 182R · S/N 18267734N551JWCirrus Design SR22T · S/N 0454N580NGExtra Flugzeugproduktions UND EXTRA NG · S/N NG004N6047KRepublic RC-3 · S/N 222N604CHBombardier CL-600-2B16 · S/N 5350N608DDAirborne Windsports PTY OUTBACK · S/N 582-1047N613MNMN Designs CCX-1865 · S/N CCX-1865-2033N6942WPiper PA-28-140 · S/N 28-21122N7157UMooney M20E · S/N 396N721RXMooney M20E · S/N 700060N781THCirrus Design SR22T · S/N 1843N806MNRaytheon HAWKER 800XP · S/N 258605N822BDGulfstream Aerospace GV-SP (G550) · S/N 5064N8327XCessna 172C · S/N 17248827N843BCBeech B200 · S/N BB-1011N8468TCessna 182C · S/N 52368N86JLAircraft Assembly LANCAIR EVOLUTION · S/N 056N8756MBeech 23 · S/N M-544N881FGPilatus PC-12/47E · S/N 1026N9272DPiper PA-18A 150 · S/N 18-6573
Back to Paradise Valley, AZ