Earlier aircraft under this name · 19

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'MISSISSIPPI STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'MISSISSIPPI STATE UNIVERSITY') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'MISSISSIPPI STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'MISSISSIPPI STATE 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 = 'MISSISSIPPI STATE UNIVERSITY' OR list_contains(d.other_registrant_names, 'MISSISSIPPI STATE 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.

N604GMSky Hero SPYDER X8 · S/N E1-16309Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Starkville, MS N588XMRoboflight Systems RF-70 · S/N E1-16196Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Starkville, MS N562JMDJI PHANTOM 2 VISION + · S/N PH645220858 V2.0Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Starkville, MS N554DMDJI PHANTOM 2 P330Z · S/N 0175634Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Starkville, MS N530XMAltavian NOVA · S/N MSU-3005Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Starkville, MS N530WMRobota TRITON · S/N 127Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Starkville, MS N551GHPrecisionhawk LANCASTER · S/N 14HE03088Cancelled Aug 7, 2018 · Registration expired, pending cancellation · Starkville, MS N401MSWinward Performance OWL · S/N 001Cancelled Sep 3, 2009 · Triennial form not returned · Starkville, MS N2768QMississippi State Univ MARVEL · S/N 1Cancelled Dec 5, 2003 · Triennial form not returned · Mississippi State, MS N250ATBeech A36 · S/N E-1493Cancelled Nov 8, 2001 · Triennial form not returned · Built 1979 · Mississippi State, MS N376TCAero Commander 690 · S/N 11057Cancelled Feb 23, 2001 · Exported to Canada · Mississippi State, MS N9MUMississippi State University R-1 · S/N 1Cancelled Oct 4, 1994 · Triennial form not returned · Mississippi State, MS N86MUMississippi State University R-1 · S/N 2Cancelled Aug 4, 1994 · Triennial form not returned · Mississippi State, MS N64907Schweizer TG3A · S/N 34Cancelled Jun 1, 1993 · Triennial form not returned · Mississippi State, MS N93228Pratt Read PR-G1 · S/N 53Cancelled Apr 30, 1993 · Triennial form not returned · Mississippi State, MS N65862Schweizer TG3A · S/N 20Cancelled May 8, 1981 · State College, MS N55231Bell H-13 · S/N 5114024Cancelled Feb 19, 1981 · State College, MS N6710Beech UC-45J · S/N 67175Cancelled May 25, 1976 · State College, MS N6712MBeech UC-45J · S/N 67123Cancelled May 25, 1976 · State College, MS

Back to Mississippi State University