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 ('2072734')
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 ('2072734')
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.
N776DLSky West Aviation Inc Trustee · Albuquerque, NMN777VJTucker Billy J · Arley, ALN77LNNass Edwin L · Port Orange, FLN782RGL-Bird LLC · Hood River, ORN789GTJj Hughes Logistics LLC · Canyon, TXN78RGBubber Inc · Lake Providence, LAN79STAllevato Eugenio · Northridge, CAN7BVHartman Gregory S · San Mateo, CAN800TGAftg Aviation LLC · Hopkins, MIN8051BBryant James T Jr · Pryor, OKN816TXDavis Derek P · Sebastian, FLN822LMLehberger Charles W · Madison, CTN824FFly Well Flying Club Inc · Roseville, MNN82ERMidwest Airmotive Inc · Mount Sterling, KYN831HNChambers Jack · Sonoma, CAN855SPKirschner Joel D · Clarkesville, GAN85AAmerican Aerial Patrol LLC · Gonzales, LAN86EFCic Aviation LLC · Wenatchee, WAN882FCFlying C Aviation Inc · Searcy, ARN8YAInternational Air Services Inc Trustee · Carson City, NVN9032CGoodman Kim J · Burnsville, NCN9039CDouble O Seven Limited Co · Carefree, AZN9040CTexas Skyways Inc · Boerne, TXN9053CGuthrie Matt W · Corrales, NMN9054CDunlap Joseph A · Brainerd, MNN9055CBison Aero LLC · Kalispell, MTN9076CEvv Pilots Club Inc · Evansville, INN9077C389 Fifth Street LLC · Placida, FLN9091CYoung Gregory S · Riverside, CAN9092CAdirondack Aviators LLC · Peru, NYN9099CCasa Miguelita LLC · Santa Fe, NMN9101CJanak Jeffrey · Corpus Christi, TXN9106CUpper Valley Flying Club Inc · White Riv Jct, VTN9107CCagle Holdings LLC · Jenks, OKN9112CCk Jet LLC · Hillsboro, MON9117CRegistered aircraftN9118CWalter Tina R · Yorkville, CAN9123CRegistration Pending · San Bernardino, CARegistration pendingN9126CBowers Gordon M · Chesterfield, VAN9131CScott Michael F · Dothan, ALN9139CA F S Inc · Grants Pass, ORN9142CIndiana Aviation Inc · Nicktown, PAN9145CReitz Andrew P · Pembroke Pines, FLN9149CBryan Robert G · New Lenox, ILN9153CPax Enterprises Inc · Allen, TXN9155CN9155c LLC · Palm Harbor, FLN9157CAims Community College · Greeley, CON9158CSmith Robert A · Stillwater, OKN9164CMonmouth Aircraft Services Inc · Toms River, NJN9171CCartright Eugene · Pelham, NH
Back to Cessna R182