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.
N80956Brian Engineering & Consulting Pllc · Tulsa, OKN80960Perry Robert Lawrence Trustee · Salinas, CAN80963Koester John K · Cottage Grove, ORN80966Holliday Mark · Lake Elmo, MNN80969Windsock Capital LLC · Bertram, TXN80971Simmons Aeronautical LLC · Springfield, MON80973Williams Daniel L · Pickrell, NEN80974Richbourg Keith D · Waco, TXN80977Van Pelt Martin J · Venice, FLN80978Smith David Carroll · Brewster, WAN80983Walz Thomas D · Lakeville, MNN80986Albright John W · Richmond, INN80989Aviation Trust Company LLC Trustee · Oklahoma City, OKN80993Kerby Brett · Orem, UTN80995Theen David R · Englewood, FLN80997Jenkins Johnny L · Dallas, GAN80999Troeleman Nicholas D · Sun City Center, FLN8154RRegistration Pending · Bertram, TXRegistration pendingN81CWEllingham Jeffrey B · Perry, GAN81MARoberts Max E · Loudon, TNN84799Mercandetti Paul L · Knoxville, TNN8508XZambelli Robert Gene · Manning, SCN853CRegistered aircraftN853EDavid 30 LLC · Boise, IDN888JGHughston Thomas E · Boerne, TXN88VASo Send I You LLC · Cheyenne, WYN90305Varnado Jason P · Hattiesburg, MSN90316Miller Charles · Bynum, TXN90321Jackson Virgil Gene · Kingsport, TNN90323High Edward O · Winter Park, FLN90325Avent Barry G · Bennettsville, SCN90333Gattuso Phillip Joseph · Healdsburg, CAN90341Chileprop LLC · Mimbres, NMN90347R & S Aircraft LLC · Wilmington, DEN90355Williams Mike A · Hartsville, INN90356Rokosny Tyler · Port Orange, FLN90361Fisher Nicholas W · Ponchatoula, LAFirst renewal noticeN90363Mahoney Gerald P · Sequim, WAN90373Wolff Reese · Chula Vista, CAN90392Parsons Walter E · Clinton, NCN90394Evans Douglas B · Wimberley, TXN90395Mccall James L · La Pine, ORFirst renewal noticeN958MMcgaha James M · Jonesborough, TNN9DBPeters Dylan Richard · Hampton Falls, NH
Back to Globe GC-1B