Southern Illinois University
Earlier aircraft under this name · 20
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 = 'SOUTHERN ILLINOIS UNIVERSITY' OR list_contains(d.other_registrant_names, 'SOUTHERN ILLINOIS UNIVERSITY') 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 = 'SOUTHERN ILLINOIS UNIVERSITY' OR list_contains(d.other_registrant_names, 'SOUTHERN ILLINOIS UNIVERSITY') 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.
N888FAGates Lear Jet 24D · S/N 257N51UCBeech U-8F · S/N 62-03872N3053LCessna 310J · S/N 310J0053N18231Cessna 150L · S/N 15073884N4668GCessna 172N · S/N 17273294N2414XBell 206B · S/N 9035N67125Bell TH-13T · S/N 3644N221SBell 47D1 · S/N 476N4915HCessna 152 · S/N 15284018N2636YCessna 310R · S/N 310R1652N67124Bell TH-13T · S/N 3681N3088XCessna 150F · S/N 15064488N306SDouglas C-47D · S/N 4349525N5993TCessna 150D · S/N 15060693N9437ZBeech C-45H · S/N 51-11845N8689EHiller UH-12A · S/N 51-16128N9461ZNorth American AT-6G · S/N 49-3154N9099CStinson L-5E · S/N 4385N13006Lockheed T-33A · S/N 53-5010N7424Vickers VISCOUNT 745-D · S/N 122
Back to Southern Illinois University