OpenAirDocs.org
Rockville, MD

Cancelled registrations · 59

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

N166HSDJI MATRICE 600 · S/N M64DDH08010088Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Hover Solutions LLCN68218Cessna 152 · S/N 15282192Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1978 · Safe Pilots IncN163HSDJI PHANTOM 3 PROFESSION · S/N P78DCH25031592Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Hover Solutions LLCN161HSDJI INSPIRE 1 · S/N W13DCG10040198Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Hover Solutions LLCN89711Cessna 140 · S/N 8760Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Johnston Walter DN412RSSpatz Richard C ROTORWAY EXEC 162F · S/N 7054Cancelled Jul 25, 2017 · Exported to Canada · Built 2009 · Spatz Richard CN61509Preceptor N-3 PUP · S/N 002Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1996 · Grim Kyle DN3218EAms-Flight D O O APIS · S/N A013Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 2004 · Blanchi Christophe GN165HSDJI INSPIRE 1 PRO · S/N WZ1ACL25020139Cancelled Jan 19, 2017 · Hover Solutions LLCN3UKRolladen-Schneider LS-4 · S/N 4212Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1981 · Sampson SteveN155FEaa Biplane PF · S/N 1Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1964 · Kutyna Francis AN4004HMooney M20J · S/N 25-0403Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1980 · Rodgers Joseph CN6361HRaven Industries RALLY RX7 · S/N RX7-3242Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1991 · Sky Sports IncN3584DAerostar International RAVEN S57-A · S/N S57A-3093Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Re Max Regional Services Ad Fund IncN996CStinson 108-3 · S/N 108-3996Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1947 · Light George AN7602WPiper PA-28-180 · S/N 28-1561Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1964 · Translation Systems IncN6079RPiper AEROSTAR 601P · S/N 61P07358063359Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1979 · G&J Leasing CoN6287SCessna 150G · S/N 15067087Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1967N4445RCessna R182 · S/N R18200600Cancelled Nov 30, 2012 · Registration expired, pending cancellation · Built 1978 · N4445r IncN4561JPiper PA-28R-180 · S/N 28R-30421Cancelled Jul 24, 2012 · Revoked, canceled · Built 1968 · Weikel Gerald EN5135RCessna 172M · S/N 17263352Cancelled Apr 6, 2012 · Exported to Canada · Built 1974N3901UCessna 150E · S/N 15061301Cancelled Aug 10, 2011 · Revoked, canceled · Built 1965 · Aviation Education IncN787WHBoeing 737-2V6 · S/N 22431Cancelled Jun 16, 2011 · Exported to Cayman Islands · Built 1981 · Blair Investors CorpN678LWBell 206B · S/N 3171Cancelled Aug 27, 2008 · Triennial form not returned · Built 1980 · Apm USA IncN3521NSeair FLYING INFLATABLE BO · S/N 001Cancelled May 8, 2008 · Hannickel Joseph DN91000Cessna T210M · S/N 21062944Cancelled Nov 14, 2005 · Exported to Mexico · Built 1978 · Eschenberg Hors H HN6521AAerostar International RAVEN S57-A · S/N S57A-3001Cancelled Feb 4, 2000 · Triennial form not returned · Cbs IncN383SMMilburn Samuel A SAM 41854 · S/N 8383Cancelled Jun 10, 1998 · Triennial form not returned · Littleton David AN981Bell UH-1F · S/N 657936Cancelled Jul 25, 1995 · Administratively canceled · Department Of CommerceN7168Beech D55 · S/N TE757Cancelled May 27, 1994 · Triennial form not returned · Casey Eugene SN182PLReims CESSNA F182Q · S/N F182-0166Cancelled Sep 15, 1987 · Exported to Germany · Rose Enclosures Systems IncN729SDassault FALCON 20 F · S/N 173Cancelled Nov 29, 1984 · Exported to Indonesia · Omni International CorpN727UDBoeing 727-100 · S/N 18367Cancelled Jul 2, 1984 · Exported to Democratic Republic of the Congo · Omni International CorpN816HIsrael Aircraft Industries 1124 · S/N 323Cancelled Sep 15, 1981 · Exported to Australia · Omni International Jet Trading Floor IncN7782Lockheed 1329 · S/N 5066Cancelled Oct 20, 1980 · Exported to Panama · Built 1965 · Washington Jet IncN90WJCessna 500 · S/N 5000053Cancelled Aug 20, 1980 · Exported to Italy · Washington Jet IncN127MMazzie Bruce L BD-5B · S/N 4528Cancelled May 29, 1980 · Mazzie Bruce LN585MMoth 60-GM · S/N 86Cancelled May 9, 1980 · Exported to United Kingdom · Fox F MN4PHRockwell International NA-265-40 · S/N 282-116Cancelled Jun 12, 1979 · Exported to Mexico · Built 1973 · Washington Jet AincN3944PPiper PA-22-150 · S/N 223619Cancelled Mar 26, 1976 · Built 1956 · Buck Jon RN6438QMooney M20F · S/N 670517Cancelled Sep 26, 1975 · Conda Kenneth JN3840WPiper PA-32-260 · S/N 32-777Cancelled Jun 6, 1975 · Fred Richard K DrN201EHGlasflugel STD LIBELLE 201B · S/N 437Cancelled Mar 14, 1975 · Exported to Canada · Eschenberg Floride CN9777CHiller UH-12L4 · S/N 2173Cancelled Oct 25, 1974 · Fairchild-Hiller CorpN1262TPiper PA-28R-200 · S/N 28R-7235249Cancelled Jun 26, 1973 · Lamco And Associates IncN2359LBeech 23 · S/N M-197Cancelled Dec 23, 1971 · Culler Robert WayneN248PABeech 95-55 · S/N TC-142Cancelled Jul 14, 1971 · Rockville Leasecar IncN2111GCessna 182A · S/N 51411Cancelled Dec 4, 1970 · Rockville Construction CoN81007Hiller OH-5A · S/N 3Cancelled Jun 29, 1970 · Fairchild Hiller CorpN90482Hiller UH-12L4 · S/N 2516Cancelled Jun 29, 1970 · Fairchild Hiller Corp
Back to Rockville, MD