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.
N60HFTexas Flying Club Inc · Bryan, TXN610AMSwaz Aviation LLC · Mesa, AZN611CAWilliams Todd A · Littleton, CON611EAEndeavour Flight Training Inc · Opa Locka, FLN6122DBudde Bobby M Jr · San Jose, CAFirst renewal noticeN6123FJws Aviation LLC · Edina, MNN6124DWegener Flying Services LLC · Indialantic, FLN612BZDerby City Aviation LLC · Vero Beach, FLN6130DJones Matthew A · Saluda, NCN6132GMorcom Aviation Services Inc · Everett, WAN6133DThomas Aviation · Granada Hills, CAN6134GMagruder David · Independence, LAN6137EPennington Mitchell T · Medley, WVN6142XHurt Ronald L · Smithville, TNN6150FFranklin Aviation LLC · Paradise, CAN6158GCag Aircraft Holdings LLC · Crystal River, FLN6163FVagabond Flying Association · Winfield, ILN6164FBlue River Aviation LLC · Palmer, AKN616SKSuperior Flying Services LLC · Superior, WIN6172DBlue Spruce Aviation LLC · Fairview Park, OHN6175GKimber 123 Holdings LLC · Morgantown, WVN6176GGaruda Flight Training LLC · Miami, FLN6181FTarchinski James E · Rochester Hills, MIN618MNEack Kenneth B · White Rock, NMN618TMTuskegee Airmen National Historical Museum · Detroit, MIN6190DTap Solutions Inc · San Diego, CAN6194DBha Leasing Corp · South Portland, MEN6194EReeburgh Scott L · Vancouver, WAN6196DJeff Air Pilot Services LLC · Shelbyville, INN6198FFox Aviation LLC · Glencoe, ALN6206DP & W Investments Inc · Wilmington, DEFirst renewal noticeN6211DMcdonald Air Services LLC · Saint Johns, MIN6212FParker Helicopter LLC · Watsonville, CAN6212GLionheart Aviation Services LLC · Fairfax, VAN6230DUsda Aphis Wildlife Services · Cedar City, UTN6231EMiller Edward P · Northfield, MNN6231FH & F Aviation Inc · Labelle, FLN6232DJav Air Services LLC · Anchorage, AKN6233DGrauert Ritter Trustee · Van Nuys, CAN6239DAerial Precision LLC · Entiat, WAN6239FEckert Ted · Cedar Creek, TXN6245DJeffery & Weiss Holdings LLC · Long Beach, CAN6248DEscobar Frank · Tampa, FLN6252DH & H Aviation Enterprises LLC · Fairfield, OHN6254DSeventy Seven Industries LLC · Waddell, AZN6255DBowdidge Jeffrey E · Kingwood, TXN6256GIlmberger Stephen J · Bend, ORN6257DDrabek Howard E · Richmond, TXN6258FNance David B · Quinton, VAN6261DN6261d LLC · Wilmington, DE
Back to Cessna 172N