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.

N404JZAgustawestland Philadelphia AW139 · S/N 41502Cancelled Dec 12, 2016 · Exported to Egypt · Agusta Westland Philadelphia CorpN639SSAgustawestland Philadelphia AW119MKII · S/N 14912Cancelled Dec 12, 2016 · Exported to China · Built 2016 · Agustawestland Philadelphia CorpN564SHAgusta A109E · S/N 11171Cancelled Nov 21, 2016 · Exported to Mexico · Agustawestland Philadelphia CorpN287MMAgustawestland Philadelphia AW119MKII · S/N 14901Cancelled Nov 10, 2016 · Exported to Russia · Agustawestland Philadelphia CorpN642SSAgustawestland Philadelphia AW119MKII · S/N 14913Cancelled Oct 25, 2016 · Exported to China · Agustawestland Philadelphia CorpN412PGDassault-Breguet FALCON 50 · S/N 97Cancelled Oct 21, 2016 · Exported to Canada · Built 1982 · Bpg 412 LLCN641SSAgustawestland Philadelphia AW139 · S/N 41523Cancelled Oct 20, 2016 · Exported to Thailand · Agusta Westland Philadelphia CorpN643SSAgustawestland Philadelphia AW139 · S/N 41524Cancelled Oct 20, 2016 · Exported to Thailand · Agustawestland Philadelphia CorpN644SSAgustawestland Philadelphia AW139 · S/N 41525Cancelled Oct 20, 2016 · Exported to Thailand · Agustawestland Philadelphia CorpN633SSAgustawestland Philadelphia AW119MKII · S/N 14911Cancelled Oct 18, 2016 · Exported to China · Agustawestland Philadelphia CorpN629SSAgustawestland Philadelphia AW139 · S/N 41520Cancelled Sep 12, 2016 · Exported to Thailand · Agustawestland Philadelphia CorpN637SSAgustawestland Philadelphia AW139 · S/N 41522Cancelled Sep 12, 2016 · Exported to Thailand · Agustawestland Philadelphia CorpN10197Hiller UH-12C · S/N 803Cancelled Sep 9, 2016 · Revoked, canceled · Built 1958 · Carson FranklinN588SHAgustawestland Philadelphia AW139 · S/N 41518Cancelled Aug 31, 2016 · Exported to Japan · Agustawestland Philadelphia CorpN626SSAgustawestland Philadelphia AW119KX · S/N 14908Cancelled Aug 16, 2016 · Exported to China · Agustawestland Philadelphia CorpN592SHAgustawestland Philadelphia AW139 · S/N 41519Cancelled Aug 8, 2016 · Exported to Japan · Agustawestland Philadelphia CorpN625SSAgustawestland Philadelphia AW119KX · S/N 14907Cancelled Jul 29, 2016 · Exported to China · Agustawestland Philadelphia CorpN624SSAgustawestland Philadelphia AW119KX · S/N 14903Cancelled Jul 27, 2016 · Exported to China · Agustawestland Philadelphia CorpN237MHAgustawestland Philadelphia AW119MKII · S/N 14904Cancelled Jul 26, 2016 · Exported to Philippines · Built 2016 · Agustawestland Philadelphia CorpN586SHAgustawestland Philadelphia AW139 · S/N 41514Cancelled Jul 25, 2016 · Exported to Japan · Agustawestwind Philadelphia CorpN308MMAgustawestland Philadelphia AW139 · S/N 41512Cancelled Jul 19, 2016 · Exported to Mexico · Built 2016 · Agustawestland Philadelphia CorpN211JSAgustawestland Philadelphia AW119MKII · S/N 14905Cancelled Jul 1, 2016 · Exported to South Africa · Built 2016 · Agustawestland Philadelphia CorpN587SHAgustawestland Philadelphia AW139 · S/N 41515Cancelled May 16, 2016 · Exported to Japan · Agusta Westland Philadelphia CorpN296MMAgustawestland Philadelphia AW139 · S/N 41510Cancelled Apr 29, 2016 · Exported to Italy · Agustawestland Philadelphia CorpN622SSAgustawestland Philadelphia AW119MKII · S/N 14843Cancelled Apr 7, 2016 · Exported to South Africa · Built 2016 · Agustawestland Philadelphia CorpN614SSAgustawestland Philadelphia AW119MKII · S/N 14845Cancelled Feb 17, 2016 · Exported to China · Agustawestland Philadelphia CorpN278MMAgustawestland Philadelphia AW139 · S/N 41505Cancelled Feb 3, 2016 · Exported to France · Agustawestland Philadelphia CorpN279MMAgustawestland Philadelphia AW139 · S/N 41507Cancelled Feb 3, 2016 · Exported to France · Augustawestland Philadelphia CorpN561SHAgustawestland Philadelphia AW119MKII · S/N 14841Cancelled Jan 28, 2016 · Exported to India · Built 2015 · Agusta Westland Philadelphia CorpN612SSAgustawestland Philadelphia AW119MKII · S/N 14844Cancelled Jan 19, 2016 · Exported to China · Agustawestland Philadelphia CorpN608SSAgustawestland Philadelphia AW119MKII · S/N 14842Cancelled Dec 17, 2015 · Exported to China · Agustawestland Philadelphia CorpN401JZAgustawestland Philadelphia AW139 · S/N 41399Cancelled Dec 14, 2015 · Exported to Thailand · Built 2015 · Agustawestland Philadelphia CorpN6186RCessna T210F · S/N T210-0086Cancelled Dec 14, 2015 · Exported to Mexico · Built 1966 · Bjork Ann SofieN87552Raytheon 1900D · S/N UE-216Cancelled Dec 4, 2015 · Exported to Argentina · Built 1996 · Fmc CorpN262MMAgustawestland Philadelphia AW139 · S/N 41404Cancelled Nov 2, 2015 · Exported to South Korea · Built 2015 · Agustawestland Philadephia CorpN582SHAgustawestland Philadelphia AW119MKII · S/N 14840Cancelled Oct 13, 2015 · Exported to India · Built 2015 · Agustawestland Philadelphia CorpN583SHAgustawestland Philadelphia AW139 · S/N 41506Cancelled Oct 7, 2015 · Exported to Japan · Agustawestland Philadelphia CorpN273MMAgustawestland Philadelphia AW139 · S/N 41405Cancelled Sep 10, 2015 · Exported to Italy · Built 2015 · Agustawestland Philadelphia CorpN565SHAgustawestland Philadelphia AW119MKII · S/N 14838Cancelled Jul 20, 2015 · Exported to China · Agustawestland Philadelphia CorpN566SHAgustawestland Philadelphia AW139 · S/N 41408Cancelled Jul 16, 2015 · Exported to Japan · Agustawestlnd Philadelphia CorpN195NTAgustawestland Philadelphia AW119MKII · S/N 14790Cancelled Jul 13, 2015 · Exported to South Africa · Built 2012 · Agustawestland Philadelphia CorpN193NTAgusta Aerospace AW119 MKII · S/N 14780Cancelled Jun 12, 2015 · Exported to Italy · Built 2012 · Agustawestland Philadelphia CorpN265MMAgustawestland Philadelphia AW139 · S/N 41403Cancelled Jun 12, 2015 · Exported to Italy · Built 2015 · Agustawestland Philadelhia CorpN257MMAgustawestland Philadelphia AW139 · S/N 41400Cancelled Jun 11, 2015 · Exported to France · Agustawestland Philadelphia CorpN264MMAgustawestland Philadelphia AW139 · S/N 41401Cancelled Jun 11, 2015 · Exported to France · Agustawestland Philadelphia CorpN3834VCessna 150M · S/N 15076634Cancelled May 19, 2015 · Exported to Brazil · Built 1975 · Goncalves Adriano ValmirN2057RBoeing CH47-414 · S/N M4478Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 1998 · Boeing CompanyN901AVPiper PA-28RT-201 · S/N 28R-8118028Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1980 · Northeast Aviation IncN263MMAgustawestland Philadelphia AW139 · S/N 41396Cancelled May 8, 2015 · Exported to Colombia · Agustawestland Philadelphia CorpN40018Consolidated Vultee BT-13 · S/N 10547Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1943 · Claire Aviation Inc
Back to Philadelphia, PA