OpenAirDocs.org
Springfield, VA

Cancelled registrations · 29

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

N1210YAkrotech GILES G-200 · S/N G2001012Cancelled Jan 12, 2026 · Exported to Canada · Built 1997 · Taylor David CN99VYM-Squared BREESE 2 · S/N 03-2019-0809Cancelled Feb 5, 2025 · Built 2019 · Flying Club 1 IncN23846Taylorcraft BC-65 · S/N 1482Cancelled Mar 19, 2019 · Revoked, canceled · Built 1939 · Roger Robin D WN2638JCessna 150G · S/N 15065638Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1966 · Smith Robert HN78964Mooney M20C · S/N 1998Cancelled Apr 19, 2018 · First renewal notice · Built 1962 · Bickert Marshal AN62RRRomeo Ross T CRUISER CLASS I · S/N NX230946939Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Romeo Ross TN40SEDiamond Aircraft Ind DA20-C1 · S/N C0222Cancelled May 2, 2017 · Exported to Canada · Built 2003 · Mcmasters James IN9293VRans RANS S12 · S/N 1093442Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1996 · Lewark Lynn EN7179JHinds Tom RX-550 · S/N BRX-0116Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1990 · Carlson JerryN9806WPiper PA-28-140 · S/N 28-23305Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1967 · Edwards Charles WN2902UCessna 172D · S/N 17250502Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1963 · Childress Ruey JN240BWWelch Bryant E KITFOX 1 · S/N 240Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Welch Bryant EN9302NPiper PA-28R-200 · S/N 28R-35002Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1969 · Hepp Robert JN1541GBalloon Works FIREFLY 7 · S/N 10223Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1980 · Ntw IncN6606UMooney M20D · S/N 101Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1963N1057MRabung Clifford L ANDERSON-KINGFISHER · S/N 122Cancelled May 18, 2012 · Registration expired, pending cancellation · Rabung Clifford LN818BWCessna 310R · S/N 310R1223Cancelled May 8, 2012 · Exported to Thailand · Souvannavong Sonny BN4927PPiper PA-23-235 · S/N 27-512Cancelled Feb 9, 2006 · Second triennial mailing, no response · Built 1962 · Thompson Cory AN1RXCrowell Sam R SH-2R · S/N 222Cancelled Nov 22, 2002 · Second triennial mailing, no response · Built 1989 · Harrison Realty Dvlpmnt Corp TrusteeN5016TPiper PA-34-200 · S/N 34-7250199Cancelled Jun 19, 2000 · Triennial form not returned · Hofmann Frederick LN52773Cessna 182P · S/N 18262836Cancelled Jul 27, 1999 · Triennial form not returned · Mullady Brian PN8057RRobinson Helicopter R22 BETA · S/N 1222Cancelled Mar 3, 1995 · Exported to South Africa · Helicorp IncN3320XCarver HP-14 B · S/N 1Cancelled May 6, 1983 · Clarken William F & Niswonger Gregory AllenN511PSLockheed 188C · S/N 1071Cancelled Nov 10, 1982 · Exported to Argentina · W K B Aviation IncN66WCBeech 65-90 · S/N LJ-54Cancelled Mar 31, 1982 · Exported to France · Aircraft Sales CoN78848Aircraft Manufacturing TEXAS BULLET 205 · S/N 102Cancelled Oct 4, 1976 · White Grayden GN6664VBellanca 17-30 · S/N 30023Cancelled Apr 8, 1976 · Exported to Canada · Clarken William FN8203DBeech H35 · S/N D5315Cancelled Nov 13, 1967 · Slavin AlanN89160Cessna 140 · S/N 8172Cancelled Oct 24, 1955 · Springfield Airport Inc
Back to Springfield, VA