OpenAirDocs.org
Poway, CA

Registered aircraft · 115

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.

N9013XCessna 182D · S/N 18253413Built 1961 · Spooner Brian PN901PCGeneral Atomics Aero Systems UPC97000-1 · S/N PC001Built 2008 · General Atomics Aeronautical Systems IncN903PCGeneral Atomics Aero Systems UPC97000-5 · S/N GA-10-1009Built 2019 · General Atomics Aeronautical Systems IncN929STCessna 510 · S/N 510-0352Built 2010 · Showtech Aviation IncN966ACCessna 172S · S/N 172S8845Built 2001 · Whiskey Charlie Aero LLCN971BNGeneral Atomics Aero Systems USH97000-1 · S/N GA-14-1001General Atomics Aeronautical Systems IncN9724LBeech A24R · S/N MC-101Built 1972 · Barlam Theodore PN972BNGeneral Atomics Aero Systems USH97000-1 · S/N GA-14-1002General Atomics Aeronautical Systems IncN974BNGeneral Atomics Aero Systems USH97000-1 · S/N GA-14-1004General Atomics Aeronautical Systems IncN975BNGeneral Atomics Aero Systems USH97000-1 · S/N GA-14-1005General Atomics Aeronautical Systems IncN976BNGeneral Atomics Aero Systems USH97000-1 · S/N GA-14-1006General Atomics Aeronautical Systems IncN980WCSides Rick A MANTA 503 · S/N M503-08-002Built 2008 · Perico Herbert HN990DAGeneral Atomics Aero Systems UBC97000-10 · S/N GA-6-1496Built 2020 · General Atomics Aeronautical Systems IncN9955XCessna 185 · S/N 185-0155Built 1961 · Murphy Niccolai AN99CJCessna 525 · S/N 525-0333Built 1999 · Bryan Air LLC
Back to Poway, CA