OpenAirDocs.org
Downey, CA

Registered aircraft · 30

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

N10TNBritish Aerospace HS 125-700A · S/N 257085Pacific Rim Management LLCN1466UCessna 172M · S/N 17267133Concepcion LeonardoN1AMGulfstream Aerospace G-V · S/N 623Built 2000 · Meruelo Group LLCN2000Grumman G-1159 · S/N 56Global Avionics LLCN213RGBritish Aerospace BAE 125 SERIES 800A · S/N 258073Built 1986 · Global Avionics LLCN227ECPiper PA-31-350 · S/N 31-7405184Built 1974 · Ecjet IncN227LJSwearingen SA227-AC · S/N AC-522Built 1982 · Metro-Jet LLCN28DFPiper PA-31-325 · S/N 31-7812121Global Avionics LLCN307CRCessna 172M · S/N 17262385Empire Of Stars Commercial And Residential RealN3530BPiper PA-31-310 · S/N 31-7912075Built 1979 · Global Avionics LLCN39921Piper PA-32RT-300T · S/N 32R-7887167Guevara Cerrato Edras ON404AAGulfstream American G-1159A · S/N 362Built 1982 · Pacific Rim Management LLCN421JMCessna 421B · S/N 421B0956Built 1975 · Schuck James MN42408Piper J-3C · S/N 14668Registration revokedBuilt 1945 · Sullivan Robert JrN434RBGreat Lakes 2T-1A-2 · S/N 0740Built 1976 · Brown Brian MN43JRBritish Aerospace BAE 125-800A · S/N 258173Global Avionics LLCN488DPBeech A36 · S/N E-522Built 1974 · Rodarte LionelN511KAGulfstream Aerospace G-IV · S/N 1111Built 1989 · 1111 Giv LLCN6454ECessna 172 · S/N 46554Registration pendingN717LFDassault MYSTERE-FALCON 50 · S/N 32Onpoint Avionics LLCN7356LAmerican AA-1B · S/N AA1B-0056Built 1972 · Crosetto Pierre FN7425GCessna 172K · S/N 17259125Built 1970 · Smoke Eagles IncN748MNGrumman American Avn. G-1159 · S/N 215Built 1977 · Onpoint Avionics LLCN8544HBellanca 17-31ATC · S/N 31010Built 1970 · Law Offices Of Timothy E Nilan A Pro Law CorpN855MWCorporate Jets BAE 125-800A · S/N 258241Built 1993 · Munguia MarioN8843PPiper PA-24-260 · S/N 24-4298Built 1965 · Rodarte Lionel AN900DGSocata TBM 700 · S/N 225Built 2002 · Caterers Leasing IncN914ECBritish Aerospace BAE 125 SERIES 800A · S/N 258001Pacific Rim Management LLCN9342HCessna 172M · S/N 17266100Built 1975 · Gutierrez RicardoN9573LGrumman American Avn. AA-5 · S/N AA5-0573Built 1974 · Crosetto Pierre F
Back to Downey, CA