OpenAirDocs.org
Del Mar, CA

Registered aircraft · 22

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 = 'DEL MAR'
  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.

N120WLPilatus PC-12/47E · S/N 2418Built 2024 · N120wl LLCN140PPPiper PA-46-600TP · S/N 4698140Built 2020 · N560hp LLCN1469ZCampbell Scott W VANS RV8 · S/N 83063Built 2019 · Campbell Scott WN202PBEurocopter EC120B · S/N 1084Built 2000 · Calpass CorpN21074Cessna 182P · S/N 18261396Built 1972 · Church Brian LeeN262NJJeremiah Jackson VANS RV-10 · S/N 41147Built 2012 · J2environmental LLCN26875Gulfstream American AA-5A · S/N AA5A0779Built 1978 · Yin SteveN271CSCessna 510 · S/N 510-0158Built 2009 · 105 Alas LLCN3776TCessna T182T · S/N T18208314Built 2004 · Fractional Villas IncN403FDAgusta F.260D · S/N 768Built 1990 · Francesco TedeschiN46EYSocata TB 30 EPSILON · S/N 46Built 1985 · Firefly LLCN518WBFairey FIREFLY AS-6 · S/N 135129Built 1950 · Kurdziel Edward G Jr TrusteeN5258NCessna 182Q · S/N 18267607Built 1980 · Offcourt LtdN552RMSchempp Hirth Flugzeugbau DISCUS 2C · S/N 67Tedeschi Francesco TrusteeN5WFBeech A36 · S/N E-2892Built 1994 · Mociva IncN600HMCessna 208B · S/N 208B0479Built 1995 · Farm And Harvest Machinery LLCN672SRProgressive Aerodyne SEAREY LSA · S/N 1109Noonan JeffN747JJCessna 525A · S/N 525A0314Built 2006 · 314 LLCN78SDBombardier BD-700-1A10 · S/N 9765Built 2017 · Liquid Aviation IncN79326Mooney M20E · S/N 536Built 1964 · Campbell Scott WN8091TBeech F33A · S/N CE-1655Built 1992 · Transki TylerN919JRRobinson John RV-7A · S/N 70840Built 2014 · Byrne Ian E
Back to Del Mar, CA