Kenmore Crew Leasing Inc Trustee

Registered aircraft · 59

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 = 'KENMORE CREW LEASING INC TRUSTEE' OR list_contains(g.other_registrant_names, 'KENMORE CREW LEASING 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.

N103LCCirrus Design SR22T · S/N 2281Built 2021 · Bellingham, WAN105DAAir Tractor AT-301 · S/N 3010653Built 1986 · Bellingham, WAN124MDBeech 58P · S/N TJ374Built 1981 · Bellingham, WAN134WSPiper PA-28-181 · S/N 28020137Built 2023 · Bellingham, WAN198XPilatus PC-24 · S/N 198Built 2020 · Bellingham, WAN201EAEclipse EA500 · S/N 000201Built 2008 · Bellingham, WAN210SLCessna P210N · S/N P21000129Built 1978 · Bellingham, WAN2458RRaytheon 58 · S/N TH-2089Built 2004 · Bellingham, WAN26TGPiper PA 46-350P · S/N 4636193Built 1999 · Bellingham, WAN2771CCessna 170B · S/N 26315Built 1954 · Bellingham, WAN285KRobinson Helicopter R66 · S/N 0073Bellingham, WAN298KDKodiak KODIAK 100 · S/N 100-0298Built 2021 · Bellingham, WAN312FURaytheon HAWKER 800XP · S/N 258545Built 2001 · Bellingham, WAN32JEGulfstream Aerospace G-IV · S/N 1460Built 2001 · Bellingham, WAN33PMBeech 58P · S/N TJ-78Built 1977 · Bellingham, WAN354SNCirrus Design SR22T · S/N 1354Built 2016 · Bellingham, WAN369MUCessna 510 · S/N 510-0369Built 2011 · Bellingham, WAN373MCCirrus Design SR22 · S/N 2996Built 2008 · Bellingham, WAN390MAPiper PA-46-600TP · S/N 4698052Built 2017 · Bellingham, WAN401MHCirrus Design SR22 · S/N 4265Built 2015 · Bellingham, WAN4063KSmith Edgar Butlar IV BUTLERS SPECIAL · S/N 001Bellingham, WAN4161APiper PA-34-220T · S/N 3449160Built 2000 · Bellingham, WAN435TMEmbraer Executive EMB-505 · S/N 50500435Built 2017 · Bellingham, WAN4409XPiper PA-28-181 · S/N 28-7690011Built 1975 · Bellingham, WAN465DGEclipse EA500 · S/N 000250Built 2008 · Bellingham, WAN478CCirrus Design SR22 · S/N 0400Built 2002 · Bellingham, WAN479LBell Helicopter Textron Canada 505 · S/N 65111Built 2018 · Bellingham, WAN48CEmbraer Executive EMB-505 · S/N 50500746Built 2023 · Bellingham, WAN505NBell Textron Canada 505 · S/N 65458Built 2022 · Bellingham, WAN5197FPiper PA-28-181 · S/N 28-7790086Built 1976 · Bellingham, WAN542VJCirrus Design SF50 · S/N 0542Built 2024 · Bellingham, WAN545WCessna 210L · S/N 21060656Bellingham, WAN620VGTextron B300 · S/N FL-1172Built 2019 · Bellingham, WAN63CDCirrus Design SR22T · S/N 10475Built 2025 · Bellingham, WAN655BCTextron 525B · S/N 525B0579Built 2019 · Bellingham, WAN701DBGulfstream Aerospace G-IV · S/N 1036Built 1987 · Bellingham, WAN707FHHonda HA-420 · S/N 42000069Built 2017 · Bellingham, WAN7091KAermacchi AM3-C · S/N 2025Built 1974 · Bellingham, WAN727KBRaytheon 400A · S/N RK-260Bellingham, WAN735HXCessna 182Q · S/N 18265447Bellingham, WAN745SHAmerican Eurocopter AS350B2 · S/N 7455Built 2012 · Bellingham, WAN759SBCessna 510 · S/N 510-0403Built 2012 · Bellingham, WAN785HCPiper PA 46-350P · S/N 4636206Built 1999 · Bellingham, WAN786LACirrus Design SF50 · S/N 0596Built 2024 · Bellingham, WAN789TSCessna 510 · S/N 510-0395Built 2012 · Bellingham, WAN805ELCessna 208B · S/N 208B0998Built 2002 · Bellingham, WAN8715NPiper PA-28-140 · S/N 28-25617Built 1969 · Bellingham, WAN889MSGulfstream Aerospace GV-SP (G550) · S/N 5190Built 2008 · Bellingham, WAN89DJLockwood Richard ZENITH AIRCRAFT 701 · S/N 75663Built 2008 · Bellingham, WAN9056SBeech A36 · S/N E-1301Built 1978 · Bellingham, WA
Back to Kenmore Crew Leasing Inc Trustee