Camarillo, CA
Registered aircraft · 150
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 = 'CAMARILLO' 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 = 'CAMARILLO' 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.
N101BNCulver LCA · S/N 305N1101WLuscombe 11A · S/N 11-184N117BRPoland LIM-5 · S/N 1C1529N117DPBeech B35 · S/N D-2321N117RHPoland MIG 17 (LIM-5) · S/N 1C1502N119JDavid E Parson J430 · S/N 943N11JHCubcrafters CC11-160 · S/N CC11-00415N1317WMooney M20E · S/N 205N133EHMBB BO105 CBS4 · S/N S-598N14WQQuinn Walt GLASAIR SH II S · S/N 2172N154EHMBB BO105 CBS4 · S/N S-704N15ARBell 47G-3B-1 · S/N 2815N164VKenneth M Rees TEAM ROCKET F1 · S/N 229N174JGHealy Gregory C JG SPECIAL · S/N 70333N179NCSocata TBM 700 · S/N 1044N17WFBeech V35B · S/N D-10191N1813YBeech F33A · S/N CE-961N182MTCessna 182 · S/N 18268157N1VDDeluca OR-71 · S/N V102N201RPMooney M20J · S/N 24-3255N205SDBell HH-1H · S/N 70-2472N205VCBell 205B · S/N 30066N206VCBell Helicopter Textron 206L-1 · S/N 45567N2095MPiper J3C-65 · S/N 20874N210HKCessna R172K · S/N R1722481N2122QMooney M20K · S/N 250209N2138LBeech A36 · S/N E-893N2164KMooney M20R · S/N 29-0172N216RGCessna 172P · S/N 17275183N2175WCessna T182T · S/N T18208463N21804Cessna 172M · S/N 17264026N21ZECirrus Design SR20 · S/N 1372N2249TPiper PA-28-181 · S/N 28-7990318N2295KLuscombe 8E · S/N 5022N234MBeech D95A · S/N TD-560N234TYVans RV-12IS · S/N 12155N2350HCessna 182T · S/N 18281706N235FSMaule M-7-235 · S/N 4052CN24NRaytheon B36TC · S/N EA-693N25399Cessna 152 · S/N 15280633N255HHutchinson H/Briegleb R RV-6A · S/N 60132N25665Beech F33A · S/N CE-459N256SMMccartney Steven R RV-6 · S/N 23589N26616Cessna 182S · S/N 18280329N2662TPiper PA-28-180 · S/N 28-7205070N27575Ryan Aeronautical PT-22 · S/N 2210N2924RPiper PA-46-600TP · S/N 4698202N2960SCessna 150G · S/N 15066860N2977VCessna 150M · S/N 15076340N2RVVallance VAN'S RV-3 · S/N 27-A2
Back to Camarillo, CA