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.
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
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.
N51455Aerostar International S-64A · S/N S64A-EXP3001N90296Aerostar International RAVEN S49A · S/N S49A-3127N6320YAerostar International RAVEN S49A · S/N S49A-3012N6349VAerostar International W100LB · S/N W100LB-3001N6347UAerostar International RAVEN S-47A · S/N S47A-3001N6303GAerostar International RX 8 · S/N RX8-3069N6511XAerostar International RAVEN S-55A · S/N S55A-3036N63765Aerostar International RAVEN S-49S · S/N S49S-3001N6351HRaven Industries RALLY RX7 · S/N RX7-3240N9138DAerostar International S53A · S/N S53A-3031N35861Aerostar International RAVEN S-55A · S/N S55A-3050N5002YAerostar International S-51A · S/N S51A-3022N5005UAerostar International RXS-8 · S/N RXS8-3091N5016BAerostar International S-57A · S/N S57A3237N5079LAerostar International S-57A · S/N S57A-3212N5082SAerostar International S53A · S/N S53A-3056N50905Aerostar International S53A · S/N S53A-3058N51677Aerostar International S53A · S/N S53A-3065N5291CAerostar International S53A · S/N S53A-3082N5291JAerostar International RX 8 · S/N RX8-3343N5292JAerostar International S-60A · S/N S60A-3273N53159Aerostar International AEROSTAR S53H · S/N S53H-3003N6361DAerostar International RAVEN S49A · S/N S49A-3088N63658Aerostar International RAVEN S49A · S/N S49A-3097N9174CAerostar International S-60A · S/N S60A-3193N3600JAerostar International RAVEN S57-A · S/N S57A-3035N3585BAerostar International RAVEN S57-A · S/N S66A-3036N3644YRaven Industries RALLY RX7 · S/N RX7-3256N1248RRaven Industries RX6 · S/N RX6-243N411AMAerostar International S-60S · S/N S60S-3004N43027Bell Helicopter Textron 206L-1 · S/N 45227N101CDBell 206B · S/N 2310N206JRBell 206B-III · S/N 4041N6317RAerostar International RX 8 · S/N RX83097N63076Aerostar International RX 8 · S/N RX83079N7097CAerostar International RAVEN S52A · S/N S52A3018N5686MRaven S-40A · S/N S40A115N6562LAerostar International S-66A · S/N S66A3020N90611Aerostar International 90C · S/N 90C3003N9066DAerostar International S-60A · S/N S60A3183N4124GRaven Industries RALLY RX7 · S/N RX7289N5GDRaven S55A · S/N S55A587N6335WAerostar International RX-7 · S/N RX73231
Back to Aerostar International Inc