OpenAirDocs.org
Peoria, AZ

Cancelled registrations · 78

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 = 'PEORIA'
  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.

N4535ZCameron Balloons US V-90 · S/N 5906Cancelled Aug 3, 2024 · Registration pending, canceled · Built 1993N722BLJabiru USA Sport J250-SP · S/N 379Cancelled Feb 27, 2024 · Exported to Costa Rica · Wheeler Curtis EN3419LCessna TU206B · S/N U206-0719Cancelled May 27, 2023 · Revoked, canceled · Built 1966 · Johnson Thomas HN291KTJahnke Lionel G GLASAIR III · S/N 3141Cancelled Dec 15, 2022 · Registration expired, pending cancellation · Built 1990 · Fbi-Glasair LLCN7714HHoffman Jimmie ZODIAC 601 XL · S/N 6-6088Cancelled Nov 24, 2022 · Registration expired · Built 2006 · Hoffman JimmieN811RHHill Richard VARI-EZE · S/N 1081Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Hill Richard IIIN717WCWoods Brian T RANS S-12XL · S/N 04111024Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Woods Brian TN78294Cessna 172K · S/N 17257555Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1968 · Aero Flight Three LLCN3365GGreco Robert J AERO VIPER · S/N AV 001Cancelled Apr 17, 2021 · Wheeler Curtis EN8172MPiper PA-28-181 · S/N 28-8090260Cancelled Feb 20, 2021 · Registration pending, canceledN351WBBabcock Dayton A TRICKTRIKE AB · S/N TTAB01Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 2009 · Sneddon Duane NN4440GFly Products GOLD 130 TRIKE · S/N M2924Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Thompson Michael DN7383CDJI PHANTOM 3 PROFESSION · S/N P76DK2Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Crystal Vision Aerial Videography & Photography LlN6216LAmerican AA-1B · S/N AA1B-0016Cancelled Dec 21, 2018 · Registration expired · Built 1972 · Swortzel Robert LN4239JBell 47G-2 · S/N 1Cancelled May 3, 2018 · Registration expired, pending cancellation · Underwood William DN998HBZing Aerosports ZR-6A · S/N ZR6-001Cancelled Apr 6, 2018 · Registration expired, pending cancellation · Zing Aerosports LLCN3022RCameron Balloons US POLARBEAR 90 · S/N 3768Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1996 · Mr Dd LLCN8416EBell 47G-3 · S/N 2600Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1960 · Pacific Aero Ser. IncN8500FBell 47G-3B-1 · S/N 3385Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1965 · Pacific Aero Services IncN3755AAeroworks AEROLITE 103 · S/N A-AWI-081800-67-2SICancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 2000 · Eaa Ultralight Chapter 55 LitefliersN9110NKemmeries John K KEMMERIES/CLIPPER · S/N KATUZ1095JK582Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Kemmeries John KN3048KCameron Balloons US N-90 · S/N 6027Cancelled Nov 21, 2017 · Exported to New Zealand · Zing Aerosports LLCN997ZAZing Aerosports ZR-50 · S/N ZR-5001Cancelled Aug 11, 2017 · Third renewal notice · Zing Aerosports LLCN9211QKemmeries ARV TANARG · S/N T05013Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 2006 · Kemmeries Aviation IncN4252ABell 47D1 · S/N 117Cancelled Mar 15, 2017 · Exported to Costa Rica · Built 1948 · Helicopters West LLCN42861Thunder & Colt COLT 400A · S/N 891Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1988 · Romaneschi RobertN3097GBell 47G-3B-1 · S/N 3377Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1965 · Underwood William DN28098Raven S55A · S/N S55A-1102Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Duke LarryN231FRMooney M20K · S/N 25-0032Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1979 · Arizona Airplanes IncN899SBZing Aerosports ZING-T-29 · S/N ZA-002Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Berg Steven RN17ZBeech 65-80 · S/N LD-52Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1962 · Arizona Airplanes IncN4364XPiper PA-32R-300 · S/N 32R-7680013Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1975 · E Z Flights IncN187ACCrawford Anthony C KR 2 · S/N 8805Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Crawford Anthony CN26873Gulfstream American AA-5A · S/N AA5A0682Cancelled Sep 12, 2013 · Registration pending, pending cancellation · Built 1978N6038MCameron Balloons US V-77 · S/N 5482Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1988N40LLBell 47G-2A-1 · S/N 3443Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1965 · Pacific Aero Service IncN83779Bell 47G-3B-1 · S/N 2907Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1964 · Pacific Aero Services IncN7706RBeech 36 · S/N E-106Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1968 · Rayty David RN65038Bell 47G-3B-1 · S/N 3548Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1966 · Pacific Aero Service IncN3550XCessna 172S · S/N 172S8894Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Dahlgren Steven WN1604XCameron Balloons US C-80 · S/N 5965Cancelled Sep 10, 2012 · Registration pending, canceledN5586WPiper PA-28-160 · S/N 28-693Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1962N871JPPrice Jack QUICKSILVER MX II · S/N 1Cancelled Aug 14, 2012 · Registration pending, canceledN4819EDouglas B-26B · S/N 44-34609Cancelled Aug 7, 2012 · Registration pending, canceledN203RSSherman Rick J RANS AIRAILE S-14 · S/N 0393057Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1995 · Sherman Rick JayN650RVRadford Joseph R RV-6 · S/N 23971Cancelled Jan 25, 2012 · Third renewal notice · Built 2009 · Radford Joseph RN53KTWalentine Roger RV4 · S/N 1239ACancelled Nov 30, 2011 · First renewal notice · Built 1987 · Velvick Tom LN53LLBell 47G-3B-1 · S/N 3445Cancelled Sep 8, 2010 · Exported to Mexico · Built 1965 · Helicopters West LLCN4257CMaule MXT-7-180A · S/N 21070CCancelled Jul 8, 2010 · Triennial form not returned · Built 1999 · Sst IncN6132YYellowega Dorland CGS HAWK 2 · S/N H-II-072-R503Cancelled Apr 13, 2010 · Triennial form not returned · Yellowega Dorland D
Back to Peoria, AZ