Skip to content

Cancelled registrations · 188

Query with SQL

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 = 'WA' AND d.registrant_city = 'TACOMA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'WA' AND d.registrant_city = 'TACOMA'
  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.

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 = 'WA' AND d.registrant_city = 'TACOMA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N88080Bellanca 8GCBC · S/N 7374Cancelled Oct 10, 2026 · Registration pending, canceled · Built 1974 N846WTNoble Travis E AVID C · S/N 846Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2014 · Robinson Auston T N36695Aeronca 65-LB · S/N LB17531Cancelled Jul 15, 2022 · Registration expired, pending cancellation · Built 1941 · Andre Joseph L N607TWYuneec International Q500 4K TYPHOON · S/N VU15220579B04B01Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Peters W Dan N57576Dehavilland DHC-2 MK. I(L20A) · S/N 1168Cancelled Jul 2, 2021 · Exported to Sweden · Built 1956 · Astra Pacific Aviation LLC N57579Consolidated Vultee BT-13A · S/N 11384Cancelled Dec 20, 2019 · Revoked, canceled · Laferriere Jacques A N6729JPiper PA-28-140 · S/N 28-24438Cancelled May 31, 2018 · Sale reported, canceled · Built 1968 N73057Cessna 140 · S/N 10269Cancelled May 18, 2018 · Revoked, canceled · Built 1946 · Hanson Erling B N90680Commonwealth 185 · S/N 1805Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1946 · Riffle Robert E N90699Commonwealth REARWIN 185 · S/N 1793Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1946 · Riffle Robert E N67051Commonwealth 185 · S/N 1775Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1946 · Riffle Robert E N5209TPiper PA-28-140 · S/N 28-7225354Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1972 · Chapman Recovery Corp N9818VCessna 172M · S/N 17264514Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1974 · Stout Roderick A N7053SCessna 150H · S/N 15067753Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1967 · Murray Blain T N29232Aeronca 65-TL · S/N 2820TCancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Heisley David N77410Cessna 120 · S/N 11851Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Benson Wilmont E N90694Commonwealth 185 · S/N 1789Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Currah Edward H N94681Airborne Windsports PTY EDGE XT-912-B · S/N XT-912-0074Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 2005 · Burks Earl Jay N5827BCessna 182 · S/N 33827Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1956 · Polebrook Aviation LLC N25060Mcclintock Warren J WINDROSE 15 M · S/N 001Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Mcclintock Warren J N81150Funk B85C · S/N 280Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Wood Stanley P N161DGlasflugel STD LIBELLE 201B · S/N 22Cancelled Jun 5, 2015 · Third renewal notice · Built 1968 · Buschman Dennis L N604LSPoland LIM-5 · S/N 1J0604Cancelled May 20, 2015 · Registration pending, canceled N85LLLorenz Gary E KR-2 · S/N 7150Cancelled Dec 31, 2014 · Registration expired, pending cancellation · Lorenz Gary E N836DMMott Douglas C TIERRA · S/N 8185-1Cancelled Dec 24, 2014 · Registration expired, pending cancellation · Mott Douglas C N23KSGrubert David W KIS TRI-R TR1 · S/N 023Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1993 · Grubert David W N9263TPiper PA-38-112 · S/N 38-78A0303Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Johnson Faith Audre N7593MCessna 175 · S/N 55893Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1959 · Simon Jerry B N568BEEdwards Benson A MINI-500 · S/N 143Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1996 · Cascade Sport Helicopters Inc N825PBAdkins David Earl RIDGE RUNNER II · S/N 722811Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 2003 · Epperson Tony J N98350Piper PA-28-140 · S/N 28-26181Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1969 · Cusack Jill N4961ZPiper PA-22-108 · S/N 22-8564Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1961 · Ward Amos A N44916Douglas C-118A · S/N 51-3830Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1951 · Moriarty W Patrick N7683CConsolidated Vultee P4Y-2 · S/N 59742Cancelled Aug 8, 2013 · Revoked, canceled · Cameron Lazone G N5273MCessna 152 · S/N 15284512Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1980 · Dennerline Gary R N5580DBurton Norman L PIETENPOL 1932 · S/N 6043Cancelled Jun 27, 2013 · Sale reported, canceled N83645Piper PA-28RT-201T · S/N 28R-8131113Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1981 · Mintken Charles L N9202Cessna 180 · S/N 30336Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1953 · Perhalfos Inc N717GGGreenwood Gilbertm EXEC 16F · S/N 6093Cancelled May 8, 2013 · Registration expired, pending cancellation · Greenwood Gilbert M N7400FHughes 269C · S/N 250397Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1975 · Fly Fishing Inc N68647Home Built Baby Ace T1 · S/N 1Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1966 · Talen Herbert L N6406FCessna 150F · S/N 15063006Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1966 · Hayes Raymond H N5931PPiper PA-24 · S/N 24-1019Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1959 · Airmet Inc N5678HRaven S55A · S/N S55A-482Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Swan Construction N5439GCessna 404 · S/N 404-0057Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1977 · Northwest Sea Lane Inc N1150TCessna 172M · S/N 17266082Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1975 N49688Burris ED QUICKSILVER MX · S/N 4100Cancelled Mar 11, 2013 · Sale reported, pending cancellation N766HSSmith Harold H RV-6 · S/N 20509Cancelled Feb 14, 2013 · Built 1998 · Smith Harold H N1834VCessna 140 · S/N 14014Cancelled Feb 8, 2013 · Built 1947 · Masura Judith E N37358Cessna 340A · S/N 340A0365Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1977 · Sds Aircraft Enterprises

Back to Tacoma, WA