Pasadena, CA

Cancelled registrations · 131

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

N1165RRaven Industries RX6 · S/N RX6-224Cancelled Jun 25, 2009 · Registration revoked · Built 1977 · Jones FrankN1238RRaven S-50A · S/N S50A-276Cancelled Jun 25, 2009 · Registration revoked · Built 1977 · Lancaster JohnN27996Piper PA-31-350 · S/N 31-7952083Cancelled Jan 14, 2009 · Built 1979 · Uas Transervices IncN655MACessna 172S · S/N 172S8507Cancelled Nov 5, 2004 · Exported to Canada · Built 2000 · Andringa Aviation LcN88414Bellanca 7GCBC · S/N 780-75Cancelled Sep 15, 2004 · Exported to Canada · Built 1974 · Blew Steven SN86208Enstrom F-28C · S/N 522-2Cancelled Apr 4, 2000 · Triennial form not returned · City Of PasadenaN9445ZCessna 172R · S/N 17280433Cancelled Sep 27, 1999 · Lewis James WN3030HEngineering & Research ERCOUPE 415-D · S/N 3655Cancelled Jan 22, 1999 · Triennial form not returned · Kaplan Jordan AN2209PBell 206B · S/N 3520Cancelled Mar 24, 1997 · Fleet Unlimited IncN4337KPiper PA-32R-301 · S/N 32R8413007Cancelled Mar 20, 1995 · Exported to New Zealand · Rust H IanN7765CNorth American T-6G · S/N 501288ACancelled May 3, 1994 · Elliot Francis WN505GMPiper PA-30 · S/N 30251Cancelled Jun 14, 1991 · Smalldridge Jonathan DN9JEELY Jack L. THORP T-18 · S/N 892Cancelled May 23, 1991 · Duval James EN522HEnstrom F-28A · S/N 323Cancelled Jun 25, 1984 · City Of Pasadena Pasadena Police DepartmentN510BCCessna 320 · S/N 320D0113Cancelled Feb 28, 1983 · Cornet StoresN978VBeech B-55 · S/N TC-2038Cancelled Jan 9, 1980 · United Medical Leasing Co IncN4036GBell 206A · S/N 193Cancelled Dec 16, 1977 · Exported to Canada · Built 1968 · United Medical Leasing Co IncN8115ZCessna 210-5(205) · S/N 2050115Cancelled May 16, 1975 · Sorensen Griffith LN3212CBeech E35 · S/N D-3875Cancelled May 7, 1975 · A Crosby Doe Or George D BuchananN3903CCessna 150H · S/N 15069123Cancelled Jul 10, 1974 · Irwin Jr Kalman JN9496ZBeech C-45H · S/N 51-11570Cancelled May 17, 1974 · West Edward JrN7498ECessna 210 · S/N 57198Cancelled Mar 14, 1974 · Sohus JohnN7514QCessna T310Q · S/N 310Q-0014Cancelled Sep 24, 1973 · Mieras J WesleyN4323GMcculloch J-2 · S/N 033Cancelled Jun 22, 1973 · United Medical Leasing Co IncN913YNorth American F-51D · S/N 122-38859Cancelled Oct 13, 1972 · Built 1945 · Vartanian Richard MN4897Enstrom F-28A · S/N 054Cancelled Feb 28, 1972 · Built 1969 · City Of PasadenaN3399TCessna 177 · S/N 17700699Cancelled Aug 27, 1971 · Eddie MccuneN1385WMooney M20E · S/N 231Cancelled Jul 23, 1971 · Hays Satterfield And BooneN4235NCessna 140 · S/N 13706Cancelled Jan 20, 1971 · Eads RobertN5434DBeech H35 · S/N D-4925Cancelled Jan 4, 1971 · Stoehr Frederick GN4160ZPiper PA-18-150 · S/N 18-8342Cancelled Sep 17, 1970 · Exported to Canada · California Institute Of TechnologyN1458Garnett BENSEN B-8M · S/N RG13Cancelled Jul 10, 1970 · Garnett Robert AN86674Zefir SZD 192A · S/N P-420Cancelled Jun 30, 1970 · Austin Jerry RN6882CRepublic F-84E · S/N F84E-49-2344Cancelled Jun 19, 1970 · Pasadena City Junior College DistrictN3642GBenson GYROCOPTER · S/N PG-12Cancelled Oct 15, 1965 · Garnett Robert AN9107RBeech C18S · S/N 5660Cancelled Sep 24, 1965 · Richard G KennedyN2768VBeech 35 · S/N D-159Cancelled May 21, 1965 · Neff Andrew MN68104Beech D17S · S/N 6732Cancelled Aug 13, 1958 · Nienstedt Donald A & Winifred D NienstedtN81653Aeronca 7AC · S/N 7AC-274Cancelled May 17, 1958 · Fred J RingN69902Lockheed P-38L-5 · S/N 8470Cancelled May 2, 1958 · Hycon Mfg CoN67824Consolidated Vultee BT-13 · S/N 5532Cancelled Feb 17, 1956 · Roberts James K Clinton HetrickN684CStinson 108-3 · S/N 108-3684Cancelled Nov 17, 1955 · Wanamaker RobertN57105Fairchild M-62A · S/N T42-1476Cancelled Oct 11, 1955 · Reed Harold DN593CStinson 108-3 · S/N 108-3593Cancelled Oct 4, 1955 · Short Karl RoyN57287Consolidated Vultee BT-13A · S/N 5743Cancelled Apr 1, 1955 · Stewart Donald RN63447Consolidated Vultee BT-13A · S/N 5355Cancelled Apr 1, 1955 · Alwin M EN90618Fletcher FU-24 · S/N 6Cancelled Jan 14, 1955 · Exported to New Zealand · Fletcher Aviation CorpN43246Taylorcraft BC12-D · S/N 6905Cancelled Jun 9, 1954 · Exported to Mexico · Till JohnN52779Consolidated Vultee BT-15 · S/N 3298Cancelled May 5, 1954 · Padley Harry E Eunice A PadleyN90802Fletcher FD-25A · S/N 1Cancelled Feb 4, 1953 · Exported to Japan · Fletcher Aviation Corp
Back to Pasadena, CA