OpenAirDocs.org
Baltimore, MD

Cancelled registrations · 379

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

N5794GCessna 150K · S/N 15071294Cancelled Nov 3, 1997 · Triennial form not returned · Ramair IncN149PJCessna 500 · S/N 5000149Cancelled Aug 1, 1997 · Exported to South Africa · Somair CorpN350PMPiper PA 46-350P · S/N 4636028Cancelled Feb 27, 1997 · Exported to Norway · Skytech IncN93874Cessna 152 · S/N 15285566Cancelled Jul 12, 1996 · Triennial form not returned · Ramair IncN346BBHughes Helicopters HUGHES 369D · S/N 1260061DCancelled Jun 10, 1996 · Exported to Canada · Built 1976 · US Lease Co IncN1WCAgusta AGUSTA A109 · S/N 7278Cancelled Feb 27, 1996 · Triennial form not returned · Signet Lsg And Financial CorpN3218XBeech C90A · S/N LJ1418Cancelled Feb 27, 1996 · Exported to Egypt · 421c-1408 Aircraft CorpN4748QCessna 152 · S/N 15285058Cancelled Feb 1, 1996 · Exported to Yemen · Hinson Corporate Flight Services IncN2363MPiper PA-12 · S/N 121617Cancelled Jan 22, 1996 · Exported to Ireland · Levis Enterprises LtdN92575Piper PA 46-350P · S/N 4636012Cancelled Dec 29, 1995 · Exported to Germany · Skytech IncN921BCPiper PA-46-310P · S/N 468608038Cancelled Oct 23, 1995 · Exported to Germany · Skytech IncN1221KPiper PA 46-350P · S/N 4622148Cancelled Aug 11, 1995 · Exported to Germany · Skytech IncN144BWWard William F AMATEUR BUILT · S/N 1Cancelled Jul 20, 1995 · Triennial form not returned · Watson Raymond SN100JWPiper PA-46-310P · S/N 4608089Cancelled Apr 6, 1995 · Exported to Germany · Skytech IncN68JTPiper PA-46-310P · S/N 468608030Cancelled Mar 2, 1995 · Exported to Germany · Skytech IncN58185Hughes Helicopters HUGHES 369D · S/N 280258DCancelled Feb 28, 1995 · Exported to Canada · U S Leaseco IncN8303VChampion 7ECA · S/N 383Cancelled Jan 11, 1995 · Triennial form not returned · Parker Robert GN2774GCessna 182B · S/N 52074Cancelled Jun 24, 1994 · Triennial form not returned · Davis Leroy WN3194FCessna 182J · S/N 18257294Cancelled May 18, 1994 · Triennial form not returned · Wozniak Robert FN360WTBritten-Norman BN-2T-4R · S/N 2115Cancelled May 11, 1994 · Exported to United Kingdom · Westinghouse Electric CorporationN2093SBell 212 · S/N 30944Cancelled May 9, 1994 · Exported to Canada · Helicopter Transport Services IncN909FRDassault/Sud FAN JET FALCON · S/N 209Cancelled Nov 30, 1993 · Exported to United Kingdom · Mercantile-Safe Dep & Tr Co TrusteeN908FRDassault/Sud FAN JET FALCON · S/N 207Cancelled Jul 9, 1993 · Exported to United Kingdom · Mercantile-Safe Dep & Tr Co TrusteeN183WWPiper PA-46-310P · S/N 4608120Cancelled Jun 18, 1993 · Exported to Germany · Skytech IncN658NHCessna T210R · S/N T21064958Cancelled Apr 22, 1993 · Exported to Mexico · Skytech IncN907FRDassault/Sud FAN JET FALCON SER D · S/N 224Cancelled Mar 31, 1993 · Exported to United Kingdom · Mercantile-Safe Dep & Tr Co TrusteeN904FRDassault/Sud FAN JET FALCON · S/N 151Cancelled Mar 16, 1993 · Exported to United Kingdom · Mercantile-Safe Dep Tr Co TrusteeN6132ESchweizer 269C · S/N S1583Cancelled Mar 3, 1993 · City Of BaltimoreN9101ZPiper PA-46-310P · S/N 4608017Cancelled Nov 18, 1992 · Exported to Germany · Skytech IncN906FRDassault/Sud FAN JET FALCON · S/N 214Cancelled Oct 20, 1992 · Exported to United Kingdom · Mercantile-Safe Dep & Tr Co TrusteeN32HGBeech 200 · S/N BB146Cancelled Oct 19, 1992 · Triennial form not returned · Omega Air IncN26RVHughes Helicopters HUGHES 369D · S/N 110864DCancelled Oct 8, 1992 · Franklin Air CompanyN905FRDassault/Sud FAN JET FALCON · S/N 213Cancelled Oct 8, 1991 · Exported to United Kingdom · Mercantile-Safe Deposit And Trust CoN21394Swift William BEAVER RX-550 · S/N SB2447Cancelled Jul 24, 1991 · Glazer John EN4304KAirship Industries UK AIRSHIP 600 · S/N 1215-04Cancelled Jun 25, 1991 · Westinghouse Airships IncN4679SBensen B-8M · S/N 1012BRCancelled Jun 14, 1991 · Triennial form not returned · Rankin Alvin CharlesN77ATNorth American NA-265-40 · S/N 282109Cancelled Jun 5, 1991 · Exported to Ecuador · Alban Tractor Co IncN1785GBeech 35-B33 · S/N CD511Cancelled May 1, 1991 · Triennial form not returned · Young Charles NN8684MBeech 35-B33 · S/N CD687Cancelled May 1, 1991 · Triennial form not returned · Corson Norman LN903FRDassault/Sud FAN JET FALCON · S/N 20Cancelled Apr 24, 1991 · Exported to United Kingdom · Mercantile-Save Dep & Tr Co TrusteeN738CECessna R182 · S/N R18200910Cancelled Feb 1, 1991 · Triennial form not returned · Arlco IncN19FHBell 222 · S/N 47046Cancelled Dec 14, 1990 · Exported to Canada · Cignarale Armando JN17JLLefils-James VOLMER VJ-22 · S/N 001Cancelled Sep 18, 1985 · Administratively canceledN5117SPiper PA-28-140 · S/N 28-7125562Cancelled Feb 1, 1984 · Built 1971 · Dooley Geroge TN3538RPiper PA-31 · S/N 31-7912115Cancelled Apr 14, 1983 · 7c'S Transportation IncN6211JPiper PA-34-200T · S/N 34-7670269Cancelled Nov 19, 1982 · Baltimore Airways Leasing AssociatesN2BSScherer BUSHBY MUSTANG M II · S/N MII-654Cancelled Nov 9, 1982 · Scherer Robert DN1420CPiper PA-22-135 · S/N 221172Cancelled May 21, 1982 · Sale reportedN8423JVarga 2150A · S/N VAC-165-80Cancelled Feb 22, 1982 · Chandler NoelN1235TPiper PA-28R-200 · S/N 28R-7235243Cancelled Oct 15, 1981 · Administratively canceled · Thiel Melvin H
Back to Baltimore, MD