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 ('1151548')
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 ('1151548')
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.
N33VHRegistered aircraftN33VSRare Eagle Aviation LLC · Westcliffe, CON342UWelch Robert T · Alamogordo, NMN346BGWebstrong Aviation LLC · Conway, ARN346S200 Knot LLC · Amarillo, TXN348SKoritz Iowa Properties LLC · Key Colony Beach, FLN350NEMaresco International Corp · Alpha, NJN350YRSilverman Kenneth · Pelham, NHN3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARN351VBWudtke Dale A Trustee · Palos Park, ILN3526ARoeder Miles · Houston, TXN353RSecond Time Around Lt LLC · Corona, CAN354DJN354dj LLC · Gulfport, MSN354DRRadwanski D · Westmont, ILN354DZDachnowicz Peter A · Avon, CTN354PFBillen Jerome · Hodges, SCN358ALlewellyn Development LLC · Charlotte, NCN3594AFlying Fur Animal Rescue · Kintnersville, PAN359ERJames Chad · Needville, TXN35BCjs Aviation LLC · Methuen, MAN35BMBecker Lawrence D Md · Anacortes, WAN35BNAerospace Trust Management LLC Trustee · Wilmington, DEN35BTMarconi Properties LLC · Westbrook, CTN35CGComesa Service Group · Middletown, DEN35EKHaupt Erik · Great Barrington, MAN35KAHacker Timothy J · Pangburn, ARN35KJBunn John Timothy · Winter Garden, FLN35KWCoy Walter Thomas · Titusville, FLN35LFPlane Fun Inc Tr Trustee · Snellville, GAN35MSimmons Dennis L · Wichita, KSN35MFFlying Barefoot Ranch LLC · Wilmington, DEN35NBBert John Boyd III · Vero Beach, FLN35NYPerry Charles E · Aldie, VAN35SCCramp Steven J · Cleveland, TXN35TBCencalcom Inc · Santa Barbara, CAN35TJBeech D9462 LLC · Perry, OHN35TPMccallister Mark A · Qulin, MON35VBEquipment Lessors Inc · Lake Hawatha, NJN35YRTonini Farm And Cattle Co · San Luis Obispo, CAN3627AHint Mart H · Peachtree City, GAN3629ADarrow Mark A Trustee · Mukilteo, WAN362TBarnett Blake C · Boynton Beach, FLN3632APauly Adam · Macomb, MIN36363Klein John · Woodland, CAN363BCBig Cha Inc · Wilmington, DEN3650AMcclain Aviation LLC · Newark, DEN3676YYesco Administration LLC · Salt Lake City, UTN3692ABva Bonanza LLC · Keizer, ORN3728AAc Bonanza LLC · Carrollton, TXN3735BBas Part Sales LLC · Greeley, CO
Back to Beech V35B