Salome, AZ
Registered aircraft · 62
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 = 'SALOME' 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 = 'SALOME' 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.
N10812Stinson SM-7B · S/N M3013N1101DPassow TAILWIND W-8 · S/N PW-396N11748Cessna 150L · S/N 15075610N129MCessna A185F · S/N 18502208N129MLLarkin Marion J RAF 2000 GTX SE FI · S/N H2-01-12-513N1509GReppert Merlyn R QUICKSILVER MXSPRINT · S/N 2004N151DHHerk Darrell D RV-4 · S/N 2915N167SFNeal Allen B SERIES 5 OUTBACK · S/N S9812-0180N169MLLarkin Marion Jean MURPHY SR 2500 · S/N 009SRN198TPPiper PA-22-160 · S/N 22-5625N2027CChandler Walter W PHOENIX · S/N 31200HN2073ZCone James A. ZENAIR CH701 STOL · S/N 7-1274N2087CPiper PA-12 · S/N 12-3497N2096ZCessna 150C · S/N 15059896N21006Cessna 182P · S/N 18261351N2449LCessna 172H · S/N 17255649N2738HErcoupe 415-C · S/N 3363N27MEMills Merle E BAKENG DUCE · S/N M-1N282CFrost Gary RV-6 · S/N 20853N3120XFowles Randall K FLIGHTSTAR II SC · S/N 329N320JSSeela Joel Jay MAGNUM · S/N 102MN3448MPiper PA-12 · S/N 12-2344N3688MPiper PA-12 · S/N 12-2634N369MLMarion J Larkin MIGLET · S/N 003N386MCDan Ballin CCK-1865 · S/N CCK-1865-0070N4143FCessna 172 · S/N 46043N41700Bellanca 7GCBC · S/N 596-73N42806Piper J3C-85 · S/N 15121N4293BBeech F35 · S/N D-4355N464BFJohn W Moore REPLICA PA-11 · S/N 11-001N46686Cessna 180J · S/N 18052434N4972MBeech A36 · S/N E-1275N5680ACessna 172 · S/N 28280N5776ECessna 150 · S/N 17276N584RVValek Roger/Randall Jack RV 4 · S/N 587N593ZSMike Swendsen/Darwin Roberts HP16 SCHREDER · S/N SNR 0695N606FBMclaughlin George G RANS S6S · S/N 08011421N62138Boeing A75 · S/N 75-3457N62TMitchell Jack C BREEZY RLU-1 · S/N 623N6629TCessna 150A · S/N 15059029N6640ECessna 175 · S/N 56140N67452Cessna 152 · S/N 15281843N67RPAmerican Legend AL18 · S/N AL-1227N6869KPiper PA-16 · S/N 16-704N716DWSeifert Dale E HIGHLANDER · S/N JAESC0043N7259MCessna 175 · S/N 55559N7454MCessna 175 · S/N 55754N752DRDaniel A New ZENITH STOL 750 · S/N 75-7571N7555WPalmer Jerry A ULTRAPUP · S/N 001N7566CForney F-1 · S/N 5683
Back to Salome, AZ