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.
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
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.
N103LCCirrus Design SR22T · S/N 2281N105DAAir Tractor AT-301 · S/N 3010653N124MDBeech 58P · S/N TJ374N134WSPiper PA-28-181 · S/N 28020137N198XPilatus PC-24 · S/N 198N201EAEclipse EA500 · S/N 000201N210SLCessna P210N · S/N P21000129N2458RRaytheon 58 · S/N TH-2089N26TGPiper PA 46-350P · S/N 4636193N2771CCessna 170B · S/N 26315N285KRobinson Helicopter R66 · S/N 0073N298KDKodiak KODIAK 100 · S/N 100-0298N312FURaytheon HAWKER 800XP · S/N 258545N32JEGulfstream Aerospace G-IV · S/N 1460N33PMBeech 58P · S/N TJ-78N354SNCirrus Design SR22T · S/N 1354N369MUCessna 510 · S/N 510-0369N373MCCirrus Design SR22 · S/N 2996N390MAPiper PA-46-600TP · S/N 4698052N401MHCirrus Design SR22 · S/N 4265N4063KSmith Edgar Butlar IV BUTLERS SPECIAL · S/N 001N4161APiper PA-34-220T · S/N 3449160N435TMEmbraer Executive EMB-505 · S/N 50500435N4409XPiper PA-28-181 · S/N 28-7690011N465DGEclipse EA500 · S/N 000250N478CCirrus Design SR22 · S/N 0400N479LBell Helicopter Textron Canada 505 · S/N 65111N48CEmbraer Executive EMB-505 · S/N 50500746N505NBell Textron Canada 505 · S/N 65458N5197FPiper PA-28-181 · S/N 28-7790086N542VJCirrus Design SF50 · S/N 0542N545WCessna 210L · S/N 21060656N620VGTextron B300 · S/N FL-1172N63CDCirrus Design SR22T · S/N 10475N655BCTextron 525B · S/N 525B0579N701DBGulfstream Aerospace G-IV · S/N 1036N707FHHonda HA-420 · S/N 42000069N7091KAermacchi AM3-C · S/N 2025N727KBRaytheon 400A · S/N RK-260N735HXCessna 182Q · S/N 18265447N745SHAmerican Eurocopter AS350B2 · S/N 7455N759SBCessna 510 · S/N 510-0403N785HCPiper PA 46-350P · S/N 4636206N786LACirrus Design SF50 · S/N 0596N789TSCessna 510 · S/N 510-0395N805ELCessna 208B · S/N 208B0998N8715NPiper PA-28-140 · S/N 28-25617N889MSGulfstream Aerospace GV-SP (G550) · S/N 5190N89DJLockwood Richard ZENITH AIRCRAFT 701 · S/N 75663N9056SBeech A36 · S/N E-1301
Back to Kenmore Crew Leasing Inc Trustee