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 ('05628VC')
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 ('05628VC')
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.
N101TTGowdy Green LLC · Bunnell, FLN19CJDesmond Richard B · East Falmouth, MAN21740Nanchang Coastal Partners Inc · Wilmington, DEN21753Cutler Jay L · Canton, OHN21790Mills Aviation Charities · Flagler Beach, FLN2181WMcnerney Robert T · Rch Palos Vrd, CAN2183XMuhle Bradford Kurt · Columbus, NEN2184ZKokos Alexander S · Newnan, GAN22YKI Love To Fly LLC · Asheville, NCN23298Peterson Tyler J · Battle Mountain, NVN2329XGriffith Evan J Trustee · Chandler, AZN23PMStinebring Brad L · Columbus, INN26YKNew Venture Properties LLC · Mesa, AZN285CJBlue Skies Aviation LLC · Gulfport, MSN29NLNerad Anton M · Newnan, GAN300YKShales Gary A · Wenatchee, WAN357ABDirty Birds Inc · Noblesville, INN38CVRhino Aerosports LLC · Ponte Vedra Beach, FLN4024NBates Steven R · Prosperity, SCN40369Kilroy Aviation LLC · Versailles, KYN443LMRegistered aircraftN457ABDirty Birds Inc · Noblesville, INN4MFGlidden Kenneth W · Battle Creek, MIN581DSScs Aircraft Management LLC · Culver City, CAN58TAvcraft Inc · Columbus, NEFirst renewal noticeN60849Demarco Roland D Jr · Omaha, NEN60972Gramlick Carl S · Cameron Park, CAN6186Holmes Christopher M · Pittsboro, NCN6339KFtxder LLC · Boulder Creek, CAN63536Reiley Jeremy W · Harlingen, TXN666RWWebb Randol B Jr · Sherman, CTN68WHRed Star Aviation LLC · Lewes, DEN69CYRed Bandit LLC · Phoenix, AZN700YKEttore Varini · Fort Worth, TXN721DSBaar None LLC · Dover, DEN757PSTodd Gaugler · Wichita, KSN76187Jones Donald R · Sandwich, ILN8YKHawgwild Aviation & Holdings LLC · Kansas City, MON92862N586rm LLC · Wilsonville, OR
Back to Nanchang China CJ-6