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.
N1526DBalloon Works FIREFLY 7 · S/N 11090N103WRRuehle HP-18 · S/N WHR-3N36EXUltramagic S A N-250 · S/N 250/31N44809Dist 876 Annandale School ACRO SPORT · S/N 502N23728Cahill Mark G SABRE · S/N MC0068N2459KCessna 172S · S/N 172S10034N63348Consolidated Vultee BT-13A · S/N 3457N7628PPiper PA-24-250 · S/N 24-2838N8999TCessna 182C · S/N 52899N90235Beech SNB-5 · S/N 67324N5141VMorrisey 2150A · S/N SP37N1931KLuscombe 8A · S/N 4658N5954DPiper PA-22-150 · S/N 22-4618N604BHBeech 60 · S/N P-38N653LCCravens Larry L C-653 · S/N C653-001N504JPAirbus Industrie A320-231 · S/N 322N28398Grumman American Avn. AA-5B · S/N AA5B0590N1363MAir Creation GTE · S/N T06014N308CBCameron Balloons V-77 · S/N 344N93FPiper PA-24-180 · S/N 24-1057N38099Texas Helicopter OH-13E/M74 · S/N 77-006N61050Fairchild SA227-DC (C26B) · S/N DC-834MN4304YPiper PA-23-160 · S/N 23-2027N7RSsbm CF-5D · S/N 116837N9PSsbm CF-5D · S/N 116823N6131ZFairchild SA227-DC (C26B) · S/N DC803MN191MHHigginbotham Mark Oneill RANS S-9 · S/N 1005191N481CAPiper PA-32R-301T · S/N 3257081N9504YCameron Balloons US V-77 · S/N 5626N2904FRaven Industries S77A · S/N S77A-118N7445RPiper PA-28-140 · S/N 28-21986N4194FRaven Industries S-66A · S/N S66A-134N3289XCessna 310L · S/N 310L-0139N4059KBalloon Works FIREFLY 7 · S/N 7962N1677APiper PA-22 · S/N 22-439N422TRKurtzman Chad CHALLENGER II · S/N CH2-0804-2519N4279ASchempp-Hirth STANDARD AUSTRIA SH1 · S/N 60N7672MCessna 175 · S/N 55972N301MCessna 195 · S/N 7772N518SHHickam Steven A QUICKIE-1 · S/N 518N5281ZPiper PA-22-108 · S/N 22-8976N90141Balloon Works FIREFLY 8-24 · S/N F8-140N324PSBeechcraft TC-12B · S/N 161510N3487TCessna 177 · S/N 17700787N48EXUltramagic S A N-250 · S/N 250/55N91PLCessna 210L · S/N 21060477N54177Cirrus Design SR20 · S/N 1496N669JCCupp Jackie M CASSUTT SPECIAL · S/N JC4N72954Dooley Philip E WAG AERO SPT TRAINER · S/N PD001N906Cobb Intl/DBA Rotorway Intl IN EXEC 162F · S/N 6050
Back to Phoenix, AZ