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 ('1151406')
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 ('1151406')
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.
N7942KMiller Gregory M · Prescott, AZN7943KWeiss Joyce Ann Trustee · San Jose, CAN7953KPowell Bobby D · Dothan, ALN7959KRon Arnold Dpe LLC · Springtown, TXN7960KMorton John W · Hurricane, UTN7961KGriesman Scott W · Sandy Valley, NVN7976KLeonardo David · Hollister, CAN7977KLingelbach John C · Saint Petersburg, FLN7980KRegistered aircraftN818JHutto Christopher J · West Columbia, SCN8502MBeech Aero Club Of Frederick Inc · Columbia, MDN8509MDaybreak Aviation LLC · Daytona Beach, FLN8524MMachado Ricardo S · Ashtabula, OHN8525MHutt Aviation Inc · Minden, NVN8531MRuhl Taylor Lee · Orange, CAN8539MDfr Motors LLC · Concord, NCN8543MKooiman Mary C Trustee · Eden Prairie, MNN8546MLapointe Dale · Lewiston, MIN8554MStott Jerry L · Jefferson, IAN8555NSc Infinities LLC · Dover, DEN8557MLaprade Matthew · Riverside, CAN8559MMcneil Joey K · Hartville, MON8562MSale Reported · Fairfax, VASale reportedN8571MSuper Richard C II · Redlands, CAN8574MK R T Aviation LLC · Tulsa, OKN8583MWhalen Shenandoah · Amelia, OHN8584MPacific Wings LLC · Turner, ORN8597MCoffman John P · Chandler, AZN8603MArabian Richard J · El Segundo, CAN8608MObeid Mahd Khaled · Sunnyvale, TXN8609QDury Aviation Services Inc · De Soto, ILN8611MSolutions One LLC · Middletown, INN8614QTaylor Leland O · Diamondhead, MSN8617QTautz Steve · Bow Mar, CON8621MBeech Flyers LLC · Tarzana, CAN8622MLynch James T · Lawton, OKN8627MPrince Lonnie E · Waterville, OHN8628MCruse Patrick J · Soquel, CAN8631MWalker Evan · Nicholls, GAN86340Vickery Forest H · Tallahassee, FLN8645MGulf Airbatics Ltd · Jennings, LAN8646MRegistered aircraftN8652MForster Sebastian A · Elberta, ALN8653MMedic Choppers LLC · Springdale, ARN8660QCook John W · Tempe, AZN8663MHot Seat Aviation · Blacksburg, VAN8664MWarren Mark P · Memphis, TNN8670MStephens Brent · Nacogdoches, TXN8679MN8679m Inc · Cochran, GAN8809MProvidence Asset Management Inc · Melbourne Beach, FL
Back to Beech 35-B33