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.
N38JAOmek Aviation Corp · Wilmington, DEN419TRAmundsen John D · Soldotna, AKN4425BRadle Alexander P · Flower Mound, TXN459TJohnson Mckenna D · Floydada, TXN471FMccullough Kevin C · Friday Harbor, WAN4796QNeufield Daniel · Brea, CAN479TWilson Chuck W · Mckinney, TXN47HBSparks John Jr · Orange Beach, ALN4VACurrie Michael J · Oceanside, CAN50WLMaw Andrew W · Germantown, TNN5107ZBasic Daniel J · Mulberry, FLN526HHausch LLC · Milwaukee, WIN5608KRyan Carroll M · Redding, CAN5609KNewell Edwin R · Ocean Isle Beach, NCN5616KDebonair 5616k LLC · Saco, MEN5623KLyell Danny P · Ridgeway, SCN5650KCampbell Gordon S · Cleveland, TNN566MMason Seth D · Raleigh, NCN5673KSmith Clifford · Chico, CAN5679KMurphy John Joseph · Mesquite, NVN5680KHarkness Douglas M · Chicago, ILN5714KHonour Aviation LLC · Merritt Island, FLN5744KFlores Isael DBA Flores & Flores Trucking · Bloomington, CAN5772KMarkgraf Klaus · Tullahoma, TNN5796KCooksy Kevin · Cameron Park, CAN5WGHong David S · Yorba Linda, CAN61JKRegistered aircraftN646KDillion James Leo Jr · Colorado Springs, CON64GBEberle John Joseph · Henderson, NVN675ASSan Marco Andrew · Fairfield, CTN6832QWilliams John D · Geneva, OHN6886QYoung Steven F · Sun City, AZN694HLGarza Robert Jr · Minden, NVN69AWReid Wayne P Jr · Yucaipa, CAN711VGStuart William C · Tullahoma, TNN711WPWinston Walter W · Fall City, WAN718CDBussing Robert C · Fort Myers, FLN727NGKarp Michael E · Alameda, CAN728JGMoore Scott P · Tiger, GAN748JHHefley John S · Jensen Beach, FLN750PLittleton Aviation Inc · Ozark, MON756WTNew Age Investments LLC · Joseph, UTN75YRLagergren Steven R · Litchfield, MNN777NOgle Paul W Jr · Norris, TNN785AANeusch Joseph · Fairmont, MNN789VColwell Jeffrey · Tipp City, OHN7902KHutchisson Thomas James · Waxhaw, NCN7912KMorgan William J Trustee · Cleveland, TNN7918KBailey Richard D · Knoxville, TNN7935KMidwest Thermal Optics LLC · Walnut, IL
Back to Beech 35-B33