Kenmore Crew Leasing Inc Trustee
Earlier aircraft under this name · 109
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
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 = 'KENMORE CREW LEASING INC TRUSTEE' OR list_contains(d.other_registrant_names, 'KENMORE CREW LEASING 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 = 'KENMORE CREW LEASING INC TRUSTEE' OR list_contains(d.other_registrant_names, 'KENMORE CREW LEASING 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.
N34QKPiper PA-34-220T · S/N 348133115N55QKGrumman American Avn. AA-5 · S/N AA5-0591N9021MWeatherly 620B · S/N 1621N2ZNBeech B90 · S/N LJ347N34PRCessna 525A · S/N 525A0392N904USBeech C90 · S/N LJ-856N761NACessna T210M · S/N 21062377N72SSBeech V35B · S/N D-9302N188KMRaytheon A36 · S/N E-3361N93GABeech 300 · S/N FA-93N98GAMooney M20R · S/N 29-0372N348CCCirrus Design SR22 · S/N 9281N174SCAirbus Helicopters AS350B3 · S/N 9349N5971Cirrus Design SR22 · S/N 3900N365NKSocata TBM 700 · S/N 340N457SRCirrus Design SR22 · S/N 2277N402MBCirrus Design SR22 · S/N 0289N4057QCessna 401A · S/N 401A0109N503KHTextron 560XL · S/N 560-6289N127BRCirrus Design SR22T · S/N 10492N62300Beech C90 · S/N LJ-989N128WTCessna 525B · S/N 525B0399N3061XPiper PA-34-200T · S/N 34-7970192N117Airbus Helicopters AS355NP · S/N 5809N886AGCirrus Design SR22 · S/N 5039N168BRCirrus Design SR22T · S/N 10608N579BRCirrus Design SR22T · S/N 10579N577DTPiper PA 46-350P · S/N 4636408N43TABeech B200 · S/N BB-1432N919DFTextron 208B · S/N 208B5538N710SDEurocopter AS 350 B3 · S/N 4067N158BRCirrus Design SR22 · S/N 10588N379DBCessna 525B · S/N 525B0191N600KABeech 300 · S/N FA-143N926LDPiper PA-31T · S/N 31T-7820047N107BRCirrus Design SR22 · S/N 10300N887PCHawker Beechcraft HAWKER 900XP · S/N HA-0095N782ATCirrus Design SR22T · S/N 10370N65254Cessna T206H · S/N T20608462N782SSCirrus Design SR22 · S/N 9872N8036JHawker Beechcraft C90GTI · S/N LJ-2036N6858WBeech 58 · S/N TH-1438N375JCBell Helicopter Textron Canada 427 · S/N 56079N194ALCessna 208 · S/N 20800036N7251TBeech 58 · S/N TH-1425N684CAPiper PA-46-600TP · S/N 4698084N419PSRaytheon C90A · S/N LJ-1543N125GRIsrael Aircraft Industries ASTRA SPX · S/N 116N499BRCirrus Design SR22T · S/N 9816N906SYCirrus Design SR22T · S/N 9603
Back to Kenmore Crew Leasing Inc Trustee