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 ('9230104')
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 ('9230104')
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.
N80712Hansen Ernest F Trustee · Sequim, WAN80717Whittaker Paul R · New Alexandria, PAN80730Davis Lee B · North Little Rock, ARN80733Dicker Janet L · Scottsdale, AZN80737Registered aircraftN80740Neal Craig L · Melissa, TXN80741Pitts Daniel L · Hayesville, NCN80744Miller Kevin R · Addison, TXN80748Coker Stephen R · West Berlin, NJN80762Moving Tails Aviation LLC · Woodbridge, VAN80772Payne Michael S · Sequim, WAN80775Sierra Bravo LLC · Littleton, CON80776Winslow Donald Raymond · Bullhead City, AZN80786Oney Marilyn S · Beach City, OHN80787York Richard Alan · Amherst, NYN80794Durham David C · Belton, SCN80796Supina Mickey A · Prescott, AZN80799Globe Swift LLC · Chino Valley, AZN80801Hougen Greg H · Rifle, CON80805Elmore Brandon Tracy · Wytheville, VAN80817Early Patricia A · Palmyra, PAN80819Mccormick Robert A · Scottsdale, AZN80820Palmer Thomas T · Kapowsin, WAN80827Joda Leasing Inc · Tampa, FLN80829Johnson Kyle A · Cheshire, CTN80833Irwin International Inc · Corona, CAN80844Laforce Larry B · Big Sandy, TXN80846Bartholomew Don · Gardnerville, NVN80850Travland Lewis H · Alpine, TXN80851Spirit Of Flight Foundation · Nampa, IDN80856Andrews Terry L · Camp Verde, AZN80862Ulmer Bryce D · Locust Grove, GAN80869Bailey Robert L · Shoreview, MNN80883Gann Edward L · Brighton, CON80888Jensen Luke L · Burlingame, CAN80901Mccann Michael · Springfield, ORN80902Javarey David J · Corning, NYN80903Southern Aircraft Consultancy Inc Trustee · Casper, WYN80909Kirkman Todd · Port Charlotte, FLN80910Edmonds Jonathan · Jonesboro, ARN80913Perla Guido F · Vashon, WAN80919Registered aircraftN80922Montpelier Gary L · Bushnell, FLN80923Registered aircraftN80924Legacy Flight Museum · Rexbury, IDN80932Swift Museum Foundation Inc · Athens, TNN80933King Larry Joe · Quanah, TXN80949Barker Bradley C · Houma, LAN80953Benson Wayne L · Wurtsboro, NYN80955Lane Kevin M · Fort Wayne, IN
Back to Globe GC-1B