OpenAirDocs.org
Culver City, CA

Cancelled registrations · 186

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 = 'CULVER CITY'
  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.

N108CDDJI INSPIRE 1 · S/N W13DCC17030353Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Fortin MichaelN119CDCinedrones S1000 · S/N CD10050Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Fortin MichaelN594QFDJI PHANTOM 3 PROFESSION · S/N P76DCG21017084Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Fortin MichaelN9601FHughes 269C · S/N 290002Cancelled Feb 13, 2017 · Revoked, canceled · Built 1969 · Summa CorporationN7339QCessna 182P · S/N 18260979Cancelled Feb 4, 2017 · Revoked, canceled · Built 1972 · Lund Carl E JrN8706FHughes 269A · S/N 1010017Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Summa CorporationN739WCCessna 172N · S/N 17270856Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1978 · Bayat Monica LN73906Bell 47J-2 · S/N 2624Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1963 · Oregon Helicopters IncN666WBHandley Page HP-137 MK1 · S/N 237Cancelled Nov 4, 2014 · Registration expired, pending cancellation · Built 1969 · California Flight Partners LtdN92872North American B-25J · S/N 44-29128Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Lebate CorpN61PYMackay John QUCKIE Q-200 · S/N 1956Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Mackay JohnN65CASkyfly CA-65 · S/N 2Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1965N7349ECessna 210 · S/N 57049Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1959 · Walker Lloyd IN7603QCessna T310Q · S/N 310Q0538Cancelled May 1, 2013 · Sale reported, pending cancellation · Built 1972N5771ECessna 150 · S/N 17271Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1959 · Brammell John LN64ENNelson Earl M Q-200 · S/N 2020Cancelled Mar 19, 2013 · Sale reported, canceledN7084JBell 47G-5 · S/N 25028Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1970N2280CTurner ROTA-1 · S/N 001Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1981 · Turner Barry HN48578Grumman Acft ENG Cor-Schweizer G-164A · S/N 1673Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1976 · Aeropostale Productions IncN66413Cessna T-50 · S/N 2772Cancelled Sep 5, 2012 · Revoked, canceled · Built 1943 · Caribbean Macomber BrunzellN67295Cessna T-50 · S/N 6071Cancelled Sep 5, 2012 · Revoked, canceled · Built 1943 · Allison LeslieN25957Cessna 152 · S/N 15280881Cancelled Aug 22, 2012 · Sale reported, canceled · Built 1977N12223Handley Page HP-137 MK1 · S/N 223Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1969 · California Corporate Leasing LtdN50BJMooney M20J · S/N 24-0657Cancelled Nov 7, 2011 · Built 1978 · Jackson BruceN3157KCulver V · S/N V526Cancelled Dec 9, 2010 · Revoked, pending cancellation · Built 1957 · Rogers MuirN4758GCessna 172N · S/N 17273340Cancelled Sep 10, 2010 · Exported to Mexico · Built 1979 · Oconnell MichaelN4062KEugster Fritz FERMAX GYROPLANE · S/N 001Cancelled Jul 27, 2009 · Registration revoked · Built 1962 · Eugster FritzN7JTCessna T210L · S/N 21059721Cancelled Apr 30, 2008 · Second triennial mailing, no response · Built 1972 · Rubinstein NormanN789CTHutter Robert A LONG EZ · S/N 1991LCancelled Feb 10, 2004 · Exported to Pakistan · Built 1989 · Hutter Robert AN9293FHughes 269C · S/N 250394Cancelled Feb 13, 1998 · Exported to Dominican Republic · CampbellairN8808HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1535Cancelled Jun 10, 1997 · Exported to Dominican Republic · Aries Enterprises IncN9704Grumman Acft ENG Cor-Schweizer G-164A · S/N 1216Cancelled Aug 19, 1996 · Exported to Dominican Republic · Aries Enterprises IncN8129WPiper PA-28-180 · S/N 282239Cancelled Mar 20, 1996 · Triennial form not returned · Thompson David RN4042HMooney M20K · S/N 250397Cancelled Jul 1, 1992 · Exported to Germany · Landcap Management Co IncN739HMCessna 172N · S/N 17270556Cancelled Oct 30, 1991 · Exported to Germany · Franklin T ArdenN5080KHughes Helicopters HUGHES 369D · S/N 711031DCancelled Apr 10, 1984 · Exported to Canada · Hughes Helicopters IncN58266Hughes Helicopters HUGHES 369D · S/N 390472DCancelled Mar 30, 1984 · Exported to Japan · Hughes Helicopters IncN5152NHughes Helicopters HUGHES 369D · S/N 1126DCancelled Oct 24, 1983 · Exported to Germany · Hughes Helicopters IncN5199NHughes Helicopters HUGHES 369D · S/N 1178DCancelled Sep 6, 1983 · Exported to Germany · Hughes HelicoptersincN5189GHughes Helicopters HUGHES 369D · S/N 1141DCancelled Sep 1, 1983 · Exported to Germany · Hughes Helicopter IncN58326Hughes Helicopters HUGHES 369D · S/N 990430DCancelled May 20, 1983 · Exported to China · Hughes HelicoptersN58351Hughes Helicopters HUGHES 369D · S/N 390340DCancelled May 20, 1983 · Exported to China · Hughes Helicopters IncN58375Hughes Helicopters HUGHES 369D · S/N 590402DCancelled May 20, 1983 · Exported to China · Hughes Helicopters IncN58394Hughes Helicopters HUGHES 369D · S/N 790468DCancelled May 19, 1983 · Exported to Israel · Hughes Helicopters IncN5292JHughes Helicopters HUGHES 369D · S/N 911064DCancelled Dec 20, 1982 · Exported to China · Hughes Helicopters IncN50605Hughes Helicopters HUGHES 369D · S/N 711019DCancelled Oct 4, 1982 · Exported to Hong Kong · Hughes Helicopters IncN369MDHughes Helicopters HUGHES 369D · S/N 590492DCancelled Sep 30, 1982 · Built 1979 · Summa CorpN8394FHughes Helicopters HUGHES 369D · S/N 370103DCancelled May 20, 1982 · Exported to Canada · Hughes Helicopters IncN8627FHughes Helicopters HUGHES 369D · S/N 570132DCancelled Mar 29, 1982 · Exported to Canada · Summa CorpN50902Hughes Helicopters HUGHES 369D · S/N 811043DCancelled Mar 15, 1982 · Exported to Venezuela · Hughes Helicopter Inc
Back to Culver City, CA