Gilbert, AZ
Registered aircraft · 223
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 = 'GILBERT' 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 = 'GILBERT' 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.
N252GPiper PA-28-140 · S/N 28-26191N254AZSaylor Edward SAYLOR RV-7A · S/N 72102N255DPCirrus Design SR22 · S/N 2728N255KRCessna 172N · S/N 172-69860N2571DCessna 170B · S/N 20723N264VAVans RV-12 · S/N 12039N270MDWest Richard GLASAIR SUPER II S · S/N 2217N2819XCessna 177 · S/N 17700219N287WMEclipse EA500 · S/N 000247N290RVDJI PHANTOM 4 PRO · S/N 0AXCE5R0B30112N29295Culver LCA · S/N 164N2967XChristen Industries A-1 · S/N 1054N2996YCessna 182E · S/N 18253996N3007RFirefly Balloons 2010 FIREFLY 8B-15 · S/N F8B-2116N30524Cessna 177A · S/N 17701302N305RKMooney M20K · S/N 25-0820Registration pendingN310XADiamond Aircraft Ind DA 62 · S/N 62.C072N313TCCoffman Timothy K STOL CH 701 · S/N 7-5480First renewal noticeN315XADiamond Aircraft Ind DA 42 NG · S/N 42.N590N316XACompagnie Daher TBM 700 · S/N 1610N3187MPiper PA-12 · S/N 12-2014N3187QPiper PA-28-181 · S/N 28-7790441N3293DCessna 180 · S/N 32091N331XATextron 525B · S/N 525B0703N333XATextron 525 · S/N 525-0889N3352FCessna 182J · S/N 18257352N33566Piper PA-28R-200 · S/N 28R-7535161N335CBBeck Charles GLASAIR III · S/N 3290N336XADiamond Aircraft Ind DA 40 NG · S/N 40.NC292N337XADiamond Aircraft Ind DA 40 NG · S/N 40.NC296N338XADiamond Aircraft Ind DA 40 NG · S/N 40.NC307N339XADiamond Aircraft Ind DA 40 NG · S/N 40.NC311N33SEDG Flugzeugbau DG-800B · S/N 8-176B100N3575JCessna 150E · S/N 15061275N3589MPiper PA-28R-201T · S/N 28R-7803181N3616UCessna 182F · S/N 18255016N372VRCKD Engrg LLC DBA Vashon Acft RANGER R7 · S/N 10227N3753YCessna 210D · S/N 21058253N382CFPiper PA-38-112 · S/N 38-79A1043N3929FPiper PA-32R-300 · S/N 32R-7680420N3944Cessna 172E · S/N 17251510N3965TPiper PA-28R-180 · S/N 28R-30311N4007YRobinson Helicopter R66 · S/N 1442N4101JPiper PA-28-140 · S/N 28-22413N4153DPiper PA-18-150 · S/N 1809038N42025Cessna 180J · S/N 18052301N422BWCessna 210J · S/N 21059100N424JDSchuld Jeremy D RV-7 · S/N 73827N4285TPiper PA-28-180 · S/N 28-7205056N42885Piper PA-28-151 · S/N 28-7415403
Back to Gilbert, AZ