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.
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
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.
N443GEGeneral Atomics Aero Systems UWA97000-22 · S/N GA-9-1180N44886Piper PA-28-161 · S/N 28-7816038N450MVGeneral Atomics Aero Systems UWA97000-50 · S/N GA-9-1276N4633QCessna 172M · S/N 17261731N4685LCessna 172G · S/N 17254680N468SGGeneral Atomics Aero Systems UBC97000-10 · S/N GA-6-1554N470SGGeneral Atomics Aero Systems UBC97000-10 · S/N GA-6-1557N471SGGeneral Atomics Aero Systems UBC97000-10 · S/N GA-6-1558N479SGGeneral Atomics Aero Systems UBC97000-16 · S/N GA-6-1592N480SGGeneral Atomics Aero Systems UBC97000-16 · S/N GA-6-1635N488SGGeneral Atomics Aero Systems UBC97000-18 · S/N GA-6-1604N490EKGeneral Atomics Aero Systems UBC97000-10 · S/N GA-6-1514N490SGGeneral Atomics Aero Systems UBC97000-18 · S/N GA-6-1606N492SGGeneral Atomics Aero Systems UBC97000-21 · S/N GA-6-1608N493SGGeneral Atomics Aero Systems UBC97000-21 · S/N GA-6-1610N494SGGeneral Atomics Aero Systems UBC97000-21 · S/N GA-6-1612N496MWWonder Michael S RV-4 · S/N 2510N505NLGeneral Atomics Aero Systems UHK97000-36 · S/N GA-6-1652N50796Schweizer SGS 2-8 · S/N 43N508HKGeneral Atomics Aero Systems UHK97000-15 · S/N GA-6-1440N509SGGeneral Atomics Aero Systems UBC97000-26 · S/N GA-6-1616N510SGGeneral Atomics Aero Systems UBC97000-26 · S/N GA-6-1617N512HKGeneral Atomics Aero Systems UHK97000-15 · S/N GA-6-1446N515SGGeneral Atomics Aero Systems UBC97000-22 · S/N GA-6-1609N516SGGeneral Atomics Aero Systems UBC97000-23 · S/N GA-6-1618N519DHCirrus Design SR22 · S/N 0233N529CPChilders William F PULSAR III · S/N P97060030N52TZBeech F33A · S/N CE1297N53619Laister-Kauffman LK-10A · S/N 48N54502Cessna 172P · S/N 17274991N545HPPerico Herbert RAPTOR · S/N AR-2555-5N554TCQuicksilver SPRINT · S/N E023N555TNGeneral Atomics Aero Systems UBC97000-22 · S/N GA-6-1615N5633PPiper PA-24-180 · S/N 24-703N6326UBeech C24R · S/N MC-774N661STAbbott Harry E LONG EZ · S/N 6N6843YPiper PA-23-250 · S/N 27-4187N718BCSchleicher ASW-27 · S/N 27195N732GGCessna 210L · S/N 21061497N737HJCessna 172N · S/N 17269427N742MMChristopher L Ives VANS RV-8 · S/N 83426N74CCessna 172N · S/N 17270368N75JGBeech C23 · S/N M-1716N7818Cessna T240 · S/N T24002024N858APGeneral Atomics Aeronautical UEA97000-1 · S/N AP001GN8616RSchweizer SGS 1-26A · S/N 144N8654RSchweizer SGS 1-26B · S/N 191N8699XCessna 180E · S/N 18051099N878EMCanadair CL-600-2B16 · S/N 5074N87PDRyan Patrick W VANS AIRCRAFT RV6A · S/N 21875
Back to Poway, CA