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 ('2072702')
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 ('2072702')
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.
N5489BNewhouse David · Belvidere, NJN548PGuin Wilson L · Alamogordo, NMN5491BSmith Richard D II · Luthersville, GAN5495BCable Strong Aircraft Holdings LLC · Tyler, TXN5497BBlue Sky Powers N5497b LLC · Dover, DEN5500BKay James L · Irvine, CAN5501BSeymour George N · Shelby, MTN5508BBohner Richard A · Pls Vrds Est, CAN5509BKorn Antony · Chehalis, WAN5513BDemartini Mark D · San Jose, CAN5519BRaven Air LLC · Athol, IDN5521BHunt Nicholas R · Bozeman, MTN5522BBazerko Family Fun LLC · Caldwell, IDN5526BDoelger Parker · Norwood, NYN5527BAdrenaline Inc · Chambersburg, PAN5530BInternational Air Services Inc Trustee · Carson City, NVN5531BNighthawk N8231g LLC · Granite Bay, CAN5535BAvery John W · Fergus Falls, MNN5536BHigh Five Flying LLC · Amarillo, TXN5542BSkydive Coolidge Inc · Tempe, AZN5543BSvetlik Ludvik J · Victoria, TXN5546BHeczko Eric M · Longmont, CON5550BLieberherr John W · Clancy, MTN5555BGonzales Gerson · San Juan, PRN5561BLammers Bart · Jordan, MTN5563BVanlaningham Larry B · Lakewood, CON5564BKramer Clifford R · Eastport, IDN5565BMargetts Kevin M · Folsom, CAN5566BMoore Michael E · Renton, WAN5568BDill David M · Buena Vista, CON5570BDavis Lucas · Kennewick, WAN5572BOrcutt David R · Greenleaf, IDN5574BEyler Keith Michael-Wayne · Menifee, CAN5575BBorcherding Steven T · Anchorage, AKN5577BTheobald Daryl · Aberdeen, SDN5578BFrench Daniel T · Hobson, MTN5579BHutchison Robert T · Big Lake, AKN5580BLayman James D · Eagle, AKN5590BChambless Ronald Hugh · Abernathy, TXN5591BRegistered aircraftN5592BJopson James M · Newman Lake, WAN5593BQualick Robert N · White Rock, NMN5594BPara-Plane Aviation Inc · Thomasboro, ILN5595BLahn Dave R · Quincy, WAN5596BFlyventure LLC · Fort Wayne, INN5597BBucher Burton W · Waukegan, ILN5600BParks Darryl D Trustee · Eagle River, AKN5609BWinkelman Ronald A · Chugiak, AKN5616BCasey Joseph · Buffalo, WYN5617BTruck Plus · Nampa, ID
Back to Cessna 182