Sierra Nevada Corp
Earlier aircraft under this name · 17
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 = 'SIERRA NEVADA CORP' OR list_contains(d.other_registrant_names, 'SIERRA NEVADA CORP') 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 = 'SIERRA NEVADA CORP' OR list_contains(d.other_registrant_names, 'SIERRA NEVADA CORP') 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.
N590QPPolskie Zaklady Lotnicze Spzoo PZL M28 05 · S/N AJE00343N351SFBeechcraft B300 · S/N FL-924N896FLBeechcraft B300 · S/N FL-896N8041X21st Century Airships SPAS 70 · S/N 70-1AN36EGPilatus PC-12/47 · S/N 809N600KPPilatus PC-12/47 · S/N 700N757EDPilatus PC-12/47 · S/N 790N822BMPilatus PC-12/47 · S/N 822N824BKPilatus PC-12/47 · S/N 718N838PEPilatus PC-12/47 · S/N 838N56EZPilatus PC-12/45 · S/N 488N609TWPilatus PC-12/47 · S/N 712N691PCPilatus PC-12/47 · S/N 691N711PNPilatus PC-12/47 · S/N 711N72EAPilatus PC-12/47 · S/N 736N829PEPilatus PC-12/47 · S/N 829N840PEPilatus PC-12/47 · S/N 840
Back to Sierra Nevada Corp