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 ('2072418')
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 ('2072418')
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.
N80537Clark Robert E · Meridian, MSN80543Redwire LLC · Collierville, TNN80548Southwest Flyers Inc · Spring Branch, TXN80554Green Lawrence M · Las Vegas, NVN80575Wallace Hunter Garrett · Park Hill, OKN80578First Eclipse Ltd · Richmond, VAN80585Ck Leasing Services LLC · Wilmington, DEN80590Air Ward Inc · Novato, CAN80597Panker Patricia A · Lake Havasu City, AZN80602Crass Harold L · Albuquerque, NMN80612Wodishek Mark A · Honolulu, HIN80616Aero Equities LLC · Ventura, CAN80619Level Flight Aviation LLC · Prior Lake, MNN80620Dkr Flyers LLC · Vandalia, MON80627Darke County Aircraft Rental Inc · New Madison, OHN80635Clements Calvin · Palmyra, PAN80636Walls George H · Matthews, NCN80641Missionary Flight Training Inc · Fort Pierce, FLN80643Santa Barbaara Flying Club · Goleta, CAN80657Shelburne Airport Inc · Shelburne, VTN80669Buchert Barbara K · Shrewsbury, MAN80670Jb Aviation Management Inc · Wonder Lake, ILN80673Mitchell Aviation LLC · Mitchell, SDN80678Aero Maintenance Inc · Vancouver, WAN80692Registered aircraftN80697Moe-Air LLC · Cincinnati, OHN806HAFlywell Aviation LLC · Bowling Green, KYN80700Changes In Latitude LLC · Kingwood, TXN80725High Flight Academy LLC · Allison Park, PAN80729Poon Tsui P · Rosemead, CAN80734Tipps Robert J Jr · Port Aransas, TXN80735S & S Aircraft Inc · El Dorado, ARN80742Elliott Richard D · Castle Rock, WAN80751Haaland Karlyle R · Dalhart, TXN80759Leaseair LLC · Wilmington, DEN80764Mcneill Jim R · Wichita, KSN80767Ainsworth Martha Trustee · Bowie, MDN80773Boyl Traci L · Ukiah, CAN80774Dugger Aviation LLC · Merritt Island, FLN80781P D H S Aerial Photography Inc · Spicewood, TXN80784Stamm David A · Lake Almanor, CAN80788Bell Aa Flying Club Inc · Mechanicsburg, PAN80790Wingsleasing LLC · Wichita, KSN80797Neitz Frank · Bethel, AKN80798Thomas Dean Properties LLC · O Fallon, MON807HDTubbs Jerry M · Manns Harbor, NCN80800West Bend Air Inc · West Bend, WIN80803Bradley Charles S · East Bethel, MNN80807Wings Over Texas Holdings LLC · Denton, TXN80810White Hawk Aviation Inc · Brandy Station, VA
Back to Cessna 172M