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 ('2072706')
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 ('2072706')
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.
N2453GPeloquin William A · Portland, MIN2461GSeven Hi Flying Club · Saratoga, CAN2465GMunson Darrel L · Ogallala, NEN2467GShort David J · Warrensburg, MON2470GBaillargeon Richard W · Springville, IAN2477GRamsey Stephen C · Aspen, CON2478GGilliland Sandra K · Julian, NCN2480GGassaway Mitchell E · Carrollton, TXN2481GEaster Brett D · Enumclaw, WAN2483GLenox Mark W · Idaho Falls, IDN2485GBack Country Guys LLC · Prescott, AZN2486GDenton Bob · Nampa, IDN2487GRegistration Pending · Aledo, TXRegistration pendingN2488GRumley Orville C · Minco, OKN2489GRogers Gregory J · Plesant Hill, MON2491GShowah Christopher Douglas · Indianola, MSN2495GHayton James B · Sedro Woolley, WAN2497GChapman William F · Coeur D Alene, IDN2498GKc Aircraft LLC · Missoula, MTN2507GBanks Gary M Jr Trustee · Scituate, MAN2508GBig Well Flying Club Inc · Kinsley, KSN250FBishop Thomas W · Decatur, TXN2512GSutton Aircraft Salvage LLC · Palmer, AKN2513GSedlickas Mark A · Graham, WAN2520GGrinch Aviation LLC · Madera, CAN2521GMountain Aviator LLC · Edwards, CON2522GMull Morgan · Greensburg, PAN2523GDannebrog Air LLC · Grand Island, NEN2525GWoods Dana · Mountain View, ARN2527GRafter H Livestock · Rawlins, WYN2530GRegistered aircraftN2532GWilliams Mark E Trustee · Reno, NVN2536GDittmer Larry J · Basco, ILN2537GDirigo Aviation LLC · York, MEN2541GDuvall Paul M · Scottsburg, INN2544GEnsman Enterprises LLC · Chino Valley, AZN2545GSpokane Turbine Skydiving LLC · Medical Lake, WAN2547GHiebert Franz · Seminole, TXN2548GWells Kenneth B · Fort Myers, FLN2549GBrooks Roger W · Fairbanks, AKN2551GDaum Cole C · Woodstock, GAN2553GRegistered aircraftN2558GScolari Shawn Fenton · Meeteetse, WYN2560GJackson Air LLC · Temecula, CAN2564GGarrison Jeffrey R · Clemson, SCN2565GMoore Timothy L · Wendell, IDN2567GSunrise Exploration Inc · Northport, WAN2568GKoechen Wayne L · Cooper Landing, AKN2571GGolf Air LLC · Anchorage, AKN2572GMorgan Nathan · Boise, ID
Back to Cessna 182B