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 ('1151526')
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 ('1151526')
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.
N9772RAterianus Jacques · Suamico, WIN9777RSingleton Shawn P · Nipomo, CAN9779RRhodes Orval D · Aztec, NMN9783RMoore Michael C · Brooklyn, MIN9785RShaul Kurt · Kelseyville, CAN9786RLaguna Henry · Glendale, CAN9787RThorny Oak Ranch LLC · Missouri City, TXN9789RBorth Christian D · Alameda, CAN9790RRorke David E · Benicia, CAN9791RBlaskovich Thomas M · Highland, CAN9795RDevins Frederick G · Sussex, NJN9796RMeadowlake Airpark LLC · Lenoir City, TNN9797RGrave Eugene G · Spencer, INN9798RMarine Aviation Museum Inc · Wilmington, DEN9799RBergen Daniel Michael Jr · Millersville, MDN9801RMaradei Jefferson V · Mcallen, TXN9802RSchutes John T · Brimfield, MAN9804RCentral Coast LLC · Olympia, WAN9805RYoder Daniel L · Pond Creek, OKN9806RGifford Brent D · Elk City, OKN9808RI M Foxbo LLC · Wilmington, DEN9809RJimmy Michael Fletcher · Wausa, NEN980DRJessen Dennis H · Pequot Lakes, MNN9810RMccreary William B · Turnersville, NJN9814RMankins Kristina · Paso Robles, CAN9816RV Tail Flyers Group LLC · Deland, FLN9817RVetter Aviation · Helena, MTN9818RDurkee Michael S · Amelia, OHN9821RBender Josh · El Reno, OKN9822RHawkins Albert W · Santa Maria, CAN9823RLettunich John William Jr · Wild Horse, CON9826RJacques Jeffrey P · Spokane, WAN9828RHarbin Billy C · Floydada, TXN9830RPollock Craig D · Walnut Creek, CAN9831RFreilich Richard E · Sugar Land, TXN9833RL&M Aircraft Inc · Rome, GAN9834RBailey Eugene P · Dickinson, TXN9835RAviation Hangar LLC · Wentzville, MON9837RWinn Larry V · Tucson, AZN9842REdelman Freddie L · Manlius, NYN9843RRegistered aircraftN9844RAlsworth John H · Anchorage, AKN9846RSmith Louis · Dundee, NYN9847RWininger Floyd W · Duncan, OKN9848RStark James E · Mansfield, TXN9849RSmith Tyler · Vancouver, WAN9850RLeffingwell Thomas W Jr · Wilton Manors, FLN9852REverready Aviation LLC · Dickson, TNN9853RDwight Hawkins H · Allen, TXN9856RMcgrath Stephen · Hawley, PA
Back to Beech M35