Eloy, AZ
Registered aircraft · 47
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 = 'ELOY' 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 = 'ELOY' 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.
N1248LConsolidated Aeronautics LAKE LA-4-200 · S/N 747N133FTCubcrafters CC11-160 · S/N CC11-00201N144CLRobinson Helicopter R44 II · S/N 10980N14981Chambliss DAVIS DA-2A · S/N 182N1814JPiper PA-28-140 · S/N 28-24243N20670Cessna 172M · S/N 17261477N2069PRans S-17 STINGER · S/N 0402036N21KNPiper J3C-65 · S/N 19468N2266TCoghill James P RANS S-14 · S/N 0392023N230AADJI AGRAS T20 · S/N 4JBBJ5B0010093N2625Beech C-45H · S/N AF-601N28320Grumman American Avn. AA-5B · S/N AA5B0559N311CBBird Carroll A VANS ACFT RV-4 · S/N 3919N3374LCessna A185E · S/N 185-1326N3380VBeech 35 · S/N D-848N3542BCessna 182T · S/N 18281216N3876DCessna 182A · S/N 34839N403SCJames A Vanek LIGHTNING · S/N 181N41JSSellers Jim M SUPER REBEL 3500 · S/N SR 136N41LHShort Bros. & Harland SC7 SERIES 3 · S/N SH 1977N422KCSlepcev Nestor STORCH · S/N 130N46EKAeroprakt Mfg SP Z O O A32 · S/N 189N4961DBalony Kubicek Spol Sro BB85Z · S/N 851N50805Cessna 150J · S/N 15069564N52NSShort Bros. & Harland SC-7 · S/N SH-1874N532ACAir Creation USA SKYPPER · S/N T14056N532SCJames A Vanek VORTEX M912 · S/N 176N53834Bellanca 8KCAB · S/N 220-75N5921WPiper PA-28-150 · S/N 28-3227N61450Mara Charles R MARA P B · S/N CRM-4N6325LHarrington Wiley E VANS RV-4 · S/N 1386N6396BCessna 182A · S/N 34296N7081RPiper PA-28-140 · S/N 28-21783N70HKCosmos PHASE III · S/N 1055N719VCFant Jonathan ROTOR LIGHTNING · S/N 001N72201Cessna 120 · S/N 9374N8101YAir Creation 503 - TWIN · S/N T00102N86584Douglas DC3-G202A · S/N 4935N8850NPiper PA-28-140 · S/N 28-25702N9100WPiper PA-28-235 · S/N 28-10711N9163LBellanca 7ACA · S/N 25-71N9244QPiper J3C-65 · S/N 16918N924MADehavilland DHC-6 TWIN OTTER · S/N 216N9701UGrumman American Avn. AA-5A · S/N AA5A-0101N9752HBoeing B75N1 · S/N 75-7129N985SBStaudacher Jon SB985 · S/N 17N995TWWhelan Thomas M RV8 SP · S/N 80013SP
Back to Eloy, AZ