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 ('1151532')
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 ('1151532')
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.
N409SSBlackwell Aviation Inc · Bell Vernon, PAN40GMSteven E Cox · Bend, ORN416GFHahn Steven P · Hutchinson, MNN41SBBrillaud Stephen A DBA · Germantown, TNN423MDSublett Charles M · Tulsa, OKN423WTCoons John K · Winston Salem, NCN425MGGrinnan Michael · Stafford, VAN42ABGallaway Michael T · Dallas, TXN42WKMariash Cary Norman · Indianapolis, INN4321SBeech Peak Aviation LLC · Boulder, CON436EButcher Gregory E · Pensacola, FLN440DDeeble Kenneth M · Dayton, MTN440QB&T Aviation LLC · Columbia, SCN4444KSivyllis Costas · Port Orange, FLN44PBMcpeck Adam S · Agar, SDN478TFoster Theresa A · Scurry, TXN48LFKraxberger Scotty L · Salida, CON499MBCook Joshua D - Trustee · Nashville, TNN500PFHumphries Stephen A · Kingwood, TXN514CSTomco Stores Ltd · Ruidoso, NMN521VRMyers Jonathan A · Dieterich, ILN523TCSmith Ranch Bonanza LLC · San Francisco, CAN534EGilday Aviation LLC · West Harrison, INN535SBSpeedy Bonanza LLC · Waitsfield, VTN535WNichols David A · Oneonta, ALN541DBKing Mark R · Oxnard, CAN544VIngle Maurice O III · Claremore, OKN550MBRegistered aircraftN555TSBas Part Sales LLC · Greeley, CON55VEChilders Ranch LLC · Templeton, CAN55WRNeumann Capital Holdings LLC · Bossier City, LAN5600KHurta Jennifer Nelsen · Cypress, TXN5604KX-Country Ventures LLC · Usafa, CON5610KAdams Timothy C · Ozark, ALN5614KSherwood George R · Burlington, KYN5615KDennmark Air LLC · Dighton, KSN5618KLundin Michael D · Magnolia, DEN5619KGood Natured Creations LLC · Tucson, AZN5624KWilson Robert J Jr · Gaithersburg, MDN5625KChung Thomas · Stanwood, WAN5640KHowe Eric · Fishers, INN5648KDale James B · Skaneateles, NYN5649KRyan Good Aviation LLC · Sioux Falls, SDN5651KStubblefield Daniel · Chino Hills, CAN5657KWatson Robin G · Eastsound, WAN5661KShockey David Allen · Deland, FLN5662KGiddings Melvin J Jr · Vacaville, CAN5668KMonroe Shannon · Bellevue, WAN5669KYankee Airmen Inc · Torrance, CAN5676KDevlin Jeff M · Seattle, WA
Back to Beech S35