Scottsdale, AZ
Registered aircraft · 685
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 = 'SCOTTSDALE' 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 = 'SCOTTSDALE' 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.
N100AMQuest KODIAK 100 · S/N 100-0259N100FFEmbraer-Empresa Brasileira De EMB-500 · S/N 50000141N100HTBell 47G-2 · S/N 2N100NJBell 206B · S/N 3992N100TLCirrus Design SF50 · S/N 0079N1026TBeech V35B · S/N D-9981N103AZYuneec TYPHOON Q500 · S/N YU16140434B04F01N1055EBellanca 7ECA · S/N 1208-77N105AZYuneec BREEZE · S/N 00E060B02828N108ETBombardier BD-100-1A10 · S/N 20333N110YWaco RNF · S/N 3298N111NCCessna 310R · S/N 310R0182N111UHRobinson Helicopter R22 BETA · S/N 3750N112CCBombardier BD-700-2A12 · S/N 70255N1136KDJI MAVIC PRO PLATINUM · S/N 08QCF3LP02237HN113AZIsrael Aircraft Industries ASTRA SPX · S/N 113N114MSEiriavion PIK 20B · S/N 20131CN11564Cessna 177B · S/N 17702347N11569Cessna 150L · S/N 15075529N115PDDJI MATRICE 300 RTK · S/N 1ZNDH9B00CP0EWN1161VColumbia Aircraft Mfg LC41-550FG · S/N 41749N116KMMccann Michael PULSAR · S/N 116N116PSCirrus Design SF50 · S/N 0472N117CCSwearingen SA226-T(B) · S/N T-325N117WTCessna 172P · S/N 17276264N118DDuane R Huff SPORTMASTER 150 · S/N DRH-1N11952Cessna 150L · S/N 15075730N11XZShawn Beck Jordan VANS RV-4 · S/N 3204N120XRBalony Kubicek Spol Sro BB20XR · S/N 852N123MLRaytheon B200 · S/N BB-1587N1248Terry D Johnstone KITFOX 7 SS · S/N KA22106544N124RKCirrus Design SR22T · S/N 0989N125TWTextron 172S · S/N 172S13023N12650Cessna 172M · S/N 17262145N127WMMoor Willard L THORP T-18 · S/N 1369N1287UCessna 172M · S/N 17266981N1292GCessna 310Q · S/N 310Q1141N129KTextron 172S · S/N 172S12825N131CWConvair C-131D · S/N 54-2809N1327KCessna T206H · S/N T20608690N133DFExtra Flugzeugbau EA 300/L · S/N 030N1343Wickham B · S/N 1N135MEHawker Beechcraft 4000 · S/N RC-13N136JAOrtner Alan E RV6 · S/N 23676N136TBRaytheon A36 · S/N E-3419N13VECirrus Design SF50 · S/N 0068N140WTCessna 172P · S/N 17276201N1421KCessna T182T · S/N T18208819N142SFCirrus Design SR20 · S/N 1527N14306Cessna T182T · S/N T18208681
Back to Scottsdale, AZ