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.

N1137YCessna 172M · S/N 17265149Cancelled Jun 19, 2002 · Exported to Mexico · Built 1975 · Covarrubias Jorge AN92GLEmbraer EMB-120ER · S/N 120.092Cancelled May 14, 2002 · Exported to Slovak Republic · Built 1988 · Finova Capital CorporationN5683KRaven S55A · S/N S55A-512Cancelled Apr 25, 2002 · Triennial form not returned · Built 1979 · Newnam James AN2819Jorden Harper B-8M · S/N 1Cancelled Apr 24, 2002 · Registration revoked · Built 1968 · Jorden William R PtnrN8138MMiller Chuck MILLER SPECIAL · S/N 01DCMCancelled Feb 25, 2002 · Triennial form not returned · Miller ChuckN6241BCessna T210M · S/N 21062719Cancelled Jan 8, 2002 · Exported to Mexico · Built 1978 · Westwind Aviation IncN723VVolk Ray KITFOX S5 · S/N S 9609-0193Cancelled Oct 25, 2001 · Triennial form not returned · Built 1999 · Volk RayN756LKCessna U206G · S/N U20604174Cancelled Oct 24, 2001 · Exported to Mexico · Built 1978 · Westwind Aviation IncN820BTTrent Bill KIT FOX SERIES 5 · S/N S9502-0101Cancelled Oct 10, 2001 · Sale reported · Built 1997N9439MCessna 207A · S/N 20700690Cancelled Sep 6, 2001 · Built 1981 · White Mountain Aero Group LLCN92WTTreadway James A PROTECH PT2 · S/N PT1146Cancelled Sep 5, 2001 · Crieco James DN16HBByrd Hershal O RANS S-12XL · S/N 09970815Cancelled May 18, 2001 · Byrd Hershal ON767AAAerostar International S-60A · S/N S60A-3080Cancelled May 12, 2001 · Paulson David HN351PABoeing 727-225 · S/N 20614Cancelled Apr 23, 2001 · Triennial form not returned · Finova Capital CorpN9322ZCessna TU206G · S/N U20606390Cancelled Mar 7, 2001 · Second triennial mailing, no response · Built 1981 · Central Az Water Conservation DistN9291TDavis Philip K RANS S-9 · S/N 0695139Cancelled Mar 1, 2001 · Triennial form not returned · Davis Phillip KN5897HPiper PA-16 · S/N 16-518Cancelled Feb 28, 2001 · Exported to Mexico · Billson Thomas AN3103SCessna 182G · S/N 18255603Cancelled Feb 27, 2001 · Triennial form not returned · Gentry Clarence EN7414EBalloon Works FIREFLY 7 · S/N F7-340Cancelled Feb 23, 2001 · Triennial form not returned · Stevens Gary WN72596Cessna 172S · S/N 172S8570Cancelled Feb 21, 2001 · Exported to Chile · South Andes IncN341AMRaven S55A · S/N S55A-406Cancelled Jan 23, 2001 · Triennial form not returned · Alexander Lyle EN50RLLarsen Raymond L THORP T18 · S/N 3001Cancelled Jan 23, 2001 · Triennial form not returned · Larsen Raymond LN4396DRaven S-60A · S/N S60A-328Cancelled Nov 2, 2000 · Triennial form not returned · Ewert Robert AN3622CCessna R182 · S/N R18200281Cancelled Sep 13, 2000 · Yoder Alfred DN97100Cessna 172R · S/N 17280100Cancelled May 24, 2000 · Exported to Canada · Jge IncN6426KAerostar International RX-7 · S/N RX7-3051Cancelled Apr 26, 2000 · Triennial form not returned · Heinrich PhilipN55038Piper PA-28-140 · S/N 28-7325310Cancelled Apr 6, 2000 · Pepper Mitchell CN330PXBritish Aerospace BAE JETSTREAM 3101 · S/N 698Cancelled Apr 4, 2000 · Exported to Canada · Finova Capital CorporationN335PXBritish Aerospace BAE JETSTREAM 3101 · S/N 712Cancelled Apr 4, 2000 · Exported to Canada · Finova Capital CorporationN333PXBritish Aerospace BAE JETSTREAM 3101 · S/N 704Cancelled Apr 3, 2000 · Exported to Canada · Finova Capital CorporationN2757GNorth American T-6G · S/N 49-2987ACancelled Mar 7, 2000 · Second triennial mailing, no response · Schmieder Carl DBAN64033Schallmann Michael CYCLONE · S/N 001Cancelled Feb 28, 2000 · Schallmann MichaelN50965Cessna 150J · S/N 15069678Cancelled Jan 10, 2000 · Triennial form not returned · Reid Robert GN55822Sanders Fred G III WAG AERO CUBY · S/N 691Cancelled Dec 21, 1999 · Triennial form not returned · Mclellan James WN6084CCameron Balloons US A-140 · S/N 5457Cancelled Nov 1, 1999 · Triennial form not returned · Christensen James RN1507NBalloon Works FIREFLY 7-B · S/N 11187Cancelled Oct 28, 1999 · Triennial form not returned · Haas Frank EN741SJBoeing 747-246F · S/N 22063Cancelled Aug 13, 1999 · Exported to Ghana · Finova Capital CorporationN39WBeech J35 · S/N D-5353Cancelled Jul 15, 1999 · Triennial form not returned · Jackson Frank WN801ASCessna 182P · S/N 18263829Cancelled Jul 14, 1999 · Triennial form not returned · Inter Ag Services IncN96640Cessna 152 · S/N 15286016Cancelled Mar 29, 1999 · Griffin Investment Group LLCN5141JMcconnell Larry S CHALLENGER II · S/N CH2-0292-0820Cancelled Mar 11, 1999 · Triennial form not returned · Mcconnell Larry SN3019GForney F-1 · S/N 5712Cancelled Oct 21, 1998 · Triennial form not returned · Zeiders Sterling DN820USnyder Edward A AVENGER I · S/N 91002ICancelled Oct 6, 1998 · Triennial form not returned · Snyder Edward AN20118Cessna 172M · S/N 17261024Cancelled Oct 2, 1998 · Triennial form not returned · Remmel Philip FN458AMFairchild SA227-AC · S/N AC699Cancelled Sep 24, 1998 · Exported to Spain · Finova Capital CorpN9210DPiper PA-22-160 · S/N 226269Cancelled Sep 16, 1998 · Triennial form not returned · Hall George KennethN4616LCessna 152 · S/N 15284198Cancelled Sep 2, 1998 · Exported to Mexico · Sawyer AviationN4864UCessna T210N · S/N 21064826Cancelled Aug 25, 1998 · Triennial form not returned · Sawyer Aviation IncN69BPAmerican Champion 8KCAB · S/N 76396Cancelled Aug 11, 1998 · Exported to Switzerland · Bunch BenN800ESSnyder Edward A RANS AIRAILE S-12 · S/N 0693431Cancelled Jul 29, 1998 · Exported to Tanzania · Snyder Edward A
Back to Phoenix, AZ