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.
N27EHCessna 335 · S/N 335-0052N1846NCessna 120 · S/N 12090N4909TCessna TR182 · S/N R18201787N91RRPipistrel D O O VIRUS SW 121C · S/N VSWX121C0106N52799Cessna 182P · S/N 18262854N8211UCessna 172F · S/N 17252111N530FMcdonnell Douglas Heli 369FF · S/N 0066FFN400RWPiper PA-24-400 · S/N 26-63N4351TPiper PA-28-140 · S/N 28-7225155N704LDCessna 150M · S/N 15078688N583MBBeech 58TC · S/N TK-150N312UASpektreworks COBALT-CR · S/N CBCR-2B-0823-GVTOL-512N313UASpektreworks COBALT-CR · S/N CBCR-2B-0823-GVTOL-513N40WTextron 525 · S/N 525-1000N8FZSchempp-Hirth K G MINI-NIMBUS C · S/N 118N705CPCessna 182T · S/N 18281705N554GPBombardier BD-700-1A11 · S/N 60109N8467XPiper PA-34-220T · S/N 34-8233034N307PHEurocopter Deutschland EC 135 P2 · S/N 0398N79077Cessna 172K · S/N 17257865N5MMckenzie Greg LANCAIR IV-P TURBINE · S/N LIV-490N400HCCessna 340A · S/N 340A0705N788JCPiper PA-32RT-300T · S/N 32R-7887275N109HWWolfe H/Wolfe B 320 FB LANCAIR · S/N 795N2103QCessna 177RG · S/N 177RG0503N344TWPiper PA-34-200 · S/N 34-7350061N965DSDiamond Aircraft Ind DA 40 · S/N 40.1035N967DSDiamond Aircraft Ind DA 40 · S/N 40.1036N8694WPiper PA-28-235 · S/N 28-10227N3162NCessna 140 · S/N 13420N916CPCessna 172S · S/N 172S8336N5554QMooney M20E · S/N 630N725PTHall Tom LANCAIR IV-P · S/N 1011N4947UCessna 210E · S/N 21058647N62368Cessna 310R · S/N 310R0131N59WPDJI INSPIRE 2 · S/N 09YDFBC0040514N47BPCessna 340 · S/N 340-0223N4888WRockwell International 114 · S/N 14218N497WPWSK PZL Mielec M-18A · S/N 1Z015-05N499WPWSK PZL Mielec M-18A · S/N 1Z013-27N27DMMuxlow PITTS S-1C · S/N 1970DMN405RAerospatiale SA330J · S/N 1475N65423Cameron Balloons Z-133 · S/N 6676N70RJPiper PA-23-160 · S/N 23-1503N9566CMidniter B-1 · S/N BB-1N1671JPiper PA-28-140 · S/N 28-24072N9388XCessna 182R · S/N 18268509N93845Cessna 210L · S/N 21060432N20USPipistrel Doo Ajdovscina VIRUS SW · S/N 877 SWN 100 ISN609LBArbc Inc DBA Lindstrand 120A · S/N 5522
Back to Phoenix, AZ