OpenAirDocs.org
Bethesda, MD

Cancelled registrations · 58

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 = 'MD' AND d.registrant_city = 'BETHESDA'
  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.

N930PHSikorsky S-92A · S/N 920160Cancelled Dec 7, 2021 · Exported to Canada · Built 2011 · Capital One NaN736LEHawker Siddeley DH.125-400A · S/N NA736Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1969 · Lady Edith Hawker Flight Co LLCN235PCPiper J3C-65 · S/N 3179Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Airspeed Aircraft LLCN540WFFoster John GLASAIR III · S/N 001Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2008 · Foster John WN9182RAerostar International RAVEN S57-A · S/N S57A-3156Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1994 · Re/Max Of Pennsylvania Ad Fund IncN52126Cessna 172P · S/N 17274420Cancelled Feb 23, 2017 · Built 1980 · T S S Flying Club IncN744MKKimball Michael J MURPHY SR2500 · S/N 044SRCancelled May 13, 2015 · Registration expired, pending cancellation · Kimball Michael JN353RHVS MI-8-MTV-1 · S/N 95747Cancelled Sep 15, 2014 · Third renewal notice · R J Harroff Business Associates LLCN5874GCessna 150K · S/N 15071374Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1969N2236SCessna T210L · S/N 21061181Cancelled Jul 18, 2013 · Exported to Mexico · Built 1976 · Drs Cengen LLCN737JACessna TR182 · S/N R18200834Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1978 · Horn Joel SN82DJCessna 172M · S/N 17265575Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1975N7836CMooney M20A · S/N 1204Cancelled Oct 22, 2012 · Sale reported, pending cancellation · Built 1961N800RTGrumman American Avn. G-1159 · S/N 047Cancelled Sep 18, 2012 · Built 1969 · Robert E Torray And Co IncN20JFPiper PA-30 · S/N 30-133Cancelled Jun 7, 2011 · Sale reported, pending cancellation · Built 1963N20977Piper PA-28-161 · S/N 28-7916022Cancelled Apr 11, 2011 · Registration expired · Built 1978 · Mountain Air Aviation IncN160CDCirrus Design SR20 · S/N 1064Cancelled Nov 25, 2009 · Exported to Brazil · Built 2000 · Vongkovit PiyapongN80652Mil MI-17 · S/N 108M10Cancelled Apr 6, 2009 · Triennial form not returned · R J Harroff Business Associates LLCN52173Mil MI-8 · S/N 95840Cancelled Jan 15, 2009 · Triennial form not returned · Built 1992 · R J Harroff Business Associates LLCN70308Kazan Helicopters MI-17-V5 · S/N 004C165Cancelled Jan 15, 2009 · Rj Harroff Business Associates LLCN7038SKazan Helicopters MI-17-V5 · S/N 004M164Cancelled Jan 15, 2009 · Rj Harroff Business Associates LLCN393RHVS MI-8-MTV-1 · S/N 95716Cancelled Aug 15, 2008 · Triennial form not returned · R J Harroff Business Associates LLCN8065RMil MI-17 · S/N 108M06Cancelled Aug 15, 2008 · Triennial form not returned · R J Harroff Business Associates LLCN872CABeech B200 · S/N BB-1114Cancelled Oct 12, 2007 · Built 1983 · Capital AeroleaseN8992MBeech S35 · S/N D-7315Cancelled Jun 21, 2000 · Triennial form not returned · Jacoby ItzhakN1775BBeech F33A · S/N CE546Cancelled Apr 3, 1996 · Brown Ben JarrattN62JWGlaser-Dirks DG-400 · S/N 4112Cancelled May 28, 1993 · Exported to France · Spriet IncN3357XMooney M20E · S/N 1080Cancelled Aug 21, 1992 · Mueller Stephen PN5024EAero Commander 500 S · S/N 1797-12Cancelled Aug 1, 1984 · Exported to Australia · Brundred & Snider Associates IncN4888UCessna 172F · S/N 17253022Cancelled May 11, 1984 · Sale reported · Built 1965N22CCRockwell International 500-S · S/N 1798-13Cancelled Apr 5, 1979 · Exported to Australia · Built 1968 · Brundred & Snider Associates IncN5031EAero Commander 500 S · S/N 1856-38Cancelled Mar 11, 1979 · Exported to Australia · Brundred & Snider Associates IncN81891Aero Commander 500 S · S/N 3315Cancelled Aug 24, 1978 · Exported to Australia · Brundred & Snider Associates IncN5151MAero Commander 680FL · S/N 1518-99Cancelled Aug 23, 1978 · Exported to Australia · Brundred & Snider Associates IncN45JWAero Commander 685 · S/N 12015Cancelled Jul 3, 1978 · Exported to Australia · Built 1972 · Brundred & Snider Associates IncN2488BBell 47G-2 · S/N 1467Cancelled Feb 9, 1977 · Exported to French Polynesia · Moulene Jean LN57162Rockwell International 500-S · S/N 3251Cancelled Jul 18, 1975 · Exported to Australia · Brundred & Snider Associates IncN9036NAero Commander 500 S · S/N 1875-48Cancelled Apr 17, 1975 · Exported to Australia · Brundred & Snider Associates IncN6621VAero Commander 500-U · S/N 1639-3Cancelled Sep 25, 1974 · Exported to Australia · Brundred & Snider Associates IncN5980YPiper PA-23-250 (6PCLM) · S/N 27-3153Cancelled Aug 8, 1974 · Johnson Leland EN9026NAero Commander 500 S · S/N 3053Cancelled Jul 10, 1974 · Exported to Australia · Brundred & Snider Associates IncN83010Aeronca 7AC · S/N 7AC-1664Cancelled Apr 18, 1974 · Anders Robert VN471SCAero Commander 690 · S/N 11044Cancelled Oct 30, 1973 · Exported to Australia · Brundred & Snider Associates IncN9236NAero Commander 500 S · S/N 3157Cancelled Sep 4, 1973 · Exported to Australia · Brundred & Snider Asscoiates IncN5036EAero Commander 500 S · S/N 3152Cancelled Jun 14, 1973 · Exported to Australia · Built 1973 · Brundred And Snider AssociatesN9147NAero Commander 690 · S/N 11062Cancelled Apr 5, 1973 · Exported to Australia · Brundred & Snider AssociatesN5298LPiper PA-28-180 · S/N 28-4600Cancelled Oct 4, 1971 · Fieni ErnestN9095NAero Commander 500 S · S/N 3074Cancelled Aug 26, 1970 · Exported to Australia · Brundred & Snider Assoc IncN9083NAero Commander 500 S · S/N 3069Cancelled Jul 27, 1970 · Exported to Australia · Brundred & Snider Assoc IncN361KAero Commander 680FL · S/N 1490-94Cancelled Feb 5, 1970 · Exported to Australia · Brundred & Snider Associates Inc
Back to Bethesda, MD