OpenAirDocs.org
Mclean, VA

Cancelled registrations · 43

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 = 'MCLEAN'
  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.

N93528Cessna 152 · S/N 15285509Cancelled Jun 25, 2026 · Exported to United Arab Emirates · Built 1982 · Zimmitti AndrewN942ACCessna 208B · S/N 208B5202Cancelled Apr 4, 2025 · Exported to Canada · Built 2015 · Isr Platforms LLCN71EBTextron 208B · S/N 208B5671Cancelled Mar 25, 2025 · Exported to Philippines · Built 2022 · Isr Platforms LLCN2045PPiper PA-23 · S/N 23-628Cancelled Nov 18, 2023 · Revoked, canceled · Built 1956 · Wheeler Charles E IIIN627HCCirrus Design SR22T · S/N 8573Cancelled Nov 7, 2023 · Built 2022 · Buckle Up Aviation LLCN4779WRockwell International 114 · S/N 14109Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Gibbens Jason LN690TPGulfstream AM Corp Comm Div 690D · S/N 15001Cancelled Jul 23, 2019 · Exported to Canada · Built 1982 · Isr Platforms LLCN9061GCessna 182N · S/N 18260601Cancelled Mar 23, 2018 · Revoked, canceled · Built 1971 · Alcar Aviation IncN2539APiper PA-38-112 · S/N 38-78A0743Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1978 · Wood Michael RN66FVAero Commander 680V · S/N 1676-59Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1967 · Wood Michael RN7478RPiper PA-28-140 · S/N 28-22029Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Ostermann Paul AN40KGBeech A36 · S/N E-1283Cancelled Mar 18, 2014 · Built 1978 · Fourstars AviationN1057VCessna R172K · S/N R1722096Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1976 · Bailey Mark HN900RJAero Commander 680V · S/N 1572-27Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1965 · Wood Michael RN429VABell Helicopter Textron Canada 429 · S/N 57024Cancelled Sep 1, 2011 · Exported to Brazil · Victor Alpha Aviation LLCN400GXBombardier BD-700-1A10 · S/N 9037Cancelled Jun 15, 2010 · Triennial form not returned · Built 1999 · Churchill Aviation LLCN718KSDassault FALCON 2000 · S/N 216Cancelled Jun 16, 2008 · Exported to Austria · Built 2004 · Ksi Properties LLCN122LKRolladen-Schneider LS-4 · S/N 4097Cancelled Nov 19, 2007 · Exported to Argentina · Built 1982 · Williams ChristianN94490Cessna 152 · S/N 15285689Cancelled Aug 19, 2002 · Triennial form not returned · Built 1983 · Aviation Equipment Co LLCN341KSSchleicher ASK-21 · S/N 21252Cancelled Aug 8, 2002 · Triennial form not returned · Built 1985 · K21 GroupN337BESaab-Fairchild 340A · S/N 340A-047Cancelled Apr 26, 2001 · Exported to Canada · Mcc Financial CorpN914MADehavilland DHC-6-300 · S/N 724Cancelled Oct 13, 1995 · Exported to Canada · Mcc Financial CorporationN929MADehavilland DHC-6 TWIN OTTER · S/N 500Cancelled Oct 4, 1995 · Exported to French Polynesia · Mcc Financial CorporationN915MADehavilland DHC-6-300 · S/N 731Cancelled Sep 26, 1995 · Exported to Canada · Mcc Financial CorpN2615ZCessna 402C · S/N 402C0110Cancelled Sep 18, 1995 · Exported to Venezuela · Mcc Financial CorporationN916MADehavilland DHC-6 TWIN OTTER · S/N 339Cancelled Dec 13, 1994 · Exported to Canada · Mcc Aircraft Leasing I IncN918MADehavilland DHC-6 TWIN OTTER · S/N 287Cancelled Dec 13, 1994 · Exported to Canada · Mcc Aircraft Leasing I IncN928MADehavilland DHC-6 TWIN OTTER · S/N 269Cancelled Dec 13, 1994 · Exported to Canada · Mcc Aircraft Leasing I IncN934MADehavilland DHC-6 TWIN OTTER · S/N 279Cancelled Dec 13, 1994 · Exported to Canada · Mcc Aircraft Leasing I IncN342AESwearingen SA227-AC · S/N AC545Cancelled Nov 20, 1992 · Triennial form not returned · Mcc Financial CorporationN726USFairchild F-27A · S/N 106Cancelled Jun 12, 1991 · Triennial form not returned · US Aircraft Sales IncN2958HSchweizer SGS 1-26E · S/N 688Cancelled Dec 5, 1990 · Goehring Jack J IIIN539SAFairchild SA227-AT · S/N AT539Cancelled Apr 30, 1986 · Investair Leasing CorpN73730Beech C-45H · S/N AF674Cancelled May 8, 1985 · Investair Leasing CorpN64139Dehavilland DHC-6 · S/N 139Cancelled Jul 5, 1984 · Exported to France · U S Aircraft Sales IncN3225Fairchild F-27 · S/N 40Cancelled Sep 8, 1983 · Exported to Sweden · Built 1959 · US Aircraft Sales IncN6765UCessna 404 · S/N 4040806Cancelled Jun 27, 1983 · Exported to Panama · Investair Leasing CorpN9196QBeech 58 · S/N TH-153Cancelled Jul 9, 1980 · Exported to South Africa · Stern Norman HawkinsN204CSBeech 200 · S/N BB119Cancelled Jun 12, 1980 · Exported to Denmark · Built 1976 · US Aircraft Sales IncN16DACessna 310P · S/N 301P-0192Cancelled Oct 31, 1977 · Lrw Aircraft Sales IncN5602Scheperle C W MUSTANG II MOD · S/N S74-1Cancelled Aug 14, 1974 · Scheperle Cletus WN9952FCessna 414 · S/N 414-0402Cancelled Oct 5, 1973 · Exported to Philippines · Built 1973 · Worldwide Wilcox IncN8391HNorth American T-28A · S/N 491584Cancelled Feb 11, 1971 · Mount John F
Back to Mclean, VA