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 ('2072434')
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 ('2072434')
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.
N738ZYRegistration Pending · Syracuse, NYRegistration pendingN73900Dewey William B · Santa Barbara, CAN73904Vaayu Aviation LLC · Newark, CAN73910Arispe Aviation LLC · Mckinney, TXN73917Wingsleasing LLC · Wichita, KSN73922Mouton Charles J Jr · Gladewater, TXN73923Professional Aviation Aircraft Services Ltd · New Philadelphia, OHN73924Mack Aviation Holdings LLC · Atlanta, GAN73925Wings Over Texas Holdings LLC · Denton, TXN73926Hatanaka Brandon C · Loveland, CON73927Abcd Ventures LLC · Ada, OKN73928Air Peanut Ltd · Wilmington, DEN73929Jprg Aviation Inc · Orlando, FLN73930Bunke Paul R Trustee · Harrison, OHN73934Hanson Alexander P · Bremerton, WAN73938Preston Richard R Trustee · Albuquerque, NMN73946Carastro Enterprises LLC · Montgomery, ALN7395DAviation Management Group LLC · Endicott, NYN73964Coachron Investments LLC · Grosse Ile, MIN73977Bfl Aviation LLC · Bakersfield, CAN73981Gagnon Michael J · Merrimack, NHN739ADSeven Three Nine Alpha Delta Club Inc · Memphis, TNFirst renewal noticeN739AFSilver Isaac M · Satellite Beach, FLN739AGS O W Aviation LLC · Crystal River, FLN739AJAviation Adventures LLC · Billings, MTN739AKChen Wu · West Windsor, NJN739AMBartels Michael · San Antonio, TXN739APMilwaukee Aero LLC · Milwaukee, WIN739AQAzure Mahpiya LLC · Dublin, CAN739ATSocal Aviation Inc · Chino, CAN739AVMk914 Aviation LLC · Boynton Beach, FLN739AWOsborn Lawanda H · Weatherford, TXN739BCSecond Wind Aviation Corp · Friday Harbor, WAN739BEFtg Leasing LLC · Watkins, COFirst renewal noticeN739BJDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN739BKSundown Robert W · Bethel, AKN739BNR&R Aero Services LLC · Eden Prairie, MNN739BTBoeing Employees Flying Assn Inc · Renton, WAN739BVBurgol Hisham · Novi, MIN739BXSkypark Inc · Wadsworth, OHN739BZTfs Air LLC · Loveland, CON739CCCitadelle Holdings LLC · Wilmington, DEN739CDKcsi Aerial Patrol Inc · Bakersfield, CAN739CMHansen Lee A · Faulkton, SDN739CNAerobiz LLC · Lewes, DEN739CYTodd Goven Farms Inc · Turtle Lake, NDN739CZBullock Michael L · Albany, INN739DBMelbourne Flight Training LLC · Melbourne, FLN739DDRivera Carlos R · Carolina, PRN739DEWings Over Texas Holdings LLC · Denton, TX
Back to Cessna 172N