Phoenix, AZ
Cancelled registrations · 1,583
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 = 'AZ' AND d.registrant_city = 'PHOENIX' 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 = 'AZ' AND d.registrant_city = 'PHOENIX' 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.
N191TSWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF20900902N1368VCampbell Lucky QUICKSIVER MX · S/N 3027N95375Taylorcraft BC12-D · S/N 9775N74737Bell 47D1 · S/N 415N74DPPiccard AX-6 · S/N 721N77MERaven S55A · S/N S-55A-327N7967FCessna 150F · S/N 15064067N439JPPastorello Joseph F BENSEN BM-1 · S/N 1N6752DBell 47G-2 · S/N 2243N7118VBalloon Works FIREFLY 8B · S/N F8B-136N28387Bowlus BA-100 · S/N 165N6267MMaule M-5-235C · S/N 7217CN5363XCessna TU206G · S/N U20605679N7023CGunn William B DRAGONFLY · S/N 4415N910KJHughes 269B · S/N 1250224N247ABGrumman G-1159 · S/N 208N51530Raven S-50A · S/N S50A-220N101LXBurton Larry Alan FLY BABY · S/N LBX101N1933YMooney M20E · S/N 240N2815SRaven Industries S-55A · S/N S55A-1108N2816JRaven Industries S-60A · S/N S60A-426N2848GRaven Industries S-60A · S/N S60A-435N74193Balloon Works FIREFLY 7 · S/N F7-300N2595ZBertram Allen QUICKSILVER MX II · S/N 3160N39699Battersby Joe MITCHELL T-10 · S/N T-156N51130Stinson L-5 · S/N 76-483N1875NCessna 120 · S/N 12119N36221Aerostar International RAVEN S57-A · S/N S57A-3082N423ESCessna 172R · S/N 17280258N42CRCessna T210L · S/N 21059701N1349BHiller UH-12E4 · S/N 2119N3LVAtkinson Vance VARIEZE · S/N 1N4030GRaven Industries RALLY RX7 · S/N RX7-266N54524Sikorsky S-58 · S/N 143946N6557ZAerostar International RAVEN S57-A · S/N S57A-3013N9370ECessna 182R · S/N 18268404N9097ZPiper PA-28-161 · S/N 28-8616023N4038GPiper PA-31-325 · S/N 31-8112011N97417Stinson 108 · S/N 108-417N929SHHughes 269B · S/N 106-0272N93000Schempp-Hirth K8B · S/N 8364N3368PPiper PA-23-160 · S/N 23-1325N86751Bellanca 14-13-3 · S/N 1112N8876NPiper PA-28-140 · S/N 28-25739N81657Aeronca 7AC · S/N 7AC-277N5492YPiper PA-23-250 · S/N 27-2585N6443DAerostar International S-60A · S/N S60A-3038N7690VAero Commander CALLAIR A-9B · S/N 1443N61JNNoyce Jerry D MXL II · S/N 1661N759YFCessna 182Q · S/N 18266359
Back to Phoenix, AZ