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 ('2072431')
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 ('2072431')
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.
N758XWNorton Donald A · Kodiak, AKFirst renewal noticeN758XZSpinde Martin R · Anchorage, AKN7606VDahdah Kurt J · Agawam, MAN7654VRene Ronald M · Linden, NCN76XPCag Interional Inc DBA · Longmont, CON770CBTeton Avjet LLC · Driggs, IDN772KWTime Flies LLC · Loxahatchee, FLN772MABaumbaugh Randal Kelly · Granger, INN772MVAir And Sea LLC · Oak Bluffs, MAN77551Otto Robert E · Battle Ground, WAN775JDPolakewich Gerald F · Biddeford, MEN777MBCullen Maryrose · Longmont, CON777TWMcdonald Timothy J · Daytona Beach, FLN77XPObrien Daniel T · Boise, IDN79BVBethurem Conrad D · Sheridan, WYN801XPAmel Donald · Burleson, TXN802JMDixon David Scott · Renton, WAN803HLAir Hammer LLC · Wilmington, DEN80RXMccord Cheryl · Kuna, IDN810MFTorroija Matias · Miami, FLN8124VFarhat Jamal M · Rochester, MIN82MNDodson International Parts Inc · Rantoul, KSN837DDKleeman Thomas J · Cooper Landing, AKN875RHGreat Lakes Aviation LLC N875rh · Antioch, ILN8896VWheels Down 2 LLC · Bozeman, MTN8907VSmith Melvin Roy · Gulf Breeze, FLN8923VMollica Richard Anthony · Oxnard, CAN8939VBray Bradley DBA · North Charleston, SCN898HCSmith Andy · Fitzgerald, GAN900RTTakle Raymond L · Hudson, WIN910TWMultnomah County Sheriffs Office · Portland, ORN914CBChan Blair H · Arlington, TXN946PKPrado Mike · Sugar Land, TXN950MGDurante Salvatore · Oro Valley, AZN9565VHijazi Sakher Samir · San Clemente, CAN9595VSmith Ryan N · Saratoga Springs, UTN961UTRepllp LLC · Marietta, GAN9637VAllen Linda M · Amarillo, TXN963WMMorrison William S · Aliquippa, PAN9659VAitken Lyle W · Tuscaloosa, ALN9681VCooperative Cross Roads Flying Club · Albuquerque, NMN9692VShow Low Flight Academy LLC · Show Low, AZN988PWChristiansen Bruce L · Windham, MEN9908VDls Computer Services Inc · Lake In The Hills, ILN9927VBunin David K · Rockwall, TXN9948VSchultz Vaughn P · Marysville, CAN9956VFetch N Wag LLC · Sarasota, FLN9971VWalters Aaron R · Estes Park, CON998MSteamboat Springs Flying Club Inc · Steamboat Springs, CON9998VCox Danny A · Panama City Beach, FL
Back to Cessna R172K