Oxnard, CA
Registered aircraft · 90
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 = 'OXNARD' 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 = 'OXNARD' 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.
N6480FCessna 150F · S/N 15063080N6602LPartenavia P 68 OBSERVER · S/N 326 19 OBN6664LBeech A36TC · S/N EA-20N6693UMooney M20C · S/N 2420N6697ACessna 172 · S/N 28797N6698QBeech C23 · S/N M-2391N674CBBeech 77 · S/N WA-8N68VAVulcanair P68C · S/N 440/CN696NSCessna 150H · S/N 15068871N69765Boeing A75N1(PT17) · S/N 75-1044N7042ECessna 175A · S/N 56542N707AHBell 407 · S/N 53632N71519Luscombe 8A · S/N 2946N720CATextron 172S · S/N 172S13528N7391LCessna A152 · S/N A1520808N739PHCessna 172N · S/N 17270693N7438ACessna 172 · S/N 29538N76TRSwaney Mark J TEAM ROCKET F1 · S/N 031N78VLGrumman American Avn. AA-5A · S/N AA5A-0558N814CLDouglas DC3C · S/N 34370N814PPFlight Design CTSW · S/N 05-06-04N8222UCessna 172F · S/N 17252122N8249MCessna T210M · S/N 21062039N826FPRaytheon B300 · S/N FL-284N8287DBeech J35 · S/N D-5371N841CMPiper PA-28-180 · S/N 28-5488First renewal noticeN888GWPilatus PC-12/45 · S/N 421N88NPartenavia P.68C · S/N 352-37/TCN8923VCessna R172K · S/N R1722326N89959Cessna 140 · S/N 9011N928JCCessna 182Q · S/N 18265616N9341MMooney M20E · S/N 1273N9363LAmerican AA-1A · S/N AA1A-0063N93MCMark Craven VANS RV7 · S/N 71004N93RRRonald T Reid RV-9 · S/N 91757N942BAIcon A5 · S/N 00203N9765HCessna T182 · S/N 18268006N98EBFairchild SA226-T · S/N T-332N995GSStucker Gary BANTY · S/N 1285First renewal noticeN9YZGrumman American Avn. AA-5 · S/N AA5-0822
Back to Oxnard, CA