Pittsburgh, PA
Cancelled registrations · 380
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 = 'PITTSBURGH' 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 = 'PITTSBURGH' 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.
N29647Taylorcraft BF · S/N 2488N89176Cessna 140 · S/N 8190N62PTWaters Peter T AVID BANDIT · S/N 1509EN84834Aeronca 7AC · S/N 7AC-3550N9200SBeech B24R · S/N MC-372N6BFSchleicher ASW-20C · S/N 20832N95MSHughes 369HS · S/N 1130536SN447JRRocca John C 1600R · S/N 001N2750ALafean Earle B JR LOEHLE · S/N 001N99022Engineering & Research ERCOUPE 415-C · S/N 1645N51346Fairchild M-62A · S/N T40-174N30811Piper J4A · S/N 41234N4476NHoward DGA-15P · S/N 710N89625Cessna 152 · S/N 15282804N172DGCessna 172N · S/N 17272124N25TZGates Learjet 25D · S/N 364N52745Boeing A75 · S/N 75194N8562GCessna 150F · S/N 15062662N9508YBeech 35-B33 · S/N CD-544N43342Taylorcraft BC12-D · S/N 7001N500CQGates Learjet 35A · S/N 620N711SGAero Commander 560-F · S/N 1054-21N9768TPiper PA-38-112 · S/N 38-78A0197N74NLPiper PA-31T · S/N 31T-7720010N757FNCessna 152 · S/N 15279706N45PAExperimental Aircraft Assn EVANS VP-1 · S/N 258N4046WBalloon Works FIREFLY 5 · S/N 512N3722WPiper PA-32-260 · S/N 32-634N1103ZHughes 369C · S/N 900809DN1534WBalloon Works FIREFLY 7 · S/N 10209N11RZZiesmer VOLKSPLANE · S/N VP222N6676BCessna 310C · S/N 35776N8203RFalgiani Wayne E FA-1 · S/N FA-1N3822WPiper PA-32-260 · S/N 32-754N97594Cessna 172P · S/N 17276214N6612BCessna 310B · S/N 35712N10506Cessna 150L · S/N 15074895N34NBBenson Donald G BENSON 791 · S/N 79001N136GFColt Balloons 105-A · S/N 1060N37166Balloon Works FIREFLY 7 · S/N F7-322N5661NMaule MX-7-235 · S/N 10019CN65700Lake LA-4-200 · S/N 605N8830ZCessna 172H · S/N 17255480N4055CCessna 310R · S/N 310R1359N2783CRaven S-60A · S/N S60A-357N59MDCessna 441 · S/N 441-0177N99TCLearjet 23 · S/N 098N6518RBeech B19 · S/N MB-708N6531QAlon A2 · S/N A-131N5720DPiper PA-22-150 · S/N 22-4418
Back to Pittsburgh, PA