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 aircraft_model_code IN ('2073449')
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 aircraft_model_code IN ('2073449')
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.
N774CSWyo Ventures LLC · Buffalo, WYN774RDDemuth Roger C Trustee · Valley View, TXN776TMAero Performance LLC · Scooba, MSN7776HAcevedo Adriel · San Antonio, TXN777HSJohnson Erik L · Long Beach, CAN787AECoordinate Productions LLC · Waterloo, IAN7LTRobertson Cameron Lee · Las Vegas, NVN80GWSnyder Michael P · Las Vegas, NVN8130LPerfect 10 Roofing · Billings, MTN8139LWashburn Kyle A · Yukon, OKN813DMAp-1 LLC · Newman Lake, WAN887WQuad City Area Flying Eagles Inc · Milan, ILN888KAQualitair LLC Trustee · MichelstadtN888KBAarons Plumbing LLC · Grand Ledge, MIN899MDLarson Aeromedical Services LLC · Salem, ORN89EPBas Part Sales LLC · Greeley, CON8KMWolding Jeffrey D · Ashland, WIN8MNNichols Farms · Seminole, TXN919HWStonehollow Pain Services LLC · Elizabeth, ARN920GGAbbott Air Inc · Hydro, OKN92711Intergard R&D LLC · Miami, FLN92DSBooty Bill · Idaho Falls, IDN93128High Plains Aero Consulting Inc · Pampa, TXN93129Klca Inc · Warsaw, INN93186Bates Byron B · Ethel, WAN93262Land Office LLC · Burlington, CON93274Wltf LLC · Caldwell, IDN93285Corrie Brent · Vero Beach, FLN93295Gates Steven · Midlothian, TXN93344Cardinal Headings Ltd · Wilmington, DEN93350Rowe M D Trustee · Bozeman, MTN93354Utah County Sheriff · Spanish Fork, UTN93362Bouvier Ellis C · Prineville, ORN93380Stahla Robert E Trustee · Grand Island, NEN93836Clarkson Michael D · Anniston, ALN93867Sunup Flyers Coop · Moscow, IDN94035Husbands David · Bosque, NMN94148Gates Don · Richmond Hill, GAN94202Gilsdorf David R Trustee · Pleasant Hill, MON94203Frasier Air Inc · Tulsa, OKN94227Dodson International Parts Inc · Rantoul, KSN94244Bryant Kenneth D · Black Diamond, WAN94263Hitch Aviation Inc · Malta, MTN9426KO Max Aviation · Willowbrook, ILN949MDUnruh Leasing LLC · Blossom, TXN96734D & G Aviation LLC · Woodward, OKN969SLWojcik Bart C · Kimberly, IDN96LLHuck-Mag LLC · Plano, TXN9748ZKerr Kenneth E · Bakersfield, CAN981WMFlying Fortress Of Swfl LLC · Fort Myers, FL
Back to Cessna T210L