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.

N509SHAgustawestland Philadelphia AW139 · S/N 41394Cancelled May 1, 2015 · Exported to Colombia · Agusta Westland Philadelphia CorpN238MMAgustawestland Philadelphia AW139 · S/N 41383Cancelled Mar 24, 2015 · Exported to Malaysia · Agustawestland Philadelphia CorpN513SHAgustawestland Philadelphia AW139 · S/N 41398Cancelled Mar 6, 2015 · Exported to Trinidad and Tobago · Agustawestland Philadelphia CorpN504SHAgustawestland Philadelphia AW139 · S/N 41395Cancelled Feb 26, 2015 · Exported to Trinidad and Tobago · Augustawestland Philadelphia CorpN496SHAgustawestland Philadelphia AW139 · S/N 41386Cancelled Feb 4, 2015 · Exported to Japan · Agustawestland Philadelphia CorpN251MMAgustawestland Philadelphia AW139 · S/N 41388Cancelled Jan 21, 2015 · Exported to France · Agusta Westland Philadelphia CorpN245MMAgustawestland Philadelphia AW139 · S/N 41387Cancelled Jan 20, 2015 · Exported to France · Agustawestland Philadelphia CorpN168MMAgustawestland Philadelphia AW119MKII · S/N 14825Cancelled Dec 22, 2014 · Exported to Australia · Built 2014 · Agustawestland Philadelphia CorpN20LCCessna 421C · S/N 421C0636Cancelled Dec 19, 2014 · Exported to Czech Republic · Keystone Aerial Surveys IncN52GFFeldman George J JR CGS HAWK A · S/N 52Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Feldman George JN4164GRaven S-60A · S/N S60A-191Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1982 · Boland Gary SN627SMAgustawestland Philadelphia AW139 · S/N 41376Cancelled Nov 24, 2014 · Exported to Malaysia · Agustawestland Philadelphia CorpN603SMAgustawestland Philadelphia AW139 · S/N 41378Cancelled Nov 19, 2014 · Exported to United Kingdom · Agustawestland Philadelphia CorpN6275WPiper PA-28-140 · S/N 28-20325Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1964 · Lapin GaryN65XEngle HPK · S/N 1Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1957 · Passamante Michael AN495SHAgustawestland Philadelphia AW139 · S/N 41385Cancelled Nov 5, 2014 · Exported to Japan · Agustawestland Philadelphia CorpN459SHAgustawestland Philadelphia AW139 · S/N 41347Cancelled Oct 17, 2014 · Exported to Benin · Built 2013 · Agustawestland Philadelphia CorpN497SHAgustawestland Philadelphia AW139 · S/N 41390Cancelled Oct 14, 2014 · Exported to Japan · Agustawestland Philadelphia CorpN625SMAgustawestland Philadelphia AW139 · S/N 41380Cancelled Oct 1, 2014 · Exported to Brazil · Agustawestland Philadelphia CorpN626SMAgustawestland Philadelphia AW139 · S/N 41382Cancelled Oct 1, 2014 · Exported to Brazil · Agustawestland Philadelphia CorpN3004LCessna 310J · S/N 310J0004Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1965 · J&G Const CoN493SHAgustawestland Philadelphia AW139 · S/N 41381Cancelled Sep 29, 2014 · Exported to Japan · Agustawestland Philadelphia CorpN488SHAgustawestland Philadelphia AW139 · S/N 41372Cancelled Jul 30, 2014 · Exported to Japan · Agustawestland Philadelphia CorpN385RHAgusta AW139 · S/N 41013Cancelled Jul 14, 2014 · Agustawestland Philadelphia CorpN18YCAgusta A119 · S/N 14004Cancelled Jul 7, 2014 · Built 1995 · Agustawestland Philadelphia CorpN490SHAgustawestland Philadelphia AW139 · S/N 41370Cancelled Jun 26, 2014 · Exported to Australia · Agustawestland Philadelphia CorpN489SHAgustawestland Philadelphia AW139 · S/N 41373Cancelled Jun 23, 2014 · Exported to Japan · Agustawestland Philadelphia CorpN473SHAgusta A109S · S/N 22104Cancelled Apr 23, 2014 · Exported to United Kingdom · Agustawestland Philadelphia CorpN167MMAgustawestland Philadelphia AW139 · S/N 41361Cancelled Apr 11, 2014 · Exported to Indonesia · Agustawestland Philadelphia CorpN467SHAgustawestland Philadelphia AW139 · S/N 41359Cancelled Mar 28, 2014 · Exported to Spain · Agustawestland Philadelphia CorpN611SMAgustawestland Philadelphia AW139 · S/N 41357Cancelled Mar 28, 2014 · Exported to Spain · Augustawestland Philadelphia CorpN148MMAgustawestland Philadelphia AW119MKII · S/N 14813Cancelled Feb 26, 2014 · Exported to Chile · Agustawestland Philadelphia CorpN152MMAgustawestland Philadelphia AW139 · S/N 41354Cancelled Jan 28, 2014 · Exported to Thailand · Agustawestland Philadelphia CorpN607SMAgustawestland Philadelphia AW119MKII · S/N 14816Cancelled Jan 24, 2014 · Exported to Brazil · Built 2013 · Agustawestland Philadelphia CorpN159MMAgustawestland Philadelphia AW119MKII · S/N 14815Cancelled Jan 17, 2014 · Exported to Russia · Agustawestland Philadelphia CorpN323YSAgustawestland Philadelphia AW119MKII · S/N 14805Cancelled Jan 17, 2014 · Exported to Algeria · Built 2013 · Agustawestland Philadelphia CorpN40259Piper PA-23-250 · S/N 27-7305069Cancelled Jan 15, 2014 · Third renewal notice · Built 1973 · Vincent F Licolli IncN605SMAgustawestland Philadelphia AW139 · S/N 41355Cancelled Dec 12, 2013 · Exported to United Kingdom · Agustawestland Philadelphia CorpN313YSAgustawestland Philadelphia AW119MKII · S/N 14787Cancelled Nov 25, 2013 · Exported to Algeria · Built 2012 · Agustawestland Philadelphia CorpN316YSAgustawestland Philadelphia AW119MKII · S/N 14794Cancelled Nov 25, 2013 · Exported to Algeria · Built 2013 · Agustawestland Philadelphia CorpN439SHAgustawestland Philadelphia AW139 · S/N 41349Cancelled Nov 15, 2013 · Exported to Japan · Agustawestland Philadelphia CorpN322YSAgustawestland Philadelphia AW119MKII · S/N 14803Cancelled Nov 14, 2013 · Exported to Algeria · Built 2013 · Agustawestland Philadelphia CorpN327YSAgustawestland Philadelphia AW139 · S/N 41348Cancelled Oct 30, 2013 · Exported to Malaysia · Agusta Westland Philadelphia CorpN451SHAgustawestland Philadelphia AW139 · S/N 41345Cancelled Oct 28, 2013 · Exported to Japan · Agustawestland Philadelphia CorpN6839ACessna 172 · S/N 28939Cancelled Oct 24, 2013 · Revoked, canceled · Built 1956 · Mroczek Joseph LN325YSAgustawestland Philadelphia AW119MKII · S/N 14797Cancelled Sep 26, 2013 · Exported to Algeria · Built 2013 · Agustawestland Philadelphia CorpN507SMAgustawestland Philadelphia AW119MKII · S/N 14796Cancelled Sep 26, 2013 · Exported to Algeria · Built 2013 · Agustawestland Philadelphia CorpN326YSAgustawestland Philadelphia AW139 · S/N 41342Cancelled Sep 18, 2013 · Exported to Malaysia · Agustawestland Philadelphia CorpN435SHAgustawestland Philadelphia AW139 · S/N 41344Cancelled Sep 13, 2013 · Exported to Tanzania · Agusta Westland Philadelphia CorpN438SHAgustawestland Philadelphia AW139 · S/N 41346Cancelled Sep 10, 2013 · Exported to Tanzania · Agustawestland Philadelphia Corp
Back to Philadelphia, PA