Oxnard, CA
Registered aircraft · 91
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.
N1001JMooney M20J · S/N 24-3095N107RZWhite J/White C LONG EZ · S/N 685N1085TBell Helicopter Textron 206L-1 · S/N 45376N1305PPiper PA-23 · S/N 23-345N130SASabrewing RG-1-A · S/N 00001N13454Cessna 177B · S/N 17702423N1428CPiper PA-22-135 · S/N 22-1180Registration revokedN182BVCessna 182P · S/N 18263665N1984MCirrus Design SR22 · S/N 4218N20CEGlover Austin V CHRISTEN EAGLE II · S/N GLOVER-0001N212AHBell 212 · S/N 30959N2207LBeech A36 · S/N E-915N2326RCessna 182G · S/N 18255426N260GRChristen Industries PITTS S-2B · S/N 5059N269DSDiamond Aircraft Ind DA 40 · S/N 40.269N272JACessna 172M · S/N 17267439N2784QPiper PA-28R-201T · S/N 28R-7703077N2912SCessna 150G · S/N 15066812N300LFPartenavia P.68C · S/N 295N3109RCessna 182L · S/N 18258509N3171TCessna 177 · S/N 17700471N340PNPartenavia P68-TC OBSERVER · S/N 340-02/OTCN3503Hodges William H II QUICKSILVER GT-500 · S/N 001Registration pendingN362ERWolf Robert S LANCAIR 360 MK II · S/N FB350N377Aviat A-1 · S/N 1344N383SHBell 206L-3 · S/N 51073N384VPPartenavia P.68 OBSERVER 2 · S/N 384-01-OB2N39049Bell 206B · S/N 3101N3MEBeech F90 · S/N LA-101N403AHPartenavia C.A. AP68TP SERIES 300 · S/N 8009N408MRBell 206B · S/N 2397N412ESBell 412EP · S/N 36423N42019Piper J3C-65 · S/N 8277-22N4277BCessna R172K · S/N R1722556N42TKSSV Works CCX-2300 · S/N CCX-2300-0056N44959Partenavia P 68 OBSERVER · S/N 319-14/OBN477KABell 407 · S/N 53579N48ASSky International S-2C · S/N 6007N503SACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 041/USN50577Cessna 150J · S/N 15069408N5068CBeech B35 · S/N D-2330N53727Fairchild M-62A · S/N T435144N541DBBeech S35 · S/N D-7333N545GHCessna 525C · S/N 525C0067N55TBPiper PA-28-140 · S/N 28-21634N5743HBell 206B · S/N 3042N5906GCessna 150K · S/N 15071406N617ACBell 407 · S/N 53570N6219ECessna 172 · S/N 46319N63469Cessna 150M · S/N 15077339
Back to Oxnard, CA