OpenAirDocs.org
Dos Palos, CA

Cancelled registrations · 36

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 = 'DOS PALOS'
  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.

N80863Cessna 172M · S/N 17266777Cancelled May 13, 2020 · Registration expired, pending cancellation · Built 1976 · Gamboni Farming CoN17527Boeing A75 · S/N 75-275Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Agair Int IncN7850CGrumman TBM-3E · S/N 69355Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Hyde R EN66974Boeing A75 · S/N 75-1189Cancelled May 6, 2015 · Registration expired, pending cancellation · Agair IncN3179HErcoupe 415-C · S/N 3804Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1946 · Azevedo Louie L JrN68401Boeing A75N1(PT17) · S/N 75-6855Cancelled Oct 25, 2013 · Revoked, canceled · Agair IncN68406Boeing A75N1(PT17) · S/N 75-7648Cancelled Oct 25, 2013 · Revoked, canceled · Built 1943 · Agair IncN6829CGrumman TBM-3U · S/N 91741Cancelled Oct 23, 2013 · Revoked, canceled · Agron DanielN5043VBoeing 75 · S/N 75-7787Cancelled Sep 18, 2012 · Revoked, canceled · Agair IncN5041VBoeing A75N1(PT17) · S/N 75-7471Cancelled Aug 10, 2012 · Revoked, canceled · Agair IncN5042VBoeing A75N1(PT17) · S/N 75-7417Cancelled Aug 10, 2012 · Revoked, canceled · Agair IncN4713VBoeing A75N1(PT17) · S/N 75-5528Cancelled Aug 1, 2012 · Revoked, canceled · Montys Agric Aviation IncN5003VBoeing A75N1(PT17) · S/N 75-2595Cancelled Jan 12, 2012 · Revoked, pending cancellation · Agair IncN23930Air Tractor AT-301 · S/N 301-0465Cancelled Jan 27, 2011 · Triennial form not returned · Built 1982 · Spain Air IncN54259Piper PA-23-250 · S/N 27-7554047Cancelled Oct 21, 2009 · Exported to Philippines · Built 1974 · Carollo James VN17528Boeing PT-17 · S/N 75-859Cancelled Jul 9, 2009 · Registration revoked · Built 1941 · Agron DanielN8793SAir Tractor AT-301 · S/N 301-0195Cancelled Feb 13, 2008 · Triennial form not returned · Built 1979 · Spain Air IncN2330VAir Tractor AT-301 · S/N 301-0392Cancelled Jan 10, 2007 · Triennial form not returned · Built 1981 · Spain Air IncN12RXWinkleman Thomas L S-12 AIRAILE · S/N 1191150Cancelled Oct 7, 1996 · Sorg Floyd CN5990TCessna 150D · S/N 15060690Cancelled Apr 17, 1981 · Garrett Robert D And Or Garrett CarlineN8176UCessna 172F · S/N 17252076Cancelled Feb 23, 1981 · Brooks GaryN56752Boeing A75N1(PT17) · S/N 75-472Cancelled Dec 5, 1977 · Montys Agric Aviation IncN44841Naval Aircraft Factory N3N-3 · S/N 4481Cancelled Jan 17, 1972 · Gutchow HomerN68403Boeing A75 · S/N 756890Cancelled Dec 1, 1971 · Exported to Japan · Built 1947 · Agair IncN7633VAero Commander CALLAIR A-9B · S/N 1361Cancelled Mar 30, 1971 · Comfort Farms IncN7760VAero Commander CALLAIR A-9 · S/N 1517Cancelled Mar 22, 1971 · Kens Flying ServiceN144CStinson 108-2 · S/N 108-3144Cancelled Jun 29, 1970 · Built 1948 · Serv-Aero Engineering IncN6828CGrumman TBM-3U · S/N 91719Cancelled Feb 7, 1968 · R E HydeN68684Grumman TBM-3 · S/N 5979Cancelled Oct 30, 1967 · Agron DanielN53449Fairchild M-62A · S/N T42-1763Cancelled Aug 16, 1963 · Built 1945 · Perry Floyd N And Kyle Donovan WN45237Naval Aircraft Factory N3N-3 · S/N 2680Cancelled Apr 5, 1962 · Built 1943 · Gutchow HomerN68493Boeing A75N1 · S/N 75-3114Cancelled Feb 17, 1956 · Agair IncN53249Cessna T-50 · S/N 5436Cancelled Nov 29, 1955 · Jardins R E DesN57338Consolidated Vultee BT-13A · S/N 1913Cancelled Oct 11, 1955 · Montys Agricultural AviationN4757VBoeing A75N1 · S/N 75-5245Cancelled Nov 19, 1951 · Gutchow HomerN48600Interstate S-1B1 · S/N 21Cancelled Feb 7, 1949 · Frank F Dennis
Back to Dos Palos, CA