OpenAirDocs.org
Shafter, CA

Cancelled registrations · 27

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

N7335FCessna 172N · S/N 17273248Cancelled Sep 26, 2023 · Registration pending, canceled · Built 1979N110DTBell 47G-4A · S/N 7631Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1968 · Inland Crop Dusters IncN1185WBell 47G-4A · S/N 7513Cancelled Apr 25, 2018 · Registration expired, pending cancellation · Built 1966 · Inland Crop Dusters IncN4090GBell 47G-4A · S/N 7640Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1968 · Inland Crop Dusters IncN28938Bell 47G-4A · S/N 7728Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1970 · Inland Crop Dusters IncN97347Cessna 182Q · S/N 18267064Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1979 · Foxen Air And Land LLCN54460Piper J5A · S/N 51120Cancelled Nov 20, 2017 · Revoked, canceled · Built 1941 · Beeman David EN4331ZPiper PA-18-150 · S/N 18-8652Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1968 · Lightning Air Patrol IncN78591Piper PA-12 · S/N 12-3974Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1947 · Lightning Air Patrol IncN75899Boeing B75N1 · S/N 75-7911Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1938 · Duffy Harold TN57339Boeing IB75A · S/N 75-3776Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1942 · Duffy Harold TN91501North American NAVION · S/N NAV-4-296Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1946N48850Aeronca 0-58B · S/N 0-58B3262Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1942 · Minter Field Air Museum IncN4248XRockwell International S-2R · S/N 2024RCancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1974 · Reimer Dwight LN75789Consolidated Vultee BT-13 · S/N 5997Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Minter Field Air MuseumN5904YPiper PA-23-250 · S/N 27-3059Cancelled Sep 27, 2012 · Sale reported, pending cancellation · Built 1965N932BPReck Donald R PIETENPOL AIRCAMPER · S/N 001Cancelled Jun 7, 2012 · Sale reported, canceled · Built 2005N6483MStinson 108-3 · S/N 108-4483Cancelled May 23, 2006 · Exported to Canada · Built 1948 · Ryker Wallace WN92723Piper PA-12 · S/N 12159Cancelled Jun 8, 1994 · Triennial form not returned · Bagby Dudley LN3337GNorth American B-25J · S/N 44-86891ACancelled Sep 24, 1982 · Built 1944 · Reimer Dwight LN9859CNorth American T-28A · S/N 49-1647ACancelled Mar 2, 1971 · Peters Edward GN54102Fairchild M-62A · S/N T42-3173Cancelled Oct 6, 1970 · Built 1942 · Isabell SidN37138Engineering & Research 415-C · S/N 105Cancelled Jun 8, 1970 · Vaux MelvinN9686ACessna 140A · S/N 15407Cancelled May 22, 1965 · Bone David EN67448Cessna T-50 · S/N 2793Cancelled Oct 13, 1955 · Built 1943 · Robert Neauman And SonsN9126KStinson 108-1 · S/N 108-2126Cancelled Jun 6, 1955 · Pierce VernonN62690Cessna T-50 · S/N 4701Cancellation date not recorded · Albright James S
Back to Shafter, CA