OpenAirDocs.org
Bridgewater, VA

Cancelled registrations · 88

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

N43UBeech 200T · S/N BT13Cancelled Mar 7, 2025 · Exported to Guernsey · Built 1980 · Dynamic Avlease IncN45DBeech 200T · S/N BT-15Cancelled May 31, 2024 · Exported to Guernsey · Built 1985 · Dynamic Avlease IncN432FEDehavilland DHC-8-102 · S/N 237Cancelled Apr 2, 2024 · Exported to Canada · Built 1990 · Dynamic Avlease IncN65LBeech 65-A90-1 · S/N LM-73Cancelled Nov 9, 2023 · Built 1967 · Dynamic Avlease IncN46XBeech A200 · S/N BC-47Cancelled Sep 13, 2023 · Built 1977 · Dynamic Avlease IncN327ENBoeing Of Canada/Dehav Div DHC-8-311 · S/N 261Cancelled Aug 27, 2023 · Built 1991 · Dynamic Aviation Group IncN301KDehavilland DHC-8-301 · S/N 190Cancelled Jul 26, 2023 · Dynamic Aviation Group IncN328ENBoeing Of Canada/Dehav Div DHC-8-311 · S/N 281Cancelled Jul 26, 2023 · Built 1991 · Dynamic Aviation Group IncN23WBeech E-90 · S/N LW230Cancelled May 29, 2023 · Built 1977 · Dynamic Avlease IncN28MBeech E-90 · S/N LW-147Cancelled May 29, 2023 · Built 1975 · Dynamic Avlease IncN7043DBeech 65-A90-1 · S/N LM-35Cancelled May 27, 2023 · Dynamic Aviation Group IncN7051KBeech 65-A90-1 · S/N LM-44Cancelled May 27, 2023 · Dynamic Aviation Group IncN7169UBeech 65-A90-1 · S/N LM-122Cancelled May 27, 2023 · Dynamic Aviation Group IncN806WPBoeing / Dehavilland DHC-8-103 · S/N 357Cancelled May 27, 2023 · Built 1993 · Dynamic Avlease IncN805WPDehavilland DHC-8-103 · S/N 353Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1993 · Dynamic Avlease IncN57019Cosmos PHASE 2 · S/N B21072Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 2000 · Larsen William VN449FEDehavilland DHC-8-102 · S/N 128Cancelled May 14, 2022 · First renewal notice · Dynamic Avlease IncN590KDehavilland DHC-8-315 · S/N 590Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2002 · Dynamic Aviation Group IncN320XDehavilland DHC-8-311 · S/N 320Cancelled Jun 22, 2021 · Built 1992 · Dynamic Aviation Group IncN308HDehavilland DHC-8-315 · S/N 374Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Dynamic Aviation Group IncN1900RBeech 1900D · S/N UE-187Cancelled Dec 7, 2017 · Built 1995 · Dynamic Avlease IncN308VDehavilland DHC-8-315 · S/N 397Cancelled Jun 22, 2017 · Dynamic Aviation Holding LLCN1900SRaytheon 1900D · S/N UE-239Cancelled Nov 2, 2016 · Built 1996 · Dynamic Avlease IncN199DRaytheon 1900D · S/N UE252Cancelled Aug 11, 2016 · Exported to Canada · Built 1996 · Dynamic Avlease IncN8300LDehavilland DHC-8-315 · S/N 352Cancelled Jan 5, 2016 · Built 1993 · Dynamic Avlease IncN1900FBeech 1900D · S/N UE-147Cancelled Dec 22, 2015 · Exported to Canada · Built 1995 · Dynamic Avlease IncN79ZBeech 65-A90-1 · S/N LM-22Cancelled Dec 22, 2015 · Second renewal notice · Built 1967 · Dynamic Avlease IncN8300FDehavilland DHC-8-315 · S/N 338Cancelled Nov 20, 2015 · Built 1992 · Dynamic Avlease IncN8300YDehavilland DHC-8-311 · S/N 332Cancelled Nov 20, 2015 · Dynamic Avlease IncN41RBeech A200 · S/N BC-31Cancelled Oct 20, 2015 · Second renewal notice · Dynamic Aviation Group IncN7043GBeech 65-A90-1 · S/N LM-37Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1967 · Dynamic Avlease IncN1340LBeech B200 · S/N BB-1340Cancelled Jun 25, 2014 · First renewal notice · Dynamic Aviation Group IncN7071HBeech 65-A90-1 · S/N LM-58Cancelled May 6, 2014 · Third renewal notice · Dynamic Aviation Group IncN14CPBeech C90 · S/N LJ-585Cancelled Apr 1, 2014 · Second renewal notice · Built 1973 · Dynamic Avlease IncN448CPBeech E-90 · S/N LW-232Cancelled Apr 1, 2014 · Second renewal notice · Built 1977 · Dynamic Avlease IncN71597Beech 65-A90-1 · S/N LM-118Cancelled Apr 1, 2014 · Second renewal notice · Dynamic Aviation Group IncN39UBeech E-90 · S/N LW-109Cancelled Mar 25, 2014 · Built 1974 · Dynamic Aviation Group IncN70879Beech 65-A90-1 · S/N LM-76Cancelled Mar 25, 2014 · Second renewal notice · Dynamic Aviation Group IncN71581Beech 65-A90-1 · S/N LM-116Cancelled Mar 25, 2014 · Second renewal notice · Dynamic Aviation Group IncN7165JBeech 65-A90-1 · S/N LM-119Cancelled Mar 25, 2014 · Second renewal notice · Dynamic Aviation Group IncN7201ZBeech 65-A90-1 · S/N LM-100Cancelled Mar 25, 2014 · Second renewal notice · Dynamic Aviation Group IncN6653Beech 3NMT · S/N CA-145Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1952 · K And K Aircraft IncN7644RBeech B90 · S/N LJ-335Cancelled Aug 21, 2013 · First renewal notice · Built 1968 · Dynamic Avlease IncN7198SBeech 65-A90-4 · S/N LU-01Cancelled Jul 15, 2013 · First renewal notice · Dynamic Avlease IncN638DBeech B90 · S/N LJ-424Cancelled May 10, 2013 · First renewal notice · Built 1968 · Dynamic Aviation Group IncN6641YPiper PA-23-250 · S/N 27-3955Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1968N6898Beech E18S · S/N BA-243Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1967N1149WBeech A200 · S/N BC-72Cancelled Feb 7, 2013 · First renewal notice · Built 1977 · Dynamic Aviation Group IncN1290ABeech 65-90 · S/N LJ-30Cancelled Feb 7, 2013 · First renewal notice · Built 1965 · Dynamic Aviation Group IncN654CBeech 65-90 · S/N LJ-12Cancelled Feb 7, 2013 · First renewal notice · Built 1964 · Dynamic Aviation Group Inc
Back to Bridgewater, VA