OpenAirDocs.org
Petersburg, VA

Cancelled registrations · 40

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

N80583Cessna 172M · S/N 17266659Cancelled Apr 3, 2024 · Exported to Canada · Central Virginia Aviation IncN191WBBeech C90A · S/N LJ-1295Cancelled May 26, 2023 · Exported to Norway · Built 1991 · Central Virginia Aviation IncN470TCBeech 200 · S/N BB424Cancelled May 23, 2023 · Built 1978 · Central Virginia Aviation IncN600CXBeech E-90 · S/N LW-43Cancelled Dec 29, 2022 · Exported to Mexico · Built 1973 · Central Virginia Aviation IncN5YBeech 65-A90 · S/N LJ-272Cancelled Nov 19, 2022 · Central Virginia Aviation IncN577DCBeech 65-A90 · S/N LJ308Cancelled Jan 24, 2022 · Exported to Mexico · Built 1968 · Central Virginia Aviation IncN70AJBeech 200 · S/N BB206Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Central Virginia Aviation IncN1549Beech A200 · S/N BC-45Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 1977 · Central Virginia Aviation IncN90MVBeech C90 · S/N LJ-701Cancelled Jan 2, 2020 · Exported to Mexico · Built 1976 · Central Virginia Aviation IncN711VMBeech 200 · S/N BB544Cancelled Dec 3, 2019 · Exported to Mexico · Built 1979 · Central Virginia Aviation IncN17HMBeech 200 · S/N BB-94Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1975 · Central Virginia Aviation IncN400UBeech 200 · S/N BB-247Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1977 · Central Virginia Aviation IncN88RPBeech B90 · S/N LJ-491Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1970 · Aero Transportation IncN724EABritish Aerospace HS 125-700A · S/N NA 0264Cancelled Feb 21, 2019 · Registration expired, pending cancellation · Built 1980 · Central Virginia Aviation IncN912SQBeech 200 · S/N BB478Cancelled May 2, 2018 · Exported to Mexico · Built 1979 · Central Virginia Aviation IncN8139QCessna 414 · S/N 414-0039Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1970 · Central Virginia Aviation IncN94850Ercoupe E · S/N 4965Cancelled Jun 15, 2015 · Exported to Brazil · Built 1948 · Central Virginia Aviation IncN47AALight Aero AVID AMPHIBIAN AF2 · S/N 001Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1985N79422Cessna 182P · S/N 18261817Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1973N2372LBeech 23 · S/N M-214Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1963 · Gill Ernest RN6910QBeech A23-19 · S/N MB-282Cancelled Mar 16, 2012 · Exported to Canada · Built 1967 · Reynolds Stuart NN6891YPiper PA-23-250 · S/N 27-4244Cancelled Feb 7, 2012 · Exported to Guatemala · Built 1969 · Central Virginia Aviation IncN404ABEurocopter/Canada BO 105LS A-3 · S/N 2041Cancelled Sep 15, 2011 · Exported to Australia · Built 1993 · Central Virginia Aviation IncN77ZMPiper PA-31-325 · S/N 31-7512066Cancelled Jun 29, 2010 · Exported to Canada · Built 1975 · Mazza John V JrN8418FCessna 401 · S/N 401-0266Cancelled Oct 28, 2008 · Exported to Spain · Built 1968 · Central Virginia Aviation IncN83FMBeech B90 · S/N LJ-341Cancelled Jul 24, 2007 · Exported to Venezuela · Built 1968 · Central Virginia Aviation IncN867PCPiper PA-31-350 · S/N 31-7952229Cancelled Aug 23, 2006 · Exported to Colombia · Built 1979 · Airshares IncN6171QNorth American SNJ-4 · S/N 88-13509Cancelled Feb 3, 2005 · Exported to South Africa · Central Virginia Aviation IncN714VQCessna 152 · S/N 15279470Cancelled Aug 27, 2002 · Exported to Portugal · Built 1977 · Central Virginia Aviation IncN93370Cessna 152 · S/N 15285474Cancelled Apr 29, 2002 · Exported to Portugal · Built 1981 · Central Virginia Aviation IncN5159LCessna 152 · S/N 15284274Cancelled Apr 25, 2002 · Exported to Portugal · Built 1980 · Central Virginia Aviation IncN8203BBond Daniel E RANS S10 · S/N 1088035Cancelled Apr 10, 1998 · Exported to Costa Rica · Bond Daniel FN13FJJordan BOWERS FLY BABY · S/N 6544Cancelled Aug 14, 1996 · Triennial form not returned · Jordan Fred A JrN4109XDonavon Michael T TEAM MINI-MAX · S/N 454Cancelled Jan 9, 1996 · Sale reportedN5793GCessna 150K · S/N 15071293Cancelled Sep 21, 1976 · C W Moore DBA Wekonda Flight ServicesN1707Roper B-8M · S/N 1Cancelled Jun 26, 1970 · Roper Leroy BN9221ACessna 170A · S/N 18982Cancelled Feb 15, 1957 · Floyd Louis CN60910Fairchild M-62C(PT-23A) · S/N H0 395Cancelled Feb 15, 1956 · Ware Richard SN7159HPiper J3C-65 · S/N 20417Cancelled Jun 10, 1954 · Paul L EarlyN320MCessna CG-2 · S/N 16Cancelled Mar 8, 1933 · Built 1930 · Goodier H W
Back to Petersburg, VA