OpenAirDocs.org
Brawley, CA

Registered aircraft · 27

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

N124BLCessna 525B · S/N 525B0181Built 2007 · Lofton Robert AN157RJPiper PA-28-236 · S/N 28-7911168Built 1979 · Tdt Ag Support LLCN182SGCessna 182P · S/N 18261617Built 1972 · Farm Recharge LLCN2047BBeech A36 · S/N E-1394Built 1978 · Field Inspection LLCN2531UBeech A36 · S/N E-2301Clyde Shields Entomological ServiceN25543Porterfield CP-55 · S/N 664Registration revokedBuilt 1940 · Harvey John DN27834Piper J4A · S/N 4-1052Built 1940 · Smith Ronald MN284DBeech A36 · S/N E-1303Built 1978 · Reeves Stephen TrusteeN3114EAeronca 7AC · S/N 7AC6711Built 1946 · Smith Ronald MN3446KPiper J3C-65 · S/N 22137Densburen Farms IncN344WBBeechcraft B200GT · S/N BY-222Built 2014 · Brandt Transport LLCN4323KRyan NAVION · S/N NAV-4-1323Built 1948 · Rothfleisch Joseph RyanN50202Cessna 150H · S/N 15069132Built 1968 · Velasquez JorgeN55575Boeing A75N1(PT17) · S/N 75-1824Built 1946 · Bemis Kenneth L TrusteeN55776Piper PA-32-300 · S/N 32-7340137Built 1973 · Jordan John RN5722VBeech 35-C33A · S/N CE-36Built 1966 · Shank Joel FN6097SBeech A36 · S/N E-789Built 1975 · Donbee Farms IncN6589BMooney M20A · S/N 1259Built 1958 · Elliott Jason RN6675YBeech 58P · S/N TJ-254Built 1980 · Field Inspection LLCN6797YBeech A36 · S/N E-2974Built 1995 · Far West Ranches IncN7235Maule MT-7-235 · S/N 18061CBuilt 2001 · Hale Edward S JrN750PSPaul Sanders STOL CH750 · S/N 75-8102Built 2017 · Sanders Paul MN7697TCessna 172A · S/N 47297Built 1960 · Elliott Jason RexN7926KBeech S35 · S/N D-7421Built 1964 · Oconnell RaymondN8008ZHicks Douglas W TEAM EROS · S/N 1906PPeterson Blake RN9430SBeech 35-C33 · S/N CD-999Built 1966 · Smith Ronald MN9499QBeech A36 · S/N E-323Built 1972 · E J K LLC
Back to Brawley, CA