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.

N4850JCardamone Rayner Mark Gibson · Manistique, MIBuilt 1966 · S/N D-8345 N4852JStoffel Christopher David · Colorado Springs, COS/N D-8349 N4853JNaca 130 LLC · Cameron Park, CABuilt 1966 · S/N D-8350 N4856JN4856j LLC · Boulder, COBuilt 1967 · S/N D-8536 N4871JGray Robert R · Granbury, TXBuilt 1966 · S/N D-8356 N4889JRegistered aircraftBuilt 1967 · S/N D-8424 N4894JCapri Blue Aviation LLC · Norcross, GABuilt 1967 · S/N D-8430 N4896JMyshatyn Michael · Eaton, COBuilt 1967 · S/N D-8435 N48RSColin A Oerton · Miami Beach, FLBuilt 1966 · S/N D-8250 N499DSDelta Sierra Aviation · Wilmington, DEBuilt 1967 · S/N D-8316 N49PGVasiloff Mark · Barberton, OHBuilt 1967 · S/N D-8452 N4HHAndrews Terry · Camp Verde, AZS/N D-8422 N4WRShoemaker David J · Menlo Park, CABuilt 1967 · S/N D-8497 N50BDGoodrich Gilbert Joseph · Katy, TXS/N D-8175 N51HMDw Peterson Inc · Warren, MNBuilt 1966 · S/N D-8288 N523QNixon John H · Ormond Beach, FLBuilt 1967 · S/N D-8582 N52AUUllman Aaron L · Barksdale Afb, LABuilt 1967 · S/N D-8484 N533SZilz Tammy S · Saint Peters, MOBuilt 1965 · S/N D-8028 N535PTaylor Jim A · Kernersville, NCBuilt 1966 · S/N D-8119 N5404UHubbard James E · Dover, OHBuilt 1967 · S/N D-8543 N5405URyan Good Aviation LLC · Sioux Falls, SDS/N D-8493 N5410UN5410u LLC · West Babylon, NYBuilt 1967 · S/N D-8531 N5413USleigh James E · Palm City, FLBuilt 1967 · S/N D-8498 N5420UJohnson Michele J · Buena Vista, COBuilt 1967 · S/N D-8505 N542DSFox James R DBA · Saint Paul, MNBuilt 1966 · S/N D-8048 N5431UBrown David G · Knoxville, TNBuilt 1967 · S/N D-8515 N5433UHynes Kevin P · Wichita Falls, TXBuilt 1967 · S/N D-8512 N5434UVance Daniel · Bend, ORBuilt 1967 · S/N D-8520 N5442UMorisseau Walner · Tampa, FLBuilt 1967 · S/N D-8516 N5444UBooze Gregory Trustee · Punta Gorda, FLBuilt 1967 · S/N D-8518 N5450UStay Air Borne LLC · Wilmington, DEBuilt 1967 · S/N D-8529 N5469VSchweers John · Plano, TXBuilt 1967 · S/N D-8565 N5480UGwb Air LLC · Waterford, MIS/N D-8553 N5487USuss Charles H Trustee · Woodford, VTBuilt 1967 · S/N D-8559 N5491UAarestad Potato Co Ltd · Halstad, MNBuilt 1967 · S/N D-8584 N54VKPain Management And Aesthetics LLC · Celina, OHBuilt 1966 · S/N D-8066 N552BWinkelbauer Kim G · Sun City, AZBuilt 1967 · S/N D-8524 N555BCHammett Michael James · Hattiesburg, MSBuilt 1966 · S/N D-8341 N555GGSoutherland Corp · New Port Richey, FLBuilt 1967 · S/N D-8380 N555KMVerrill Christopher R · Williamstown, NJBuilt 1966 · S/N D-8361 N55SPJ&D Flying LLC · Clinton, MOBuilt 1966 · S/N D-8084 N5601SArno Aero LLC · Merton, WIBuilt 1966 · S/N D-8152 N5602SRegistered aircraftBuilt 1966 · S/N D-8153 N5604SThrasher Luke DBA · Amarillo, TXBuilt 1966 · S/N D-8156 N5605SDevereaux Saw Mill Inc · Pewamo, MIBuilt 1966 · S/N D-8319 N5610SJager Rylan W · Indn Hbr Bch, FLBuilt 1966 · S/N D-8177 N5611SHenry Daniel · Paris, TXBuilt 1966 · S/N D-8150 N5616SVanel Clyde · Cambria Heights, NYS/N D-8158 N5624SKin-Air Inc · Hendersonville, TNBuilt 1966 · S/N D-8168 N5633SQualitair LLC · MichelstadtBuilt 1966 · S/N D-8330

Back to Beech V35