Corona Del Mar, CA

Cancelled registrations · 28

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'CA' AND d.registrant_city = 'CORONA DEL MAR'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N8501PPiper PA-24-400 · S/N 26-81Cancelled Apr 26, 2023 · Built 1964 · Richmond Ronald LN277JTFreefly ALTA · S/N 553890Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Shotwell Media LLCN660JTFreefly Systems ALTA 8 · S/N 95000049Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Shotwell Media LLCN4088GMcsparren Larry D GENESIS · S/N G47LM1Cancelled May 22, 2017 · Registration expired, pending cancellation · Mcsparren Larry DN93075Piasecki HUP-2 · S/N 130016Cancelled Feb 13, 2017 · Revoked, canceled · Built 1965 · Santa Fe Inn IncN93076Piasecki HUP-2 · S/N 128534Cancelled Feb 13, 2017 · Revoked, canceled · Built 1965 · Santa Fe Inn IncN93077Piasecki HUP-2 · S/N 128555Cancelled Feb 13, 2017 · Revoked, canceled · Built 1965 · Santa Fe Inn IncN88944Piasecki HUP-2 · S/N 130053Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Santa Fe Inn IncN88948Piasecki HUP-2 · S/N 130066Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Santa Fe Inn IncN7932KBeech S35 · S/N D-7423Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · Herrick John PN3201NMooney M20J · S/N 24-0567Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1978N9090VMooney M20C · S/N 690007Cancelled Jun 24, 2013 · Sale reported, pending cancellation · Built 1968N151AGLearjet 24 · S/N 137Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1966 · Smith George WN12006Raven S-50 · S/N 111Cancelled Jun 25, 2009 · Registration revoked · Built 1963 · Higbie RichardN325LThomson James W HARMON ROCKET II · S/N 141Cancelled Jun 28, 2007 · Second triennial form not returned · Built 2001 · Thomson James WN53679Cessna 337G · S/N 33701778Cancelled Nov 3, 2006 · Exported to Mexico · Anido VicenteN271ECSchleicher ASW-27 · S/N 27149Cancelled Jul 22, 2004 · Triennial form not returned · Built 2000 · Carapetyan Eugene H TrusteeN5BRSocata TBM 700 · S/N 089Cancelled Aug 14, 2001 · Rasner LloydN63813Piper PA-23-250 · S/N 27-7754137Cancelled May 1, 1984 · Registration expired, pending cancellation · Built 1977 · Burke Walter FN4943CCessna T210N · S/N 21063682Cancelled Dec 6, 1982 · Hahne Walter BN50RKPiper PA-31 · S/N 31196Cancelled Jun 11, 1981 · Exported to Colombia · A To Z LeasingN3106SCessna 182 · S/N 182-55606Cancelled Aug 14, 1972 · Built 1964 · The Richard Webster CorporationN66696Consolidated Vultee BT-13 · S/N 1900Cancelled Feb 23, 1971 · Donald E ElderN53178Boeing A75N1 · S/N 75-3987Cancelled Sep 23, 1970 · Built 1942 · Jessee DavidN127DJodel D-11 · S/N 1Cancelled Apr 21, 1970 · Borden Robert S & Borden Arlene DN4998LPiper PA-28-161 · S/N 28-4384Cancelled Feb 13, 1970 · Nancy N CunninghamN62862Cessna T-50 · S/N 6465Cancelled Oct 24, 1955 · Gutridge Donald FN67260Consolidated Vultee BT-13A · S/N 3070Cancelled Oct 13, 1955 · Stowers John Thomas
Back to Corona Del Mar, CA