OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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:89-24-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-24-01-R1')
  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.

N731HTAeolus Aviation LLC · Franklin, TNBuilt 1980 · S/N P21000465N731HWOne Hotel Whskey LLC · Hugoton, KSBuilt 1980 · S/N P21000468N731JGGate Air LLC · Ketchum, IDBuilt 1980 · S/N P21000474N731JXKai Herbert DBA · Rillito, AZFirst renewal noticeS/N P21000479N731KLMullen James P Jr · Rogers, ARS/N P21000483N731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WABuilt 1980 · S/N P21000488N731LTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N P21000436N731LUDiversified Air LLC · Kalispell, MTBuilt 1980 · S/N P21000490N731MQClassic Management Corp · Marion, INBuilt 1980 · S/N P21000496N731NCSmith Bryan · Wenatchee, WABuilt 1980 · S/N P21000502N731NRWife Approved LLC · Torrance, CABuilt 1980 · S/N P21000509N731NUNgu Services LLC · Sheridan, WYBuilt 1980 · S/N P21000512N731NXCarey Richard · Dallas, TXBuilt 1980 · S/N P21000515N731NZWoodgrain Millwork Transportation LLC · Fruitland, IDBuilt 1980 · S/N P21000517N731PDInvisible Angels · Washington, DCBuilt 1980 · S/N P21000519N731PJBreckenridge Interests Ltd · Corpus Christi, TXBuilt 1980 · S/N P21000523N731QGMowbray Jerry H · Reno, NVBuilt 1980 · S/N P21000525N731QHK17 Corp · Alamosa, COBuilt 1980 · S/N P21000526N731QNOkeeffe William Trustee · San Francisco, CABuilt 1980 · S/N P21000529N731QRAir Rosa LLC · Tupelo, MSBuilt 1980 · S/N P21000531N731RRAviation Inventions LLC · Windsor, COBuilt 1980 · S/N P21000538N731RWAdvanced Products Sales LLC · Tempe, AZBuilt 1980 · S/N P21000540N731SCMoore Scott A · Longview, TXBuilt 1980 · S/N P21000543N731TPHangar 28 LLC · Littleton, COBuilt 1980 · S/N P21000546N731XXGrimm John H II · Driftwood, TXBuilt 1980 · S/N P21000559N731ZBVanderwaal Shane J · Junction City, WIBuilt 1980 · S/N P21000565N731ZFTuggle James L Jr · Scottsdale, AZBuilt 1980 · S/N P21000566N732ADDavis Billy E · Castlewood, SDBuilt 1976 · S/N 21061355N732AQGold Star Air · Portland, MEBuilt 1976 · S/N 21061366N732BASparks Steve · Hamilton, OHBuilt 1976 · S/N 21061376N732BKJones Mark A · Johnson City, TXBuilt 1976 · S/N 21061385N732CBAire Flight Systems Inc · Midwest City, OKBuilt 1976 · S/N 21061400N732CRGlobal Energy Werks LLC · Ely, MNBuilt 1976 · S/N 21061414N732CXEvans Terry W · Corning, IABuilt 1976 · S/N 21061420N732DKMckay Donald E · White City, ORBuilt 1976 · S/N 21061432N732DMFlying Knights LLC · Farmington, NMS/N 21061434N732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTBuilt 1976 · S/N 21061437N732ECPompa Oliver · Tucson, AZBuilt 1976 · S/N 21061448N732ETCaudill Jimmy L · Grove, OKBuilt 1980 · S/N P21000575N732EWFiller Leslie Trustee · Emerald Hills, CABuilt 1976 · S/N 21061466N732FPLancair Of Texas DBA · Snyder, TXBuilt 1976 · S/N T21061482N732GK3jc LLC · Phoenix, AZBuilt 1976 · S/N 21061500N732HDMgp Investments LLC · Woods Cross, UTBuilt 1976 · S/N 21061518N732HRBowdle Ricke H · San Dimas, CABuilt 1978 · S/N U20604680N732JFSpeed Of Light Aerospace LLC · Lompoc, CABuilt 1976 · S/N 21061543N732JJCj Air LLC · Escondido, CABuilt 1976 · S/N 21061546N732JMGarcia Victor C · Cameron Park, CABuilt 1978 · S/N U20604685N732JS732js Partners Ltd · Batavia, ILBuilt 1976 · S/N 21061554N732JWSunniland Ranch Airport LLC · Okeechobee, FLS/N 21061558N732KBTadco Equipment Inc · Laveen, AZBuilt 1976 · S/N 21061563
Back to AD 89-24-01 R1