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.
N9616UGrumman American Avn. AA-1C · S/N AA1C0074N434SHAgustawestland Philadelphia AW139 · S/N 41341N300WMPiccard AX-6 · S/N 517N6122YPiper PA-23-250 · S/N 27-3333N8340CPiper PA-28-181 · S/N 28-7690118N430SHAgustawestland Philadelphia AW139 · S/N 41322N6436RPiper PA-28-140 · S/N 28-21617N6083XMooney M20A · S/N 1679N360BVBoeing Vertol 360 · S/N 001N20ANPiper PA-23-250 · S/N 27-4693N137MMAgustawestland Philadelphia AW139 · S/N 41330N146MMAgustawestland Philadelphia AW139 · S/N 41332N498SMAgustawestland Philadelphia AW139 · S/N 41313N98JCClevenger STARDUSTER SA-300 · S/N 579N8595WPiper PA-28-235 · S/N 28-10107N8880SCessna 150F · S/N 15062180N432SHAgustawestland Philadelphia AW139 · S/N 41325N8475GCessna 150F · S/N 15062575N502SMAgustawestland Philadelphia AW119MKII · S/N 14793N62497Piper PA-23-250 · S/N 27-7654021N63762Piper PA-23-250 · S/N 27-7754080N64492Thompson BOXMOTH · S/N 1N431SHAgustawestland Philadelphia AW139 · S/N 41324N506SMAgustawestland Philadelphia AW119MKII · S/N 14798N6279YPiper PA-23-250 · S/N 27-3525N314YSAgustawestland Philadelphia AW119MKII · S/N 14789N428SHAgustawestland Philadelphia AW139 · S/N 41319N311YSAgustawestland Philadelphia AW139 · S/N 41318N427SHAgustawestland Philadelphia AW139 · S/N 41315N497SMAgustawestland Philadelphia AW139 · S/N 41314N4379KRyan NAVION · S/N NAV-4-1379N10912Cessna 150L · S/N 15075127N5978YPiper PA-23-250 · S/N 27-3149N961Piasecki HRP-2 · S/N 3N69143Cessna T-50 · S/N 2717N2230HEngineering & Research ERCOUPE 415-C · S/N 2853N2978XCessna 177 · S/N 17700378N60845Stinson AT-19 · S/N 77205N544AFrontline Helicopter TEICHER · S/N 2N24567Beech C23 · S/N M-1411N213DLCessna 337 · S/N 337-0033N494SMAgustawestland Philadelphia AW119MKII · S/N 14788N798AAAgusta AW139 · S/N 31121N489SMAgustawestland Philadelphia AW119MKII · S/N 14785N41857Teicher HUMMINGBIRD · S/N 1N4025AStits Playboy SA3B · S/N 0W1N680ALAero Commander 680-F · S/N 680F-952-17N384SHAgusta Aerospace AW119 MKII · S/N 14771N487SMAgustawestland Philadelphia AW139 · S/N 41282N395SHAgusta Aerospace AW139 · S/N 41270
Back to Philadelphia, PA