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.
N636CXNewton Property Leasing LLC · Greene, IAN6370DMelbourne Flight Training LLC · Melbourne, FLN6372DHofmann LLC · Blauvelt, NYN6374DWings Flight Enterprises Inc · Danville, KYN6375DXin Han Aviation LLC · Atwater, CAN6379FHuffman Jacob M III · Burleson, TXN6380DLawson Justin · Jeffersonville, KYN6380ECessna N6380e LLC · Spring Branch, TXN6382DSocal Aviation Inc · Eastvale, CAN6383FWilliams William C Jr · Houston, TXFirst renewal noticeN6384DN2893e LLC · Reno, NVN6386ER M Aviation Inc · Lakeview, MIN6387FMitich Nathan · Fort Worth, TXN6388DBdo Aviation LLC · Dallas, TXN6391JAty Aviation Inc · Watertown, SDN6392GJtw Aero Leasing LLC · Frederick, MDN6393GKrusell Robert S · Blairsville, GAN6394EMilco Airways Inc · River Hills, WIN6395DBirks Jeffrey R · Nokesville, VAN6396DOc Flight Lessons LLC · Costa Mesa, CAN6397DGlacier Cascade LLC · Vashon, WAN63AMSierra Yankee Victor LLC · Austin, TXN63JDD'Angelo Joseph P · Callicoon Center, NYN6407DWalo Enterprises LLC · Aurora, CON6408GWebb Joe R · Union, WAN6409DMontgomery Aviation LLC · San Diego, CAN6412DPort Aero Club Inc · Gold River, CAN6412FRick Aviation Inc · Newport News, VAN6417JChapman Michael K · North Salt Lake, UTN6418DAirways Aviation Inc · Grand Rapids, MNN6418ELima-001 LLC · Muscatine, IAN6426FHigh Anxiety LLC · Kokomo, INN6435DMarion Military Institute · Marion, ALN6440DBurns John Michael III · San Mateo, CAN6441DInter State Aviation Inc · Pullman, WAN6441FMach III Flying Inc · Platte City, MON6446DN2893e LLC · Reno, NVN6449JBentley Aviation Services · Lewes, DEN6450GN6450g Inc · Jacksonville, NCN6454GRoberge James F · Waterville, MEN6457DTristar Aviation Services LLC · Hendersonville, TNN6462DN2893e LLC · Reno, NVN6463GTeens-In-Flight Inc · Palm Coast, FLN6464DHoney B LLC · Hillsboro, ORN6466DValley River Leasing Inc · Murphy, NCN6468DShorter Laurence K · Hinsdale, MAN6468FFlying Aces Aero Fleet Inc · Guyton, GAN6473DTurner Glenn · West Melbourne, FLN6475DDarcy Aviation LLC · Danbury, CTN6476GChupito Sabrocito LLC · Paso Robles, CA
Back to Cessna 172N