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.

N67769York Stanley A · Leetonia, OHBuilt 1937 · S/N 146 N69HKfg Aviation Inc · Huntersville, NCS/N 4896 N7024KMcneill Steven H · Santa Fe, NMS/N 6870 N711ZZGoodman Michael K · Brooksville, FLBuilt 1943 · S/N 4811 N722MDAnderson Richard E · Roanoke, VABuilt 1944 · S/N 6750 N75544Richardson Robert L · Rch Palos Vrd, CABuilt 1946 · S/N 3088 N75614Schmidt Victor M · Corbett, ORBuilt 1943 · S/N 4806 N79484Garnreiter Michael Trustee · Scottsdale, AZBuilt 1943 · S/N 4917 N838Garcia Roberto P · Spring Hill, FLBuilt 1946 · S/N 6731 N848JDTurner Michael A · Cartersville, GABuilt 1938 · S/N 201 N9115HMontmorency John Trustee · Napa, CAS/N 1014 N9169HShackelford John S Jr · Roanoke, TXBuilt 1947 · S/N 6879 N9290HDelta Enterprise · Brighton, COBuilt 1944 · S/N 6726 N92SLApd LLC · Madison, OHBuilt 1941 · S/N 01640 N9370HRath Aviation Services LLC · Spearfish, SDBuilt 1944 · S/N 4846 N9405HInternational Air Services Inc Trustee · Carson City, NVS/N 4803 N9463HEzell Chadwick S · Breckenridge, TXBuilt 1944 · S/N 6900 N9466HGiles Forrest D · Springtown, TXBuilt 1944 · S/N 6688 N9470HDeer Creek Dusters Inc · Rolling Fork, MSBuilt 1943 · S/N 6670 N9597HVeruca Salt LLC · Washington, TXBuilt 1943 · S/N 4840 N985SWPietsch Warren A · Minot, NDBuilt 1943 · S/N 4870 N9873HMoyle Lee E · Heyburn, IDBuilt 1943 · S/N 4839 N991VBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1943 · S/N 4823 N9936HPerras Uwanna P · Morrisville, VTBuilt 1943 · S/N 4808

Back to Beech D17S