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.

N191TSWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF20900902Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1995N1368VCampbell Lucky QUICKSIVER MX · S/N 3027Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1981 · US Ultralight Aviation IncN95375Taylorcraft BC12-D · S/N 9775Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1946 · Radcliffe GeorgeN74737Bell 47D1 · S/N 415Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Wall Richard EN74DPPiccard AX-6 · S/N 721Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1974 · Sky Hook Balloon Corps IncN77MERaven S55A · S/N S-55A-327Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1977 · Spidell Dennis EN7967FCessna 150F · S/N 15064067Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1966 · Mahana Glen RN439JPPastorello Joseph F BENSEN BM-1 · S/N 1Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Pastorello Joseph FN6752DBell 47G-2 · S/N 2243Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1957 · Lmb Industries IncN7118VBalloon Works FIREFLY 8B · S/N F8B-136Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1988 · Antioco LorettaN28387Bowlus BA-100 · S/N 165Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1942 · Shoen Michael LN6267MMaule M-5-235C · S/N 7217CCancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1978 · Dickson M R DBAN5363XCessna TU206G · S/N U20605679Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1980 · Sawyer AviationN7023CGunn William B DRAGONFLY · S/N 4415Cancelled Jun 27, 2013 · Sale reported, canceledN910KJHughes 269B · S/N 1250224Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1965 · Hibbitts John HayesN247ABGrumman G-1159 · S/N 208Cancelled Jun 26, 2013 · First renewal notice · Built 1977 · Cutter Southwest Aircraft Sales LLCN51530Raven S-50A · S/N S50A-220Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1973 · Tonka Leasing CorpN101LXBurton Larry Alan FLY BABY · S/N LBX101Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1986 · Kingsland Paul WN1933YMooney M20E · S/N 240Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1950 · Gollubske Edward FN2815SRaven Industries S-55A · S/N S55A-1108Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Hutson Robert A JrN2816JRaven Industries S-60A · S/N S60A-426Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1986 · Pegasus Hot Air Balloon Co IncN2848GRaven Industries S-60A · S/N S60A-435Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1986 · A Aeronautical Adventure IncN74193Balloon Works FIREFLY 7 · S/N F7-300Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Austin Connie AN2595ZBertram Allen QUICKSILVER MX II · S/N 3160Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Bertram AllenN39699Battersby Joe MITCHELL T-10 · S/N T-156Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Arizona Mitchell UltralightsN51130Stinson L-5 · S/N 76-483Cancelled Jun 10, 2013 · Registration pending, canceled · Built 1943N1875NCessna 120 · S/N 12119Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1946N36221Aerostar International RAVEN S57-A · S/N S57A-3082Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1989N423ESCessna 172R · S/N 17280258Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1997N42CRCessna T210L · S/N 21059701Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1972 · R R B S D IncN1349BHiller UH-12E4 · S/N 2119Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1961 · Whirlwind Aviation LtdN3LVAtkinson Vance VARIEZE · S/N 1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1983 · Worne Steven LN4030GRaven Industries RALLY RX7 · S/N RX7-266Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1981 · Eccles Parley NN54524Sikorsky S-58 · S/N 143946Cancelled Jun 5, 2013 · Sale reported, canceledN6557ZAerostar International RAVEN S57-A · S/N S57A-3013Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1987N9370ECessna 182R · S/N 18268404Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1984 · J And N Enterprises IncN9097ZPiper PA-28-161 · S/N 28-8616023Cancelled May 31, 2013 · Sale reported, canceled · Built 1985N4038GPiper PA-31-325 · S/N 31-8112011Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1980 · Johnson RobertN97417Stinson 108 · S/N 108-417Cancelled May 24, 2013 · Registration expired, pending cancellation · Built 1946 · Billingsley D CN929SHHughes 269B · S/N 106-0272Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1966 · Bean Richard DN93000Schempp-Hirth K8B · S/N 8364Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1965 · Bloom David MN3368PPiper PA-23-160 · S/N 23-1325Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1958 · Accelerated Flight Crew Training CorpN86751Bellanca 14-13-3 · S/N 1112Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1946 · Monroe Thomas AN8876NPiper PA-28-140 · S/N 28-25739Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Bergquist Kurt RN81657Aeronca 7AC · S/N 7AC-277Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1945 · Morgan E VirgilN5492YPiper PA-23-250 · S/N 27-2585Cancelled May 10, 2013 · Sale reported, canceled · Built 1964N6443DAerostar International S-60A · S/N S60A-3038Cancelled May 10, 2013 · Sale reported, canceled · Built 1986N7690VAero Commander CALLAIR A-9B · S/N 1443Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Morgan Virgil EN61JNNoyce Jerry D MXL II · S/N 1661Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1989 · Johnson Randall VN759YFCessna 182Q · S/N 18266359Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1978 · Ready Aero Inc
Back to Phoenix, AZ