Skip to content

Registered aircraft · 124

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

N1030Coffelt Kelly L · Bend, ORBuilt 1940 · S/N 409 N1112MHanusin John J · Huntley, ILBuilt 1954 · S/N 6684 N113QShore Brian R · Carmichael, CABuilt 1943 · S/N 4815 N114HHoff Robert A · Idaho Falls, IDBuilt 1939 · S/N 327 N1174VBlack Cat Aviation LLC · Indianapolis, INBuilt 1944 · S/N 6892 N1178VSorenson Fred C · Las Vegas, NVBuilt 1944 · S/N 6917 N1180VRegistration Pending · Mount Pleasant, TXRegistration pendingS/N 6904 N1181VSchmidt Victor M · Corbett, ORBuilt 1945 · S/N 6706 N1184VGrossberg Michael J · Atlantic Beach, FLBuilt 1944 · S/N 6748 N1185VLatta Russell R Trustee · Atwater, CABuilt 1944 · S/N 6746 N1192VSchmidt Victor M · Corbett, ORBuilt 1945 · S/N 6884 N1195VJones Flying LLC · Helena, MTBuilt 1947 · S/N 6749 N1196VWebstrong Aviation LLC · Conway, ARBuilt 1944 · S/N 6703 N1341VBischoff Roy H III · Flower Mound, TXS/N 6728 N160Niemyjski Justin S · Franksville, WIBuilt 1943 · S/N 4836 N161KWalker John D · Neosho, MOBuilt 1943 · S/N 4821 N164EGoodman Aircraft Inc · Wilmington, DES/N 6933 N16MJacobsen Chris · Arvada, COBuilt 1944 · S/N 6765 N16SInternational Air Services Inc Trustee · Carson City, NVBuilt 1946 · S/N 6687 N17082Scaletta Samuel L · Middleton, WIBuilt 1940 · S/N 137 N170SWalker Ray A · Sanger, TXBuilt 1945 · S/N 4817 N17643Smith James E Trustee · Kalispell, MTBuilt 1943 · S/N 4827 N17679Walton Paul L · Indianapolis, INBuilt 1944 · S/N 6911 N17985Black Cat Aviation LLC · Indianapolis, INBuilt 1943 · S/N 4807 N17GBRegistration Pending · Babylon, NYRegistration pendingBuilt 1943 · S/N 4818 N17GLInternational Air Services Inc Trustee · Carson City, NVBuilt 1942 · S/N 4885 N17SFO'Flanagan Clany H · Chowchilla, CAS/N 6890 N17SWHead Inc · Columbus, OHBuilt 1955 · S/N 4850 N18028Mcconnell Paul H · Main BeachS/N 147 N18575Greenblatt Michael A · Midland, GABuilt 1937 · S/N 179 N18777Dunn Larry L · Conway, WABuilt 1938 · S/N 200 N18BJMckay Richard Trustee · Rch Palos Vrd, CABuilt 1943 · S/N 4891 N18VEastern Stearman Inc Trustee · Leesburg, VAS/N 6869 N192HEastern Stearman Inc Trustee · Leesburg, VABuilt 1945 · S/N 6723 N19482Pitts M12 LLC · Warwick, RIBuilt 1938 · S/N 254 N19493Demark Aviation Inc · Wilmington, DEBuilt 1939 · S/N 263 N20753Beechcraft Heritage Museum Inc · Tullahoma, TNS/N 395 N20779Thomas Daniel Craig · Shady Shores, TXBuilt 1940 · S/N 398 N217SDSennas Ghost LLC · Missoula, MTBuilt 1942 · S/N 3098 N2277ZMorgan Charles R · Shelbyville, INS/N 4902 N230Momentum Foundation Inc · Tullahoma, TNBuilt 1943 · S/N 4835 N236Cooper Stephen · Fairbanks, AKBuilt 1942 · S/N 3179 N239ESundale Aviation Inc · Erwinna, PABuilt 1943 · S/N 4916 N241KRollison James · Scottsdale, AZBuilt 1939 · S/N 287 N248EPemberton Addison J · Spokane, WABuilt 1944 · S/N 6871 N25KSleeper William H · Bainbridge Island, WABuilt 1944 · S/N 6881 N264EStark David M · Merkel, TXS/N 4888 N265EStaggerwing 265e LLC · Wilmington, DEBuilt 1943 · S/N 4940 N278WWWedell Williams Memorial Foundations · Patterson, LABuilt 1939 · S/N 264 N27EN27e LLC · Chesapeake, VABuilt 1944 · S/N 6883

Back to Beech D17S