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.

N90NMBeech B90 · S/N LJ-404Cancelled Feb 7, 2013 · First renewal notice · Built 1968 · Dynamic Aviation Group IncN93RYBeech 65-A90 · S/N LJ-174Cancelled Feb 7, 2013 · First renewal notice · Built 1966 · Dynamic Aviation Group IncN28CBeech A100 · S/N B-216Cancelled Feb 6, 2013 · First renewal notice · Dynamic Aviation Group IncN45ABeech A200 · S/N BC48Cancelled Dec 7, 2012 · First renewal notice · Dynamic Aviation Group IncN5137XChampion 7KCAB · S/N 182Cancelled Sep 20, 2012 · Revoked, canceled · Built 1969 · Mann Benjamin FN4730PPiper PA-23-250 · S/N 27-260Cancelled Aug 23, 2012 · Sale reported, pending cancellation · Built 1960N90RGBeech C90 · S/N LJ-546Cancelled Jul 31, 2012 · First renewal notice · Built 1971 · Dynamic Aviation Group IncN882JMDouglas DC-9-32 · S/N 47292Cancelled Jul 25, 2012 · Dynamic Jetlease LLCN883JMDouglas DC-9-32 · S/N 47611Cancelled Jul 25, 2012 · Dynamic Jetlease LLCN889JMDouglas DC-9-32 · S/N 47293Cancelled Jul 25, 2012 · Dynamic Jetlease LLCN894JMDouglas DC-9-32 · S/N 47554Cancelled Jul 25, 2012 · Dynamic Jetlease LLCN49KBeech A200 · S/N BD26Cancelled May 8, 2012 · First renewal notice · Dynamic Aviation Group IncN13KBeech A100 · S/N B-101Cancelled Nov 17, 2011 · Second renewal notice · Built 1971 · Dynamic Avlease IncN525JKBeech 65-A90 · S/N LJ-305Cancelled Nov 15, 2011 · First renewal notice · Built 1967 · Dynamic Aviation Group IncN168LBeech C-45H · S/N AF-340Cancelled Oct 17, 2011 · Triennial form not returned · Built 1951 · K And K Aircraft IncN850BCBeech C-45H · S/N 51-11844ACancelled Aug 30, 2011 · First renewal notice · Built 1951 · Dynamic Aviation Group IncN6461YPiper PA-23-250 · S/N 27-3755Cancelled Aug 11, 2011 · Sale reported · Built 1967N76LSSchweizer G-164B · S/N 783BCancelled Aug 9, 2011 · Triennial form not returned · K & K Aircraft IncN22782Cessna 150H · S/N 15068511Cancelled Aug 5, 2011 · Triennial form not returned · Built 1968 · Rockingham Aviation CorpN48XPBeech 65-90 · S/N LJ-109Cancelled Aug 4, 2011 · Triennial form not returned · Built 1966 · K And K Aircraft IncN711DNBeech E18S · S/N BA-43Cancelled Aug 4, 2011 · Triennial form not returned · Built 1955 · K And K Aircraft IncN81GABeech E18S · S/N BA199Cancelled Aug 4, 2011 · Triennial form not returned · Built 1974 · K & K Aircraft IncN4164RCessna 411 · S/N 4110164Cancelled Aug 3, 2011 · Sale reported · Built 1966N8154GShort Bros SD3-30 200 · S/N SH-3010Cancelled Aug 3, 2011 · Triennial form not returned · K And K Aircraft IncN3221QGrumman G-164A · S/N 1184Cancelled Jul 14, 2011 · Dynamic Aviation Group IncN249KBeech E18S · S/N BA-233Cancelled May 27, 2011 · Second renewal notice · Built 1958 · K & K Aircraft IncN8365KGrumman Acft ENG Cor-Schweizer G-164B · S/N 664BCancelled Dec 27, 2010 · First renewal notice · Built 1981 · K & K Aircraft IncN63DGrumman Acft ENG Cor-Schweizer G-164B · S/N 301BCancelled Sep 25, 2008 · Built 1977 · Dynamic Aviation Group IncN299MSBeech B90 · S/N LJ-457Cancelled Sep 3, 2008 · Built 1969 · Dynamic Aviation Group IncN342TBeech E18S · S/N BA-366Cancelled Sep 27, 2004 · Triennial form not returned · Built 1958 · K And K Aircraft IncN9TWBeech B90 · S/N LJ379Cancelled Jun 15, 2001 · Triennial form not returned · Dynamic Aviation Group IncN49KBeech G18S · S/N BA519Cancelled Jun 5, 1995 · K And K Aircraft IncN7002Beech CONRAD 9800D · S/N A804Cancelled Sep 9, 1993 · Triennial form not returned · K & K Aircraft IncN1FNDouglas DC3-G202A · S/N 11685Cancelled Mar 23, 1992 · Triennial form not returned · K&K Aircraft IncN87912Lockheed T-33A · S/N 554399Cancelled Feb 24, 1991 · Triennial form not returned · K And K Aircraft IncN87572Dehavilland BEAVER U-6A · S/N 842Cancelled Jan 28, 1981 · Exported to Canada · AvotekN5330GDehavilland DHC-2 MK 1 · S/N 1255Cancelled Dec 19, 1980 · Exported to Canada · K & K Aircraft IncN15077Driggs DART II · S/N 6BCancelled Jun 17, 1938 · Miller Horace G
Back to Bridgewater, VA