OpenAirDocs.org
Whittier, CA

Cancelled registrations · 51

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

N7648WPiper PA-28-180 · S/N 28-1624Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1964 · Lawrence Bob WN849JMAeropilot S R O LEGEND 600 · S/N 1634Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 2016 · Skycamjoe.Com LLCN156TSDiamond Aircraft Ind DA 42 · S/N 42.156Cancelled Dec 5, 2019 · Exported to China · Joerithan & Mp Aviation LLCN44010Taylorcraft BC12-D · S/N 9810Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1944 · Cline Dana TN89961Cessna 140 · S/N 9013Cancelled May 21, 2018 · Revoked, canceled · Built 1946 · Bialy Anthony PN3977EAeronca 11BC · S/N 11BC-62Cancelled Mar 16, 2018 · Revoked, canceled · Built 1947 · Garcia Franklin DN35949Cessna 177RG · S/N 177RG1084Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1976 · Young Ezra AN5310XMann Terence EIPPER MX II · S/N 1658Cancelled Feb 27, 2018 · Registration pending, canceledN81762Quicksilver GT-400 · S/N GT-2801171Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2006 · Woolery Lloyd AN89006Cessna 140 · S/N 8010Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Downey Flyers IncN6611NCessna T210N · S/N 21063118Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1978 · Harcourt C P CotrusteeN470RWWright Roland K RANS S-9 · S/N S9587006Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Woolery David NN74JMiller Special JM-101 · S/N JM101Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1949 · Whittier Historical SocietyN271MDDrews Michael L XP-503 · S/N DR 0271Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Drews Michael LN9529UGrumman American Avn. AA-1C · S/N AA1C0025Cancelled May 24, 2013 · Registration expired, pending cancellation · Built 1977 · Severino Mario JN8532RBellanca 14-19-3 · S/N 4294Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1966 · Macdonald Archibald AN732SNCessna T210M · S/N 21061739Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Collier Douglas R JrN56154Consolidated Vultee BT-13 · S/N 8279Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1945N35289Cessna 177B · S/N 17702309Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1975 · Eastman Ross HN89PDobson Franklin A DOBSON CONVERTIPLANE · S/N 100Cancelled Jul 15, 2011 · Revoked, pending cancellation · Built 1956 · Dobson Franklin AN3763Walker VP-1 · S/N 582114627Cancelled Sep 30, 2009 · Triennial form not returned · Wells Alan WN46478Cessna 152 · S/N 15283057Cancelled Mar 18, 2004 · Exported to Philippines · Built 1978 · B & E AircraftN739THCessna 172N · S/N 17270789Cancelled Mar 15, 2004 · Exported to Philippines · Built 1978 · B & EaircraftN7097DPiper PA-18A 150 · S/N 18-5588Cancelled Mar 1, 2004 · Exported to Canada · Built 1957 · Gilliland Paul W JrN1348LCessna T337H · S/N 33701840Cancelled Jun 25, 2002 · Triennial form not returned · Built 1978 · Dirian DonaldN6409AShouse Lewis S-12XL · S/N 01990868Cancelled Mar 5, 2002 · Exported to Philippines · Built 1999 · Shouse Lewis EN88VEGage J Marshell VARI-EZE · S/N 65Cancelled Dec 2, 1996 · Triennial form not returned · Gage J MarshallN250PProcter CASSUTT III M · S/N 250Cancelled Oct 6, 1993 · Triennial form not returned · Procter James RN9456HCessna 182R · S/N 18267952Cancelled Apr 10, 1991 · Triennial form not returned · Ball Gerald LN9745HCessna 182R · S/N 18267991Cancelled Mar 27, 1991 · Exported to Tanzania · Fisher Greg LN2810ECessna 172N · S/N 17271331Cancelled Jan 30, 1991 · Triennial form not returned · B&E AircraftN62120Cessna 172 · S/N 36039Cancelled Dec 20, 1977 · R E A P Mission IncN3426H-O Pusher II · S/N 1776Cancelled Apr 23, 1974 · Ortner Dean CN46660Cessna 172K · S/N 17257417Cancelled Apr 23, 1974 · Cranford Burt EN338GDouglas DC3A · S/N 2250Cancelled Sep 5, 1973 · Exported to Guatemala · Laramore LouisN527ABellanca 14-19 · S/N 2080Cancelled Aug 4, 1973 · Built 1951 · Kennedy Henry J JrN4314Volmer Jensen VJ22 · S/N 131Cancelled Apr 28, 1972 · Built 1969 · Robertson Robert LN43652Taylorcraft BC12-D · S/N 7311Cancelled Oct 26, 1971 · Passehl Jr Ernest FN1253Hatch-Bensen GYROCOPTER · S/N 1Cancelled Feb 24, 1971 · Built 1967 · Hatch Edward MN91PStits FG-1 · S/N 1Cancelled Sep 10, 1970 · Fall Roland EverettN72451Cessna 140 · S/N 9616Cancelled Sep 3, 1970 · Sherry B BN4248VCessna 170 · S/N 18604Cancelled Sep 1, 1970 · Mccauley B DN67156Cessna T-50 · S/N 6133Cancelled Jan 27, 1961 · Exported to Mexico · Harry Brittain IncN37350Interstate S-1A · S/N 193Cancelled Nov 10, 1955 · Built 1941 · Fritz W F & Mohr C AN73742Consolidated Vultee BT-13 · S/N 965Cancelled Oct 25, 1955 · E R RothenbergerN54257Fairchild M-62A · S/N T42-1760Cancelled Jan 6, 1955 · Richard L ShuteN17048Rearwin 9000-L · S/N 542-DCancelled Oct 31, 1949 · Built 1937 · Grimes Curtis WN89043Cessna 140 · S/N 8047Cancelled Jun 14, 1949 · Mcmillin DoyleN6701Waco GXE · S/N 1596Cancelled Apr 2, 1948 · Built 1929 · Oxford JackN109WD H Vollmer VOLLMER MODEL A · S/N 1Cancelled Feb 11, 1933 · Rose Vollmer V
Back to Whittier, CA