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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N404JZAgustawestland Philadelphia AW139 · S/N 41502N639SSAgustawestland Philadelphia AW119MKII · S/N 14912N564SHAgusta A109E · S/N 11171N287MMAgustawestland Philadelphia AW119MKII · S/N 14901N642SSAgustawestland Philadelphia AW119MKII · S/N 14913N412PGDassault-Breguet FALCON 50 · S/N 97N641SSAgustawestland Philadelphia AW139 · S/N 41523N643SSAgustawestland Philadelphia AW139 · S/N 41524N644SSAgustawestland Philadelphia AW139 · S/N 41525N633SSAgustawestland Philadelphia AW119MKII · S/N 14911N629SSAgustawestland Philadelphia AW139 · S/N 41520N637SSAgustawestland Philadelphia AW139 · S/N 41522N10197Hiller UH-12C · S/N 803N588SHAgustawestland Philadelphia AW139 · S/N 41518N626SSAgustawestland Philadelphia AW119KX · S/N 14908N592SHAgustawestland Philadelphia AW139 · S/N 41519N625SSAgustawestland Philadelphia AW119KX · S/N 14907N624SSAgustawestland Philadelphia AW119KX · S/N 14903N237MHAgustawestland Philadelphia AW119MKII · S/N 14904N586SHAgustawestland Philadelphia AW139 · S/N 41514N308MMAgustawestland Philadelphia AW139 · S/N 41512N211JSAgustawestland Philadelphia AW119MKII · S/N 14905N587SHAgustawestland Philadelphia AW139 · S/N 41515N296MMAgustawestland Philadelphia AW139 · S/N 41510N622SSAgustawestland Philadelphia AW119MKII · S/N 14843N614SSAgustawestland Philadelphia AW119MKII · S/N 14845N278MMAgustawestland Philadelphia AW139 · S/N 41505N279MMAgustawestland Philadelphia AW139 · S/N 41507N561SHAgustawestland Philadelphia AW119MKII · S/N 14841N612SSAgustawestland Philadelphia AW119MKII · S/N 14844N608SSAgustawestland Philadelphia AW119MKII · S/N 14842N401JZAgustawestland Philadelphia AW139 · S/N 41399N6186RCessna T210F · S/N T210-0086N87552Raytheon 1900D · S/N UE-216N262MMAgustawestland Philadelphia AW139 · S/N 41404N582SHAgustawestland Philadelphia AW119MKII · S/N 14840N583SHAgustawestland Philadelphia AW139 · S/N 41506N273MMAgustawestland Philadelphia AW139 · S/N 41405N565SHAgustawestland Philadelphia AW119MKII · S/N 14838N566SHAgustawestland Philadelphia AW139 · S/N 41408N195NTAgustawestland Philadelphia AW119MKII · S/N 14790N193NTAgusta Aerospace AW119 MKII · S/N 14780N265MMAgustawestland Philadelphia AW139 · S/N 41403N257MMAgustawestland Philadelphia AW139 · S/N 41400N264MMAgustawestland Philadelphia AW139 · S/N 41401N3834VCessna 150M · S/N 15076634N2057RBoeing CH47-414 · S/N M4478N901AVPiper PA-28RT-201 · S/N 28R-8118028N263MMAgustawestland Philadelphia AW139 · S/N 41396N40018Consolidated Vultee BT-13 · S/N 10547
Back to Philadelphia, PA