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 ('2072732')
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 ('2072732')
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.
N94853Middle Georgia Aviation Services LLC · Warner Robins, GAN94854Sutliff John K · Walla Walla, WAN94872Weber Brian T · Hastings, MNN94897Baca Raymundo · El Paso, TXN94908Robert E Carroll Logging Inc · Ebony, VAN94916Milne Dave · Snohomish, WAN94918Urfer Kenneth M · Sparks, NVN94937Kidder Robert S · Burlington, KYN94938Kalaiselvan Arunram · Richland, GAN94940Shurley Billy R · Cabot, ARN94944Jav Air Services LLC · Anchorage, AKN94946Van Duzer John P · Alpine, CAN94986United States Air Force (Owner) · Usaf Academy, CON94993Meyer Michael S · Marietta, GAN94BCChapman Air LLC · Plain City, OHN94EJCamp Gerald M · Murrieta, CAN951CCBrouchoud Jayson R Trustee · Ridgecrest, CAN95494Valiair Limited Co Trustee · Casper, WYN954CCSavvas Evangelos · Edina, MNN95500Pond Scott L · Moorpark, CAN95521Martin Aviation LLC · Kalispell, MTN95528Welch Clare A · Longboat Key, FLN95540Gracejet Aviation LLC · Brownsboro, TXN95541Pershing Air LLC · Sheridan, WYN95544Keller Lucas J · Vale, ORN95602King Douglas W · Bend, ORN95631Tree Top Partners LLC · Berea, KYN95649Hawker Aviation LLC · Lewes, DEN95650Jnl Leasing LLC · Basalt, CON95659Uccellino Inc · Roslyn Heights, NYN95661Godfrey Turhan L · Lewis Center, OHN95677Steils Building Renovation And Management Inc · Lino Lakes, MNN95678Jpr Aviation LLC · Hillsdale, INN95682Longview Research And Development Inc · Chetek, WIN95686Shutt Terence M · Goleta, CAN95696Cobb Brent D · Eden Prairie, MNN95720Stilley John · Flagstaff, AZN95721Copeland Danny K · Roseville, CAN95740Nicholes Steven A Trustee · Portland, ORN95747Eichelberger John Andrew · Winchester, MAN95764Marc Inc · Bolton, MSN95766Ongstad William · Harvey, NDN95785Elton Donald Robert · Kissimmee, FLN95789Katmai LLC · Mount Pleasant, TXN95801Abraham James · Johnson City, TNN95802Aircraft Acquisitions Inc · Durham, NCN95807Prostar Flight Services LLC · Bozeman, MTN95808Cape Cod Aero Club LLC · Falmouth, MAN95826Mountain Air Inc · Ducktown, TNN95834Herschend James R · Ozark, MO
Back to Cessna 182Q