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.

N4988ZPiper PA-22-108 · S/N 22-8596Cancelled May 13, 2015 · Sale reported, canceledN70JSLittle Taggart K LONG-EZ · S/N 1742SN19A2107Cancelled May 13, 2015 · Registration expired, pending cancellation · Little Taggert KN5403UBeech B-60 · S/N P-306Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1974 · H I M LLCN757MVCessna 152 · S/N 15279857Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1977 · Bales Thomas EN433JCBeech 35-A33 · S/N CD-351Cancelled May 11, 2015 · Sale reported, canceled · Built 1961N5184WPiper PA-28-160 · S/N 28-219Cancelled May 11, 2015 · Sale reported, canceled · Built 1961N54WSSweet Wayne A BUSHBY MUSTANG II · S/N WS-1Cancelled May 11, 2015 · Sale reported, canceled · Built 1991N56DSSchafer Dennis LANCAIR 360 · S/N 001Cancelled May 11, 2015 · Registration expired, pending cancellation · Testa Sheree LN582JJabiru USA Sport J170-SP · S/N 89Cancelled May 11, 2015 · Sale reported, canceled · Built 2006N6285ECessna 172 · S/N 46385Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1959 · Witt Tom CN62TWSchempp-Hirth VENTUS-2B · S/N 140Cancelled May 11, 2015 · Sale reported, canceled · Built 2002N8554WPiper PA-28-235 · S/N 28-10067Cancelled May 11, 2015 · Sale reported, canceled · Built 1963N112SQPromavia JET SQUALUS F1300 · S/N 001Cancelled May 8, 2015 · Registration expired, pending cancellation · Jet Recon Services IncN3468QCessna 320E · S/N 320E-0068Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1966 · Trans-Plant Enterprises IncN3233UCook Norman J ZENITH TRI Z · S/N 3-422Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1984 · Permoda Edward JN333STBetter Burn LLC/Startube Div EXEC 162F · S/N 6755Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 2004 · Cobb International DBAN2207WParadise Air LANCAIR 4P · S/N LIV-378Cancelled May 5, 2015 · Registration expired, pending cancellation · Paradise Air LLCN3757UCessna-Thunderbird A-37A · S/N 67-14535Cancelled May 5, 2015 · Registration expired, pending cancellation · Thunderbird Avn IncN7863ZCessna 150C · S/N 15059963Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1963 · Stewart James WilliamN15RLovings Love B · S/N 100Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1960 · Harding Harvard KN2983JCameron Balloons US V-77 · S/N 5155Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1985 · Pitcher Dorothy AN59EXUltramagic S A N-250 · S/N 250/61Cancelled Apr 28, 2015 · Mars LeasingN4520DHead Balloons AX9 118 · S/N 164Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1990 · Peek JamesN8681SCessna 150 · S/N 15061981Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1965 · Flying Ten Flying ClubN212MRJankowski Michael L HARMON ROCKET II · S/N 393Cancelled Apr 17, 2015 · Third renewal notice · Jankowski Michael LN30049Ultramagic S A N-250 · S/N 250/16Cancelled Mar 2, 2015 · Mars Leasing IncN837TCThunder & Colt Airborne Amer COLT 240A · S/N 2652USACancelled Mar 2, 2015 · Built 1995 · Mars LeasingN4877UCessna TU206G · S/N U20605135Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1979 · Garvin Fire Protection Systems IncN5684NRaven S55A · S/N S55A-523Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1979 · Arizona Balloon CoN35EXUltramagic S A N-250 · S/N 250/30Cancelled Dec 18, 2014 · First renewal notice · Built 2004 · Mars Leasing Co IncN574HEnstrom F-28C · S/N 361Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1976N6231XCessna 340A · S/N 340A0432Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1977 · Hagerman R DN57879Boeing A75 · S/N 75-1145Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1941 · Morris John AN532MACostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 251Cancelled Dec 3, 2014 · Sale reported, canceled · Built 2007N160SWPiper PA-31-350 · S/N 31-7405176Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1974 · Express Air IncN8344Apex CROSS 5 · S/N 824Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1998 · Foster R DouglasN41ELCosmos PHASE III · S/N B-21501Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 2002 · Wells Fred CN86UDouglas C-47A · S/N 13073Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1944 · Freefall Enterprises IncN8898CPiper PA-22 · S/N 22-1477Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1953 · Hargraves Ronald WN48LLBell 47G-3B-1 · S/N 2823Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1963 · Global Aeronautical Museum IncN8111EMooney M20A · S/N 1382Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1959 · Thomas Jackie RN811RRRohrstaff HOMEBUILT · S/N 1Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Schaaf Garnett LN140FFFones Frederick H Z-MAX 1300 · S/N 1575-PCancelled Nov 17, 2014 · Registration expired, pending cancellation · Fones Frederick HenryN4397LRaven S-60A · S/N S60A-339Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Arizona Balloon CompanyN6331PPiper PA-24-180 · S/N 24-1175Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1959 · Adams Robert DN6350WPiper PA-28-140 · S/N 28-20408Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1964 · Pyatt William HN555MBCessna 680 · S/N 680-0337Cancelled Nov 6, 2014 · Exported to Canada · Built 2012 · Premiere Servicing Consulting Group LLCN131BJDornier Werke BU 131 · S/N 23Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1938 · Brinkop GeorgeN63553Cessna 150M · S/N 15077391Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Shepard William EN514SFBell 47G-2 · S/N 30Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1947 · Global Aeronautical Museum Inc
Back to Phoenix, AZ