Prescott Valley, AZ
Registered aircraft · 63
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 = 'PRESCOTT 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 = 'PRESCOTT 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.
N105RCOlds Rodger C GLASAIR III · S/N 3201N11993PK Gyrocopter PK-B-7MC · S/N 100N125ATBurk Corey SABRE TRIKE · S/N 033099N1350YCessna 172C · S/N 17249050N1431APiper PA-22 · S/N 22-347N15277Piper PA-28-235 · S/N 28-7310030N154DCPiper PA-32-300 · S/N 32-40599N162BSCessna 162 · S/N 16200006N1746AReimer Alexander D SPAD 13 REPLICA · S/N 0001N174MGMark Gaboriault RV-7 · S/N 70676N185YMCessna A185F · S/N 18503441N195WDWilliam W Daniel LLC Gyro Flie CALIDUS · S/N C00418N2083YCessna 172D · S/N 17249583N225CSTextron T240 · S/N T24002130N22LFGreen BEDE BD-4 · S/N 298N2375XCessna 182H · S/N 18256275N272PCSchleicher ASW-27 · S/N 27031N321GMMitsubishi MU-2B-60 · S/N 1505 SAN3347FCessna 182J · S/N 18257347N34852Cessna 177B · S/N 17702046N35NWNorth Wing NAVAJO · S/N 51004N361RPPiper PA-32-300 · S/N 32-7440046N38082Beech A36TC · S/N EA-183N3814ASchweizer SGS 1-26 · S/N 94N38590Piper J5A · S/N 5-1010N386JJohn C Johnson CH750 CRUZER · S/N 75-10518N3871ASchweizer SGS 1-26A · S/N 6N421BSSell Robert O VANS RV-9A · S/N 90247N45DLAeroprakt Manufacturing SP Zoo A22LS · S/N 265N483BAAerospatiale SA315B · S/N 2558N52VBBeech 95-B55 (T42A) · S/N TC-560N548ACAir Creation USA ARV TANARG · S/N T10055N551PJim C Gohm S-51 · S/N 132N5704SSchweizer SGS 2-33 · S/N 52N6074QMooney M20C · S/N 3253N60RCCastle Rondle Preston KR2 · S/N 007RPCN66PTAvions Pierre Robin PIERRE ROBIN R2160 · S/N 194N69142Cessna 152 · S/N 15282510Registration pendingN71125Silvaire LUSCOMBE 8A · S/N 2552N7201JPiper PA-28-140 · S/N 28-24531N72RVHarral Blake G HARRAL RV4 · S/N 2401First renewal noticeN73029Cessna 120 · S/N 10234N7632Schweizer SGS 1-34 · S/N 12N7767SSchweizer SGS 2-33A · S/N 137N7791XCessna 172B · S/N 17248291N78092Cessna 182P · S/N 18261748Sale reported, pending cancellationN797EJSchupp Edward W RV9A · S/N 90964N804PLNorth BP PAZMANY PL-4A · S/N PFA 017-10155N8107ACessna 170B · S/N 20959N811ZZPrescott Acft & Automotive SLING TSI · S/N 669SQ
Back to Prescott Valley, AZ