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 ('1152740')
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 ('1152740')
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.
N673HPBk Investment Co LLC · Jupiter, FLN6741DPerformance Aircraft C LLC · Litchfield Park, AZN6742NCrazy Mountains Aviation LLC · Columbus, GAN6745MPerkins Communication LLC · Northport, ALN6747TYesco Administration LLC · Salt Lake City, UTN676GGuest Air LLC · Plains, GAN678JInternational Air Services Inc Trustee · Carson City, NVN67971Trophy Holding LLC · Ocoee, FLN6810SUsda-Aphis-Ppq · Edinburg, TXN6860LPrevost Christopher D · Sonoma, CAN686FRVon Syke Orchards LLC · Anderson, SCN68BQUnfinished Journey LLC · Dover, DEN69WSHurricane Joaquin LLC · Umatilla, FLN6BYDac Aero LLC · Jacksonville, FLN6CHHodge Cleophas U · St Thomas, VIN6VUPro Motive LLC · Glade Spring, VAN6WWWintons Wings LLC · Bardstown, KYN700KBrenner Gary Lynn · Mission Viejo, CAN702JKAlpha Whiskey Air Company LLC · Richardton, NDN703NCNunn Bryant · Canton, MIN705GWFba Aviation LLC · Wildwood, FLN705NCEagle Leasing Inc · Gaylord, MIN707LAStowers Machinery Corp · Knoxville, TNN707PWAtaraxia Aircraft Holdings LLC · Greenville, SCN707WLFlight Solutions LLC · Chesterfield, MON708MAFlying Machines LLC · Grand Ledge, MIN7092THidden Valley Aviation LLC · Denton, TXN710JBbs Aircraft Leasing LLC · Wellington, FLN712GDOsborne David · Texarkana, ARN712JZHeffley Brothers Flying Circus LLC · Benbrook, TXN7166KKellar John C · Runaway Bay, TXN717ERThomas James V · Cullman, ALN71GRRahmeyer Gary W · Lake Ozark, MON7208VMeyer Ag Aviation Inc · Whittemore, IAN7209BFly By Knight Inc · Hammond, LAN720WCSw Aviation LLC · Wilmington, DEN7210CUpupair LLC · Raleigh, NCN7217HMaine Instrument Flight · Augusta, MEN7219HGrandview LLC · Columbus, MSN721LTWhite River Holdings LLC · Southaven, MSN7220JMuddy Waters LLC · Pompano Beach, FLN7220UFlying R Aviation LLC · Smackover, ARN72235Blass Robert · New Smyrna Beach, FLN7223BAmerican National University Inc · Salem, VAN7223YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN72252Aerospace Trust Management LLC Trustee · Wilmington, DEN7225RWalker Michael E · Lewistown, MTN7229CLietzke Gerald P · Geneva, FLN722AGLdg Aviation LLC · Carefree, AZN7232HCu Tigers Fly LLC · Greensboro, NC
Back to Beech 58