Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('41465')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('41465')
ORDER BY n_numberRun 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.
N70CSAero Assurance Services LLC · Yakima, WAN715SAJrw Aviation LLC · Reno, NVN718CXValiair Lc Trustee · Casper, WYN71DTTerhaar David · Beulah, MIN723GGLoneair LLC · Cartersville, GAN72TPPeacock Stephen · Franktown, CON733DBColaur LLC · Wilmington, DEN73PRIndy Air Sales LLC · Anderson, INN747FLPro Gas LLC · Loma, CON751AKAaa Aircraft LLC · Missoula, MTN761DDTaliaferro Aviation LLC · Ardmore, OKN76PG999 Leasing II LLC · Cedar Springs, MIN7775ZCarbon Cub 5x LLC · Sun Valley, IDN77CG619pg LLC · Cedar Springs, MIN781AMichaud Steven D · Orono, MEN786VCBacon Air LLC · Shreveport, LAN79SWRegistered aircraftN79WFBubs Leasing LLC · West Des Moines, IAN7TSUpland Aviation LLC · Medford, ORN813HSWhiskey Charlie LLC · Stahlstown, PAN814DDClear Line Aviation LLC · St George, UTN814FXM2 Companies LLC · Loveland, CON815CGRice Timothy J · Anchorage, AKN816CCStk-N-Rudr LLC · Highland Village, TXN818HGGillespie William Hunter · Memphis, TNN819WKCub Crafters Resale LLC · Union Gap, WAN81UEHuft John M · Pagosa Springs, CON822TLRiver Bay Aviation Cub LLC · Jacksonville, FLN824EMAngle Of Incidence LLC · Anchorage, AKN824SPCck-2000-0069 LLC · Mount Juliet, TNN833MLRobinson Kenneth R · Star Valley Ranch, WYN838TSBlue Sky Assets LLC · Kelso, WAN840TMesa Aviation LLC · Brookings, SDN84EXLatham Bradley · Guthrie, OKN854CBRegistered aircraftN855CAMoon Mountain Montana LLC · Missoula, MTN855CCCarbon Cub 855cc LLC · Kalispell, MTN855PJNull Perry D · Gallup, NMN859TWN859tw LLC · Crestview Hills, KYN872ADDelk Andy K · Coolidge, AZN876CCCub Adventures LLC · Lenoir City, TNN877RTRrt Aircraft LLC · St George, UTN879WNiner Whiskey LLC · Clark Fork, IDN87MFAero Assurance Services LLC Trustee · Yakima, WAN88259Seguin Drew G · Mason, MIN901PBSmith Ben R · Eads, TNN910BLLund Investments LLC · Newport Beach, CAN911JNRoger Wilco Idaho LLC · New Meadows, IDN919VWCoit Mitchell · Drain, ORN91TJFrei Enterprises LLC · Kalispell, MT
Back to Lycoming CC363I