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.

N272EFCessna T210K · S/N 21059302Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1970 · N9402m Aviation LLCN302AHUrban UFM 13 LAMBADA · S/N 13/13Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 2002 · Fly By Night Holdings LLCN1294DCameron Balloons Z-90 · S/N 6415Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Kbi Leasing LLCN20107Beech 76 · S/N ME-69Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1978 · G Michael Lewin CorporationN1112Stinson L-5E · S/N 44-17570Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1944 · Gray James HN90620Battle Martin Patrick A · S/N 1Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Battle Martin PN952RSSampson Robert L SPITFIRE II · S/N 9052SCancelled Mar 9, 2018 · Registration expired, pending cancellation · Samson Robert LN158ZXComstock Bill TUKAN · S/N WLC001Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Comstock William LN598WComstock Bill TUKAN · S/N WLC002Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Comstock William LN985KBBalony Kubicek Spol Sro BB100Z · S/N 985Cancelled Mar 8, 2018 · Built 2013 · Mars Leasing Corp IncN5376GBeech T-34A · S/N 34-91Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1955 · Stilwell Floyd TrusteeN6455QMooney M20F · S/N 670534Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1967 · West Coast Properties LLCN38EXUltramagic S A N-250 · S/N 250/51Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 2008 · Mars Leasing Corp IncN98DBPiper PA-46-310P · S/N 46-8608052Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1986 · Expomex LLCN14UTFreeman C R JR CHALLENGER II · S/N CH2-0789-0444Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1989 · Freeman Cecil R JrN1800YEdward Knesl KOLB MARK III · S/N M3 266Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Knesl Edward EN74ESRaudenbush Ernie LANCAIR SUPER ES · S/N KIT74Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 2000 · Snider Richard O JrN4890WRockwell International 114 · S/N 14220Cancelled Feb 21, 2018 · Sale reported, canceledN60005Lindstrand Balloons 90A · S/N 5143Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 2000 · Mars LeasingN714RECessna 150M · S/N 15079368Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1977 · Tipton Tracy JN642PTWetmore P L/Vallee T VELOCITY RG ELITE · S/N 1Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1999 · AllianceN15QCPiper PA-31-325 · S/N 31-7812006Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1977N2092KPiper PA-44-180 · S/N 44-7995178Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1978N2559ZPiper PA-23-250 · S/N 27-8054050Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1980N3608NBalloon Works FIREFLY 7-B · S/N F7B-065Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1983 · Kub Vincent AN4095CStinson 108-3 · S/N 108-5095Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1950N412EEBeech A36 · S/N E-264Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1971N6271UMooney M20C · S/N 2110Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1962N701CBMulloy Charles STOL CH 701 · S/N 73899Cancelled Feb 15, 2018 · Sale reported, canceled · Built 2002N9641XCessna 210B · S/N 21057941Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1962N979DCDiamond Aircraft Ind DA20-C1 · S/N C0314Cancelled Feb 15, 2018 · Sale reported, canceled · Built 2005N3021PLindstrand Balloons 90A · S/N 5091Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1998 · Mars Leasing IncN310RBCessna 310N · S/N 310N0089Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Cassels BillN31EXUltramagic S A N-250 · S/N 250/50Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Mars Leasing IncN7505WLindstrand Balloons 105A · S/N 5238Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2003 · Mars Leasing IncN20DSSmith PITTS SPECIAL S-1 · S/N 296-HCancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1973 · Perry Raymond PN81ELCosmos PHASE II · S/N B-21257Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1997 · Wells Fred CN75204Hiller UH-12E · S/N 1276Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1961 · Hall William WN7520NCessna TU206G · S/N U20603663Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Hernandez David PN622PACessna 152 · S/N 15281073Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1977 · Dgv Holdings Inc DBAN44628Piper PA-28-140 · S/N 28-7425434Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1974 · World And Hawaii Property Service Corp TrusteeN5047CAerostar International S-71A · S/N S71A-3022Cancelled Jan 23, 2018 · Built 1999 · Mars Leasing IncN722JRenaissance Acft 8-F · S/N RA0001Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Msj LLCN4VKVarga 2180 · S/N VAC187-82Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Donaldson Davy KN31ELCosmos ECHO · S/N M-0086Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2002 · Wells Fred CN3447ZPiper PA-22-160 · S/N 22-7366Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1960 · Lash Richard WN3516HErcoupe 415-CD · S/N 4141Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1948 · Hiett CraigN1503KBalloon Works FIREFLY 7 · S/N 11149Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1982 · Miller Jeremiah ScottN176BT17633 162F · S/N 6144Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1996 · 17633 Inc DBAN231NWMooney M20K · S/N 25-0333Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1980 · Baize Enterprises Inc
Back to Phoenix, AZ