OpenAirDocs.org
Porterville, CA

Cancelled registrations · 198

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

N3411VBeech 35 · S/N D-889Cancelled Mar 20, 2021 · Registration pending, canceled · Built 1947N104EAHiller UH-12E · S/N HA3028Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Arrow Falcon Exporters IncN5316VHiller UH-12C · S/N 762Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1956 · Johnson Helicopter Service IncN74158Hiller UH-12L · S/N 1758Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1965 · Arrow Falcon Exporters IncN8679DPiper PA-18A 150 · S/N 18-6283Cancelled Oct 2, 2019 · Revoked, canceled · Built 1958 · Brady George CN35DADellicker Harry R STARDUSTER SA-300-DA · S/N 111767Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Dellicker Donna L TrusteeN3624Dellicker Hary R STARDUSTER II · S/N 12086Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Dellicker Donna L TrusteeN7090HHiller UH-12E · S/N 5188Cancelled May 31, 2018 · Sale reported, canceledN1146NSchweizer TG3A · S/N 70Cancelled Mar 23, 2018 · Revoked, canceled · Long Calvin HN6585ECessna 175 · S/N 56085Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1959 · Dellicker Donna L TrusteeN50690Cessna 150J · S/N 15069486Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1968 · Dellicker Donna L TrusteeN281PAPiper PA-28-181 · S/N 2843458Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2001 · Taggard Kevin WN3165BCessna 170B · S/N 25407Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1952 · Dellicker Donna L TrusteeN3404CCessna 170B · S/N 25925Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1953 · Dellicker Donna L TrusteeN2496DCessna 170B · S/N 20648Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1952 · Dellicker Donna L TrusteeN4911VBellanca 17-30 · S/N 30075Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1967 · Speidell Richard HN37526Balloon Works FIREFLY 7 · S/N F7-137Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Kelly Stockton EN56403Fairchild M-62A · S/N T41910Cancelled Nov 21, 2017 · Revoked, canceled · Built 1941 · Wilson Robert FN7923JBell 47G-5 · S/N 25040Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1971 · Pullin Terry SN9913NCessna TU206G · S/N U20603727Cancelled Feb 13, 2017 · Revoked, canceled · Built 1977 · Coe Aviation IncN66MXMooney M-18C · S/N 203Cancelled Jan 6, 2016 · Exported to Chile · Built 1950 · Favrholdt Ben C TrusteeN140DBBroadhead Darrel L BEATS WALKIN · S/N 1Cancelled May 8, 2015 · Registration expired, pending cancellation · Boughton Air Replicas IncN9786CHiller UH-12E · S/N 2267Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1963 · Helicopter Parts Svc IncN7513SRobinson Helicopter R44 · S/N 1195Cancelled Apr 20, 2015 · Exported to Mexico · Built 2002 · Arrow Falcon Exporters IncN46359Boughton Air Replicas C-10 · S/N 100Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Boughton Air Replicas IncN4398XPiper PA-28-151 · S/N 28-7615005Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1975 · Fowler RayN6970FPiper PA-28-151 · S/N 28-7715189Cancelled Sep 3, 2014 · Revoked, canceled · Built 1976 · Bierman Travis HN911PPBell OH-58C · S/N 71-20476Cancelled Aug 23, 2013 · Sale reported, canceledN8486BGiotto Richard J BENSEN B8MG · S/N 0375-01Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1981N2133Johanson Jason SCORPION · S/N 02Cancelled Jul 30, 2013 · Sale reported, canceled · Built 2006N62470Hiller UH-12D · S/N 1373Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1952 · Trupe Edwin L DBAN516FHFairchild Hiller FH-1100 · S/N 9Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1966N5555XMeade James M MITCHELL AG-38A · S/N 101Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1984 · Meade James MN138BBLockheed-Boughton Air Rep P-38 · S/N 2001Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Boughton Air Replicas IncN93478Hiller UH-12E · S/N 1608Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1964 · Helicopter Parts Service IncN8702PPiper PA-24-260 · S/N 24-4148Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1965 · Wall MikeN2067DMitchell T10 · S/N 102Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1983 · Mitchell Aircraft CorpN58012Bell 206B · S/N 1027Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1973 · Trupe Edwin L DBAN103RKBell OH-58A · S/N 71-20600Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Arrow Falcon ExportersN3004THiller UH-12E · S/N 5012Cancelled Apr 2, 2013 · Sale reported, pending cancellation · Built 1977N47078Hiller UH-12D · S/N 1371Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1962 · Helicopter Parts ServiceN64723Bell TH-13T · S/N 65-8052Cancelled Feb 13, 2013 · Sale reported, canceledN1342PStephenson Jeffrey MITCHELL WING B-10 · S/N B1147Cancelled Jan 22, 2013 · Third renewal notice · Stephenson Jeffrey LN4636Cox STITS PLAYBOY SA-3A · S/N JC-72-2Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1972 · Cox Ferman JN51607Hiller OH-23C · S/N 64-15295Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1964N5063FFairchild Hiller FH-1100 · S/N 243Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1971N5064FFairchild Hiller FH-1100 · S/N 244Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1971N3221UMitchell P-38 · S/N L378Cancelled Dec 7, 2012 · Sale reported, pending cancellationN3210FHiller UH-12E4 · S/N 2313Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1976 · Hiller AviationN1959ZCessna 150C · S/N 15059759Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1962 · Rowlett Anthony Lee
Back to Porterville, CA