Skip to content

Cancelled registrations · 132

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

N2051CBeech 95 · S/N TD-238Cancelled Aug 22, 2026 · Built 1959 · Crest Airpark Inc N921CBryant M A/Bryant N W AEROCOMP INC/CP AR 6 · S/N 97139Cancelled Jun 30, 2025 · Registration pending, canceled N8661VBellanca 7KCAB · S/N 511-75Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1975 · Regan Robert C N4203JPiper PA-28-140 · S/N 28-22548Cancelled Jul 24, 2021 · Sale reported, canceled · Built 1966 N41WWBeech F33 · S/N CD-1245Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1970 · Gehring Norman F N49140Taylorcraft DCO-65 · S/N 0-4301Cancelled Dec 4, 2018 · Registration expired, pending cancellation · Built 1942 · Nason David F N9397VMooney M20C · S/N 700030Cancelled Aug 18, 2018 · Registration pending, canceled · Built 1969 N4077BMiller James Alan AVID FLYER · S/N 719Cancelled May 30, 2018 · Sale reported, canceled N5099AAir Creation CLIPPER 582S · S/N 123Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1994 · Stevenson Jared J N4886VCessna 172RG · S/N 172RG0409Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1980 · Crest Airpark Inc N5254ECessna 172N · S/N 17271800Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1978 · Crest Airpark Inc N22379Robertson Stuart A GENESIS · S/N 079Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 2003 · Robertson Stuart A N3681WPiper PA-32-260 · S/N 32-591Cancelled Nov 18, 2017 · Revoked, canceled · Built 1966 · Lizotte Aldric A Jr N5086KCessna 195A · S/N 491954Cancelled Nov 18, 2017 · Revoked, canceled · Built 1949 · Skycrest Aviation Inc N180CSCessna 150K · S/N 15071201Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1969 · Peterson Glenn S N74675Schweizer TG3A · S/N 58Cancelled Feb 4, 2017 · Revoked, canceled · Built 1942 · Thermal Chasers N77383Cessna 140 · S/N 11824Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Skycrest Avn Inc N95LGAerospatiale AS350 B2 ECUREUIL · S/N 2389Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1990 · Geneva Transport Equipment Corp N5011SCobb Eli H SKYBOLT · S/N C-1-6352774Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Charbonneau Thomas C N2606CCessna 310 · S/N 35006Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1954 · Five Star Aviation N1699APiper PA-22 · S/N 22-456Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1952 · Gorski Frank J Jr N2076HErcoupe 415-C · S/N 2699Cancelled Jul 30, 2014 · Second renewal notice · Built 1946 · Curtiss Kent O N95MABeech D17S · S/N 1013Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Smith Lois May N51423Hedgepeth Ted GABCO FLYER · S/N GABCO-001Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Johnson Victor T N393DBRobinson Helicopter R22 BETA · S/N 1162Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Antone Manufacturing Inc N65252Semco Balloon T · S/N SEM129Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Johnson Victor T N19TSShaver Timothy L SA750 ACRODUSTER II · S/N 1758274Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Shaver Timothy L N203RAAltman Roger D KOLB MARK III · S/N 203403396Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2007 N8004FRobinson Helicopter R22 BETA · S/N 2354Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1993 N155RLCessna 170B · S/N 20701Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1952 N225RVRobicheau Bill RV-8 · S/N 80860Cancelled Aug 19, 2013 · Sale reported, canceled N704XACessna 150M · S/N 15078945Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1976 N2821XRosengreen John A BENSEN B8M · S/N 1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Rosengreen John A N9566XCessna 210B · S/N 21057866Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1962 · Westervelt Douglas J N72984Cessna 140 · S/N 10185Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1946 · Brose Samuel D N63217Cessna 180K · S/N 18052837Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1977 · Mccall Charles W N5957XBrantly B-2 · S/N 98Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1961 · Champlain Daniel D Jr N5954JCessna A150L · S/N A1500254Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1970 · Wangsness Steve E N3851Abbott B-8M · S/N 007Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1971 · York Edwin N N5967DPiper PA-22-150 · S/N 22-4632Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1956 N9244ZLet BLANIK L-13 · S/N 026503Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1975 N5636YMaule M-5-235C · S/N 7307CCancelled Jan 31, 2013 · Sale reported, canceled · Built 1980 N139FGrumman G-44 · S/N 1375Cancelled Jan 30, 2013 · Built 1944 · Widgeon Enterprises LLC N8034URegis Edgar VARIEZE · S/N REGIS-1978Cancelled Nov 30, 2012 · Sale reported, pending cancellation · Built 1980 N3964VCessna 170 · S/N 18283Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Fremont Margrette H N3970KPiper PA-28-140 · S/N 28-23854Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1967 · Cepeda Joe M N4176YCessna 185A · S/N 185-0376Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1962 N185NCessna 310C · S/N 35958Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1959 · Banning Bruce L N137GGriffith MINIPLANE · S/N FG-1Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1975 · Griffith Frederick W N2825Zeeb OWL RACER · S/N 020Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1971 · Compton George A

Back to Kent, WA