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.
N4858ZPiper PA-22-108 · S/N 22-8434N8010XCameron Balloons US A-250 · S/N 6266N97BPCessna 404 · S/N 404-0085N32KGGray Ken 2000 GTX-SEFI · S/N H2-99-10-419N901AJSchleicher ASW-27 · S/N 27191N9989ZBannick-Copter T · S/N 1N9157KStinson 108-1 · S/N 1082157N500NXPiper PA46-500TP · S/N 4697590N3103APiper PA46-500TP · S/N 4697190N6887CFairchild C-82A · S/N 44-23015N7529CForney 415-CD · S/N 5644N7633TCessna 172A · S/N 47233N8486ABeech A35 · S/N D-2016N90232Beech SNB-5 · S/N 39768N90625Let BLANIK L-13 · S/N 025621N91300Lockheed F-5G · S/N 5266N9654CConsolidated Vultee P4Y-2 · S/N 66252N6094GPiper PA 46-350P · S/N 4636460N51EXUltramagic S A N-250 · S/N 250/57N57EXUltramagic S A N-250 · S/N 250/59N60EXUltramagic S A N-250 · S/N 250/71N41FBCessna 310R · S/N 310R0666N101VCCanadair T33-MK3 · S/N 101N5155CBeech B35 · S/N D-2440N5428ACessna 310B · S/N 35628N6UNUltramagic S A N-250 · S/N 250/47N69105Piper PA-28-161 · S/N 28-8516054N3037VCameron Balloons US A-250 · S/N 6052N871DRedfield Scott F CHALLENGER II · S/N CH2-0105-2578N2047HFirefly Balloons FIREFLY 11 · S/N F11-2005N297ATBeech 58 · S/N TH1349N85AVSocata TB-20 TRINIDAD · S/N 458N5931RCessna 172G · S/N 17253600N7361BBeech E35 · S/N D-3824N1272DCessna 170A · S/N 19848N2700QCessna 182K · S/N 18257900N4302PPiper PA-23-160 · S/N 23-1803N4397KRaven S-60A · S/N S60A-338N162CGAmerican Champion 7GCBC · S/N 1453-2009N4107HCameron Balloons US A-210 · S/N 6109N6568WPiper PA-28-140 · S/N 28-21271N6706UBeech 77 · S/N WA-52N75148Piper PA-28-151 · S/N 28-7615259N77227Cessna 140 · S/N 11689N8233YPiper PA-30 · S/N 30-1359N8815HNorth American NAVION · S/N NAV-4-815N9554JPiper PA-28-180 · S/N 28-3684N9667CCessna T303 · S/N T30300200N144ZVBeech 1900D · S/N UE-144N166SEDiamond Aircraft Ind DA20-C1 · S/N C0266
Back to Phoenix, AZ