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.

N410SMAgusta Aerospace AW139 · S/N 41231Cancelled Jan 28, 2010 · Exported to Brazil · Agusta Aerospace CorpN408SMAgusta A109S · S/N 22121Cancelled Jan 22, 2010 · Exported to Mexico · Agusta Aerospace CorpN117YSAgusta AW139 · S/N 41207Cancelled Jan 4, 2010 · Exported to Brazil · Agusta Aerospace CorpN248SMAgusta Aerospace AW139 · S/N 41212Cancelled Jan 4, 2010 · Exported to Brazil · Agusta Aerospace CorpN403SMAgusta Aerospace AW139 · S/N 41220Cancelled Jan 4, 2010 · Exported to Brazil · Agusta Aerospace CorpN361SHAgusta A109S · S/N 22142Cancelled Dec 2, 2009 · Exported to Mexico · Agusta Aerospace CorpN302SHAgusta Aerospace AW119 MKII · S/N 14724Cancelled Nov 12, 2009 · Exported to Japan · Built 2009 · Agusta Aerospace CorpN257ABeech G35 · S/N D-4809Cancelled Sep 21, 2009 · Registration revoked · Built 1956 · Demarco Leonard JN9537Hooper BENSEN B-8M · S/N GP-203Cancelled Sep 17, 2009 · Registration revoked · Built 1972 · Hooper Robert P JrN249SMAgusta Aerospace AW139 · S/N 41214Cancelled Sep 14, 2009 · Exported to United Arab Emirates · Agusta Aerospace CorpN405SMAgusta Aerospace AW139 · S/N 41218Cancelled Sep 10, 2009 · Exported to United Arab Emirates · Agusta Aerospace CorpN225SMAgusta Aerospace AW139 · S/N 41213Cancelled Aug 24, 2009 · Exported to United Arab Emirates · Agusta Aerospace CorpN341SHAgusta Aerospace AW139 · S/N 41215Cancelled Aug 21, 2009 · Exported to United Arab Emirates · Agusta Aerospace CorpN395GPAgusta Aerospace AW139 · S/N 41217Cancelled Aug 4, 2009 · Exported to Egypt · Agusta Aerospace CorpN139DHAgusta Aerospace AW139 · S/N 41209Cancelled Jul 29, 2009 · Exported to Egypt · Agusta Aerospace CorpN2265BLuscombe 8A · S/N 6692Cancelled Jul 13, 2009 · Registration revoked · Built 1949 · Wuest EdwardN103YSAgusta Aerospace AW119 MKII · S/N 14738Cancelled Jun 4, 2009 · Exported to Panama · Built 2009 · Agusta Aerospace CorpN111YSAgusta Aerospace AW119 MKII · S/N 14732Cancelled May 22, 2009 · Exported to Spain · Agusta Aerospace CorpN236SMAgusta A109E · S/N 11760Cancelled Apr 30, 2009 · Exported to Mexico · Built 2009 · Agusta Aerospace CorpN105YSAgusta A109S · S/N 22110Cancelled Apr 10, 2009 · Exported to United Arab Emirates · Built 2009 · Agusta Aerospace CorpN296SHAgusta Aerospace AW119 MKII · S/N 14720Cancelled Apr 9, 2009 · Exported to Brazil · Built 2008 · Agusta Aerospace CorpN980GPPreiss Robert TWINSTAR MK III XTRA · S/N M3X0020003Cancelled Apr 6, 2009 · Triennial form not returned · Preiss Robert CN114YSAgusta AW139 · S/N 41205Cancelled Mar 18, 2009 · Exported to United Arab Emirates · Agusta Aeerospace CorpN106YSAgusta Aerospace AW119 MKII · S/N 14727Cancelled Mar 5, 2009 · Exported to Spain · Agusta Aerospace CorpN107YSAgusta Aerospace AW119 MKII · S/N 14728Cancelled Mar 5, 2009 · Exported to Spain · Agusta Aerospace CorpN108YSAgusta Aerospace AW119 MKII · S/N 14729Cancelled Mar 5, 2009 · Exported to Spain · Agusta Aerospace CorpN109YSAgusta Aerospace AW119 MKII · S/N 14730Cancelled Mar 5, 2009 · Exported to Spain · Agusta Aerospace CorpN112YSAgusta AW139 · S/N 41204Cancelled Mar 5, 2009 · Exported to United Arab Emirates · Agusta Aerospace CorpN292SHAgusta Aerospace AW119 MKII · S/N 14712Cancelled Feb 18, 2009 · Exported to Cyprus · Built 2008 · Agusta Aerospace CorpN531AMAgusta Aerospace AW119 MKII · S/N 14718Cancelled Feb 18, 2009 · Exported to Mexico · Built 2008 · Agusta Aerospace CorpN297SHAgusta Aerospace AW119 MKII · S/N 14722Cancelled Jan 29, 2009 · Exported to Mexico · Built 2008 · Agusta Aerospace CorpN332SHAgusta AW139 · S/N 41022Cancelled Dec 23, 2008 · Exported to United Arab Emirates · Agusta Aerospace CorpN330SHAgusta AW139 · S/N 41020Cancelled Dec 18, 2008 · Exported to United Arab Emirates · Agusta Aerospace CorpN331SHAgusta A109E · S/N 11736Cancelled Nov 12, 2008 · Exported to Mexico · Agusta Aerospace CorpN294SHAgusta Aerospace AW119 MKII · S/N 14717Cancelled Nov 7, 2008 · Exported to Libya · Agusta Aerospace CorpN291SHAgusta Aerospace AW119 MKII · S/N 14710Cancelled Oct 17, 2008 · Exported to New Zealand · Agusta Aerospace CorpN126AWAgusta Aerospace AW119 MKII · S/N 14715Cancelled Oct 7, 2008 · Exported to Libya · Agusta Aerospace CorpN325SHAgusta AW139 · S/N 41017Cancelled Sep 15, 2008 · Exported to United Arab Emirates · Agusta Aerospace CorpN216SHAgusta Aerospace AW119 MKII · S/N 14708Cancelled Sep 3, 2008 · Exported to Libya · Agusta Aerospace CorpN279SHAgusta Aerospace AW119 MKII · S/N 14709Cancelled Sep 2, 2008 · Exported to South Africa · Agusta Aerospace CorpN162SHAgusta Aerospace AW119 MKII · S/N 14707Cancelled Jun 24, 2008 · Exported to Switzerland · Agusta Aerospace CorpN809SMAgusta Aerospace A119 · S/N 14537Cancelled Jun 20, 2008 · Exported to Uganda · Built 2007 · Agusta Aerospace CorpN25CKPiper PA-38-112 · S/N 38-81A0062Cancelled Jun 6, 2008 · Exported to New Zealand · Hortman Aviation Services IncN141AWAgusta AW139 · S/N 41011Cancelled Jun 5, 2008 · Exported to United Arab Emirates · Agusta Aerospace CorpN80MEAgusta Aerospace AW119 MKII · S/N 14705Cancelled May 28, 2008 · Exported to Libya · Agusta Aerospace CorporationN88MEAgusta Aerospace AW119 MKII · S/N 14706Cancelled May 28, 2008 · Exported to Libya · Agusta Aerospace CorporationN52MEAgusta Aerospace AW119 MKII · S/N 14702Cancelled Mar 31, 2008 · Exported to Spain · Agusta Aerospace CorporationN60MEAgusta Aerospace AW119 MKII · S/N 14703Cancelled Mar 31, 2008 · Exported to Spain · Agusta Aerospace CorporationN108AWAgusta AW139 · S/N 41006Cancelled Dec 31, 2007 · Exported to United Arab Emirates · Agusta Aerospace CorpN167AWAgusta A119 · S/N 14536Cancelled Nov 30, 2007 · Exported to Mexico · Built 2007 · Agusta Aerospace Corp
Back to Philadelphia, PA