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 ('2072712')
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 ('2072712')
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.
N3136YReed Jason B · Faith, SDN3137YLopez Juan F Jr · Del Rio, TXN3140YParker Mccrum LLC · Eugene, ORN3142YOdom Aviation Inc · Cabot, ARN3145YSiskiyou Aviation LLC · San Jose, CAN3148YHernandez Alfonso C · Garland, TXN3151YVert James E · Davison, MIN3156YGrant Robert N · Pollock Pines, CAN3161YSleepy Cat Mountain Real Estate Co · Meeker, CON3162YRogers Anthony L · Monrovia, CAN3165YFoster John W · Olathe, KSN3170YStillson John L · Rock Rapids, IAN3171YDj Aviation LLC · Newburgh, INN3172YPeters Barry S · Montague, CAN3175YPittman Joel C · Apple Valley, CAN3176YThomas Steven Dale · Monticello, ILN3177YSkyknights Sport Parachute Club Inc · East Troy, WIN3178YNiles Air LLC · Concord, NCN3179YWolstein Joe M · Bigfork, MTN317KAWycka Michelle Sarah · Stayton, ORN3180YWalker Jim · Lovell, WYN3182YHeckethorn Philipp · Baker, NVN3183YAlc Aviation LLC · Milwaukee, WIN3184YFunkhouser David E · Weatherford, OKN3185YGochenour Air Inc · Fort Wayne, INN3186YJram Air Parts LLC · Henderson, NVN3187YMiller Richard G · Anson, TXN3188YIngram Patrick Joseph · Pinedale, WYN3190YSpencer Thomas D · Brentwood, TNN3192YArea 52 Aviation LLC · Casper, WYN3193YDavis Loyal A · Santa Rosa, CAN3194YSchexnayder Jennifer · New Roads, LAN3195YFlyers Above The Payette LLC · Mccall, IDN3196YRickles Richard J · Chamblee, GAN3197YMonahan Robert J · Bulverde, TXN3198YKembel Cary A · Snyder, CON3199YClearwater Valley Aero Club Inc · Kamiah, IDN3200YCondo Gerardo B · Miami, FLN3208YHamilton Triple C Farms · Ririe, IDN3210YBergren William · Des Moines, IAN3211YFour M Properties LLC · Prague, OKN3213YFletcher Jerry D · Yukon, OKN3217YBrowne Robin P · Dallas, TXN3218YCollins Marcus E Jr · Camilla, GAN3220YTanner Fred E · Westville, FLN3221YRegistration Pending · Brea, CARegistration pendingN3222YCreighton Andrew M · Lebanon, TNN3224YCrouchet Jay · Kremlin, MTN3225YSamaritans Purse · Boone, NCN3226YVaughn William Harrison · San Antonio, TX
Back to Cessna 182E