OpenAirDocs.org
Benavidez Robert

Earlier aircraft under this name · 20

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'BENAVIDEZ ROBERT' OR list_contains(d.other_registrant_names, 'BENAVIDEZ ROBERT')
  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.

N756NBCessna TU206G · S/N U20604214Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Deming, NMN712SNCessna TU206F · S/N U20601800Cancelled Apr 7, 2010 · Deming, NMN206XVCessna U206G · S/N U20605861Cancelled Mar 13, 2009 · Triennial form not returned · Built 1980 · Deming, NMN102MNCessna TU206G · S/N U20604404Cancelled Jan 14, 2009 · Exported to Mexico · Deming, NMN742MCessna 210-5A(205A) · S/N 205-0513Cancelled Oct 30, 2007 · Exported to Mexico · Built 1964 · Deming, NMN1003VCessna U206F · S/N U20602388Cancelled Jun 18, 2007 · Triennial form not returned · Built 1974 · Deming, NMN732RXCessna T210M · S/N 21061724Cancelled Mar 8, 2006 · Exported to Mexico · Built 1977 · Deming, NMN761PFCessna 210M · S/N 21062404Cancelled Jul 14, 2005 · Exported to Mexico · Built 1977 · Deming, NMN5133JCessna 310R · S/N 310R0253Cancelled Nov 22, 2004 · Exported to Mexico · Built 1975 · Deming, NMN29795Cessna T210M · S/N 21062114Cancelled Sep 10, 2004 · Exported to Mexico · Deming, NMN761ECCessna 210M · S/N 21062189Cancelled Sep 2, 2004 · Exported to Mexico · Built 1977 · Deming, NMN1198VCessna U206F · S/N U20602509Cancelled Jul 26, 2004 · Exported to Mexico · Built 1974 · Deming, NMN9419GCessna U206E · S/N U20601619Cancelled Mar 31, 2004 · Exported to Mexico · Built 1970 · Deming, NMN9681GCessna U206F · S/N U20601881Cancelled Mar 31, 2004 · Exported to Mexico · Built 1972 · Deming, NMN2082UCessna U206F · S/N U20602327Cancelled Mar 30, 2004 · Exported to Mexico · Built 1974 · Deming, NMN6210MCessna 206 · S/N U206-02593Cancelled Oct 28, 2003 · Exported to Mexico · Built 1975 · Deming, NMN6348ACessna T210N · S/N 21063522Cancelled Feb 5, 2003 · Exported to Mexico · Built 1979 · Deming, NMN761JECessna T210M · S/N 21062287Cancelled Oct 29, 2002 · Exported to Mexico · Built 1978 · Deming, NMN761PECessna T210M · S/N 21062403Cancelled Jun 17, 2002 · Exported to Mexico · Built 1977 · Deming, NMN94032Cessna T210L · S/N 21060485Cancelled Nov 21, 2001 · Exported to Mexico · Built 1974 · Deming, NM
Back to Benavidez Robert