Cancelled registrations · 34

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_state = 'MS' AND d.registrant_city = 'STARKVILLE' 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_state = 'MS' AND d.registrant_city = 'STARKVILLE'
  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_state = 'MS' AND d.registrant_city = 'STARKVILLE'
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.

N18LVPiper PA-28-150 · S/N 28-2374Cancelled Aug 19, 2026 · Sale reported, canceled · Built 1965 N66657Cessna 150M · S/N 15076189Cancelled Feb 28, 2026 · Registration pending, canceled · Built 1974 N4114RPiper PA-32-300 · S/N 32-40433Cancelled Aug 15, 2023 · Built 1968 · Grassroots Aviation Inc N604GMSky Hero SPYDER X8 · S/N E1-16309Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Mississippi State University N588XMRoboflight Systems RF-70 · S/N E1-16196Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Mississippi State University N562JMDJI PHANTOM 2 VISION + · S/N PH645220858 V2.0Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Mississippi State University N554DMDJI PHANTOM 2 P330Z · S/N 0175634Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Mississippi State University N530XMAltavian NOVA · S/N MSU-3005Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Mississippi State University N530WMRobota TRITON · S/N 127Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Mississippi State University N7647RBeech 19A · S/N MB-438Cancelled Feb 12, 2020 · Built 1969 · Keesling Aircraft Rental And Training LLC N545FCJosef B Cobb PROTECH PT2-B · S/N 1067Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 2015 · Cobb Josef B N551GHPrecisionhawk LANCASTER · S/N 14HE03088Cancelled Aug 7, 2018 · Registration expired, pending cancellation · Mississippi State University N217FRSaab Scandia S-35XD · S/N AR117Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1971 · Flight Research Inc N3602NPiper J3C-65 · S/N 22849Cancelled Oct 28, 2017 · Revoked, canceled · Built 1947 · Dixie Acft N80957Cessna 172M · S/N 17266818Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Camp Terry M N3066XCessna 150F · S/N 15064466Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1966 · Caldwell Wesley A III N4KVDehavilland DHC-1B-2-S5 · S/N 209 247Cancelled Jun 4, 2013 · Built 1956 · Flight Research Inc N4989ZPiper PA-22-108 · S/N 22-8597Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1961 · Camp Ruth B N5410MBeech 76 · S/N ME-27Cancelled Apr 21, 2011 · Triennial form not returned · Built 1978 · Flight Research Inc N941GAGlobal GT3 · S/N TB-001Cancelled Apr 8, 2011 · Triennial form not returned · Built 1995 · Global Aircraft Coporattion N606VBeech 35-33 · S/N CD-86Cancelled Mar 25, 2011 · First renewal notice · Built 1960 · Flight Research Inc N211BRNorth American NA-265-60 · S/N 306-85Cancelled Jul 23, 2010 · Triennial form not returned · Built 1971 · Flight Research Inc N401MSWinward Performance OWL · S/N 001Cancelled Sep 3, 2009 · Triennial form not returned · Mississippi State University N171FRFlight Research FRI H58C · S/N FRI 002Cancelled May 10, 2007 · Triennial form not returned · Flight Research Inc N172FRFlight Research FRI H58C · S/N FRI 003Cancelled May 10, 2007 · Triennial form not returned · Flight Research Inc N83MSSmith Michael R SKYLARK II · S/N SII-0001Cancelled Jan 30, 2007 · Second triennial mailing, no response · Global Aircraft Corp N95BWBeech 65-80 · S/N LD-136Cancelled Aug 24, 2005 · Built 1964 · Flight Research Inc N162TPAermacchi IMPALA MB-326M · S/N 473Cancelled Apr 26, 2005 · Triennial form not returned · Built 1967 · Flight Research Inc N98229Piper PA-28-140 · S/N 28-26121Cancelled Jan 28, 2005 · Triennial form undeliverable · Built 1969 · Dollar Douglas A N882DHHarriman Dick TURNER T40A · S/N 167Cancelled Sep 11, 2001 · Triennial form not returned · Smith Michael Ross Jr N823GMMckibben Gerald H GN-1 AIRCAMPER · S/N 001Cancelled Apr 1, 1998 · Triennial form not returned · Mckibben Gerald H N66124Cessna 150M · S/N 15075853Cancelled May 26, 1976 · Triangle Aviation Inc N52024Pratt Read PR-G1 · S/N 01-31Cancelled Jan 26, 1971 · Clisby M B T A Carlton N35490Piper J3C-65 · S/N 6393Cancelled Jan 18, 1971 · Leland H Agard

Back to Starkville, MS