OpenAirDocs.org
Surprise, AZ

Registered aircraft · 55

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

N102CGMcdonnell Douglas Helicopter 500N · S/N LNO85Sale reported, pending cancellationBuilt 1998N104NRainey Norman W RV-10 · S/N 40348Built 2007 · Rainey Norman WN11DUPiper PA-22 · S/N 226252Built 1958 · Mcginnis Terry SN13522Cessna 172M · S/N 17262818Built 1973 · Recker Edward JN15860Piper PA-28-180 · S/N 28-7305165Built 1972 · Baker Stephen JN169CDCirrus Design SR20 · S/N 1077Groseth Cyler D SrN1737GBeech P35 · S/N D-6948Built 1962 · Braly John EN18HHVans RV-12IS · S/N 121216Built 2022 · Veatch John RN19226Cessna 150L · S/N 15074253Built 1972 · Burton ColeN1928NCessna 120 · S/N 12172Built 1947 · Nikkila John CN2008LSanders Mark SPARROW HAWK · S/N SH20050015KBuilt 2006 · Sanders Mark TN225CKOMF OMF-100-160 · S/N 0013G-Force Aviation LLCN231GRMooney M20K · S/N 25-0087Built 1979 · Glahn Tyler R WN236PCessna P210N · S/N P21000116Tmg Investment Properties LLCN2415PPiper PA-18A 150 · S/N 18-4290Built 1955 · Glahn Guy RN244CRRobinson Helicopter R44 II · S/N 14642Built 2023 · Chiponna Ranch LLCN2771HErcoupe 415-C · S/N 3396Built 1946 · Lambertson Paul CN2837Hergert-Stits Skycoupe SA7D · S/N 3Built 1969 · Helgeson Echeverri Mary Ann BN2940FCessna 182J · S/N 18257040Built 1966 · Harry Daye Aviation Services LLCN30382Piper PA-28-161 · S/N 28-7816543Built 1978 · Bird Victor ZN34096Cessna 177RG · S/N 177RG0970Built 1976 · Mirafuentes Akoni JrN355SFAirbus Helicopter AS355F1 · S/N 5054Howe Aviation LLCN359ZGDJI AGRAS T50 · S/N 1581F6BUB246C001T71BGroundshaker Solutions LLCN361PGDJI AGRAS T50 · S/N 1581F6BUB246H001JP91Groundshaker Solutions LLCN3726UBeech 77 · S/N WA-124Built 1980 · Pillor Dalton JohnN446ESchempp-Hirth STANDARD CIRRUS · S/N 446Built 1973 · Ongstad Clifford CN471LJVans RV-12IS · S/N 121154Stewart John CN4936GDJI AGRAS T50 · S/N 1581F6BUB24B50012Y6PGroundshaker Solutions LLCN496NGDJI AGRAS T50 · S/N 1581F6BUB249F00162F2Groundshaker Solutions LLCN499CFAlbright Adventures AIRCAM · S/N AC-247Built 2020 · Arizona Aircam LLCN5138CBeech B35 · S/N D-2423Bean Bonnie JN5216MBeech C23 · S/N M-2010Built 1978 · Chu PhilipN523CPMcdonnell Douglas Helicopter 500N · S/N LN003Howe Aviation LLCN558XBDJI T50 · S/N 1581F6BUB24AJ0017VD9Groundshaker Solutions LLCN6364PPiper PA-24 · S/N 24-1474Built 1960 · Adamczyk DouglasN6501XCessna 210 · S/N 57501Built 1960 · Fisher John PN6752UMooney M20C · S/N 2474Built 1963 · Lucarelli MichaelN694BBEurocopter AS 350 B3 · S/N 4005O307 LLCN7113RPiper PA-28-140 · S/N 28-21812Built 1966 · Newton Dennis EN736TGCessna R182 · S/N R18200768Magleby Herbert KN76GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 279Built 2008 · Culprit Aviation LLCN770TXJason Knight CAVALON · S/N V00307Built 2017 · Fitzgerald Martin LN774LRPiper PA-28R-200 · S/N 28R-7435297Built 1974 · Campbell Jeffrey RN77JMMarlin John E VARIEZE · S/N 308Built 1982 · Marlin John EN781PGMooney M20J · S/N 24-0187Built 1977 · Sword Christina ReneeN79341Mooney M20E · S/N 551Built 1965 · Sigmon Thomas WN805RPPayton Paul D VANS RV-14A · S/N 140278Built 2021 · Campbell Robert WN8075QPiper PA-28RT-201T · S/N 28R-8231026Built 1981 · G-Force Aviation LLCN87WWBrown Donald R KITFOX SERIES 5 · S/N 59511-0160Built 1997 · Reichart John JN8818RBeech B35 · S/N D-2397Crawford Brian L
Back to Surprise, AZ