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.

N85FHBeech 58 · S/N TH-483Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1974N9216CCessna R182 · S/N R18200446Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1978N6324BCessna 182A · S/N 34224Cancelled May 31, 2018 · Sale reported, canceled · Built 1957N6363NChampion 7ECA · S/N 284Cancelled May 31, 2018 · Sale reported, canceled · Built 1967N6602UMooney M20C · S/N 2389Cancelled May 31, 2018 · Sale reported, canceled · Built 1963N711PGCessna 172M · S/N 17264422Cancelled May 31, 2018 · Sale reported, canceledN711RXBeech 58 · S/N TH-611Cancelled May 31, 2018 · Sale reported, canceled · Built 1975N72CWBeech 35-C33A · S/N CE-69Cancelled May 31, 2018 · Sale reported, canceled · Built 1966N73TWCirrus Design SR22 · S/N 0472Cancelled May 31, 2018 · Sale reported, canceled · Built 2003N74632Robinson Helicopter R22 BETA · S/N 3963Cancelled May 31, 2018 · Sale reported, canceled · Built 2005N776WMBeech A36 · S/N E-2088Cancelled May 31, 2018 · Sale reported, canceled · Built 1983N7770QCessna 310Q · S/N 310Q0270Cancelled May 31, 2018 · Sale reported, canceled · Built 1971N78994Mooney M20C · S/N 2028Cancelled May 31, 2018 · Sale reported, canceledN801GJesse Saint/Troy Townsend/Etha CH-801 · S/N 8-7059Cancelled May 31, 2018 · Sale reported, canceled · Built 2013N813JECirrus Design SR22 · S/N 3107Cancelled May 31, 2018 · Sale reported, canceled · Built 2008N8162SPiper PA-28RT-201 · S/N 28R-8018042Cancelled May 31, 2018 · Sale reported, canceled · Built 1980N143LHBeech 36 · S/N E-143Cancelled May 30, 2018 · Sale reported, canceled · Built 1969N180XVCessna 180D · S/N 18050998Cancelled May 30, 2018 · Sale reported, canceled · Built 1961N1952ECessna 340A · S/N 340A0679Cancelled May 30, 2018 · Sale reported, canceled · Built 1979N2030MCessna 182M · S/N 18259657Cancelled May 30, 2018 · Sale reported, canceled · Built 1969N21048Cessna 182P · S/N 18261381Cancelled May 30, 2018 · Sale reported, canceled · Built 1972N228MGGonzalez Manuel A RV-7A · S/N 71045Cancelled May 30, 2018 · Sale reported, canceled · Built 2005N2320UCessna 172D · S/N 17249920Cancelled May 30, 2018 · Sale reported, canceled · Built 1962N27GXRemos REMOS GX · S/N 264Cancelled May 30, 2018 · Sale reported, canceled · Built 2008N2951LMooney M20C · S/N 670085Cancelled May 30, 2018 · Sale reported, canceled · Built 1967N3152UCessna 182F · S/N 18254552Cancelled May 30, 2018 · Sale reported, canceled · Built 1962N3236FMooney M20E · S/N 670029Cancelled May 30, 2018 · Sale reported, canceled · Built 1967N34899Grumman American Avn. AA-1B · S/N AA1B-0284Cancelled May 30, 2018 · Sale reported, canceled · Built 1973N3839QCessna 172L · S/N 17259939Cancelled May 30, 2018 · Sale reported, canceled · Built 1971N3877HMooney M20J · S/N 24-0972Cancelled May 30, 2018 · Sale reported, canceled · Built 1980N4038QCessna 401 · S/N 401-0138Cancelled May 30, 2018 · Sale reported, canceled · Built 1967N4433DBeech G35 · S/N D-4578Cancelled May 30, 2018 · Sale reported, canceledN4596VCessna 172RG · S/N 172RG0333Cancelled May 30, 2018 · Sale reported, canceled · Built 1980N505PCSocata TAMPICO TB 9C · S/N 1464Cancelled May 30, 2018 · Sale reported, canceledN53MTBeech 58P · S/N TJ246Cancelled May 30, 2018 · Sale reported, canceled · Built 1980N546CPiper PA 46-350P · S/N 4636626Cancelled May 30, 2018 · Sale reported, canceled · Built 2014N5TGBellanca 17-30A · S/N 74-30620Cancelled May 30, 2018 · Sale reported, canceled · Built 1973N6956UMooney M20C · S/N 2707Cancelled May 18, 2018 · Revoked, canceled · Built 1964 · Professional Leasing Co IncN3022FLindstrand Balloons 60A · S/N 5096Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1999 · Aldous Taylor MN565ACRobinson Helicopter R44 II · S/N 11785Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2007 · Black Dragon Consulting II LLCN200PPBeech 95-B55 (T42A) · S/N TC-1415Cancelled Apr 20, 2018 · Registration expired, pending cancellation · Built 1971 · P2 Holdings LLCN73285Bell 47G-3B-1 · S/N 2909Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1964 · Wall RichardN3529UCessna 182F · S/N 18254929Cancelled Apr 5, 2018 · Revoked, canceled · Built 1963 · Levie Paul DN4258FCessna 172 · S/N 46158Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Gray James HN7787PPiper PA-24-250 · S/N 24-3004Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1962 · Mclenaghan Alvin NN63253Stinson L-5 · S/N 76-225Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1943 · Gray James HN7477ZSlingsby SWALLOW TYPE T.45 · S/N 1661Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1968 · Roth Andre L RN5173CBeech 35 · S/N D-2458Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1950 · Scarlett Sidney TN6209ZStinson L-5G · S/N 4615Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Gray James HN2206KLuscombe 8A · S/N 4933Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1947 · Mcdonald Stuart D
Back to Phoenix, AZ