Skip to content

Registered aircraft · 95

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 ('1153402')
  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 ('1153402')
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.

N100BHChopper Aviation LLC · Cahokia Heights, ILBuilt 1958 · S/N TD-130 N109SGreenair Corp · Memphis, TNBuilt 1958 · S/N TD-140 N11SCHarrington John M · Payson, AZBuilt 1958 · S/N TD-141 N122BRHollon Blake D · Douglas, WYBuilt 1958 · S/N TD-65 N13131Premier Capital Enterprises LLC · Hurricane, UTBuilt 1958 · S/N TD-42 N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225 N195JRQualitair LLC Trustee · MichelstadtBuilt 1957 · S/N TD-15 N200KDQuantum Aero Services LLC · Wilmington, DEBuilt 1958 · S/N TD-176 N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177 N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178 N2021CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-212 N2022CCarriere James M · Navarre, FLBuilt 1959 · S/N TD-189 N2024CD M S Leasing Co LLC · Las Vegas, NVBuilt 1959 · S/N TD-198 N2026CSkys Aircraft Corp · Newnan, GABuilt 1959 · S/N TD-193 N2029CAnderson Rebecca L · Fort Myers, FLS/N TD-197 N2033CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-203 N2042CDms Leasing Co LLC · Las Vegas, NVS/N TD-219 N2049CPray Matthew W · Augusta, KSBuilt 1959 · S/N TD-234 N2050CDow Jeffrey W · Port Hadlock, WABuilt 1959 · S/N TD-229 N2054CParker Jerry B · Arcola, TXBuilt 1959 · S/N TD-245 N2062CBc Realty Group LLC · Lake Dallas, TXBuilt 1959 · S/N TD-262 N2065LAirspeed Jet Services LLC · Kirkland, WABuilt 1959 · S/N TD-209 N2099CFrazier Jon A · Vista, CAS/N TD-276 N2113KCalvin B Wiley · Summer Shade, KYS/N TD-283 N21RSRainier Air Inc · Wauna, WAS/N TD-224 N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215 N225JPBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1959 · S/N TD-270 N22TAWoodling Jason D · Venice, FLBuilt 1959 · S/N TD-250 N265AAWhitten Chris K · Alton, MOBuilt 1958 · S/N TD-132 N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119 N2710YPink Ibis Air LLC · Vero Beach, FLS/N TD-45 N2712YCarranza Jorge Oros · Dallas, TXBuilt 1958 · S/N TD-35 N2715YEmerson Michael J · Athens, ALBuilt 1958 · S/N TD-62 N2726YOlson Ben A · Gig Harbor, WABuilt 1957 · S/N TD-76 N2727YFreedom Aviation LLC · Dover, DEBuilt 1958 · S/N TD-79 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94 N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104 N2747YJennflight Inc · Chagrin Falls, OHS/N TD-96 N2749YBaker Paul D · Grand Prairie, TXBuilt 1958 · S/N TD-105 N2755YNancy Aviation LLC · Fayston, VTBuilt 1958 · S/N TD-106 N2760YSanders Flight Training Inc · Jasper, ALBuilt 1958 · S/N TD-126 N2762YFisher Global LLC · Conway, ARBuilt 1958 · S/N TD-129 N2764YChennault Flying Services LLC · North Las Vegas, NVBuilt 1958 · S/N TD-128 N2776YMadlener Michael J · Las Vegas, NVBuilt 1958 · S/N TD-145 N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166 N2811WRegistered aircraftN-number assigned, not yet registeredS/N TD-66 N29RBAdvantage Aviation Services LLC · South Saint Paul, MNS/N TD-174 N2TLAlexander Terry W · Hayward, CABuilt 1959 · S/N TD-233 N2VCPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD300

Back to Beech 95