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.
N488CGOregon Coast Holdings LLC · Wilmington, DEN490ABNwrm II LLC · Reno, NVN493NKAimpoint Aviation Services LLC · Argyle, TXN4TWWiens Timothy D · Broomfield, CON505UCUtah County Sheriff · Spanish Fork, UTN509BWinthrop Aviation LLC · Winthrop, WAN509HBorror Aaron J · Fort Rock, ORN511KCcn511k LLC · Boise, IDN511PLMccarty David M · Baker City, ORN516PWSands Mark · Bryan, TXN517AWAw1 Enterprises LLC · Fort Pierce, FLN528LLJardine Aviation LLC · Vienna, OHN52KGTail Dragger Aviation LLC · Ogden, UTN530BESilver Eagle II LLC · Carson City, NVN531SLCentral Coast Jet Center LLC · Santa Maria, CAN531VGAero Assurance Services LLC · Yakima, WAN536SJMills Scott V · Vancouver, WAN540AMAtlas Stone Fx3 LLC · Stamford, CTN5555UBevam Edward G · Spokane, WAN555LHR&J Aero LLC · Westfield, PAN556PGCommodore Properties LLC · Fife, WAN55XV55x LLC · Kalispell, MTN563LGAerviator LLC · Taylorsville, KYN56DZConey Michael · Sandy, UTN571CMMccallum Chris · Grand Junction, CON576BEN9fx LLC · Columbus, MTN5772Black Hills Cubs LLC · Black Hawk, SDN57875Schuler John L · Peoria, ILN580DMFx3 LLC · Somerset, KYN58QTPoint2point LLC · Rogers, ARN594SRHarmon Creighton D · Scott, LAN59JVLittle Bird Aviation LLC · Dover, DEN59KLWalter Landi · Whitefish, MTN603XKatmai Aviation LLC · Hebron, NHN6139JHostetler Kevin J · Green Forest, ARN613DCClear Sky LLC · Missoula, MTN613PWWestland Bill · Gallatin Gateway, MTN61ZZValiair Lc Trustee · Casper, WYN629SEChaos Ap LLC · Van, TXN636PWMccorry John Joseph Michael · Scottsdale, AZN639AKRoane David C · Anchorage, AKN656DELedford James D · Winter Haven, FLN658DCCruz David C · Palmer, AKN6598ZLapa Consulting LLC · Snoqualmie, WAN65LGSa Club LLC · Palo Alto, CAN665CC43kb LLC · Truckee, CAN668CCN668cc LLC · Adams, TNN677CBBloch Christopher P · Grand Rapids, MIN67THBethers James D · Montpelier, IDN689JJJoffe Finance LLC · Osprey, FL
Back to Lycoming CC363I