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 ('1151504')
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 ('1151504')
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.
N11AXLoukopoulos George Matthew · Tucson, AZN146DSale Reported · San Diego, CASale reportedN149DSBuffaloe Thomas N · Mancos, CON149EDR&R Unlimited Inc · Alma, ARN1DNWarren Howard E · Cookeville, TNN234RRMaselli John F · Bay City, ORN255BEkstrum Eric S · Mound House, NVN2TDRds LLC · Strongsville, OHN326TSShirley Terry L · Winnsboro, LAN333KPGyarfas Nicholas · Lafayette, LAN354DEHomesley Jonathan Edward · Mcgregor, TXN35EFFourt Rob · Bentonville, ARN3777JBeltz Richard D · Lehighton, PAN3812NHixon Craig · Sayre, OKN3816NBailey James · Lewisburg, TNN410BWright Samuel B · Haines, AKN424BDenney Jody M · Mcminnville, TNN426BAnyones Home LLC · Enid, OKN431BKnisley David J · Jacksonville, FLN451BVan Velden Chris W · Yucaipa, CAN461BNottingham Jeff · Fuquay Varina, NCN473ABTake Flight Aviation LLC · Grand Forks, NDN480ASArizona Air Salvage · Phoenix, AZN486BSale Reported · Nixa, MOSale reportedN489EJerrolds Skye S · Knoxville, TNN490PAnthony Ballone · Tulsa, OKRevoked, canceledN494BStutzman Frank C · Caldwell, IDN497BWillis James R · Belleview, FLN504BYeagley Daun E II · Wilmington, OHN505BLeyda Aaron M · Bartlesville, OKN515BTurnkey Design Build LLC · Sarasota, FLN526BPutnam Michael C · Topeka, KSN532BWeinreich Mark W · River Falls, WIN537BN537b LLC · Crowley, LAN545AEelkema Peter C · Mckenzie Bridge, ORN548BCopass Benjamin Jay · Fountain Run, KYN553BJ M Thomas & Assoc Inc · Panama City Beach, FLN554BDaniel James W · Somis, CAN55WRussell Richard · San Jose, CAN577BKrueger Hendrik · Rockport, TXN582BSievers Gilbert H · Medina, OHN589BRyanns Hangar LLC · Sparta, MON590BFolds James W · Tifton, GAN594BBaxter Derec L · Chatham, ILN598BMeeks Howard S · Lompoc, CAN600VRAutry Technology Center · Enid, OKN602BMeyer Charles H · Stratford, CAN607BKovas Dale K · New Carlisle, INN60KTTalhelm Timothy A · Flushing, MIN62384Watson James E Jr · Victor, CO
Back to Beech A35