OpenAirDocs.org
Sterling, VA

Cancelled registrations · 51

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_state = 'VA' AND d.registrant_city = 'STERLING'
  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.

N630EMDJI INSPIRE 1 · S/N W13DCD16031868Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Guilbault Marc RN1768KLuscombe 8E · S/N 4495Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Carter Carl GN702AHSensefly EBEE · S/N EB-03-18556Cancelled Aug 18, 2018 · Sale reported, canceledN106XJSaab-Fairchild 340A · S/N 340A-106Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Fairbrook Leasing IncN107XJSaab-Fairchild 340A · S/N 340A-107Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Lambert Leasing IncN14PFFoley Patrick LONG-EZ · S/N 1Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1994 · Foley Patrick WN251CJSaab 340B · S/N 340B-251Cancelled Apr 28, 2015 · Built 1991 · Lambert Leasing IncN429XJSaab-Scania SAAB 340B · S/N 340B-429Cancelled Sep 25, 2014 · Exported to United Arab Emirates · Built 1997 · Lambert Leasing IncN456XJSaab SAAB 340B · S/N 340B-456Cancelled Jan 30, 2014 · Exported to Sweden · Built 1998 · Lambert Leasing IncN817JTCessna 182E · S/N 18254397Cancelled Jan 14, 2014 · Exported to Bolivia · Built 1962N4718PPiper PA-23-250 · S/N 27-247Cancelled Aug 6, 2012 · Revoked, canceled · Built 1960 · Dunmire John PerryN255AJSaab SAAB 340B · S/N 340B-255Cancelled Nov 2, 2011 · Exported to Thailand · Built 1991 · Lambert Leasing IncN106RWDassault FALCON 900 EX · S/N 120Cancelled Sep 28, 2010 · Built 2003 · Mmrb Services LLCN110XJSaab-Fairchild 340A · S/N 340A-110Cancelled Jul 19, 2010 · Exported to Bahamas · Built 1988 · Lambert Lsg IncN35SZSaab-Scania SF340A · S/N 340A-035Cancelled May 28, 2010 · Triennial form not returned · Built 1985 · Lambert Leasing IncN99VCSaab-Scania SF-340-A · S/N 340A-099Cancelled Dec 7, 2009 · Exported to Bahamas · Lambert Leasing IncN217JJSaab SAAB 340B · S/N 340B-217Cancelled May 1, 2009 · Exported to Argentina · Lambert Leasing IncN288JJSaab SAAB 340B · S/N 340B-288Cancelled Apr 24, 2009 · Exported to Argentina · Lambert Leasing IncN121CQSaab-Scania SF340A · S/N 340A-121Cancelled Mar 23, 2009 · Exported to Bahamas · Built 1988 · Lambert Leasing IncN285DCSaab SAAB 340B · S/N 226Cancelled Oct 3, 2008 · Exported to Argentina · Lambert Leasing IncN284DCSaab SAAB 340B · S/N 340B-270Cancelled Sep 4, 2008 · Exported to Argentina · Lambert Leasing IncN98XJSaab-Fairchild 340A · S/N 340A-098Cancelled Jan 4, 2008 · Exported to Bahamas · Built 1987 · Lambert Leasing IncN8190JPrendergast John SEAWIND · S/N 024Cancelled Dec 14, 2007 · Triennial form not returned · Built 1999 · Prendergast John MN43SZSaab-Fairchild 340A · S/N 340A-043Cancelled Nov 17, 2006 · Exported to Canada · Built 1985 · Lambert Leasing IncN340SZSaab-Fairchild 340A · S/N 340A-004Cancelled Apr 3, 2006 · Exported to Canada · Built 1984 · Lambert Leasing IncN360SZSaab-Fairchild 340A · S/N 340A-006Cancelled Mar 16, 2006 · Exported to Canada · Built 1984 · Lambert Leasing IncN103VNSaab-Fairchild 340A · S/N 340A-103Cancelled Feb 23, 2006 · Triennial form not returned · Lambert Leasing IncN107EASaab-Fairchild 340A · S/N 094Cancelled Feb 17, 2006 · Exported to Canada · Lambert Leasing IncN363JJSaab 340B · S/N 340B-363Cancelled Jan 4, 2006 · Exported to Sweden · Lambert Leasing IncN13UVSaab-Scania SF340A · S/N 340 A-013Cancelled Dec 22, 2005 · Exported to Kuwait · Built 1984 · Lambert Leasing IncN818GLFairchild SA227-DC (C26B) · S/N DC-818BCancelled Jun 27, 2003 · Exported to Australia · Lambert Leasing IncN823MMFairchild SA227-DC · S/N DC-823BCancelled Oct 22, 2002 · Exported to Australia · Lambert Leasing IncN822MMFairchild SA227-DC · S/N DC-822BCancelled Jul 24, 2002 · Exported to Australia · Lambert Leasing IncN808SKFairchild SA227-DC (C26B) · S/N DC808BCancelled Jun 6, 2002 · Exported to Australia · Lambert Leasing IncN7719MMooney M22 · S/N 680010Cancelled Jan 28, 2002 · Exported to Australia · Built 1968 · Bastien Peter MN75UWSaab-Fairchild 340A · S/N 340A-075Cancelled Mar 28, 2001 · Exported to Canada · Lambert Leasing IncN361AEFairchild SA227-AC · S/N AC-676Cancelled Aug 13, 1999 · Exported to Canada · Fleet Capital CorporationN419MXBritish Aerospace BAE JETSTREAM 3101 · S/N 611Cancelled Aug 10, 1999 · Non-citizen corporation, flight hours not reported · British Aerospace Asset Management IncN420MXBritish Aerospace BAE JETSTREAM 3101 · S/N 617Cancelled Aug 10, 1999 · Non-citizen corporation, flight hours not reported · British Aerospace Asset Management IncN422MXBritish Aerospace BAE JETSTREAM 3101 · S/N 602Cancelled Aug 10, 1999 · British Aerospace Asset Management IncN619JXBritish Aerospace BAE JETSTREAM 3101 · S/N 619Cancelled Aug 10, 1999 · Non-citizen corporation, flight hours not reported · British Aerospace Asset Management IncN822JSBritish Aerospace BAE JETSTREAM 3101 · S/N 615Cancelled Aug 10, 1999 · British Aerospace Asset Management IncN824JSBritish Aerospace BAE JETSTREAM 3101 · S/N 627Cancelled Aug 10, 1999 · British Aerospace Asset Management IncN825JSBritish Aerospace BAE JETSTREAM 3101 · S/N 633Cancelled Aug 10, 1999 · British Aerospace Asset Management IncN135TRBritish Aerospace BAE 146 SERIES 100A · S/N E1035Cancelled Dec 27, 1996 · Exported to United Kingdom · British Aerospace Holdings IncN171TRBritish Aerospace BAE 146 SERIES 100A · S/N E1071Cancelled Oct 10, 1996 · Exported to United Kingdom · British Aerospace Holdings IncN257PXSaab SAAB 340B · S/N 340B-257Cancelled Jun 19, 1996 · Exported to Australia · Built 1991 · Lambert Leasing IncN328DADornier Luftfahrt 328-100 · S/N 3023Cancelled Sep 21, 1995 · Exported to Germany · Dornier Aviation Inc North AmericaN714CRCessna 150M · S/N 15079078Cancelled Oct 21, 1991 · Triennial form not returned · Tel Aero IncN6923ACessna 172 · S/N 29023Cancelled Jun 27, 1973 · Built 1956 · Mockabee Thomas A
Back to Sterling, VA