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 ('1151502')
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 ('1151502')
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.
N2976VDolby Kevin L · El Paso, TXN2979VZxtair LLC · Mankato, MNN2983VBellgardt Robert · North Bend, WAN2987BKrog Donald C · Somerville, NJN2989VContessa Holdings Ltd · Cheyenne, WYN2991VParsons Franklin R Jr Trustee · Kiowa, CON2992VSheridan Jeffrey S · Lakeville, MNN2994VJetmx Inc · Goodyear, AZN2997VMcmahon Jeffrey J · Paris, KYN3001VHillier David C · Oakdale, CAN3013VCusick Christopher J · La Jolla, CAN3019VTimmons Mark M · New Port Richey, FLN3021VMunoz Pedro L · Ontario, NYN3041VGood Brian L · Wildomar, CAN3056VMinneman Alan R · Jefferson, TXN3061VRegistration Pending · Amboy, INRegistration pending, pending cancellationN3064VLehmann Mark C · Trade, TNN3065VEvans Bruce E · Aztec, NMN3068VBurgin Lee · Borger, TXN3074VHancock Steven W M · Bristow, VAN3083VAnderson Charles E · Fort Worth, TXN3088VStartz John D · Dallas, TXN3089VMaximus Aviation LLC · Cheyenne, WYN3093VBeavers Charles M · Rockmart, GAN3096VNovak Warren Devereaux Grey · Lake Placid, FLN3101VWallace William D · Brunswick, GAN3111VStewart Ladd E · Augusta, KSN3114VWheeler Jack W · Greensboro, NCN3119VMartin Lynn E · Princeton, TXN3127VTyner Steven P Trustee · Lees Summit, MON3140VLayton Matthew K · Mesa, AZN3145VClonts Dale · Safford, AZN3146VWittmeyer Jamie J · Wyomissing, PAN3147VRobb Steven G · Riverside, CAN3150VSanders John B · Knoxville, TNN3159VHoogestraatcarl W · Bangor, PAN3164VDisdier David C · Vinita, OKN3171VCarpenter Colt A · John Day, ORN3173VLae Media Group LLC · Gardner, KSN3178VHowell Larry A · Terrell, TXN3181VSitkins Amber A · Ozark, MON3190VTop Flight LLC · Wilmington, DEN3196VOpenshaw Charles M · Huggins, MON3203VGumar Sherko · Scottsdale, AZN3208VIrby Darrell L · Keller, TXN3212VIvy James III · Seligman, AZN3222VRohsner Thomas A · Nacogdoches, TXN3224VHerman Ira · Albuquerque, NMN3233VSanchez Alfonso H · Albuquerque, NMN3238VAltman Michael A · Austin, TX
Back to Beech 35