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 ('1151524')
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 ('1151524')
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.
N5394ERusak Robert J · Paris, TXN5397ECasella David A · Sonoma, CAN555EVennari Victor · Elbert, CON599EPritchett Douglas C · Canyon, TXN59BETibbs Air Inc · Germantown, TNN59MKTff Inc · Parma, MIN59TEDunn Craig P · Henderson, NVN5BSShanholtzer Richard L · Mckinney, TXN5EHEsoteric Air Inc · Cypress, TXN5NBMurphy Spencer A · Rome, GAN6001EPhillips Bruce D · Vashon, WAN6003EFrehner Nathan · Roosevelt, UTN6005EMakiyama Todd · San Ramon, CAN6006ESchoenau Michael W · Tulare, CAN6007EOboa Enterprises LLC · Edmond, OKN6010EBruce Mkristo E · Ravensdale, WAN6015EGlaysh-Air Aviation LLC · Cary, ILN6016EHagins Chrisopher Ryan · Yulee, FLN6018EBurns Robert D · Billings, MTN6019ECobb Lee C · Van Alstyne, TXN601SGBrynildson Scott W · Rifle, CON6020EDominianni Michael J · Chester, NJN6021EMerhar Timothy J · Shoreview, MNN6022EWard John B · Fishers, INN6026ERegistered aircraftN6027EJava LLC · Oxford, MSN6034EKoch Gary B · Roseville, CAN6037EN6037e LLC · Williamstown, WVN6039ELangford John · Pilot Point, TXN6041EGirod Consulting Inc · Duncan, OKN6043EWhitaker Charles D · Kettering, OHN6046EMaltby Gary M · Malvern, ARN6047ECampisi Brian James · Eliot, MEN6048ESones Kelly L · South Lake Tahoe, CAN6049EBeale Paul D · Longmont, CON6050EJohnson Jay L · Hillsboro, MON6053EDublin Airforce LLC · Dublin, GAN6054EKj & J LLC · Lamar, MON6055EBurns Ortis R · Warner Robins, GAN6057EPeterson Kenneth M · Henderson, NVN6058EBrandt Glen L · West Bend, WIN6059EWiseth Kurt C · Thief River Falls, MNN6061EChase William B · West Des Moines, IAN6064EBeauboeuf Jeffrey M · Woodworth, LAN6070EBas Part Sales LLC · Greeley, CON6071EBoltz Leonard E · Pearson, WIN6072EKnott Thomas · Clinton, MON6083ESwisher Michael S · Yukon, OKN6084EMargart Geoffrey W · Mount Shasta, CAN608QDoss Steven V · New Orleans, LA
Back to Beech K35