Skip to content

Cancelled registrations · 2,333

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 = 'TX' AND d.registrant_city = 'DALLAS' 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 = 'TX' AND d.registrant_city = 'DALLAS'
  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 = 'TX' AND d.registrant_city = 'DALLAS'
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.

N1174Atr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1174Cancelled Jul 22, 2024 · Exported to Guernsey · Jah2022a Atr72 Msn 1174 LLC N812AYBombardier CL-600-2B19 · S/N 8012Cancelled May 8, 2024 · Built 2005 · Beautech Power Systems LLC N605CBBombardier CL-600-2B16 · S/N 5723Cancelled Mar 8, 2024 · Exported to Canada · Built 2007 · Bombardier Aerospace Corp N1438QCessna 150L · S/N 15072738Cancelled Oct 28, 2023 · Sale reported, canceled · Built 1971 N32510Piper PA-34-200T · S/N 34-7570027Cancelled Oct 28, 2023 · Revoked, canceled · Built 1974 · Firestone Russell A Jr N3923UCessna 150E · S/N 15061323Cancelled Sep 30, 2023 · Revoked, canceled · Built 1965 · Ritter Rodney O N1901WBombardier BD-100-1A10 · S/N 20398Cancelled Sep 25, 2023 · Exported to Morocco · Built 2013 · Bombardier Aerospace Corp N743AEPilatus PC-12/47 · S/N 743Cancelled Sep 15, 2023 · Exported to Canada · Built 2006 · Boutique Air Inc N34216Saab-Scania SAAB 340B · S/N 340B-216Cancelled Sep 6, 2023 · Exported to Canada · Built 1990 · Jah2022a Saab340b Msn 216 LLC N87CERaytheon B300 · S/N FL-231Cancelled Aug 8, 2023 · Exported to Canada · Built 1998 · Twenty Coveys LLC N213AFCessna 150M · S/N 15077337Cancelled Jul 20, 2023 · Sale reported, canceled · Built 1975 N801BABombardier BD-100-1A10 · S/N 20192Cancelled Jul 20, 2023 · Exported to Canada · Built 2007 · Bombardier Aerospace Corp N6763Bell P-63F · S/N 296E1-1RCancelled Jul 18, 2023 · Built 1946 · American Airpower Heritage Flying Mu N7227CBoeing B-17G · S/N 77235Cancelled Jul 18, 2023 · Built 1944 · American Airpower Heritage Flying Museum N485FWDassault-Breguet MYSTERE FALCON 20-F5 · S/N 485Cancelled Jul 5, 2023 · Exported to South Africa · Built 1990 · Crowe Air LLC N76TTBeech B300 · S/N FL-130Cancelled Jul 4, 2023 · Built 1995 · King Air 350 Partners LLC N327JSSaab SAAB 340B · S/N 340B-327Cancelled Jun 28, 2023 · Exported to Canada · Built 1992 · Jah2022a Saab340b Msn 327 LLC N177FFBombardier CL-600-2B16 · S/N 5878Cancelled Jun 13, 2023 · Exported to Canada · Built 2011 · Bombardier Aerospace Corp N9555ACessna 170A · S/N 19391Cancelled May 13, 2023 · Revoked, canceled · Built 1950 · White Rock Flying Club Inc N8766MBeech A23 · S/N M-582Cancelled May 9, 2023 · Sale reported, canceled · Built 1963 N428CJIsrael Aircraft Industries GULFSTREAM 100 · S/N 146Cancelled Apr 24, 2023 · Exported to Canada · Built 2003 N86553Douglas DC3-G202A · S/N 4715Cancelled Mar 15, 2023 · Registration expired, pending cancellation · Built 1942 · Thirsty 13th LLC N3660JCessna 150G · S/N 15064960Cancelled Mar 4, 2023 · Sale reported, canceled · Built 1966 N95532Airborne Windsports Australia AIRBORNE EDGE · S/N 582-160Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Wade Ules S N55455Piper PA-32-260 · S/N 32-7300038Cancelled Jan 19, 2023 · Sale reported, canceled · Built 1973 N152MWCessna 152 · S/N 15282728Cancelled Jan 11, 2023 · Sale reported, canceled · Built 1978 N201CRDassault FALCON 2000 · S/N 002Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1995 · Marklyn Jet Parts LLC N1105GEmbraer EMB-120FC · S/N 120.105Cancelled Dec 24, 2022 · Built 1988 · Ameriflight LLC N134NJEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000134Cancelled Dec 21, 2022 · Exported to Dominican Republic · Beautech Power Systems LLC N194CJSaab-Scania SAAB 340B · S/N 340B-194Cancelled Dec 19, 2022 · Exported to Canada · Jah2022a Saab340b Msn 194 LLC N680BABombardier CL-600-2B16 · S/N 6133Cancelled Dec 7, 2022 · Exported to Canada · Bombardier Aerospace Corp N5692TCessna 172E · S/N 17251592Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Watts Lawrence N797CABombardier CL-600-2B19 · S/N 7344Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1999 · Beautech Power Systems LLC N815CABombardier CL-600-2B19 · S/N 7397Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 2000 · Beautech Power Systems LLC N131ERConsolidated Aeronautics LAKE LA-4-200 · S/N 940Cancelled Nov 29, 2022 · Sale reported, canceled N3387KGlobe GC-1B · S/N 1380Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1946 · Puckett John H N191MJSaab-Scania SAAB 340B · S/N 340B-191Cancelled Oct 19, 2022 · Exported to Canada · Built 1990 · Jah 2022a Saab 340b Msn 191 LLC N269CAEmbraer EMB-120RT · S/N 120263Cancelled Sep 19, 2022 · Built 1992 · Ameriflight LLC N793PREmbraer ERJ 170-100 STD · S/N 17000093Cancelled Sep 15, 2022 · Exported to Austria · Petrus Regional One E170 Holdings LLC N47314Cessna 152 · S/N 15283212Cancelled Aug 13, 2022 · Sale reported, canceled · Built 1979 N12073Cornelius-Pitts Special S1C · S/N D.E.CCancelled Aug 8, 2022 · Registration expired, pending cancellation · Built 1969 · Damianov Venko D N126KCRaytheon Corporate Jets HAWKER 800 · S/N 258276Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1995 · Marklyn Jet Parts LLC N998PARaytheon 390 · S/N RB-70Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2003 · Attorney Aviation LLC N2187DJI PHANTOM 3 PROFESSION · S/N P76DCF01014216Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Scott Alan Wilcox Photography LLC N257RCCarroll Roger A MINI 500 · S/N 257Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1999 · Portlock Ural Jr N247JSBombardier CL-600-2B19 · S/N 7922Cancelled May 14, 2022 · Built 2004 · Beautech Power Systems LLC N7717BCessna 650 · S/N 6500214Cancelled Apr 27, 2022 · Sale reported · Built 1992 N15NZIai GULFSTREAM G280 · S/N 2183Cancelled Apr 20, 2022 · Exported to Canada · Built 2019 · Orange & Black Holdings LLC N7216CNorth American SNJ-5 · S/N 4286374Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Shaw Lewis W II N627QAAeryon Labs SKY RANGER · S/N US9001098Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Remotely Piloted Solutions LLC

Back to Dallas, TX