Safford, AZ
Registered aircraft · 64
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 = 'SAFFORD' 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 = 'SAFFORD' 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.
N108SARockwell International 690B · S/N 11416N114AZBrent Chandler Webb VANS RV-14A · S/N 140304N127HJRockwell International 690B · S/N 11467N17DLAero Commander 500 S · S/N 1866-42N1924MLeonard E Milholland CABIN EAGLE · S/N 12N197GBRockwell International 690A · S/N 11282N210HDAero Commander 500 S · S/N 1841-33N2475NCessna 120 · S/N 12728N260WERockwell International 690B · S/N 11536N262ZBeddes Wayne T TEAM HIMAX 1400 Z · S/N MK352N2946TAero Commander 100 · S/N 070N3145VBeech 35 · S/N D-575N32WSRockwell International 690A · S/N 11339N33401Piper PA-34-200T · S/N 34-7570115N3616APiper PA-22-135 · S/N 22-1876Registration pendingN3627CCessna R182 · S/N R18200285N3UVAero Commander 500 S · S/N 3146N411AZCharles Ferrin / Wade Barnett VANS RV 7A · S/N 74411N411KCBeech B200 · S/N BB-901N4149PAir Tractor AT-802A · S/N 802A-0255N4162QCameron Balloons US V-90 · S/N 5768N434CFCessna 525A · S/N 525A0434N44NCRockwell International 690B · S/N 11387N45AZRockwell International 690B · S/N 11383N4694YCessna T210N · S/N 21063988N4960JCessna T188C · S/N T18803791TN4QSAero Commander 500 S · S/N 1755-1N5110ZAir Tractor AT-802A · S/N 802A-0060N5638ZMaule M-5-235C · S/N 7294CN585RBBeech 200 · S/N BB-528N586DVRockwell International 690B · S/N 11553N5935Air Tractor AT-802A · S/N 802A-0035N59BPPridgen Blaine QUICKSILVER SPORT 2S · S/N SPORT 2S 0156N644VQuicksilver SPORT 2S · S/N 0068N647RVKenneth Wade Barnett VANS RV7 · S/N 72693N6722BCessna T210M · S/N 21062826N67BECessna 550 · S/N 550-0619N6841WPiper PA-28-140 · S/N 28-20984N690ARAero Commander 690A · S/N 11155N690CPRockwell International 690B · S/N 11451N690FDRockwell International 690B · S/N 11393N690HBAero Commander 690A · S/N 11205N690RAAero Commander 690 · S/N 11010N69ZCDaniel M Brandborg FISHER DAKOTA HAWK · S/N DH98N711CMBeech 95-55 · S/N TC-171N71704Luscombe 8A · S/N 3131N71AARockwell International 690B · S/N 11527N7506HCameron Balloons US V-77 · S/N 5798N751BRRockwell International 690B · S/N 11436N76WARockwell International 690A · S/N 11342
Back to Safford, AZ