OpenAirDocs.org
Fredericksburg, VA

Cancelled registrations · 48

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

N8109EEichhorn Gary L SKYRAIDER I · S/N 105Cancelled Nov 24, 2023 · Built 2005 · Weaver Quenton EN262DFGreen L/Gilner D RV-4 · S/N 1969Cancelled Jun 10, 2023 · Built 1996 · Clinthorne David WN64003Cessna 172M · S/N 17264951Cancelled Jul 31, 2021 · First renewal notice · Built 1975 · Jls Aviation LLC DBAN1130WNanchang China CJ-6A · S/N 2951228Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1973 · Shelley MarkN409KRFugunt Ronald Edward SONEX · S/N 1308Cancelled Mar 10, 2020 · Exported to Canada · Built 2011 · Perkins Lloyd EN628WVDJI INSPIRE 1 · S/N W18DCH14030557Cancelled Feb 7, 2020 · Sale reported, canceledN7100JMorris Thomas E BABY BEAR · S/N M101Cancelled Nov 29, 2019 · Registration pending, canceled · Built 1990N88160Piper J3C-65 · S/N 15777Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Plum James WN636MPHuff Scott R DREAM MACHINE · S/N 4946Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Built 2000 · Huff Scott RN2077LBeech C23 · S/N M-2085Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1978 · Stiles Ronald Lee JrN15BSSchmutzhart SCH-1 · S/N 1Cancelled Oct 23, 2017 · First renewal notice · Built 1977 · Schmutzhart Berthold JN7521MCessna 175 · S/N 55821Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Smith William KenrodN729ZAFairchild Dornier DORNIER 328-300 · S/N 3181Cancelled Jan 11, 2017 · Exported to Germany · Zenith Aviation IncN277CMPiper PA-23-250 · S/N 27-7405476Cancelled Apr 28, 2015 · Exported to Canada · Built 1974 · B & J Air IncN9362ECessna 172N · S/N 17272238Cancelled Sep 3, 2014 · Registration pending, canceledN46225Kosi Richard SONEX · S/N 0659Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 2005 · Haas Bruce EN4484DEaby Jeffrey L MONERAI-MAX · S/N 313Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Eaby Jeffrey LN95568Taylorcraft BC12-D · S/N 7868Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Sisson Perry RN83214Champion 7AC · S/N 7AC-1875Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1946N1954BLuscombe 8A · S/N 6381Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1948 · Perkins Lloyd E JrN1174SSchweizer SGS 2-33A · S/N 225Cancelled Sep 1, 2010 · Exported to Canada · Built 1971 · Schmutzhart Berthold JN74JSCessna 140 · S/N 12411Cancelled Feb 17, 2009 · Exported to Canada · Built 1947 · Covey Edmond SN46700Buckeye BREEZE · S/N 001Cancelled Dec 9, 2008 · Triennial form not returned · Potter Richard LN400WXLancair LC41-550FG · S/N 41517Cancelled Nov 14, 2008 · Triennial form not returned · Built 2005 · Homeowners Title LLCN2975XCessna 177 · S/N 17700375Cancelled Nov 30, 2007 · Triennial form not returned · Built 1967 · Cardinal Four LtdN640FFlynn William PAZMANY PL-4 · S/N 433Cancelled Jun 25, 2007 · Triennial form not returned · Built 1982 · Strother William MN60921Cessna 150J · S/N 15070670Cancelled Mar 15, 2007 · Exported to Canada · Built 1969 · Reames Warren PN2069BMCK MCK1 · S/N 1001Cancelled Nov 30, 2005 · Triennial form not returned · Mck Co IncN67473Cessna 152 · S/N 15281852Cancelled Nov 17, 2005 · Triennial form not returned · Built 1978 · Aire Shannon IncN19EJJones Edwin PITTS S1S · S/N 1944Cancelled Sep 27, 2004 · Triennial form not returned · Built 2000 · Jones Edwin WN811BSShackelford Leo F SPEZIO ONE-HOLER · S/N 1935Cancelled Feb 12, 2003 · Shackelford Leo FN2351ZBeech 23 · S/N M-66Cancelled Oct 11, 2002 · Built 1962 · Butler BenjaminN81QVBritish Aerospace HS 125-700A · S/N NA0245Cancelled Nov 28, 2000 · Exported to Cayman Islands · Stanford & Associates IncN4241ZJackman Don PITTS S-1S · S/N 70455Cancelled Apr 21, 1998 · Jones Edwin WN7224JPiper PA-28-140 · S/N 2824560Cancelled Dec 9, 1997 · Exported to United Kingdom · M And Ms Et IncN5463PPiper PA-24 · S/N 24520Cancelled Aug 19, 1995 · Triennial form not returned · Seats Frank RN192Glover SCORPIN II · S/N 1185Cancelled Mar 15, 1994 · Triennial form not returned · Fleming Marilyn VN14MFBeech 200 · S/N BB838Cancelled Mar 4, 1992 · Exported to South Africa · Dominion Investment Group IncN7453KPiper PA-20 · S/N 20-364Cancelled Feb 2, 1983 · Marshall Warren C IIN1824JPiper PA-28-140 · S/N 28-24255Cancelled Oct 28, 1968 · Shannon Sidney L Jr DBA Air ShannonN7673HPiper PA-12 · S/N 12-553Cancelled Jun 5, 1965 · Built 1946 · Shannon School Fo Aeronautics IncN4305HPiper PA-15 · S/N 15-88Cancelled May 20, 1965 · Shannon School Of Areonautics IncN55965Consolidated Vultee BT-13A · S/N 5961Cancelled May 20, 1965 · John Richard NorrisN7443BChampion 7EC · S/N 7EC-492Cancelled May 18, 1959 · Exported to Canada · Shannon School Of Aronautics IncN46106Taylorcraft L-2M · S/N L 3124Cancelled Nov 17, 1955 · Shannon School Of Aeronautics IncN55498Consolidated Vultee BT-13B (SNV-2) · S/N 79-1306Cancelled May 19, 1955 · John R NorrisN74117Piper L-4J · S/N 12625Cancelled Mar 28, 1949 · Col Melvin C SmithN51734Cessna T-50 · S/N 5281Cancelled Feb 11, 1949 · Safeway Flying Inc
Back to Fredericksburg, VA