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.
N483SMAgusta Aerospace AW119 MKII · S/N 14778N486SMAgustawestland Philadelphia AW119MKII · S/N 14781N57062Aero Commander 500 S · S/N 3172N201YSAgusta Aerospace AW119 MKII · S/N 14743N406SHAgustawestland Philadelphia AW139 · S/N 41279N404SHAgustawestland Philadelphia AW139 · S/N 41274N480SMAgusta AW139 · S/N 41007N403SHAgustawestland Philadelphia AW139 · S/N 41275N219YSAgusta Aerospace AW119 MKII · S/N 14776N301YSAgusta Aerospace AW119 MKII · S/N 14775N4145TCessna 320D · S/N 320D0045N998AAAgusta AW139 · S/N 31142N378SHAgusta Aerospace AW119 MKII · S/N 14766N31645Howard DGA-18 · S/N 645N391SHAgusta Aerospace AW119 MKII · S/N 14772N305YSAgusta Aerospace AW139 · S/N 41267N366SHAgusta Aerospace AW119 MKII · S/N 14759N218YSAgusta Aerospace AW119 MKII · S/N 14767N376SHAgusta Aerospace AW119 MKII · S/N 14764N478SMAgusta Aerospace AW139 · S/N 41257N470SMAgusta Aerospace AW139 · S/N 41250N209YSAgusta AW139 · S/N 31283N215YSAgusta AW139 · S/N 31277N468SMAgusta Aerospace AW139 · S/N 41247N467SMAgusta Aerospace AW139 · S/N 41245N211YSAgusta Aerospace AW119 MKII · S/N 14763N466SMAgusta Aerospace AW119 MKII · S/N 14758N377SHAgusta Aerospace AW119 MKII · S/N 14765N257GTSocata TB-20 TRINIDAD · S/N 2057N458SMAgusta Aerospace AW139 · S/N 41238N374SHAgusta Aerospace AW119 MKII · S/N 14762N419SMAgusta Aerospace AW139 · S/N 41227N453SMAgusta Aerospace AW139 · S/N 41230N461SMAgusta Aerospace AW119 MKII · S/N 14755N455SMAgusta Aerospace AW139 · S/N 41236N454SMAgusta Aerospace AW139 · S/N 41232N459SMAgusta Aerospace AW139 · S/N 41241N460SMAgusta Aerospace AW139 · S/N 41248N368SHAgusta Aerospace AW139 · S/N 41228N372SHAgusta A109S · S/N 22165N417SMAgusta Aerospace AW139 · S/N 41226N204YSAgusta A109S · S/N 22160N370SHAgusta Aerospace AW139 · S/N 41233N363SHAgusta Aerospace AW119 MKII · S/N 14748N413SMAgusta Aerospace AW139 · S/N 41225N420SMAgusta Aerospace AW139 · S/N 41222N207YSAgusta Aerospace AW119 MKII · S/N 14754N346SHAgusta Aerospace AW119 MKII · S/N 14749N202YSAgusta Aerospace AW119 MKII · S/N 14752N203YSAgusta Aerospace AW119 MKII · S/N 14753
Back to Philadelphia, PA