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 ('2073704')
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 ('2073704')
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.
N29362Registered aircraftN29366Bond Joseph C · Arlington, TXN29367Dulin Jim · Valparaiso, INN29377Duncan John M · Owingsville, KYN29379Sattler Russell P · Brooksville, FLN29389Otc Aviation LLC · Deer Creek, MNN29395Hand Randall A · Bonifay, FLN2939XDahl Skye T · Camas, WAN29400Registration Pending · Wakefield, RIRegistration pending, pending cancellationN29409Nimmo David G · Ponder, TXN29415Dahlen Jeffrey P · Devils Lake, NDN29422Kmz Transport & Leasing Services LLC · Bradenton, FLN2942XLewellen Mark A · Pensacola, FLN29430Mcvicker Max W · Sand Springs, OKN29432Waddell Bhrent E Trustee · Collinsville, OKN29434Salvi Marcos · Phoenix, AZN29436Echelon Sport Aviation LLC · Los Angeles, CAN29439Eagle Sky Patrol Inc · Deadwood, SDN2943XMccormack Robert · Sacramento, CAN29440Eagle Sky Patrol Inc · Deadwood, SDN29441Chan Luen Hei · Hacienda Heights, CAN29442Nance David B · Quinton, VAN29444Pikula Eric Martin · Brainerd, MNN29448Central Virginia Aviation Inc · North Dinwiddie, VAN29449Brown D W · Wasilla, AKN29455Heir Richard T · Lambert, MTN29459Frana Cody R · Eagle Rock, MON29462Thomas Stanley L · Thermopolis, WYN29467Teel Kevin E · Fallbrook, CAN29468Cummings Mark R · Laveen, AZN29469Gem Property Investments LLC · San Antonio, TXN29474Leslie Jason · Dayton, OHN29479Kozminski Michael J · Caledonia, WIN29480Cobra Aviation LLC · Kalispell, MTN29481Walle Heidi N · Coarsegold, CAN29485Lily Anne Aviation LLC · Bad Axe, MIN29488Luther Charles A · Walnut Creek, CAN29495Beaudine Robert J · Westlake Village, CAN29509Empty Nest Aviation LLC · Mckinney, TXN2950XEagle Sky Patrol Inc · Deadwood, SDN29512Heck Jean M · Colorado Springs, CON29518Cardinal Aviation LLC · Chambersburg, PAN29520Best Equipment Leasing LLC · Bakersfield, CAN29521Harmon Brian L · Wichita, KSN29523Mcgaha Edgar E Jr · Rio Vista, CAN29530Rockdale Flying Tigers Inc · Rockdale, TXN29531Pell George D · Hillsboro, ORN2953829538 Aviation LLC · Fernandina Beach, FLN29539Hoosier Fliers LLC · Bloomington, INN2953XJohnston Daryl T · Euless, TX
Back to Cessna 177