OpenAirDocs.org
Mesa, AZ

Registered aircraft · 714

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 = 'MESA'
  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.

N1002XMD Helicopters 369FF · S/N 0362FFMd Helicopters LLCN1004RMD Helicopters 369FF · S/N 0363FFMd Helicopters LLCN1005GMD Helicopters 369FF · S/N 0364FFMd Helicopters LLCN1006CMD Helicopters 369FF · S/N 0365FFMd Helicopters LLCN1006MMD Helicopters 369FF · S/N 0366FFMd Helicopters LLCN1006TMD Helicopters 369FF · S/N 0367FFMd Helicopters LLCN1008HMD Helicopters 369FF · S/N 0369FFMd Helicopters LLCN1010DCessna 195A · S/N 7618Built 1950 · Boggs DavidN101WSCessna 172L · S/N 17260218Built 1971 · Karnick Mark CN1041QPiper PA-28-161 · S/N 28-7716081Built 1977 · Swaz Aviation LLCN1049YCameron Balloons A-315 · S/N 6429Built 2005 · Airtime Equipment LLCN106EMPiper PA-28-181 · S/N 28-7790460Built 1977 · Venture West LLCN106PVSam R Peachey JA30 SUPERSTOL · S/N JA378-05-14Built 2014 · Jensen Douglas RN1083FMooney M20J · S/N 24-3317Kellogg Gretchen GarstN1091MCessna 172L · S/N 17259491Built 1970 · Swaz Aviation LLCN109SFAgusta A109A II · S/N 7436Built 1989 · Heli Assets LLCN10RQOriginal Microsystem Spec RQ-05 VULTURE · S/N 05-0001Original Microsystem Specialties LLCN10XQIsrael Aircraft Industries GULFSTREAM 200 · S/N 169Built 2007 · Ninja Consulting LLCN111MWPiper PA 46-350P · S/N 4636822Built 2023 · Saratoga 181 LLCN112KDTextron G36 · S/N E-4076Built 2016 · Cloud Surfing LLCN11407Cessna 150L · S/N 15075396Built 1973 · Harrop BrianN114FSDJI AGRAS T20 · S/N 36RBHAM00100B6Sunrise Drones LLCN115JWRockwell International 114 · S/N 14081Built 1976 · Feric DrazenN116DGBeech B100 · S/N BE-116Built 1981 · Structures IncN1207HPiper PA-28-181 · S/N 28-7790295Venture West LLCN1211YCessna 150B · S/N 15059611Built 1962 · Edens William DN121CRHeisdorffer Roger GLASAIR · S/N 418Maxson Lee VN121FCessna 180 · S/N 32353Built 1956 · Hamilton Wayne JN1228GCessna 310Q · S/N 310Q1081Built 1974 · Mcdaniel Dean KN123HPBell Helicopter Textron 206L-1 · S/N 45394Built 1980 · Southwest Heliservices LLCN1240DCessna 170A · S/N 19794Built 1950 · Baeder Mark AN1260TPiper PA-28-140 · S/N 28-7225441Built 1972 · Red Rock Flying School LLCN1285DColumbia Aircraft Mfg LC41-550FG · S/N 416386886 Aviation LLCN1286CColumbia Aircraft Mfg LC41-550FG · S/N 41591Built 2006 · Calabarb Aviation LLCN12931Cessna 172M · S/N 17262382Built 1973 · Walden David CN12EECessna 182S · S/N 18280038Arizona Cloudbusters IncN12RQOriginal Microsystem Spec RQ-05 VULTURE · S/N 05-0002Original Microsystem Specialites LLCN130BBBursey W James SKYBOLT · S/N 0013Built 1979 · Hatfield Derik LN1312UCessna 172M · S/N 17267001Built 1976 · Simplifly LLCN1341DCessna 170A · S/N 19917Built 1951 · Builders Guild IncN134DCVerdoorn Daniel C RV-8 · S/N 8-1116Built 2003 · Cranton Larry JN14020Waco UKC · S/N 3864Built 1934 · Hatfield Derik LN14714Bellanca 17-31ATC · S/N 74-31084Built 1973 · Poco Loco LLCN1477XPiper PA-28-140 · S/N 28-7525313Built 1975 · Red Rock Flying School LLCN14RQOriginal Microsystem Spec SV-06 SUPER VULTURE · S/N 06SV-0003Original Microsystem Specialties LLCN14WHCirrus Design SR22 · S/N 3109Waypoints LLCN1500DCessna 190 · S/N 7722Built 1951 · Maxson Lee VN150XXAero Vodochody L39C · S/N 031617Built 1980 · Mudge Consulting LLCN151RJNorth American P-51D · S/N 44-74404Newberg Edgar TN1538DCessna 195 · S/N 7760Adams Richard J
Back to Mesa, AZ