OpenAirDocs.org
Cypress, CA

Registered aircraft · 26

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 = 'CYPRESS'
  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.

N131RYYamaha Motor FAZER R · S/N 1596A34073D07C8Yamaha Motor Corp U S AN1843YYamaha Motor FAZER R · S/N L38-1-000102Yamaha Motor Corp U S AN300RTBeech A36 · S/N E-2074Built 1983 · Choux Aviation LLCN367TYYamaha Motor FAZER R AP · S/N L75-2-000104Yamaha Motor Corp U S AN450JYYamaha Motor FAZER R AP · S/N L75-2-000103Yamaha Motor Corp U S AN5364YYamaha Motor RMAX · S/N L27-1-100102Yamaha Motor Corporation U S AN53GRYamaha Motor FAZER SAR · S/N 1596F351901936428923Built 2021 · Yamaha Motor Corp USAN546VYYamaha Motor RMAX · S/N L27-1-100112Yamaha Motor Corp USAN559KWKytchener Whyte RV9A · S/N 90770Built 2009 · Whyte Kytchener SN5659CMooney M20K · S/N 25-0761Beck Gary FN67736Beech D17S · S/N 4848Built 1943 · Lane Archie G TrusteeN687YMYamaha Motor FAZER · S/N L30-2-000445Yamaha Motor Corp USAN7091DAerostar International RAVEN S-49S · S/N S49A-3192Built 1994 · Mcwilliams Robin EN747SDCirrus Design SR22 · S/N 2245Built 2006 · Avitrans IncN791UYYamaha Motor RMAX · S/N L27-3-100121Yamaha Motor Corp U S AN81081Penny Barton W RV-8A · S/N 81081Built 2009 · Lytle Brent JN820XYYamaha RMAX TYPE II · S/N L27-3-100124Non-citizen corporation, flight hours not reportedYamaha Motor Corp USAN820YYYamaha Motor FAZER · S/N 1596A34601692B3Yamaha Motor Corp U S AN821AXYamaha RMAX TYPE II · S/N L27-3-100125Yamaha Motor Corp USAN826GYYamaha Motor YAMAHA FAZER-R · S/N L31-1-000158Yamaha Motor Corporation USAN874XYYamaha Motor FAZER R · S/N L38-1-000101Yamaha Motor Corp USAN874ZYYamaha Motor FAZER SAR · S/N 1596F351901936429418Built 2021 · Yamaha Motor Corp U S AN9419HCessna 182R · S/N 18267945Built 1981 · Dedman Basil IN94EEYamaha Motor FAZER R · S/N L75-1-000102Yamaha Motor Corp USAN9704YYamaha Motor YAMAHA FAZER-R · S/N 1596F351901936429418Built 2023 · Yamaha Motor Corp USAN989HYYamaha Motor FAZER R · S/N 159A34E4E8D646Yamaha Motor Corp USA
Back to Cypress, CA