OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N737TQN737tq Aviation LLC · Sheridan, WYS/N 17269666N737TXCalifornia In Nice Inc · San Jose, CABuilt 1977 · S/N 17269672N737TYTexins Flying Club · Mckinney, TXBuilt 1977 · S/N 17269673N737TZNickell Alan L · Rigby, IDS/N 17269674N737UAAlternate Air Inc · Seattle, WABuilt 1977 · S/N 17269675N737UEHostler Susan L · Bradfordwoods, PABuilt 1977 · S/N 17269679N737UFHeart Of Texas Aviation LLC · Troy, TXBuilt 1977 · S/N 17269680N737UKAlternate Air Inc · Seattle, WABuilt 1977 · S/N 17269684N737ULMelbourne Flight Training LLC · Melbourne, FLBuilt 1977 · S/N 17269685N737URSky Warrior Flight Training LLC · Pensacola, FLBuilt 1977 · S/N 17269690N737UYFlycarolina LLC · Concord, NCBuilt 1977 · S/N 17269696N737VAMartin Dana J · Spicewood, TXBuilt 1977 · S/N 17269698N737VBDavis Gregory L · Williamsburg, NMS/N 17269699N737VCN737vc LLC · Wilmington, DEBuilt 1977 · S/N 17269700N737VFCompass Aviation Maintenance LLC · Shelby, NCBuilt 1977 · S/N 17269703N737VLAuthorized Health Insurance Inc · Fair Oaks, CABuilt 1977 · S/N 17269708N737VNRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1977 · S/N 17269710N737VSWalters Pujadas & Walker Pc · Ocilla, GAS/N 17269714N737VVDorsey Terry R · Henderson, TXBuilt 1977 · S/N 17269717N737WAFlying Taco LLC · Fountain Inn, SCBuilt 1977 · S/N 17269722N737WCJ.R.P. Leasing Ltd · Carroll, IABuilt 1977 · S/N 17269723N737WEWild Eagle Aviation LLC · Arvada, COBuilt 1977 · S/N 17269725N737WQHinote Holdings LLC · Saint Charles, MOBuilt 1977 · S/N 17269734N737WRN737wr LLC · Jacksonville, FLBuilt 1977 · S/N 17269735N737WSBoeing Employees Flying Association · Renton, WABuilt 1978 · S/N 17269736N737WTHillcrest Aircraft Co · Lewiston, IDBuilt 1977 · S/N 17269737N737WXWhorton Aviation LLC · Winder, GABuilt 1977 · S/N 17269741N737XAFirst Eclipse Limited · Richmond, VABuilt 1977 · S/N 17269744N737XFCasper Holdings Inc · New Castle, DEBuilt 1977 · S/N 17269749N737XMJ F P Inc · Ellsworth, MEBuilt 1977 · S/N 17269755N737XSUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1977 · S/N 17269759N737XTHeins Alfred Jr · Monticello, NYBuilt 1977 · S/N 17269760N737XURaynor Andrew C · Kingman, AZS/N 17269761N737XWWeiss Gregory K · Colorado Springs, COBuilt 1977 · S/N 17269763N737XZBrown John P Jr · Winter Garden, FLBuilt 1977 · S/N 17269766N737YADuffys Aircraft Sales And Lsg Inc · Neillsville, WIBuilt 1977 · S/N 17269767N737YBBurke Donald T · Scranton, NDBuilt 1977 · S/N 17269768N737YEAeroventures Flying Club Inc · Lilburn, GABuilt 1977 · S/N 17269771N737YFVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269772N737YGAgassiz Flyers Inc · Herman, MNBuilt 1977 · S/N 17269773N737YPYankee Papa LLC · Wilmington, DEBuilt 1977 · S/N 17269780N737YQTec Aviation Inc · Pasco, WABuilt 1977 · S/N 17269781N737YSCk Max LLC · Stanford, KYBuilt 1977 · S/N 17269783N737YT80075 Aircraft Corporation LLC · Wilmington, DEBuilt 1973 · S/N 17261481N737YULake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 17269785N737YVLees Sea Air · Kiana, AKBuilt 1977 · S/N 17269786N737YZWininger Spencer C · Wichita, KSBuilt 1977 · S/N 17269790N737ZACounty Of Santa Cruz · Santa Cruz, CABuilt 1977 · S/N 17269791N737ZCMoody Air Ventures LLC · Nolanville, TXBuilt 1977 · S/N 17269793N737ZDHp Air Inc · Cape Coral, FLBuilt 1977 · S/N 17269794
Back to AD 79-10-03 R2