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.
N509SHAgustawestland Philadelphia AW139 · S/N 41394N238MMAgustawestland Philadelphia AW139 · S/N 41383N513SHAgustawestland Philadelphia AW139 · S/N 41398N504SHAgustawestland Philadelphia AW139 · S/N 41395N496SHAgustawestland Philadelphia AW139 · S/N 41386N251MMAgustawestland Philadelphia AW139 · S/N 41388N245MMAgustawestland Philadelphia AW139 · S/N 41387N168MMAgustawestland Philadelphia AW119MKII · S/N 14825N20LCCessna 421C · S/N 421C0636N52GFFeldman George J JR CGS HAWK A · S/N 52N4164GRaven S-60A · S/N S60A-191N627SMAgustawestland Philadelphia AW139 · S/N 41376N603SMAgustawestland Philadelphia AW139 · S/N 41378N6275WPiper PA-28-140 · S/N 28-20325N65XEngle HPK · S/N 1N495SHAgustawestland Philadelphia AW139 · S/N 41385N459SHAgustawestland Philadelphia AW139 · S/N 41347N497SHAgustawestland Philadelphia AW139 · S/N 41390N625SMAgustawestland Philadelphia AW139 · S/N 41380N626SMAgustawestland Philadelphia AW139 · S/N 41382N3004LCessna 310J · S/N 310J0004N493SHAgustawestland Philadelphia AW139 · S/N 41381N488SHAgustawestland Philadelphia AW139 · S/N 41372N385RHAgusta AW139 · S/N 41013N18YCAgusta A119 · S/N 14004N490SHAgustawestland Philadelphia AW139 · S/N 41370N489SHAgustawestland Philadelphia AW139 · S/N 41373N473SHAgusta A109S · S/N 22104N167MMAgustawestland Philadelphia AW139 · S/N 41361N467SHAgustawestland Philadelphia AW139 · S/N 41359N611SMAgustawestland Philadelphia AW139 · S/N 41357N148MMAgustawestland Philadelphia AW119MKII · S/N 14813N152MMAgustawestland Philadelphia AW139 · S/N 41354N607SMAgustawestland Philadelphia AW119MKII · S/N 14816N159MMAgustawestland Philadelphia AW119MKII · S/N 14815N323YSAgustawestland Philadelphia AW119MKII · S/N 14805N40259Piper PA-23-250 · S/N 27-7305069N605SMAgustawestland Philadelphia AW139 · S/N 41355N313YSAgustawestland Philadelphia AW119MKII · S/N 14787N316YSAgustawestland Philadelphia AW119MKII · S/N 14794N439SHAgustawestland Philadelphia AW139 · S/N 41349N322YSAgustawestland Philadelphia AW119MKII · S/N 14803N327YSAgustawestland Philadelphia AW139 · S/N 41348N451SHAgustawestland Philadelphia AW139 · S/N 41345N6839ACessna 172 · S/N 28939N325YSAgustawestland Philadelphia AW119MKII · S/N 14797N507SMAgustawestland Philadelphia AW119MKII · S/N 14796N326YSAgustawestland Philadelphia AW139 · S/N 41342N435SHAgustawestland Philadelphia AW139 · S/N 41344N438SHAgustawestland Philadelphia AW139 · S/N 41346
Back to Philadelphia, PA