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.

N2832DSnow Diana L · Morehead City, NCBuilt 1941 · S/N 1025 N28WKNurge Richard J · Gilroy, CAS/N 4872 N295BSInternational Air Services Inc Trustee · Carson City, NVBuilt 1939 · S/N 39-139 N322HSmittys Acft Svc Inc · Oneill, NEBuilt 1951 · S/N 3184 N333EIngram Robert S · Bertram, TXBuilt 1943 · S/N 4878 N368San Diego Air And Space Museum · San Diego, CABuilt 1943 · S/N 4883 N4013KNurge Richard J · Gilroy, CAS/N 6885 N40EShackelford John S Jr · Roanoke, TXBuilt 1944 · S/N 6685 N41344International Air Services Inc Trustee · Carson City, NVS/N 6922 N420EWalker Ray A · Sanger, TXBuilt 1944 · S/N 6671 N4417SPlanes Of Fame Air Museum · Chino, CABuilt 1944 · S/N 6918 N44562Hansen Scott G · Batavia, ILBuilt 1944 · S/N 6923 N44GMEastern Stearman Inc Trustee · Leesburg, VABuilt 1944 · S/N 6916 N4512NNimbus Aviation LLC · Ponte Vedra Beach, FLBuilt 1944 · S/N 6737 N4574NStearman Aviation Inc · Crawford, COBuilt 1944 · S/N 6727 N4607NTak Air L3c · Hampshire, ILBuilt 1944 · S/N 6927 N4612NTex-Ark Air Corp · Melissa, TXBuilt 1944 · S/N 6874 N480Robins Jack S · Saint Charles, IDBuilt 1943 · S/N 4810 N487CCJgm Aviation LLC · Spring, TXBuilt 1943 · S/N 4837 N4HXGoettl Tiffany A · Clarkdale, AZBuilt 1943 · S/N 6672 N5074NSchaller Lee W · New Athens, ILS/N 6680 N50AKalabus Edward A Jr · Dallas, TXBuilt 1939 · S/N 271 N51121Bromschwig Kurt F Trustee · Montgomery, TXBuilt 1945 · S/N 4914 N51746Nichols Charles F Trustee · Baldwin Park, CABuilt 1943 · S/N 4890 N51969Culpepper Matt D · Las Vegas, NVS/N 4898 N51MMStripe Joseph R · Olympia, WAS/N 4886 N52686Heartland Aviation LLC · Ada, OKS/N 4882 N52962Worlds Greatest Aircraft Collection Inc · Polk City, FLBuilt 1944 · S/N 6880 N53298Shatz Randy · Prescott, AZBuilt 1943 · S/N 4900 N5447NLady Mcgregor Aviation LLC · Santa Teresa, NMBuilt 1943 · S/N 4875 N555PCDawson Clyde W Trustee · Indiantown, FLBuilt 1944 · S/N 23679 N5821941 Historical Aircraft Group DBA · Geneseo, NYBuilt 1944 · S/N 6704 N58NKasper Richard J · Swanzey, NHBuilt 1944 · S/N 6762 N61278Aerospace Trust Management LLC Trustee · Wilmington, DES/N 4859 N617SSmith Dennis A Trustee · Salem, ORBuilt 1943 · S/N 6886 N61862Stark David M · Merkel, TXS/N 4877 N63477Pikes Peak Flyers Llp · Colorado Springs, COBuilt 1943 · S/N 6720 N63549Bowyer Marcelyn W · Coppell, TXS/N 6729 N65594Big Wing Nut Inc · Huntington, NYBuilt 1944 · S/N 3097 N663Broken Arrow Crop Insurance Inc · Perryton, TXBuilt 1943 · S/N 4903 N666TXJetran LLC · Horseshoe Bay, TXBuilt 1947 · S/N 6897 N67543Mayer-Llamas Danna M · Santa Cruz, NMBuilt 1944 · S/N 6908 N67550Parker R · Oklahoma City, OKBuilt 1944 · S/N 6717 N67555Krl LLC · Longview, TXBuilt 1944 · S/N 6876 N67677Webb Thomas Allen · Riverside, CABuilt 1944 · S/N 6724 N67716Stimson Frederick C · Harrison, TNBuilt 1944 · S/N 6733 N67734York Stanley A · Leetonia, OHS/N 3093 N67735Brown James A · Bath, MEBuilt 1944 · S/N 6935 N67736Lane Archie G Trustee · Cypress, CABuilt 1943 · S/N 4848 N67738Hayden Aviation LLC · Rhome, TXS/N 6914

Back to Beech D17S