Registered aircraft · 220

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:50-38-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:50-38-01') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:50-38-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:50-38-01')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:50-38-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:50-38-01')
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.

N101BWEdmonds Louis R W · Georges Mills, NHS/N 121-42854 N101NZSwift Stephen · Justin, TXBuilt 1944 · S/N 41-34050 N101VTAas LLC · Ovid, MIBuilt 1958 · S/N 88-13384 N102MCCase Martin V Jr · Euless, TXS/N 42-85647 A/MC N10597Sanders Racing Inc · Jasper, ALBuilt 1957 · S/N 88-13364 N10602Hatfield Aviation LLC · Fort Wayne, INBuilt 1944 · S/N 121-41870 N107FGTwin Lakes Aviation LLC · Edmond, OKBuilt 1944 · S/N 44-80858 N11171American Airpower Heritage Fly Musm · Dallas, TXBuilt 1942 · S/N 84-7800 N127VFWoelbing Aviation LLC · Franksville, WIBuilt 1943 · S/N 88-12827 N13372Ageless Aviation Dreams Foundation Inc · Carson City, NVBuilt 1956 · S/N 88-13372 N13FYEastern Stearman Inc Trustee · Leesburg, VABuilt 1942 · S/N 78-6922 N14166National Wasp Wwii Museum · Sweetwater, TXBuilt 1943 · S/N AC41-34166 N150UBrown Jim L · Soddy Daisy, TNS/N 42-44629 N154CFNelson Craig Martin · Eastsound, WABuilt 1960 · S/N 51985 N163TXRyan Good Aviation LLC · Sioux Falls, SDBuilt 1944 · S/N 121-42642 N16730Condor Squadron Officers & Airmens Assoc Inc · Van Nuys, CABuilt 1941 · S/N 75-3473 N16JGBohannon James III · Montgomery, TXBuilt 1942 · S/N 26912 N1796Somer Charles Michael · Hillsboro, ORS/N 78-6632 N190FSAnders Gregory · Bellingham, WABuilt 1942 · S/N 42-44709A N1974MAir Cav Helicopters LLC · Wilmington, DES/N 44-81252 N200WEAukes Brian E · Huxley, IABuilt 1942 · S/N 78-6587 N2067JMuszala William P · Tucson, AZS/N 44-81942-1AM N2073YVintage Aircraft LLC · Gilbert, SCBuilt 1941 · S/N 75-3465 N211RFAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1957 · S/N 88-9419 N220BAPalmetto Moon Flight Services LLC · Georgetown, SCS/N 51811 N22KDMusick Aircraft Corp · Greenwood, MSS/N 88-13072 N246ZN246z LLC · Seattle, WABuilt 1946 · S/N 88-10676 N25SSHinote Holdings LLC · Saint Charles, MOBuilt 1944 · S/N 85087 N26862American Airpower Museum · Farmingdale, NYS/N 90699 N27409Qrd Equipment Corp · Dover, DEBuilt 1949 · S/N 49-3829 N2757Evergreen Flying Service Inc · Rayville, LABuilt 1941 · S/N 66-2490 N276RBB & B Warbird Aviation Inc · Haddon Heights, NJBuilt 1940 · S/N 91008 N2834DMuseum Of Flight Foundation · Seattle, WABuilt 1944 · S/N 44-81753 N2956Gertsen Ronald H · Glenwood, NJBuilt 1941 · S/N 66-2689 N29678Osprey Aircraft LLC · De Leon Springs, FLS/N 51999 N29910Smith Robert D · Grapevine, TXBuilt 1942 · S/N 88-13581 N29939Wiley Sanders Truck Lines Inc · Troy, ALBuilt 1943 · S/N 49-3034 N29941Besterveld Paul Z · Austin, TXBuilt 1943 · S/N 52026 N29947Cavanaugh Flight Museum · Denison, TXBuilt 1944 · S/N 42-85697A N29963Tailwinds Air Inc · Morganza, LABuilt 1942 · S/N 49-2977 N29965Currier Justin B · Rixeyville, VABuilt 1944 · S/N 90634 N29BSFirst Volunteer Warbirds Inc · Wilmington, DEBuilt 1944 · S/N 88-13635 N3012YQualitair LLC Trustee · MichelstadtBuilt 1943 · S/N 412223 N30HASmokemaster LLC · Tehachapi, CAS/N 847412 N3158WN3158w LLC · Mesa, AZBuilt 1942 · S/N 847653 N3169GCondor Squadron Officers & Airmens Association · Van Nuys, CABuilt 1945 · S/N 111974 N3171PStinnett Joel B · Broken Arrow, OKBuilt 1943 · S/N 88-12553 N3171RBuehn Dennis G · Fallon, NVS/N 88-10645 N3173LOman Lee · Sequim, WABuilt 1945 · S/N 413279 N3173NSimply Living LLC · Fort Myers, FLBuilt 1944 · S/N 42-84314

Back to AD 50-38-01