OpenAirDocs.org
Imperial, CA

Cancelled registrations · 66

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

N30286Cessna T210L · S/N 21059910Cancelled Aug 19, 2023 · Sale reported, canceled · Built 1973N724ZMiller Tl/Miller SL QUICKSILVER SPORT II · S/N 000716Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2006 · Granado Eric BN3873HEngineering & Research ERCOUPE 415-CD · S/N 4574Cancelled Jan 17, 2020 · Revoked, canceled · Built 1947 · Steiner Donald PN6540MStinson 108 · S/N 1084540Cancelled Apr 6, 2018 · Revoked, canceled · Built 1948 · White John AN423JPPitchie Jerry E QUICKSILVER MX II · S/N 1569Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Pitchie E JerryN1629YCessna 172C · S/N 17249329Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1962 · Pamkratz JamieN8686HNorth American NAVION · S/N NAV-4-686Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1947 · Hester Nathan AN5753JCessna 182P · S/N 18263518Cancelled Feb 2, 2018 · Sale reported, pending cancellation · Built 1974N4848NBoeing A75N1(PT17) · S/N 75-3079Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1946 · Visco Flying CoN68957Piper J3C-65 · S/N 13733Cancelled Feb 4, 2017 · Revoked, canceled · Built 1945 · Phillips John HN595RNorth American NAVION · S/N NAV-4-484Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1947 · Neff Tommy MN91141North American NAVION · S/N NAV-4-34Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Ross David CN48096Bell TH-13T · S/N 3563Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1966 · Imperial CountyN56538Boeing A75N1(PT17) · S/N 75-2746Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1941 · Visco Flying CoN8543LPiper PA-25-260 · S/N 25-4964Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1969N4711APiper PA-18 · S/N 18-4929Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1956 · Visco Flying Co IncN40915Piper PA-36-285 · S/N 36-7460003Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1974N48896Boeing A75N1(PT17) · S/N 75-2427Cancelled Aug 30, 2012 · Sale reported, pending cancellation · Built 1941N53PC-Craft HC-1 · S/N 1Cancelled Aug 14, 2012 · Revoked, canceled · Built 1957 · Cooke Samuel LN505BWWarnke Bernhard J RV-3 · S/N 92525Cancelled Oct 23, 2009 · Exported to Italy · Built 2006 · Schwettmann Dennis EN8927QAyres S-2R · S/N 2442RCancelled Jul 10, 2001 · Triennial form not returned · Stoker CoN7301PAir Tractor AT-301 · S/N 301-0588Cancelled May 18, 2000 · Exported to Mexico · Visco Flying CompanyN4860XRockwell International S-2R · S/N 2053RCancelled Jun 23, 1998 · Exported to Mexico · Visco Flying Company IncN4001MAyres S2R-T34 · S/N 6001Cancelled Feb 18, 1997 · Triennial form not returned · Stoker CoN4394SAir Tractor AT-301 · S/N 3010054Cancelled Feb 14, 1994 · Triennial form not returned · Visco Flying Company IncN6607GCessna 150L · S/N 15072107Cancelled Aug 23, 1982 · Milanes Henry FN9038LChampion 7ECA · S/N 766-70Cancelled Apr 2, 1982 · Exported to Mexico · Imperial Flying ServiceN4830YPiper PA-25-260 · S/N 25-4622Cancelled Aug 7, 1980 · Ross Flying Service IncN57610Piper PA-36-285 · S/N 36-7660010Cancelled Apr 11, 1980 · Exported to Australia · Ross Flying Service IncN4924RCessna A188B · S/N 18802441TCancelled Feb 11, 1980 · Exported to Mexico · Nelson Norman LN4725YPiper PA-25-235 · S/N 25-4470Cancelled Dec 28, 1977 · Sale reported · Built 1967N7659VAero Commander CALLAIR A-9B · S/N 1387Cancelled Dec 30, 1976 · Sale reported · Built 1968N1837PPiper PA-22-150 · S/N 22-2617Cancelled May 7, 1975 · Henderson Joseph MN6081Bensen B-8M · S/N 001Cancelled Aug 19, 1974 · Green Melvin PN67517Boeing A75N1 · S/N 75-6974Cancelled Jun 25, 1973 · Visco Flying Co IncN50060Boeing A75N1 · S/N 75-1074Cancelled Jun 12, 1972 · Built 1941 · Visco Flying CompanyN5947VBoeing A75N1 · S/N 75-6884Cancelled Jun 24, 1971 · Valley Insecticide ServicecoN59587Boeing A75N1 · S/N 75-1529Cancelled Jun 24, 1971 · Built 1941 · Visco Flying Co IncN8017CPiper PA-22-135 · S/N 22-2204Cancelled Feb 12, 1971 · Visco Flying CompanyN59095Boeing A75N1(PT17) · S/N 75-7091Cancelled Feb 1, 1971 · Vixco Flying CompanyN61181Boeing A75N1(PT17) · S/N 75-3261Cancelled Feb 1, 1971 · Visco Flying CompanyN67561Consolidated Vultee BT-13A · S/N 6095Cancelled Sep 10, 1970 · Valley Insecticide Service CoN65500Consolidated Vultee BT-13A · S/N 11623Cancelled Sep 9, 1970 · Built 1942 · Valley Insecticide Service CoN132RBoeing D75N1 · S/N 75-3879Cancelled Jun 11, 1970 · Built 1942 · Hess & Ross IncN134RNaval Aircraft Factory N3N-3 · S/N 4474Cancelled Jun 11, 1970 · Built 1941 · Hess & RossN135RNaval Aircraft Factory N3N-3 · S/N 2982Cancelled Jun 11, 1970 · Built 1941 · Hess & RossN82BBeech E18S · S/N BA-149Cancelled Feb 28, 1968 · Imperial Commuter Airlines IncN6942DPiper PA-22 · S/N 22-4870Cancelled May 7, 1957 · Built 1957 · Visco Flying CoN75045Boeing A75N1(PT17) · S/N 75-1099Cancelled Oct 8, 1956 · Visco Flying CoN59224Fairchild PT-19A · S/N T42-699Cancelled Mar 8, 1956 · Amos J Collinske
Back to Imperial, CA