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.
N440GBeech V35B · S/N D-9911N444RSCirrus Design SR22T · S/N 9017N44ERGary J Kapphahn Trustee MTOSPORT2017 · S/N M01519N450CTTranstrum Wallace M PITTS MONSTER · S/N 008N4549UCessna 150D · S/N 15060549N45641Luscombe 8A · S/N 2168N46349Cessna 172K · S/N 17257202N4758JBeech A23-24 · S/N MA-186N4793NBurkhart Grob G 103 TWIN II · S/N 3842-K-88N480AMCirrus Design SR22T · S/N 1570N4854XPiper PA-28-180 · S/N 287205040N492AGulfstream Aerospace G-1159A · S/N 425N4951NCessna 182Q · S/N 18267476N4970LPiper PA-28-180 · S/N 28-4344N4BQPiper PA-28-180 · S/N 28-4474N500AUDufour Aerospace X2.3 · S/N 1596F336010A0877068CN501CGCirrus Design SR22 · S/N 4358N5040MBeech B19 · S/N MB-895N5080WPiper PA-28-160 · S/N 28-89N5134KCessna 172N · S/N 17273979N5194ECessna 180B · S/N 50494N521VGDJI AGRAS T50 · S/N 1581F6BUB24CA001RLRCN5222ZPiper PA-22-108 · S/N 22-8897N52373Cessna 182P · S/N 18262560N52527Cessna 182P · S/N 18262658N527CGLuther Arthur B RV-4 · S/N 686N52863Cessna 182P · S/N 18262906N538RHRonald J Huddleston LIGHTNING · S/N 166N5407WPiper PA-28-150 · S/N 28-476N5447UBeech 35-C33A · S/N CE-162N5505FPiper PA-28-140 · S/N 28-24844N5546WPiper PA-28-160 · S/N 28-637N5720WPiper PA-28-160 · S/N 28-1231N5828ACessna 172 · S/N 28428N5832RGrumman American Avn. AA-5B · S/N AA5B-0778N58645Cessna 182P · S/N 18262201N5864BCessna 182A · S/N 33864N600LGAeropilot S R O L 600 · S/N 23116N6049QMooney M20C · S/N 3243N60KBNaval Aircraft Factory N3N-3 · S/N 2747N61097Cessna 150J · S/N 15070798N611AVBombardier BD-100-1A10 · S/N 20693N622BPiper PA-30 · S/N 1341N6235ECessna 172 · S/N 46335N6269LGrumman American Avn. AA-1B · S/N AA1B-0069N627PWCirrus Design SR22 · S/N 2793N6283QCessna 310Q · S/N 310Q0492N6294PCessna P210N · S/N P21000163N632TBeech J35 · S/N D-5632N6362VAlon A2 · S/N A-38
Back to Gilbert, AZ