OpenAirDocs.org
Poway, CA

Registered aircraft · 113

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 = 'CA' AND g.registrant_city = 'POWAY'
  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.

N107DJJardine Doug DR107 · S/N 94-001Built 1996 · Murphy Niccolai AN114HKGeneral Atomics Aero Systems UHK97000-12 · S/N FC114Built 2008 · General Atomics Aeronautical Systems IncN114RRCommander 114TC · S/N 20015Built 1996 · Mdb Air LLCN1151XBeech N35 · S/N D-6705Built 1961 · Summers Jayson VN1166DMooney M20K · S/N 25-0720Built 1983 · Qba LLCN14287Crown City ROBERTSON · S/N CC4-36Built 1946 · Fronius Douglas LN149DLPilatus PC-12/47E · S/N 1049Built 2008 · Hls Air IncN15PFPosnansky/Fronius PF-1 GLIDER · S/N 1Built 1983 · Fronius Robert LN15YKYakovlev YAK 52 · S/N 9311702Built 1993 · Tucker Brandon JN172SXCessna 172N · S/N 17273641Built 1979 · Personal Aviation IncN17HULee John HUTTER 17 · S/N 02Fronius DouglasN188HKGeneral Atomics Aero Systems UHK97000-12 · S/N FC188Built 2010 · General Atomics Aeronautical Systems IncN18984Robinson Sailplane JR-5 · S/N JR5Built 1938 · Fronius Douglas LN18GEPiper PA-18-105 SPECIAL · S/N 18-227Built 1950 · Horvitz Martha EN190TCGeneral Atomics Aero Systems UBC97000-1 · S/N YBC01General Atomics - Aeronautical Systems IncN202STGeneral Atomics Aeronautical UEA97000-1 · S/N ST002General Atomics Aeronautical Systems IncN2194CCessna 195B · S/N 16179Built 1955 · Favero Sebastian AN234ABeech 95-B55 (T42A) · S/N TC-1437Built 1972 · Tr Aero LLCN237RJCirrus Design SR22 · S/N 2159Built 2006 · Argaeus LLCN2459PPiper PA-38-112 · S/N 38-79A1031Zuberi AzharN2474PPiper PA-22-150 · S/N 22-2849Built 1955 · Seidel William G JrN261EMCessna 182N · S/N 18260587Jeffrey Brian CooperN28LKI.C.A.-Brasov IS-28B2 · S/N 90Built 1977 · Wiesmeier Edward IIIN290LBGeneral Atomics Aero Systems UBC97000-16 · S/N GA-6-1497Built 2020 · General Atomics Aeronautical Systems IncN2973EAeronca 7AC · S/N 7AC-6559Built 1946 · Whiting Stephen DN301XPGeneral Atomics Aero Systems UXA97000-2 · S/N GA-11-1001Built 2014 · General Atomics Aeronautical Systems IncN302VFWilliam G Seidel JR RV-14 · S/N 140946Built 2025 · Seidel William G JrN302XPGeneral Atomics Aero Systems UXA97000-3 · S/N GA-11-1002General Atomics Aeronautical Systems IncN308HKGeneral Atomics Aero Systems UHK97000-12 · S/N FC308Built 2013 · General Atomics Aeronautical Systems IncN32FSSchleicher ASW-20L · S/N 20471Built 1981 · Fronius Douglas LN341HKGeneral Atomics Aero Systems UHK97000-15 · S/N FC341Built 2015 · General Atomics Aeronautical Systems IncN343HKGeneral Atomics Aero Systems UHK97000-15 · S/N FC343Built 2015 · General Atomics Aeronautical Systems IncN355GCessna 172N · S/N 17272564Built 1979 · Personal Aviation IncN361HKGeneral Atomics Aero Systems UHK97000-15 · S/N FC361Built 2015 · General Atomics Aeronautical Systems IncN372CVGeneral Atomics Aero Systems UEA97000-2 · S/N AF002General Atomics Aeronautical Systems IncN373CVGeneral Atomics Aero Systems UEA97000-2 · S/N AF003General Atomics Aeronautical Systems IncN374HKGeneral Atomics Aero Systems UHK97000-12 · S/N FC374Built 2017 · General Atomics Aeronautical Systems IncN376CVGeneral Atomics Aero Systems UEA97000-2 · S/N AF006General Atomics Aeronautical Systems IncN377CVGeneral Atomics Aero Systems UEA97000-2 · S/N AF007General Atomics Aeronautical Systems IncN378CVGeneral Atomics Aero Systems UEA97000-2 · S/N AF008General Atomics Aeronautical Systems IncN390MCGeneral Atomics Aero Systems UBC97000-16 · S/N GA-6-1495Built 2020 · General Atomics Aeronautical Systems IncN3989SCessna 172E · S/N 17251189Built 1964 · Paul Kassel CorpN4044ZPiper PA-18-150 · S/N 18-8005Built 1962 · Hainline David ON4169RPiper PA-32-300 · S/N 32-40566Built 1968 · Wollen Mark AN4194SBeech A36 · S/N E-677Built 1975 · Kilpatrick Bryan JN42912Cessna 182L · S/N 18259250Forouzan Fardad TrusteeN4346FPiper PA-28-151 · S/N 28-7715022Built 1976 · Bohne Geoffrey CN437FACessna 172S · S/N 172S9437Built 2003 · Whiskey Charlie Aero LLCN439SFMooney M20R · S/N 29-0039Built 1995 · Carter Randy CN443GEGeneral Atomics Aero Systems UWA97000-22 · S/N GA-9-1180General Atomics Aeronautical Systems Inc
Back to Poway, CA