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.
N2166KCessna 172S · S/N 172S9792N2017VHughes Helicopters HUGHES 369D · S/N 1100827DN8221HSchram B J ROTORWAY ELETE · S/N RW12N156YLockheed TV-2 · S/N 128705N96078Let BLANIK L-13 · S/N 025514N3885RCessna 172H · S/N 17255385N152RKKelsch Ronald M SORRELL SNS-8 · S/N 152N6620XCessna 210A · S/N 21057620N73983Bell 47G-2A-1 · S/N 2873N8FFCorrell Philip K VENUS TRIKE · S/N A001N830RNRaven S55A · S/N S55A-945N615BTCessna 210F · S/N 21058788N7256JPiper PA-28-140 · S/N 28-24599N5303DCameron Balloons US A-105 · S/N 6124N244GCChristopher Gary R CRI-CRI · S/N 2001-1N5101LPiper PA-28-180 · S/N 28-4385N5954Sud SA316B ALOUETTE III · S/N 1825N3423RCessna 182L · S/N 18258723N53751Cessna 172P · S/N 17274813N2305UFranklin John J CHALLENGER II · S/N CH2-0597-W-1616N231KMooney M20K · S/N 25-0004N2487XCessna 182H · S/N 18256387N2822UCessna 172D · S/N 17250422N4894BCessna 152 · S/N 15283695N5097UCessna 172RG · S/N 172RG0231N5569LRaven S55A · S/N S55A-573N807SBBell UH-1B · S/N 62-1960N6601FPiper PA-28R-201T · S/N 28R-7703003N2013MAvian Balloon MAGNUM IX · S/N 196N309FVBoeing 727-224 · S/N 20661N3350XMooney M20C · S/N 3369N2980SCessna 150G · S/N 15066880N3682ABalloon Works FIREFLY 8-24 · S/N F8-016N4033PHiller UH-12E · S/N 5178N6560DBeech D18S · S/N A-844N5191XChampion 7ECA · S/N 692N6443ZPiper PA-25 · S/N 25-603N1237PPiper U0-1 · S/N 23-258N63160Cessna 150M · S/N 15077147N69035Cessna 152 · S/N 15282450N214GCChristopher Gary R CRI-CRI 5B · S/N 9301N3LJPeden BREEZY · S/N 1-976N40196Raven S55A · S/N S55A-829N7022UBalloon Works FIREFLY 7 · S/N 11070N1151KLockheed 1329-23E · S/N 5115N425ACCessna 425 · S/N 425-0009N4361YPiper PA-25-235 · S/N 25-4866N30193Fairchild SA227-DC (C26B) · S/N DC-835MN9087FBalloon Works FIREFLY 8-24 · S/N F8-142N127BDDouglas William H RANS S-12 · S/N 1092295
Back to Phoenix, AZ