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.
N660VSky Guy LLC · Frankenmuth, MIN662KWDavis Daniel · Bloomington, MNN666ZRobertson Jared Y · Pass Christian, MSN670WSchmitt Rudy · Brookshire, TXN67CSBymaster Mark · Knoxville, TNN681VStandby One Aircraft LLC · Tulsa, OKN688VBonanza Flyers LLC · Newport News, VAN691VKeilman Geary · Las Vegas, NVN693VArmstrong Blane A · Albuquerque, NMN6RHDill Steven Vaughn · Lenoir City, TNN706CMSquibb Jeffrey T · Elizabeth, PAN7747BBrawner Robert M · San Leon, TXN777WDMob Aviation USA LLC · Auburndale, FLN77RJWilkinson Dane W · Morgan, UTN781ZFolk Jerald F · Ocklawaha, FLN811AWebb Matthew K · Denton, TXN827LWarfield Gerald A · Saltillo, MSN830NRegistration Pending · Boring, ORRegistration pendingN836RCoates Stephen T · Roseville, CAN842RMutsch Craig A · Faulkton, SDN844RSteele Aviation Inc · Walnut Cove, NCN852RRauch Karl W · Fredericksburg, VAN853RBelknap Aero Services LLC · Meredith, NHN881RParker Steven L · Many, LAN882RFoss James K · Anchorage, AKN883RRegistered aircraftN889RQualitair LLC Trustee · MichelstadtN890RChitwood Thomas · Hartwell, GAN9303YBoden Josh L · Waldo, KSN9306YTff Inc · Dexter, MIN9311YWolf Zachary J · Rochester, MNN9315YAero Con Brio LLC · Wichita, KSN9323YAgerton William David Jr · Weatherford, TXN9324YHart Aviators LLC · Sparks, NVN9325YSimpkins Larry D · Danville, KYN9338YSingleton Jude G · Spring Branch, TXN9340YWaters Kenneth A · Pleasant Hill, CAN9345YDana Aviation LLC · Mesa, AZN9347YNelson Forrest W · Amherst, NHN9358YBruce Mkristo · Mesa, AZN9360YZapata Joseph B · Deland, FLN9366YMoss Douglas M Trustee · Reno, NVN941ALWatson Alfred L · Bucklin, MON951THoverter Douglas K · Frederick, CON952TEagle Mountain Aviation Inc · Wilmington, DEN9572RThompson Charles R · Maysville, KYN9574RBoykin Bobby · Brandon, MSN9575RGotsdiner Alexander M · Panama City Beach, FLN9576RBuechle Mark T · Marshall, MIN9578RJudd Richard M · Austin, TX
Back to Beech M35