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.
N410SMAgusta Aerospace AW139 · S/N 41231N408SMAgusta A109S · S/N 22121N117YSAgusta AW139 · S/N 41207N248SMAgusta Aerospace AW139 · S/N 41212N403SMAgusta Aerospace AW139 · S/N 41220N361SHAgusta A109S · S/N 22142N302SHAgusta Aerospace AW119 MKII · S/N 14724N257ABeech G35 · S/N D-4809N9537Hooper BENSEN B-8M · S/N GP-203N249SMAgusta Aerospace AW139 · S/N 41214N405SMAgusta Aerospace AW139 · S/N 41218N225SMAgusta Aerospace AW139 · S/N 41213N341SHAgusta Aerospace AW139 · S/N 41215N395GPAgusta Aerospace AW139 · S/N 41217N139DHAgusta Aerospace AW139 · S/N 41209N2265BLuscombe 8A · S/N 6692N103YSAgusta Aerospace AW119 MKII · S/N 14738N111YSAgusta Aerospace AW119 MKII · S/N 14732N236SMAgusta A109E · S/N 11760N105YSAgusta A109S · S/N 22110N296SHAgusta Aerospace AW119 MKII · S/N 14720N980GPPreiss Robert TWINSTAR MK III XTRA · S/N M3X0020003N114YSAgusta AW139 · S/N 41205N106YSAgusta Aerospace AW119 MKII · S/N 14727N107YSAgusta Aerospace AW119 MKII · S/N 14728N108YSAgusta Aerospace AW119 MKII · S/N 14729N109YSAgusta Aerospace AW119 MKII · S/N 14730N112YSAgusta AW139 · S/N 41204N292SHAgusta Aerospace AW119 MKII · S/N 14712N531AMAgusta Aerospace AW119 MKII · S/N 14718N297SHAgusta Aerospace AW119 MKII · S/N 14722N332SHAgusta AW139 · S/N 41022N330SHAgusta AW139 · S/N 41020N331SHAgusta A109E · S/N 11736N294SHAgusta Aerospace AW119 MKII · S/N 14717N291SHAgusta Aerospace AW119 MKII · S/N 14710N126AWAgusta Aerospace AW119 MKII · S/N 14715N325SHAgusta AW139 · S/N 41017N216SHAgusta Aerospace AW119 MKII · S/N 14708N279SHAgusta Aerospace AW119 MKII · S/N 14709N162SHAgusta Aerospace AW119 MKII · S/N 14707N809SMAgusta Aerospace A119 · S/N 14537N25CKPiper PA-38-112 · S/N 38-81A0062N141AWAgusta AW139 · S/N 41011N80MEAgusta Aerospace AW119 MKII · S/N 14705N88MEAgusta Aerospace AW119 MKII · S/N 14706N52MEAgusta Aerospace AW119 MKII · S/N 14702N60MEAgusta Aerospace AW119 MKII · S/N 14703N108AWAgusta AW139 · S/N 41006N167AWAgusta A119 · S/N 14536
Back to Philadelphia, PA