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 ('1151406')
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 ('1151406')
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.
N1597SJones William F · Seneca, SCN15MEnglish Dexter · Syracuse, KSN165MRDavid Rever Aviation LLC · Dewey Beach, DEN167MStoltzfus Jesse A · Greenfield, OHN1705GDavis Roger N · Cheshire, ORN1714GBull Rises LLC · Byron Center, MIN1718GWhitlock Charles Parker · Thompsons Station, TNN1723GDillahunty Chris D · Shaver Lake, CAN1724GNelson Debra L · Presque Isle, MEN1735GFeldhaus Joseph H · Shelbyville, TNN1740GOelrich Matthew Alan · Concord, CAN1742GLoftus Kevin · Pasadena, CAN1747GPalmenteri Louis J · Rhome, TXN1748GRobar Aircraft Inc · Griffin, GAN1751GThaxton Todd J · Williamson, GAN1758GMullooly Michael S · Redwood City, CAN1759GVandergenugten Brian J · Schererville, INN1766GCallaway Ike Wingate Jr · Tampa, FLN1767GFranceus Maurice Michael · Temperance, MIN1768GRl Hoffman Aviation Services Inc · Sanders, KYN1782GJts Aircraft LLC · Rock Hill, SCN1783GHarrington Perry J · Carlsbad, CAN1791GPac Flying LLC · Saint Johns, FLN1793GGeorgen Auto LLC · Manchester, IAN1798GMeaux Jimmie J Jr · Kaplan, LAN1929UHolmgren David J · Plainfield, NJN1995AReeder James T · Ottawo, KSN1QYJet X Leasing Inc · Johnson, KSN21WSRdb Leasing Inc · South Fork, CON221DBSegura Richard J III · Henderson, TXN22DSSwartwout David C · Sedona, AZN22GDMagafly LLC · Bay City, MIN2360JReed Matthew A · Burnsville, MNN253JC96 Quick LLC · Wilmington, DEN285BWWatson Alex · Chadron, NEN2LCStults Curt M · Choctaw, OKN2MTO'Leary John M · Fresno, CAN302JHYang LLC · Lewisburg, WVN30301Brown Gregory R · Spotsylvania, VAN3090TBeech 3090t Inc · Midlothian, TXN315NFOconnor Randy B · North Port, FLN3300FCarter Flygare Inc · Sacramento, CAN330CLCoalos Inc · State College, PANon-citizen corporation, flight hours not reportedN333BZBaker Adam W · Germantown, TNN334MEKline Timothy J · Van Nuys, CAN334MTBlomquist Mark S · Gardiner, MTN33MZGriffin Vinson T · Hogansville, GAN35JHFreutel Hagen · Goleta, CAN35TCLynn David R · Mobile, ALN37YRogers Jeffrey · Bend, OR
Back to Beech 35-B33