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.
N63662Cessna 150M · S/N 15077463N63BPWilliam Prokes KITFOX S7 SUPERSPORT · S/N KA07156108N6408YGardner RANS S12-XL · S/N 10980859N6442RPiper PA-28-140 · S/N 28-21624N64HCurtiss-Robertson ROBIN · S/N 415N6587GCessna 150L · S/N 15072087N658WMCirrus Design SR22T · S/N 2107N66478Cessna 150M · S/N 15076074N6669DBeech 95-B55 (T42A) · S/N TC-2271N670APiper PA-34-220T · S/N 34-33136N6980QBeech 19A · S/N MB-404N6XGHatch Hyrum G LANCAIR PROPJET · S/N LIV-533N70061National Ballooning 858 · S/N 131N7027VMooney M20F · S/N 22-1374N704SXCessna 150M · S/N 15078847N713SJCessna 172N · S/N 17269713N716JTVans RV-12 · S/N 120876N71MECessna 401B · S/N 401B0007N71TXDelano Dan E RV7A · S/N 72453N7283ECessna 182B · S/N 52283N7355PPiper PA-24-250 · S/N 24-2533N737JJCessna 172N · S/N 17269450N738EACessna 172N · S/N 17269909N7405WPiper PA-28-180 · S/N 28-1291N74079Grumman American Avn. AA-5B · S/N AA5B-0120N7413RPiper PA-28-140 · S/N 28-21930Registration pendingN74563Robinson Helicopter R44 II · S/N 11045N7474QCessna 182P · S/N 18261114N74AZBeech A36 · S/N E-2017N74KAPhil Laker KITFOX 7 SUPER SPORT · S/N KAM002-11N755LADiamond Aircraft Ind DA 40 NG · S/N 40.NC220N764TBeech A36 · S/N E-392N765SVCirrus Design SR22T · S/N 2390N769CBBeech 35-C33 · S/N CD-960N774EABell UH-1H · S/N 64-13774N777LQGoetz Christopher B RV14A · S/N 140744N777YRGrumman American Avn. AA-5B · S/N AA5B0669N78900Bell 47D1 · S/N 480N78FCessna 210D · S/N 21058258N7912Curtiss Wright ROBIN · S/N 38N7SQCessna 150F · S/N 15063743N800AUKVS Technologies EXPLORER 1.1 · S/N KVS-E-1017N8031FCessna 150F · S/N 15064131N80PADiamond Aircraft Ind DA 62 · S/N 62.C031N8111QRobert J Murrill KOLB MK-3 · S/N M3-290N812BSStephens Bruce RV4 · S/N 97N8195MCessna 310I · S/N 310I0195N821ACAms-Flight Doo APIS MC · S/N AO48 M19N823HMLearjet 45 · S/N 371N84076Cessna 172K · S/N 17258325
Back to Gilbert, AZ