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.

N161NGBritish BAC 1-11 401/AK · S/N BAC 067Cancelled Mar 23, 2012 · Built 1966 · Northrop Grumman Systems CorpN421WVCessna 172N · S/N 17273923Cancelled Mar 15, 2012 · Exported to Canada · Built 1980 · Gnau Charles J JrN516LZPiper PA-28-181 · S/N 2843064Cancelled Oct 4, 2011 · Exported to Germany · Built 1996 · Yataruba Air LLCN3853TPiper PA-28R-180 · S/N 28R-30175Cancelled Jun 17, 2011 · Second renewal notice · Built 1967 · Potts EfremN68311Cessna T-50 · S/N 6402Cancelled Mar 15, 2011 · Registration pending, pending cancellation · Built 1943N561NWCessna 172M · S/N 17261722Cancelled Jan 5, 2011 · Triennial form not returned · Built 1973 · Gnau Charles J SrN92MDAerospatiale SA365N-1 DAUPHIN · S/N 6311Cancelled May 28, 2010 · Triennial form not returned · Maryland State PoliceN7925YPiper PA-30 · S/N 30-1015Cancelled Apr 21, 2010 · Built 1966 · Flying Sorcerer IncN1244CCessna 182T · S/N 18281597Cancelled Jan 27, 2010 · Exported to Australia · Built 2005 · Skytech IncN3388Arthur Lederle B-8M · S/N 1Cancelled Oct 9, 2009 · Registration revoked · Built 1969 · East James WN9853YChampion 7FC · S/N 7FC-415Cancelled Sep 18, 2009 · Registration revoked · Built 1960 · Pennington Susan LN5310TPiper PA-28-140 · S/N 28-7225424Cancelled Sep 15, 2009 · Registration revoked · Built 1972 · Flight Training IncN1952RRaven S-50A · S/N S50A-162Cancelled Jul 10, 2009 · Registration revoked · Built 1971 · Pikes Peak Or BustN163CStinson 108-2 · S/N 1083163Cancelled Jun 30, 2009 · Registration revoked · Built 1947 · Van Winkle Phillip JN3013KCulver V · S/N V232Cancelled May 18, 2009 · Registration revoked · Built 1946 · Hlista JosephN74294Bellanca 14-13-2 · S/N 1407Cancelled Apr 21, 2009 · Triennial form not returned · Built 1946 · Wallace Robert LN4176DPiper PA-32R-301T · S/N 3257180Cancelled Sep 19, 2008 · Exported to Brazil · Built 2000 · Cowie William H JrN85WTCessna 310N · S/N 310N-0106Cancelled Apr 25, 2008 · Built 1968 · Doshier John RN5355MPiper PA 46-350P · S/N 4636336Cancelled Jan 19, 2007 · Exported to Australia · Built 2002 · Skytech IncN2168SBell 206B · S/N 3490Cancelled Dec 12, 2006 · Exported to Canada · Built 1981 · U S Leaseco IncN67SDBeech B200 · S/N BB-1327Cancelled Oct 3, 2006 · Exported to Norway · Built 1989 · Pratt Street Aviation LLCN3501JCessna 172S · S/N 172S8850Cancelled May 10, 2006 · Exported to Czech Republic · Belvedere Aviation LLCN22XLBeech H-18 · S/N BA-652Cancelled Mar 6, 2006 · Triennial form not returned · Built 1964 · Beltway MotelN407PBell 407 · S/N 53028Cancelled Jan 3, 2006 · Triennial form not returned · Built 1996 · US Leaseco IncN76LPSikorsky S-76A · S/N 760133Cancelled Nov 30, 2004 · Exported to New Zealand · Built 1999 · Helicopter Transport Services IncN600TWBell 206B · S/N 3414Cancelled Jun 9, 2004 · Exported to Canada · Built 1981 · U S Leaseco IncN1390KKillian John D PIETENPOL · S/N 001Cancelled Apr 30, 2004 · Second triennial mailing, no response · Killian John DN89431Cessna 140 · S/N 8463Cancelled Jan 21, 2004 · Exported to South Africa · Built 1946 · Gnau Aviation LLCN22NWBellanca 17-30A · S/N 79-30914Cancelled Aug 13, 2002 · Exported to Canada · Built 1979N89FBBell 206B · S/N 1980Cancelled Apr 26, 2002 · Second triennial mailing, no response · Built 1976 · U S Leaseco IncN678KGBell 206A · S/N 603Cancelled Apr 17, 2002 · Exported to Canada · Built 1972 · US Leaseco IncN44868Raytheon 1900D · S/N UE-418Cancelled Mar 15, 2002 · Exported to Algeria · Built 1999 · Northrop Grumman CorpN50919Raytheon 1900D · S/N UE-419Cancelled Dec 20, 2001 · Exported to Algeria · Built 2000 · Northrop Grumman CorpN50317Raytheon 1900D · S/N UE-417Cancelled Nov 13, 2001 · Exported to Algeria · Built 1999 · Northrop Grumman CorpN50916Raytheon 1900D · S/N UE-416Cancelled Oct 31, 2001 · Exported to Algeria · Built 1999 · Northrop Grumman CorpN31557Raytheon 1900D · S/N UE-380Cancelled Sep 28, 2001 · Exported to Algeria · Northrop Grumman CorpN50321Raytheon 1900D · S/N UE-421Cancelled Sep 24, 2001 · Exported to Algeria · Northrop Grumman CorpN32345Raytheon 1900D · S/N UE-384Cancelled Aug 1, 2001 · Exported to Algeria · Northrop Grumman CorpN50220Raytheon 1900D · S/N UE-420Cancelled Jun 1, 2001 · Exported to Algeria · Northrop Grumman CorpN44808Raytheon 1900D · S/N UE-414Cancelled Apr 19, 2001 · Exported to Algeria · Northrop Grumman CorpN44849Raytheon 1900D · S/N UE-413Cancelled Apr 19, 2001 · Exported to Algeria · Built 2000 · Northrop Grumman CorpN44663Raytheon 1900D · S/N UE-404Cancelled Mar 30, 2001 · Exported to Algeria · Northrop Grumman CorpN44824Raytheon 1900D · S/N UE-411Cancelled Mar 30, 2001 · Exported to Algeria · Northrop Grumman CorpN7511ESchweizer 269C · S/N S1693Cancelled Mar 16, 2001 · Triennial form not returned · Baltimore Police DepartmentN2100BSchweizer 269C · S/N S1762Cancelled Apr 6, 2000 · U S Leaseco IncN35EMBell 214B · S/N 28023Cancelled Mar 9, 2000 · Exported to South Korea · Helicopter Transport Services IncN122AECanadair CL-44D4 · S/N 18Cancelled Nov 4, 1999 · Triennial form not returned · Tia IncN902VBeech V35B · S/N D-9624Cancelled Jun 18, 1999 · Triennial form not returned · Dees Charles M JrN9525LGrumman American Avn. AA-5 · S/N AA5-0525Cancelled Mar 12, 1999 · Triennial form not returned · Wagner Raymond RN7027NBeech E33A · S/N CE186Cancelled Jul 21, 1998 · Second triennial mailing, no response · Lamprecht Jerome Owner
Back to Baltimore, MD