Edwards And Associates Inc

Earlier aircraft under this name · 38

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 = 'EDWARDS AND ASSOCIATES INC' OR list_contains(d.other_registrant_names, 'EDWARDS AND ASSOCIATES 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.

N58188Hughes 269C · S/N 380675Cancelled Jul 17, 1998 · Exported to Canada · Piney Flats, TNN663JBBell 206L · S/N 45046Cancelled Mar 26, 1998 · Exported to Canada · Bristol, TNN18EABell 206B · S/N 4160Cancelled Mar 13, 1998 · Exported to United Kingdom · Bristol, TNN20EABell 206B · S/N 4101Cancelled Mar 13, 1998 · Exported to Panama · Bristol, TNN94CABell 206B · S/N 2398Cancelled Nov 10, 1997 · Exported to United Kingdom · Piney Flats, TNN5735YBell 206B · S/N 3006Cancelled Sep 8, 1997 · Exported to United Kingdom · Bristol, TNN16751Bell 206L · S/N 45092Cancelled May 9, 1997 · Exported to Canada · Piney Flats, TNN2VCBell 206B · S/N 779Cancelled May 17, 1996 · Exported to United Kingdom · Bristol, TNN59554Bell 206B · S/N 1401Cancelled Sep 21, 1995 · Exported to United Kingdom · Piney Flats, TNN65EABell 206B · S/N 3364Cancelled Aug 25, 1995 · Exported to Canada · Bristol, TNN688MSBell 206B · S/N 3397Cancelled Dec 19, 1994 · Exported to South Africa · Bristol, TNN75EABell 206B · S/N 3949Cancelled Sep 2, 1994 · Exported to United Kingdom · Bristol, TNN206RPBell 206B · S/N 2309Cancelled Jan 19, 1994 · Exported to Panama · Bristol, TNN3173YBell 206B · S/N 3685Cancelled Jun 15, 1993 · Exported to Brazil · Bristol, TNN2775RBell 206B · S/N 2769Cancelled May 5, 1993 · Exported to Canada · Bristol, TNN8530FBell 212 · S/N 30940Cancelled Feb 19, 1993 · Exported to Canada · Bristol, TNN3209VBell 206B · S/N 3943Cancelled May 13, 1992 · Exported to Greece · Bristol, TNN16736Bell 206L · S/N 45075Cancelled May 30, 1991 · Exported to Canada · Bristol, TNN24FHBell 222 · S/N 47070Cancelled May 23, 1991 · Exported to Germany · Bristol, TNN144JDBell Helicopter Textron 206L-1 · S/N 45737Cancelled May 15, 1991 · Exported to Canada · Bristol, TNN57497Bell Helicopter Textron 206L-1 · S/N 45510Cancelled Apr 29, 1991 · Exported to Colombia · Bristol, TNN333WMBell 206B · S/N 2959Cancelled Apr 8, 1991 · Exported to Italy · Bristol, TNN90104Bell 206B · S/N 1599Cancelled Apr 8, 1991 · Exported to Italy · Bristol, TNN65CWBell 206B · S/N 2327Cancelled Mar 7, 1991 · Exported to Germany · Bristol, TNN400MHBell 206B · S/N 1648Cancelled Feb 13, 1991 · Exported to United Kingdom · Bristol, TNN49590Bell 206B · S/N 1714Cancelled Feb 13, 1991 · Exported to United Kingdom · Bristol, TNN22EABell 206B · S/N 1122Cancelled Dec 30, 1980 · Exported to Canada · Built 1973 · Blountsville, TNN10YBBell 206B · S/N 1393Cancelled Nov 7, 1980 · Exported to Canada · Built 1974 · Blountville, TNN12SMBell 206B · S/N 1571Cancelled Aug 13, 1980 · Exported to Canada · Built 1975 · Blountville, TNN90022Bell 206B · S/N 1688Cancelled Apr 10, 1980 · Exported to Canada · Bloutville, TNN49629Bell 206B · S/N 1790Cancelled Oct 26, 1979 · Exported to Canada · Built 1975 · Blountville, TNN8628FHughes Helicopters HUGHES 369D · S/N 670138DCancelled Oct 15, 1979 · Exported to New Zealand · Built 1977 · Blountville, TNN16753Bell 206B · S/N 2131Cancelled Jul 13, 1979 · Exported to Canada · Blountville, TNN9958KBell 206B · S/N 2032Cancelled Jun 22, 1979 · Built 1976 · Blountville, TNN8358FHughes Helicopters HUGHES 369D · S/N 170068DCancelled Mar 30, 1979 · Exported to Canada · Built 1977 · Blountville, TNN440ASBell 206B · S/N 1617Cancelled Feb 23, 1979 · Exported to Canada · Blountville, TNN49698Bell 206B · S/N 1903Cancelled Aug 18, 1978 · Exported to Venezuela · Blountville, TNN16795Bell 206B · S/N 2196Cancelled Jul 21, 1978 · Exported to Canada · Blountville, TN
Back to Edwards And Associates Inc