Aerostar International Inc

Earlier aircraft under this name · 43

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

N51455Aerostar International S-64A · S/N S64A-EXP3001Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1998 · Sioux Falls, SDN90296Aerostar International RAVEN S49A · S/N S49A-3127Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1992 · Sioux Falls, SDN6320YAerostar International RAVEN S49A · S/N S49A-3012Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Sioux Falls, SDN6349VAerostar International W100LB · S/N W100LB-3001Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1990 · Sioux Falls, SDN6347UAerostar International RAVEN S-47A · S/N S47A-3001Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1990 · Sioux Falls, SDN6303GAerostar International RX 8 · S/N RX8-3069Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Sioux Falls, SDN6511XAerostar International RAVEN S-55A · S/N S55A-3036Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Sioux Falls, SDN63765Aerostar International RAVEN S-49S · S/N S49S-3001Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1992 · Sioux Falls, SDN6351HRaven Industries RALLY RX7 · S/N RX7-3240Cancelled Jan 4, 2011 · Expired dealer · Built 1991 · Sioux Falls, SDN9138DAerostar International S53A · S/N S53A-3031Cancelled Jan 4, 2011 · Expired dealer · Sioux Falls, SDN35861Aerostar International RAVEN S-55A · S/N S55A-3050Cancelled Jan 3, 2011 · Expired dealer · Built 1990 · Sioux Falls, SDN5002YAerostar International S-51A · S/N S51A-3022Cancelled Jan 3, 2011 · Expired dealer · Built 2002 · Sioux Falls, SDN5005UAerostar International RXS-8 · S/N RXS8-3091Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN5016BAerostar International S-57A · S/N S57A3237Cancelled Jan 3, 2011 · Expired dealer · Built 2002 · Sioux Falls, SDN5079LAerostar International S-57A · S/N S57A-3212Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN5082SAerostar International S53A · S/N S53A-3056Cancelled Jan 3, 2011 · Expired dealer · Built 1999 · Sioux Falls, SDN50905Aerostar International S53A · S/N S53A-3058Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN51677Aerostar International S53A · S/N S53A-3065Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN5291CAerostar International S53A · S/N S53A-3082Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN5291JAerostar International RX 8 · S/N RX8-3343Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN5292JAerostar International S-60A · S/N S60A-3273Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN53159Aerostar International AEROSTAR S53H · S/N S53H-3003Cancelled Jan 3, 2011 · Expired dealer · Built 2002 · Sioux Falls, SDN6361DAerostar International RAVEN S49A · S/N S49A-3088Cancelled Jan 3, 2011 · Expired dealer · Sioux Falls, SDN63658Aerostar International RAVEN S49A · S/N S49A-3097Cancelled Jan 3, 2011 · Expired dealer · Built 1991 · Sioux Falls, SDN9174CAerostar International S-60A · S/N S60A-3193Cancelled Jan 3, 2011 · Expired dealer · Built 1994 · Sioux Falls, SDN3600JAerostar International RAVEN S57-A · S/N S57A-3035Cancelled Feb 21, 2004 · Triennial form not returned · Built 1988 · Sioux Falls, SDN3585BAerostar International RAVEN S57-A · S/N S66A-3036Cancelled Nov 20, 2002 · Triennial form not returned · Sioux Falls, SDN3644YRaven Industries RALLY RX7 · S/N RX7-3256Cancelled Jul 25, 2002 · Triennial form not returned · Built 1990 · Sioux Falls, SDN1248RRaven Industries RX6 · S/N RX6-243Cancelled Nov 29, 2001 · Triennial form not returned · Built 1977 · Sioux Falls, SDN411AMAerostar International S-60S · S/N S60S-3004Cancelled Mar 1, 2001 · Sioux Falls, SDN43027Bell Helicopter Textron 206L-1 · S/N 45227Cancelled Feb 3, 1998 · Exported to Guatemala · Austin, TXN101CDBell 206B · S/N 2310Cancelled Jan 26, 1998 · Exported to Canada · Austin, TXN206JRBell 206B-III · S/N 4041Cancelled Sep 5, 1997 · Exported to United Kingdom · Austin, TXN6317RAerostar International RX 8 · S/N RX83097Cancelled Mar 18, 1997 · Triennial form not returned · Sioux Falls, SDN63076Aerostar International RX 8 · S/N RX83079Cancelled Jun 17, 1996 · Triennial form not returned · Sioux Falls, SDN7097CAerostar International RAVEN S52A · S/N S52A3018Cancelled Jul 27, 1995 · Exported to Canada · Sioux Falls, SDN5686MRaven S-40A · S/N S40A115Cancelled Apr 25, 1995 · Triennial form not returned · Sioux Falls, SDN6562LAerostar International S-66A · S/N S66A3020Cancelled Dec 16, 1993 · Sioux Falls, SDN90611Aerostar International 90C · S/N 90C3003Cancelled Mar 19, 1993 · Exported to Canada · Sioux Falls, SDN9066DAerostar International S-60A · S/N S60A3183Cancelled Mar 9, 1993 · Exported to Germany · Sioux Falls, SDN4124GRaven Industries RALLY RX7 · S/N RX7289Cancelled Jun 17, 1992 · Sioux Falls, SDN5GDRaven S55A · S/N S55A587Cancelled May 20, 1992 · Sioux Falls, SDN6335WAerostar International RX-7 · S/N RX73231Cancelled Feb 25, 1991 · Exported to Japan · Sioux Falls
Back to Aerostar International Inc