Raven Industries 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 = 'RAVEN INDUSTRIES INC' OR list_contains(d.other_registrant_names, 'RAVEN INDUSTRIES 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 = 'RAVEN INDUSTRIES INC' OR list_contains(d.other_registrant_names, 'RAVEN INDUSTRIES 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.
N2796BRaven Industries RALLY RX7 · S/N RX7-417N2872YAerostar International S-60A · S/N S60A-3016N4400YRaven S-60A · S/N S60A-352N5569ARaven Industries RX6 · S/N RX6-376N65063Aerostar International RX-7 · S/N RX7-3130N6584ZAerostar International S-50A · S/N S50A-3003N2790TRaven S-60A · S/N S60A-378N28899Aerostar International RAVEN S-55A · S/N S55A-3005N2891RAerostar International S-60A · S/N S60A-3029N5568ZRaven Industries RX6 · S/N RX6-374N40284Raven Industries S-66A · S/N S66A-125N4078KRaven S55A · S/N S55A-871N4088WRaven S55A · S/N S55A-1005N4096MRaven S-60A · S/N S60A-266N5568SRaven Industries RX6 · S/N RX6-371N5569KRaven Industries RX6 · S/N RXL-378N57044Raven S55A · S/N S55A-627N57045Raven S55A · S/N S55A-628N57152Raven Industries N25SD-15/15T-0.250 · S/N 101N5727DRaven S-60A · S/N S60A-169N6485NAerostar International RX-7 · S/N RX7-3101N55683Raven Industries RX6 · S/N RX6-375N5568YRaven Industries RX6 · S/N RX6-373N5568XRaven Industries RX6 · S/N RX6-372N1068ZRaven Industries S-40 · S/N 101N1108RRaven S55A · S/N S55A-291N5711HAerostar International RX-7 · S/N RX7-233N5568FRaven Industries RX6 · S/N RX6367N1865RRaven Industries RX6 · S/N RX6-251N7283LRaven Industries RX6 · S/N RX6-123N1061RRaven S-50A · S/N S50A-261N1009RRaven Industries RX6 · S/N RX6-170N1008RRaven Industries RX6 · S/N RX6-169N1948RRaven Vulcoon R S-50A · S/N 154N12002Raven Industries S45A · S/N 101N12003Raven S-50 · S/N 108N78YRaven Industries 3323-261-134 · S/N 1N1929RRaven S-50A · S/N S50A-133
Back to Raven Industries Inc