Santee, CA

Cancelled registrations · 69

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

N7131GCessna 172K · S/N 17258831Cancelled Oct 20, 1971 · El Cajon Flying Service IncN6427JPiper PA-28-180 · S/N 28-4845Cancelled Apr 4, 1971 · Breise & Johnston Flying Ser IncN9415WPiper PA-28-235 · S/N 28-11122Cancelled Apr 4, 1971 · Breise & Johnston Flying ServiceN2702LCessna 172H · S/N 17255902Cancelled Mar 24, 1971 · Exported to Mexico · Dennis GeraldN5721UPiper PA-28-140 · S/N 28-26523Cancelled Mar 24, 1971 · Breise & Johnston Flying Svc IncN55PMay Christopher H RV-4 · S/N R-1Cancelled Nov 23, 1970 · Girard Peter FN8150SCessna 150F · S/N 15061750Cancelled Oct 13, 1970 · Dennis GeraldN5533ECessna 150 · S/N 17033Cancelled Jun 30, 1970 · El Cajon Flying ServiceN1796FCessna 172H · S/N 17255191Cancelled May 14, 1970 · Exported to Mexico · Gerald Dennis DBA Cajon Flying ServiceN8170SCessna 150 · S/N 15061770Cancelled May 14, 1970 · Exported to Mexico · Built 1966 · El Cajon Flying ServiceN9850ZBeech C-45H · S/N AF-746Cancelled Nov 13, 1967 · Exported to Mexico · Zing Enterprises IncN23647Taylorcraft BC-65 · S/N 1378Cancelled Oct 31, 1967 · Exported to Mexico · Breise & Johnston Flying Ser IncN4956FCessna U206 · S/N U206-0656Cancelled Oct 17, 1967 · Exported to Mexico · Dennis Gerald DBA El Cajon Flying ServiceN8044SCessna 150F · S/N 15061644Cancelled Jun 9, 1966 · Stardust Aviation IncN4280FCessna 172 · S/N 46180Cancelled Jun 2, 1965 · El Cajon Flying ServiceN90096Cessna 140 · S/N 9157Cancelled May 22, 1965 · Built 1946 · El Cajon Flying ServiceN70140Piper J3C-65 · S/N 17119Cancelled May 24, 1954 · Exported to Mexico · El Cajon Flying ServiceN332MMooney M-18C · S/N 213Cancelled Sep 4, 1953 · Southern Cal Airmotive IncN50188Noorduyn UC-64A · S/N 297Cancelled Jun 21, 1950 · Bart Stevenson
Back to Santee, CA