Skip to content

Eastern Stearman Inc Trustee

Earlier aircraft under this name · 32

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'EASTERN STEARMAN INC TRUSTEE' OR list_contains(d.other_registrant_names, 'EASTERN STEARMAN INC TRUSTEE') 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_name = 'EASTERN STEARMAN INC TRUSTEE' OR list_contains(d.other_registrant_names, 'EASTERN STEARMAN INC TRUSTEE')
  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_name = 'EASTERN STEARMAN INC TRUSTEE' OR list_contains(d.other_registrant_names, 'EASTERN STEARMAN INC TRUSTEE')
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.

N728CNorth American T-28C · S/N 146261Cancelled Sep 11, 2026 · Exported to France · Built 1957 · Leesburg, VA N63590Boeing A75N1(PT17) · S/N 75-7143Cancelled Mar 10, 2026 · Exported to Denmark · Built 1943 · Leesburg, VA N90ZUBeech C90A · S/N LJ1276Cancelled Nov 20, 2025 · Exported to Netherlands · Built 1991 · Leesburg, VA N122TLGreat Lakes 2T-1A-2 · S/N 0735Cancelled Oct 7, 2024 · Built 1976 · Leesburg, VA N7232RBeech B200C · S/N BL-69Cancelled Jun 4, 2024 · Exported to Netherlands · Built 1984 · Leesburg, VA N929SDehavilland TIGER MOTH DH 82A · S/N T.6558Cancelled Sep 1, 2023 · Exported to Netherlands · Built 1943 · Leesburg, VA N182ZBeech 200 · S/N BB-402Cancelled Jul 15, 2022 · Exported to Netherlands · Built 1978 · Leesburg, VA N51740Mooney M20E · S/N 279Cancelled May 13, 2022 · Exported to France · Built 1964 · Leesburg, VA N57BVDehavilland DHC-2 · S/N 1025Cancelled Dec 14, 2021 · Exported to Canada · Leesburg, VA N83GRPiper PA-18-135 · S/N 18-3851Cancelled Jul 28, 2021 · Exported to Netherlands · Leesburg, VA N62842Boeing PT-27 · S/N 75-3851Cancelled Dec 11, 2020 · Exported to United Kingdom · Leesburg, VA N102JWWallace Jack STAMPE SV4C · S/N T67283Cancelled Sep 28, 2020 · Exported to Netherlands · Built 1947 · Leesburg, VA N131EBC A S A BUCKER JUNGMANN · S/N E3B-478Cancelled Sep 28, 2020 · Exported to Netherlands · Built 1954 · Leesburg, VA N1858Pietenpol HOMEBUILT · S/N A7-1968Cancelled Sep 28, 2020 · Exported to Netherlands · Leesburg, VA N133STSimmons JUNGMEISTER BU133 · S/N TS-2Cancelled Sep 25, 2020 · Exported to Netherlands · Leesburg, VA N1917KRuthton Donald SOPWITH CAMEL · S/N C-1Cancelled Sep 25, 2020 · Exported to Netherlands · Built 1986 · Leesburg, VA N377WWNorth American T-28B · S/N 137777Cancelled Jul 21, 2020 · Exported to Belgium · Built 1954 · Leesburg, VA N28YMNorth American T-28C · S/N 146287Cancelled May 6, 2020 · Exported to France · Built 1957 · Leesburg, VA N1325MBoeing E75 · S/N 75-8484Cancelled Aug 12, 2019 · Second renewal notice · Built 1943 · Leesburg, VA N32096Boeing-Phibbs 75 · S/N 75-444Cancelled Aug 9, 2019 · Registration expired · Leesburg, VA N289ARPiper PA-30 · S/N 30-1603Cancelled May 24, 2018 · Exported to Canada · Leesburg, VA N111EVArganbright Ron FOKKER D-8 · S/N A-2Cancelled Apr 2, 2018 · Exported to Belgium · Leesburg, VA N128CXRoberson Wooldridge NIEUPORT 28 · S/N 1192Cancelled Apr 2, 2018 · Exported to Belgium · Leesburg, VA N986RSSleep Robert ALBATROSS DVA · S/N 7160/17Cancelled Apr 2, 2018 · Exported to Belgium · Built 1990 · Leesburg, VA N58095Boeing A75N1(PT17) · S/N 75-4386Cancelled Nov 15, 2017 · Exported to Canada · Built 1942 · Leesburg, VA N3922BBoeing E75N1 · S/N 75-5805Cancelled Nov 6, 2017 · Exported to United Arab Emirates · Built 1943 · Leesburg, VA N688EBellanca CH300 PACEMAKER · S/N 133Cancelled Aug 25, 2017 · Exported to Canada · Built 1929 · Leesburg, VA N8871YPiper PA-39 · S/N 39-27Cancelled Aug 9, 2017 · Exported to Argentina · Built 1970 · Leesburg, VA N1328Fairchild 24 KS · S/N 3310Cancelled Dec 5, 2015 · First renewal notice · Built 1938 · Leesburg, VA N50755Boeing A75N1(PT17) · S/N 75-4020Cancelled Dec 2, 2013 · Exported to Canada · Built 1942 · Leesburg, VA N8162GBoeing A75N1(PT17) · S/N 40-1766Cancelled Apr 24, 2002 · Exported to Luxembourg · Built 1940 · Great Falls, VA N76402Cessna 140 · S/N 10828Cancelled Apr 29, 1999 · Triennial form not returned · Great Falls, VA

Back to Eastern Stearman Inc Trustee