Skip to content

Earlier aircraft under this name · 50

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

Query with SQL

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 = 'AVEX INC' OR list_contains(d.other_registrant_names, 'AVEX INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'AVEX INC' OR list_contains(d.other_registrant_names, 'AVEX INC')
  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.

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 = 'AVEX INC' OR list_contains(d.other_registrant_names, 'AVEX INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N6824GSocata TBM 700 · S/N 1042Cancelled Aug 13, 2021 · Exported to Canada · Built 2014 · Camarillo, CA N59993Consolidated Vultee BT-13A · S/N 2837Cancelled Apr 3, 2020 · Revoked, canceled · Built 1941 · Coral Gables, FL N9089ACessna 170B · S/N 18848Cancelled Nov 21, 2017 · Revoked, canceled · Built 1949 · Coral Gables, FL N1896WBeech 58 · S/N TH-345Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1973 · Orlando, FL N51845Cessna T-50 · S/N 5155Cancelled Aug 13, 2012 · Revoked, canceled · Built 1943 · Coral Gables, FL N2457MCessna T206H · S/N T20608594Cancelled Feb 22, 2010 · Exported to Canada · Built 2006 · Camarillo, CA N328CGSocata TB21 · S/N 2025Cancelled Oct 21, 2002 · Built 2000 · Camarillo, CA N200PBoltz Vernon R LANCAIR IV · S/N LIV-007Cancelled Jun 14, 2002 · Exported to Mexico · Built 1995 · Camarillo, CA N991GABeech 200 · S/N BB812Cancelled Oct 15, 1999 · Exported to Canada · Camarillo, CA N208SNCessna 208 · S/N 20800202Cancelled Sep 16, 1994 · Exported to Kenya · Camarillo, CA N4652FPiper PA-34-200T · S/N 347670354Cancelled Jan 7, 1994 · Exported to South Africa · Santa Paula, CA N594DCBeech 200 · S/N BB547Cancelled Mar 4, 1993 · Exported to South Africa · Santa Paula, CA N88HWCessna T210N · S/N 21063265Cancelled Oct 20, 1992 · Exported to Brazil · Santa Paula, CA N1744UCessna 210N · S/N 21064737Cancelled Jun 17, 1992 · Exported to South Africa · Santa Paula, CA N2120VPiper PA-34-200T · S/N 347970162Cancelled Jun 17, 1992 · Exported to South Africa · Santa Paula, CA N33099Piper PA-34-200T · S/N 347570088Cancelled Jun 17, 1992 · Exported to South Africa · Santa Paula, CA N6521CCessna T210N · S/N 21064706Cancelled Jun 17, 1992 · Exported to Brazil · Santa Paula, CA N402CMCessna 402C · S/N 402C0487Cancelled Apr 22, 1992 · Exported to South Africa · Santa Paula, CA N3688ZBeech 58 · S/N TH1171Cancelled Mar 10, 1992 · Exported to South Africa · Santa Paula, CA N252CMBeech E-90 · S/N LW205Cancelled Dec 6, 1991 · Exported to South Africa · Santa Paula, CA N2555Cessna 177RG · S/N 177RG1260Cancelled Sep 24, 1991 · Exported to South Africa · Santa Paula, CA N473CBCessna 177RG · S/N 177RG0313Cancelled Sep 24, 1991 · Exported to South Africa · Santa Paula, CA N8096GCessna 177RG · S/N 177RG0096Cancelled Sep 24, 1991 · Exported to South Africa · Santa Paula, CA N1918QCessna 177RG · S/N 177RG0318Cancelled Aug 29, 1991 · Exported to South Africa · Santa Paula, CA N210ACCessna T210M · S/N 21062127Cancelled Aug 29, 1991 · Exported to South Africa · Santa Paula, CA N45219Cessna 177RG · S/N 177RG1097Cancelled Aug 29, 1991 · Exported to Namibia · Santa Paula, CA N758GTCessna R172K · S/N R1723091Cancelled Aug 29, 1991 · Exported to South Africa · Santa Paula, CA N6620YCessna T210N · S/N 21064463Cancelled Aug 28, 1991 · Exported to South Africa · Santa Paula, CA N195NWCessna 421B · S/N 421B0629Cancelled Aug 13, 1991 · Exported to Philippines · Santa Paula, CA N500ESCessna 421B · S/N 421B0032Cancelled Aug 8, 1991 · Exported to Philippines · Santa Paula, CA N111CXCessna 421B · S/N 421B0590Cancelled Jul 30, 1991 · Exported to Philippines · Santa Paula, CA N49905Cessna 152 · S/N 15281384Cancelled Jul 16, 1991 · Exported to Israel · Santa Paula, CA N6889HCessna 172M · S/N 17265629Cancelled Jul 16, 1991 · Exported to Israel · Santa Paula, CA N757KHCessna 152 · S/N 15279797Cancelled Jul 16, 1991 · Exported to Israel · Santa Paula, CA N456HMCessna U206F · S/N U20602840Cancelled May 2, 1991 · Exported to South Africa · Santa Paula, CA N2038QCessna 177RG · S/N 177RG0438Cancelled Apr 23, 1991 · Exported to South Africa · Santa Paula, CA N52136Cessna 177RG · S/N 177RG1175Cancelled Apr 22, 1991 · Exported to South Africa · Santa Paula, CA N8325DPiper PA-34-220T · S/N 348133005Cancelled Mar 7, 1991 · Exported to Australia · Santa Paula, CA N100BECessna 210L · S/N 21060678Cancelled Jan 15, 1991 · Exported to South Africa · Santa Paula, CA N5218TCessna TR182 · S/N R18201837Cancelled Jan 15, 1991 · Exported to South Africa · Santa Paula, CA N6641KBeech 58 · S/N TH1051Cancelled Jan 15, 1991 · Exported to South Africa · Santa Paula, CA N4026ZRobinson Helicopter R22 BETA · S/N 1520Cancelled Nov 29, 1990 · Exported to South Africa · Santa Paula, CA N38MHCessna R182 · S/N R18201325Cancelled Oct 15, 1990 · Exported to South Africa · Santa Paula, CA N5269ACessna 210N · S/N 21063338Cancelled Jan 22, 1990 · Exported to South Africa · Santa Paula, CA N3407EAeronca 7AC · S/N 7AC-6820Cancelled Jun 6, 1955 · Exported to Cuba · Coral Gables, FL N55483Consolidated Vultee BT-13A · S/N 235Cancelled May 23, 1955 · Coral Gables, FL N67172Cessna T-50 · S/N 4427Cancelled Oct 7, 1954 · Exported to Ecuador · Coral Gables, FL N84861Aeronca 7AC · S/N 7AC-3580Cancelled Mar 26, 1953 · Coral Gables, FL N33983Howard GH-1 · S/N 557Cancelled Aug 25, 1948 · Exported to Brazil · Coral Gables, FL N66160Cessna T-50 · S/N 4724Cancellation date not recorded · Coral Gables, FL

Back to Avex Inc