Camp Verde, AZ
Registered aircraft · 43
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 = 'CAMP VERDE' 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 = 'CAMP VERDE' 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.
N1376ABeech 36 · S/N E-170N1708PPiper PA-22-150 · S/N 22-2495N1730TMark E Emshwiller CH 750 ZENITH · S/N 8695N18SVVanburen Stuart B SHA-GLASAIR · S/N 580RN215MSSchweizer 269C · S/N S1313N2330GCessna 182B · S/N 51630N238WTRobinson Helicopter R44 II · S/N 14660N2392XCessna 182H · S/N 18256292N23RJFlight Design CTLS · S/N F-13-03-08N30CGGottschang John Craig VARIEZE · S/N 1949N31290Bellanca 7ACA · S/N 69-72N316XPiper PA-28R-200 · S/N 28R-35670N3201EAeronca 11AC · S/N 11AC-1546N3315RCessna 182L · S/N 18258615N3436RPiper PA-28-180 · S/N 28-5680N349EEByrd Emerson E RV6-A · S/N 22905N3682FNorth American SNJ-5B · S/N 88-17662N420PREvans Wayne FS-IISC · S/N 362First renewal noticeN4565Harr Joe L SE-5 A · S/N B4567N4757FCessna P206B · S/N P206-0357N498DACessna 310R · S/N 310R0278N4HHBeech V35 · S/N D-8422N526ZCNesbitt John ROTORWAY EXEC 162F · S/N 6638N546SCWessel Marvin E JR SPORTCOPTER II · S/N MEW001SCN546SWWessel Marvin E JR VORTEX · S/N MEW061N59PQMaurice Bernard R SONEX · S/N 1449N600SEHastings Robert E THORP T-18 · S/N 1279N639CACentrair 101A · S/N 101A0124N6415GRonald Gilbertson MARK III · S/N M3-277N652KWCessna 310P · S/N 310P0077N68PPAllsbrook Thomas B VAN RV-4 · S/N 3395N7271BBeech J35 · S/N D-5626N7398SCessna 182Q · S/N 18265188N74TLThomas C Lombardi VANS RV7A · S/N 73082N7802FCessna A185F · S/N 18502210N80856Globe GC-1B · S/N 259N83018Aeronca 7AC · S/N 7AC-1674N8334TCessna 175C · S/N 17557034N9447WPiper PA-28-235 · S/N 28-11166N95MMManley Marvin RV-6A · S/N 60035N9910ACessna 170A · S/N 19270N9924NCessna 180J · S/N 18052579N9KKKnutson John E GLASAIR III · S/N K1
Back to Camp Verde, AZ