Skip to content

Registered aircraft · 425

Aircraft of this model in the FAA registry, by N-number.

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 ('1151538')
  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 ('1151538')
ORDER BY n_number

Run 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.

N3713QAirborne Adventures LLC · Clive, IABuilt 1966 · S/N D-8370 N3715QShellington Justin R · Columbus, NJBuilt 1966 · S/N D-8375 N3720QM M & O Aviation Inc · Northglenn, COBuilt 1966 · S/N D-8373 N3731QMoore J D · Lawson, MOBuilt 1966 · S/N D-8374 N3748QThoendel Jason · Saint Charles, MOBuilt 1967 · S/N D-8411 N374TOtt James D · Kilgore, TXBuilt 1966 · S/N D-8165 N3753QMintz Jason · Houston, TXBuilt 1967 · S/N D-8393 N3759QJ & C Companies LLC · Mesa, AZBuilt 1967 · S/N D-8394 N3762QHarris Randal Glenn · Sedona, AZS/N D-8398 N3763QOrr Robert · San Clemente, CABuilt 1967 · S/N D-8399 N3770QTaylor Zachary S · Shawnee, OKBuilt 1967 · S/N D-8403 N3772QBoav8r LLC · Marana, AZBuilt 1967 · S/N D-8405 N3781QWelch Michael R · Roanoke, TXBuilt 1967 · S/N D-8417 N3785QGo Fly Missoula LLC · Missoula, MTBuilt 1967 · S/N D-8413 N3788QSale Reported · Oklahoma City, OKSale reported, canceledBuilt 1967 · S/N D-8410 N3789QHercules Jesse T · Memphis, TNS/N D8412 N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421 N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418 N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415 N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416 N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433 N37KBMccraw Michael · Myakka City, FLBuilt 1966 · S/N D-8046 N3SVYoung Karen Sue · Cincinnati, OHBuilt 1967 · S/N D-8426 N406TLevel Wings LLC · Jefferson City, MOBuilt 1966 · S/N D-8240 N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184 N422GRHolden Virgil Gary Trustee · Upland, CABuilt 1966 · S/N D-8243 N433DReyenga Steven G · Shreveport, LABuilt 1966 · S/N D-8094 N433SBesedin Thomas E · Islandia, NYBuilt 1965 · S/N D-8006 N437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1966 · S/N D-8179 N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474 N448JDavenport James A · San Antonio, TXBuilt 1966 · S/N D-8127 N454RBDan Cox LLC · Troutdale, ORBuilt 1966 · S/N D-8242 N455KBrooks Donald W · Lumberton, NJBuilt 1967 · S/N D-8440 N455RHanusin Mark J · Huntley, ILBuilt 1967 · S/N D-8526 N45TAMichalek Construction Inc · Keosauqua, IABuilt 1966 · S/N D-8252 N461AJohnson James Michael · Mount Pleasant, SCBuilt 1967 · S/N D-8392 N461DAGrave Eugene G · Spencer, INS/N D-8572 N464PGoodgame Richard C · Fort Myers, FLBuilt 1966 · S/N D-8372 N468ABrown Michael E · Wasilla, AKBuilt 1967 · S/N D-8548 N470AWWhitesell Paul Trustee · Plano, TXBuilt 1966 · S/N D-8073 N47WTDoucet Lucius J III · Baton Rouge, LABuilt 1966 · S/N D-8217 N4806JHall Thomas K DBA · Jupiter, FLBuilt 1966 · S/N D-8353 N4808JJm Beech V LLC · Winchester, TNBuilt 1966 · S/N D-8324 N4809JBenner David G · Prescott, AZBuilt 1966 · S/N D-8321 N480HKorwel Tomasz W · Cedar Rapids, IABuilt 1967 · S/N D-8569 N4810JMiller Wesley J · Silt, COS/N D-8331 N4823JHaunstein Manfred · Weirsdale, FLBuilt 1966 · S/N D-8337 N4831JSiewert Michael H · Columbus, OHBuilt 1966 · S/N D-8335 N4839JFlying For Fun LLC · Sunnyvale, TXBuilt 1966 · S/N D-8340 N4847JLittle River Corp · Anchorage, AKBuilt 1966 · S/N D-8346

Back to Beech V35