OpenAirDocs.org
AD 50-31-01

Registered aircraft · 2,499

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
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-31-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-31-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.

N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749N1044GVoelkerding William Michael · Fairbanks, AKS/N 14403N10534Shergi Nikolai W · Franklin, INS/N 15697N1103DOber John A · Candor, NYBuilt 1950 · S/N 15663N1104DRymill Mark R · Belmont, CABuilt 1950 · S/N 15664N1105DGilman Larry E · Reno, NVBuilt 1950 · S/N 15665N1106DMurdock Mark F · Ketchikan, AKBuilt 1950 · S/N 15666N1108DReddout Terry L Trustee · Wichita, KSS/N 15668N1109DMcqueen Alan G · Cocoa, FLBuilt 1950 · S/N 15669N110VSbur David A · Vancouver, WABuilt 1946 · S/N 8748N110XPlayter Bud W DBA · Gowen, MIBuilt 1946 · S/N 10449N1112DMurray Russell J · Fresno, CAS/N 15676N1116DOxman Warren L · Rhome, TXS/N 15680N1119DChumble Ameya A · Duluth, MNBuilt 1951 · S/N 15683N111GZRabinowitz Warren · Ramrod Key, FLS/N 14756N111NZBlackerby Kevin W · Spicewood, TXBuilt 1947 · S/N 12372N1121DVancuren Mary Ann · Owasso, OKBuilt 1950 · S/N 15685N1122DBeech O Sphere LLC · Casper, WYS/N 15686N1125DStarr Eric M · Queen Creek, AZBuilt 1951 · S/N 15689N1126DHynds Michelle S · Addison, TXBuilt 1951 · S/N 15675N1129DKogl John L · Valparaiso, INBuilt 1951 · S/N 15692N1133DBohl Howard M · Temecula, CABuilt 1951 · S/N 15696N1135DRodriguez Daniel Royo · Hagerstown, MDBuilt 1951 · S/N 15698N1136DWatson Frank H · Central Point, ORBuilt 1951 · S/N 15699N1139DOborny Alan R · Choteau, MTBuilt 1951 · S/N 15702N1141DKilo Mushroom Aeronautics Inc · Renton, WABuilt 1951 · S/N 15704N1142DSale Reported · Fayetteville, WVSale reportedBuilt 1951 · S/N 15705N1143DSwanland Robert C · San Jose, CABuilt 1951 · S/N 15706N1143UOman Lee · Sequim, WAS/N 11652N1147QGraber Quinten R · Brooksville, MSBuilt 1947 · S/N 12785N1148DBohl Howard M · Temecula, CABuilt 1951 · S/N 15711N1150DFlight Time Pathways · Forest Lake, MNBuilt 1951 · S/N 15713N1151DWelborn Mark G · Boonville, NCBuilt 1951 · S/N 15714N1153DCarbonaro Joseph J Jr · Lexington Park, MDBuilt 1951 · S/N 15716N115JFFields Joseph H · Placerville, CAS/N 13498N1161DJefferies Stanley J · Coos Bay, ORS/N 15724N120BMVenegas Keila R · Long Grove, ILBuilt 1947 · S/N 13195N120CEStark Rosemary A · Homosassa, FLBuilt 1946 · S/N 11936N120CMLaminar Skies Aviation LLC · Broken Arrow, OKBuilt 1946 · S/N 11903N120CWWebb Charles E · Cleburne, TXBuilt 1946 · S/N 8718N120DCHockman William C · Lebanon Church, VABuilt 1946 · S/N 12036N120HTJackson Harry A II · Findlay, ILBuilt 1947 · S/N 12924N120JNOlufsen Niels · Lakeway, TXBuilt 1947 · S/N 14207N120JSJohnson Max L Jr · Greenville, SCS/N 13137N120KFWeber Anthony · New Salisbury, INBuilt 1947 · S/N 14144N120LAldrich Justin M · Dallas, ORBuilt 1947 · S/N 12858N120MALynn Jack Bradford · Lanett, ALBuilt 1946 · S/N 12012N120MZBeames Eric G · Palestine, TXBuilt 1946 · S/N 9226N120PGSilver Rock Completions LLC · Wausau, WIS/N 11978N120RWUnruh Ronnie E · Pampa, TXBuilt 1946 · S/N 10506
Back to AD 50-31-01