OpenAirDocs.org
Richmond, VA

Cancelled registrations · 231

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

N19XXSchleicher ASW-19 · S/N 19066Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1976 · Bearden John MN2853EAeronca 7AC · S/N 7AC-6436Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1946 · Johnson Hal SN568ABIai GULFSTREAM G150 · S/N 294Cancelled Dec 4, 2020 · Exported to Canada · Built 2011 · Cca Holdings LLCN804LFDJI INSPIRE 1 · S/N WZ1ACL04020771Cancelled Jun 19, 2020 · Sale reported, canceledN82784Aeronca 7AC · S/N 7AC-1431Cancelled Apr 3, 2020 · Revoked, canceled · Built 1946 · Sky Svc CorpN513TVDJI PHANTOM 3 PROFESSION · S/N P76DCF12013758Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Lin Television Corp DBAN1966EAeronca 7AC · S/N 7AC5533Cancelled Oct 18, 2019 · Revoked, canceled · Built 1946 · Sky Svc CorpN110VADJI S1000+ · S/N 02Q0022518Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Visual Advantage IncN115VADJI S1000+ · S/N 02Q0020644Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Visual Advantage IncN145VADJI S1000+ · S/N 03P0012490Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Visual Advantage IncN582CECutting Edge Airsports BUCKEYE 582 DM · S/N 1 635 4Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2003 · Read Thomas BN808TVDJI INSPIRE 1 · S/N W130C105040974Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lin Television Corp DBAN1817PPiper PA-22-150 · S/N 22-2596Cancelled Aug 12, 2019 · Revoked, canceled · Built 1955 · Coufal JosephN74089Livingston Eugene Wite COUGHER · S/N 5Cancelled Aug 5, 2019 · Revoked, canceled · Built 1962 · Mullan John FrancisN410TVDJI INSPIRE 1 · S/N W13DC105040077Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Lin Television Corp DBAN234VBDJI INSPIRE 1 · S/N W13DCJ13040963Cancelled Jul 16, 2019 · Registration expired, pending cancellation · Lin Television Corp DBAN31VABell 407 · S/N 53465Cancelled Jul 12, 2019 · Third renewal notice · Built 2000 · Commonwealth Of VirginiaN444KNDJI INSPIRE 1 · S/N W13DCI05040079Cancelled May 6, 2019 · Registration expired, pending cancellation · Young Broadcasting Of San Francisco DBAN633MXDJI INSPIRE 1 · S/N W130CE26041935Cancelled May 6, 2019 · Registration expired, pending cancellation · Young Broadcasting Of Richmond DBAN308TVDJI INSPIRE 1 · S/N W13DC105040067Cancelled May 4, 2019 · Registration expired, pending cancellation · Media General Operations Inc DBAN5794PPiper PA-24-250 · S/N 24-874Cancelled Mar 12, 2019 · Sale reported, canceled · Built 1959N43364Madsen Ronald F RANS S-12 · S/N 1191148Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1992 · Madsen Ronald FN632HBuckeye BUCKEYE BREEZE · S/N 16432Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Hughes David WN757PGCessna 152 · S/N 15279891Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1977 · Berlekamp Leland HN67200Cessna 152 · S/N 15281719Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1978 · Berlekamp Leland HN25952Cessna 152 · S/N 15280878Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1977 · Air Chesterfield IncN6912UMooney M20D · S/N 244Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1964 · Draucker Albert DN74471Bellanca 14-13-2 · S/N 1584Cancelled Nov 21, 2017 · Revoked, canceled · Built 1948 · Foss Rudolph GN8767KStinson 108-1 · S/N 1081767Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Gregory Charles A JrN99850Engineering & Research ERCOUPE 415-C · S/N 2473Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Canady J HN1719EAeronca 7AC · S/N 7AC5284Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Sky Svc CorpN27823Piper J4A · S/N 41040Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Currie John AN3521SPiper PA-31-350 · S/N 31-7952107Cancelled Jun 20, 2017 · Exported to Canada · Built 1979 · Aero Industries IncorporatedN9267BCessna 175 · S/N 55067Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1958 · Sternheimer Mark A JrN55546Piper PA-28R-200 · S/N 28R-7335251Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1973 · Capitol Aircraft IncN804RSSolana Richard P VANS RV-6A · S/N 22227Cancelled Oct 7, 2016 · Built 1999 · Solana Richard PN36022Semco Balloon CHALLENGER · S/N SEM167Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Kirk Daniel TN67469Cessna 152 · S/N 15281851Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1978 · Air Chesterfield IncN57996Kaman HH-43F · S/N 75Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1960 · Shield Frances RN49014Cessna 152 · S/N 15283402Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1979 · Air Chesterfield IncN6895SAero Commander 560-E · S/N 570Cancelled Nov 12, 2013 · Revoked, canceled · Built 1957 · C W Enterprises IncN500FHHarlow Fred R 3/4 FOKKER D VIII · S/N 1Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1994 · Harlow Fred RN3620PPiper PA-22-150 · S/N 22-3353Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1955 · Weaver Gerald PN88703Boeing 727-224 · S/N 19512Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1968 · Nationsbank Tennessee Na TrusteeN7323AEagle Balloons AX7 · S/N E85776Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1985 · Moses William MN88709Boeing 727-224 · S/N 19800Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1968 · Nationsbank Tennessee Na TrusteeN3139XBaran Robert W HUMMER · S/N 0231-ACancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1982 · Grigg William F IIIN74CMMatthews Thurman Linwood J3 KITTEN · S/N J3001KCancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1991 · Matthews Thurman LN952VBeech C23 · S/N M-1721Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1975 · Basl Louis AN88701Boeing 727-224 · S/N 19510Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1968 · Nationsbank Tennessee Na Trustee
Back to Richmond, VA