OpenAirDocs.org
Piedmont, CA

Cancelled registrations · 18

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

N664EJDJI PHANTOM 3 PROFESSION · S/N CF281854268888Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Produce 2 Broadcast LLCN269WPCessna 320E · S/N 320E-0096Cancelled Jan 22, 2001 · Triennial form not returned · Linford John AN4301GMcculloch J-2 · S/N 011Cancelled Aug 10, 1983 · Breuner Stol CoN555CTCessna T210L · S/N 21059785Cancelled Nov 21, 1977 · Gudebski John JN6872Sud SA316B ALOUETTE III · S/N 1680Cancelled Nov 25, 1975 · Exported to South Africa · Frank CN3047Aerospatiale SE3160 ALOUETTE III · S/N 1782Cancelled Nov 21, 1975 · Exported to South Africa · Frank C DBA Frank C AssociatesN6873Aerospatiale SE3160 ALOUETTE III · S/N 1681Cancelled Jul 28, 1975 · Exported to South Africa · Frank C Dbac Frank AssociatesN8396Snias SE 3160 · S/N 1868Cancelled Apr 25, 1975 · Exported to South Africa · Built 1971 · C Frank AssociatesN6875Aerospatiale SA316B ALOUETTE III · S/N 1703Cancelled Mar 12, 1975 · Exported to South Africa · C Frank AssociatesN8261Aerospatiale SA316B ALOUETTE III · S/N 1737Cancelled Mar 12, 1975 · Exported to South Africa · Built 1970 · C Frank AssociatesN8654Socata TB20 · S/N 1727Cancelled Mar 12, 1975 · Exported to South Africa · C Frank AssociatesN9836Aerospatiale SE3160 ALOUETTE III · S/N 1636Cancelled Mar 12, 1975 · Exported to South Africa · Built 1969 · Frank C DBA C Frank AssociatesN4373Sud SE3160 ALOUETTE III · S/N 1625Cancelled Mar 10, 1975 · Exported to South Africa · Built 1969 · Frank CN8393Snias SE 3160 · S/N 1866Cancelled Mar 10, 1975 · Exported to South Africa · Built 1971 · C Frank AssociatesN9363Snias SE 3160 · S/N 1746Cancelled Mar 10, 1975 · Exported to South Africa · Built 1970 · Frank CN9703Aerospatiale SA316B ALOUETTE III · S/N 1807Cancelled Jan 23, 1975 · Exported to South Africa · C Frank AssociatesN9835Sud SE3160 ALOUETTE III · S/N 1629Cancelled Jan 23, 1975 · Exported to South Africa · Built 1969 · C Frank AssociatesN8806Stearman C3-B · S/N 218Cancelled Feb 1, 1941 · Benjamin Michael Fillmore
Back to Piedmont, CA