Philadelphia, PA

Cancelled registrations · 988

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 = 'PA' AND d.registrant_city = 'PHILADELPHIA'
  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.

N483SMAgusta Aerospace AW119 MKII · S/N 14778Cancelled Feb 29, 2012 · Exported to China · Built 2011 · Agustawestland Philadelphia CorpN486SMAgustawestland Philadelphia AW119MKII · S/N 14781Cancelled Jan 24, 2012 · Exported to Philippines · Agustawestland Philadelphia CorpN57062Aero Commander 500 S · S/N 3172Cancelled Jan 5, 2012 · Exported to Argentina · Built 1973 · Cdi-Infrastructure LLCN201YSAgusta Aerospace AW119 MKII · S/N 14743Cancelled Dec 21, 2011 · Exported to Russia · Built 2009 · Agustawestland Philadelphia CorpN406SHAgustawestland Philadelphia AW139 · S/N 41279Cancelled Nov 29, 2011 · Exported to Japan · Agustawestland Philadelphia CorpN404SHAgustawestland Philadelphia AW139 · S/N 41274Cancelled Nov 8, 2011 · Exported to Japan · Agustawestland Philadelphia CorpN480SMAgusta AW139 · S/N 41007Cancelled Nov 8, 2011 · Exported to Italy · Built 2008 · Agustawestland Philadelphia CorpN403SHAgustawestland Philadelphia AW139 · S/N 41275Cancelled Oct 26, 2011 · Exported to Japan · Agusta Westland Philadelphia CorpN219YSAgusta Aerospace AW119 MKII · S/N 14776Cancelled Oct 5, 2011 · Exported to Russia · Agustawestland Philadelphia CorpN301YSAgusta Aerospace AW119 MKII · S/N 14775Cancelled Sep 13, 2011 · Exported to Australia · Agustawestland Philadelphia CorpN4145TCessna 320D · S/N 320D0045Cancelled Aug 5, 2011 · First renewal notice · Built 1965 · Keystone Aerial SurveysN998AAAgusta AW139 · S/N 31142Cancelled Jul 12, 2011 · Exported to Finland · Built 2008 · Agustawestland Philadelphia CorpN378SHAgusta Aerospace AW119 MKII · S/N 14766Cancelled Jun 29, 2011 · Exported to Finland · Augusta Aerospace CorpN31645Howard DGA-18 · S/N 645Cancelled Jun 13, 2011 · Revoked, canceled · Built 1941 · Mcgurk Joseph EN391SHAgusta Aerospace AW119 MKII · S/N 14772Cancelled Jun 8, 2011 · Exported to Brazil · Agusta Aerospace CorpN305YSAgusta Aerospace AW139 · S/N 41267Cancelled Jun 1, 2011 · Exported to Malaysia · Agusta Aerospace CorpN366SHAgusta Aerospace AW119 MKII · S/N 14759Cancelled May 31, 2011 · Exported to Finland · Agusta Aerospace CorpN218YSAgusta Aerospace AW119 MKII · S/N 14767Cancelled May 4, 2011 · Exported to Russia · Agusta Aerospace CorpN376SHAgusta Aerospace AW119 MKII · S/N 14764Cancelled Apr 11, 2011 · Exported to Chile · Built 2011 · Agusta Aerospace CorpN478SMAgusta Aerospace AW139 · S/N 41257Cancelled Apr 1, 2011 · Exported to Canada · Agusta Aerospace CorpN470SMAgusta Aerospace AW139 · S/N 41250Cancelled Jan 21, 2011 · Exported to Canada · Agusta Aerospace CorpN209YSAgusta AW139 · S/N 31283Cancelled Jan 12, 2011 · Exported to United Kingdom · Built 2010 · Agusta Aerospace CorpN215YSAgusta AW139 · S/N 31277Cancelled Jan 5, 2011 · Exported to Canada · Agusta Aerospace CorpN468SMAgusta Aerospace AW139 · S/N 41247Cancelled Dec 27, 2010 · Exported to Canada · Agusta Aerospace CorpN467SMAgusta Aerospace AW139 · S/N 41245Cancelled Dec 14, 2010 · Exported to Canada · Agusta Aerospace CorpN211YSAgusta Aerospace AW119 MKII · S/N 14763Cancelled Dec 8, 2010 · Exported to Russia · Agusta Aerospace CorpN466SMAgusta Aerospace AW119 MKII · S/N 14758Cancelled Dec 6, 2010 · Exported to Finland · Built 2010 · Agusta Aerospace CorpN377SHAgusta Aerospace AW119 MKII · S/N 14765Cancelled Nov 29, 2010 · Exported to Brazil · Agusta Aerospace CorpN257GTSocata TB-20 TRINIDAD · S/N 2057Cancelled Nov 16, 2010 · Exported to Australia · Built 2001N458SMAgusta Aerospace AW139 · S/N 41238Cancelled Nov 12, 2010 · Exported to Canada · Agusta Aerospace CorpN374SHAgusta Aerospace AW119 MKII · S/N 14762Cancelled Nov 10, 2010 · Exported to South Africa · Agusta Aerospace CorpN419SMAgusta Aerospace AW139 · S/N 41227Cancelled Nov 1, 2010 · Exported to Canada · Agusta Aerospace CorpN453SMAgusta Aerospace AW139 · S/N 41230Cancelled Nov 1, 2010 · Exported to Canada · Agusta Aerospace CorpN461SMAgusta Aerospace AW119 MKII · S/N 14755Cancelled Sep 16, 2010 · Exported to Ethiopia · Built 2010 · Agusta Aerospace CorpN455SMAgusta Aerospace AW139 · S/N 41236Cancelled Sep 9, 2010 · Exported to Canada · Agusta Aerospace CorpN454SMAgusta Aerospace AW139 · S/N 41232Cancelled Aug 16, 2010 · Exported to Canada · Agusta Aerospace CorpN459SMAgusta Aerospace AW139 · S/N 41241Cancelled Jul 26, 2010 · Exported to Qatar · Agusta Aerospace CorpN460SMAgusta Aerospace AW139 · S/N 41248Cancelled Jul 26, 2010 · Exported to Qatar · Agusta Aerospace CorpN368SHAgusta Aerospace AW139 · S/N 41228Cancelled Jul 2, 2010 · Exported to Australia · Agusta Aerospace CorpN372SHAgusta A109S · S/N 22165Cancelled Jun 28, 2010 · Exported to Mexico · Built 2010 · Agusta Aerospace CorpN417SMAgusta Aerospace AW139 · S/N 41226Cancelled Jun 2, 2010 · Exported to Canada · Agusta Aerospace CorpN204YSAgusta A109S · S/N 22160Cancelled Jun 1, 2010 · Exported to Canada · Built 2010 · Agusta Aerospace CorpN370SHAgusta Aerospace AW139 · S/N 41233Cancelled May 13, 2010 · Exported to Australia · Agusta Aerospace CorpN363SHAgusta Aerospace AW119 MKII · S/N 14748Cancelled Apr 16, 2010 · Exported to Spain · Agusta Aerospace CorpN413SMAgusta Aerospace AW139 · S/N 41225Cancelled Apr 14, 2010 · Exported to Qatar · Agusta Aerospace CorpN420SMAgusta Aerospace AW139 · S/N 41222Cancelled Mar 31, 2010 · Exported to Qatar · Built 2010 · Agusta Aerospace CorpN207YSAgusta Aerospace AW119 MKII · S/N 14754Cancelled Feb 23, 2010 · Exported to Spain · Agusta Aerospace CorpN346SHAgusta Aerospace AW119 MKII · S/N 14749Cancelled Feb 23, 2010 · Exported to Spain · Agusta Aerospace CorpN202YSAgusta Aerospace AW119 MKII · S/N 14752Cancelled Feb 19, 2010 · Exported to Spain · Agusta Aerospace CorpN203YSAgusta Aerospace AW119 MKII · S/N 14753Cancelled Feb 17, 2010 · Exported to Spain · Agusta Aerospace Corp
Back to Philadelphia, PA