OpenAirDocs.org
El Monte, CA

Registered aircraft · 36

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 = 'EL MONTE'
  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.

N102DEPiper PA-28-151 · S/N 28-7615418Built 1976 · Universal Aviators Academy IncN1041PPercival P-40 PRENTICE SER. 1 · S/N VS385Lopez Gabriel A TrusteeN10DBCessna 210M · S/N 21062016Built 1977 · Brandon Donald A TrusteeN114WPCessna 172N · S/N 17267603Built 1976 · Universal Aviators Academy IncN144WBRobinson Helicopter R44 · S/N 0545Built 1998 · Universal Aviators Academy IncN16HFRobinson Helicopter R22 BETA · S/N 0778Built 1988 · Universal Aviators Academy IncN182EFCessna 182P · S/N 18261392Built 1972 · Mission FlightN2143APiper PA-44-180 · S/N 44-7995085Built 1978 · Universal Aviators Academy IncN21LTCessna P210N · S/N P21000216Built 1979 · Mission FlightN222HBPiper PA-28RT-201 · S/N 28R-7918254Built 1979 · Universal Aviators Academy IncN27442Fairchild SA227-AC · S/N AC750-BBuilt 1989 · Mission FlightN33LJCessna 152 · S/N 15282023Built 1978 · Universal Aviators Academy IncN3529WPiper PA-31-350 · S/N 31-7952159Built 1979 · Mission FlightN360LSStolzman Lyle STOLZMAN RV-6 · S/N 20190Built 1996 · Lopez Gabriel A TrusteeN38700Piper PA-28-181 · S/N 28-7890001Built 1978 · Universal Aviators Academy IncN401LMCessna 401B · S/N 401B-0209Mission FlightN4181WPiper PA-32-300 · S/N 32-40263Built 1967 · Mission FlightN4312FPiper PA-28-181 · S/N 287790010Built 1977 · Universal Aviators Academy IncN456BHCessna TR182 · S/N R18201482Castleton Real Estate & Developlment IncN514RWComposite Aeronautic Group TOXO SLSA · S/N TX-002Built 2008 · Wilson Robert JN52314Cessna 182P · S/N 18262521Built 1973 · Universal Aviatiors Academy IncN53153Boeing A75N1(PT17) · S/N 75-731Built 1940 · Lopez Gabriel A TrusteeN543MMAmerican Eurocopter AS350B2 · S/N 7636Built 2013 · Happyheight IncN5504TCessna 172E · S/N 17251404Built 1964 · Lam Pak ToN553XLLiberty Aerospace LIBERTY XL-2 · S/N 0043Built 2006 · Lopez Gabriel A TrusteeN5663VPiper PA-28-161 · S/N 28-7716193Universal Aviators Academy IncN64866Cessna 172P · S/N 17275639Built 1982 · Universal Aviators Academy IncN668EECessna 525 · S/N 525-0343Built 1999 · Flying Journey LLCN6827UMooney M20D · S/N 186Built 1963 · Leong Thomas MN79201Cessna 172K · S/N 17257955Built 1969 · Universal Aviators Academy IncN8269TPiper PA-44-180T · S/N 44-8107022Built 1980 · Universal Aviators Academy IncN8463FPiper PA-28-161 · S/N 28-7716003Mission FlightN8582HNorth American NAVION · S/N NAV-4-557Built 1947 · Lopez Gabriel A TrusteeN889TWPiper PA-28R-201 · S/N 2837023Built 1989 · Universal Aviators Academy IncN8934VCessna 172M · S/N 17264291Built 1974 · Universal Aviators Academy IncN9032Curtiss Wright TRAVEL AIR 4000 · S/N 833Built 1929 · Lopez Gabriel A Trustee
Back to El Monte, CA