OpenAirDocs.org
Eastern Stearman Inc Trustee

Registered aircraft · 110

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'EASTERN STEARMAN INC TRUSTEE' OR list_contains(g.other_registrant_names, 'EASTERN STEARMAN INC TRUSTEE')
  ORDER BY g.n_number"

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.

N100RZCirrus Design SR22T · S/N 0034Built 2010 · Leesburg, VAN1079EAeronca 7AC · S/N 7AC-4632Built 1959 · Leesburg, VAN11UZPiper PA-32R-301 · S/N 3213063Leesburg, VAN121AMBeech F33A · S/N CE-1126Leesburg, VAN121LBBeech 200 · S/N BB-475Leesburg, VAN1272NColumbia Aircraft Mfg LC41-550FG · S/N 41650Built 2007 · Leesburg, VAN131BKBrooks-Bucker 131 · S/N BB-1Built 1935 · Leesburg, VAN13FYNorth American AT-6 · S/N 78-6922Built 1942 · Leesburg, VAN1434MBoeing A75N1(PT17) · S/N 75-8261Built 1947 · Leesburg, VAN14395Piper PA-18-150 · S/N 18-7409093Built 1974 · Leesburg, VAN14999Lockheed 12A · S/N 1252Built 1938 · Leesburg, VAN1547KColumbia Aircraft Mfg LC41-550FG · S/N 41747Built 2007 · Leesburg, VAN156EBMorane-Saulnier 505 · S/N 752Leesburg, VAN168GDehavilland GIPSY MOTH DH.60G · S/N A7/44Built 1928 · Leesburg, VAN18VBeech D17S · S/N 6869Leesburg, VAN18WXWaxenfelter Jack G THORP T-18 · S/N 1180Built 1996 · Leesburg, VAN18XWBeech 18S · S/N CA191Leesburg, VAN19146Fairchild 24 G · S/N 2994Built 1937 · Leesburg, VAN192HBeech D17S · S/N 6723Built 1945 · Leesburg, VAN19GLBrantly B-2B · S/N 2004Built 1992 · Leesburg, VAN202PYCessna 172N · S/N 17271126Built 1978 · Leesburg, VAN21246Cessna 172M · S/N 17263914Leesburg, VAN213GCCessna T210M · S/N 21062368Built 1978 · Leesburg, VAN215SDPiper PA46-500TP · S/N 4697049Built 2001 · Leesburg, VAN216DMFouga CM 170 MAGISTER · S/N 262Built 1960 · Leesburg, VAN227PMColumbia Aircraft Mfg LC41-550FG · S/N 41750Leesburg, VAN2289UBrantly B-2B · S/N 460Built 1966 · Leesburg, VAN22ZFCirrus Design SR22 · S/N 1902Built 2006 · Leesburg, VAN25FPBeech A36 · S/N E-2720Built 1992 · Leesburg, VAN266SFSiai-Marchetti F.260 · S/N 2-29Built 1969 · Leesburg, VAN27FFFokker F27 400M TROOPSHIP · S/N 10668Built 1985 · Leesburg, VAN27VHHostetler STARDUSTER SA-300 · S/N 739Built 1975 · Leesburg, VAN298SQPiper PA-19 · S/N 18-1586Built 1952 · Leesburg, VAN29JPSukhoi SU-26MX · S/N 53-01Built 1992 · Leesburg, VAN2PUExtra Flugzeugbau EA300/200 · S/N 030Built 2001 · Leesburg, VAN313BTConsolidated Vultee BT-13A · S/N 10425Built 1943 · Leesburg, VAN31428North American T-28C · S/N 140536Built 1956 · Leesburg, VAN31NLChristen Industries S-2B · S/N 5145Leesburg, VAN321EHMooney M20M · S/N 270096Built 1991 · Leesburg, VAN3232KGlobe GC-1B · S/N 1225Built 1946 · Leesburg, VAN3279GReims CESSNA F150L · S/N 0920Built 1983 · Leesburg, VAN3286North American SNJ-5 · S/N 88-15356Built 1944 · Leesburg, VAN32CSSanders D/Clarke D CMNWEALTH BOOMERANG · S/N A46139Leesburg, VAN341GGS N I A S SA341G · S/N 1181Built 1974 · Leesburg, VAN342CAPiper PA-18-150 · S/N 18-8009005Built 1979 · Leesburg, VAN3458VCessna 195 · S/N 7159Leesburg, VAN345JRCirrus Design SR22 · S/N 0594Built 2003 · Leesburg, VAN3514APiper PA-22-135 · S/N 22-1786Leesburg, VAN3651VCessna 140 · S/N 14922Built 1948 · Leesburg, VAN38940Boeing A75N1(PT17) · S/N 75-1822Built 1941 · Leesburg, VA
Back to Eastern Stearman Inc Trustee