OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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:80-04-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:80-04-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.

N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083N489JOrr Matthew W · Kirkland, WAS/N 265N489JEChambless Mardre F II · Panama City, FLBuilt 2004 · S/N 90508N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083N489TJUnknown Media LLC · Cape Canaveral, FLS/N 3024N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163N48CLSharp Wade L · Asheville, NCS/N 21184N48DXSomers Andrew · El Paso, TXBuilt 2003 · S/N 386N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906N48GHYellowstone Aviation Inc · Jackson, WYBuilt 1999 · S/N 2049N48HYStruble Anne D · Springville, UTBuilt 2002 · S/N 2196N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693N48KBRydberg Lawrence · Albuquerque, NMBuilt 1998 · S/N 26N48KSHolcomb Garry M · Point, TXS/N PTS101N48MMDierks Herman D · Round Rock, TXBuilt 1967 · S/N RCM67N48PKWoodward Daniel S · Springville, UTS/N 5382N48PRBadrow Allan R · Warrenton, VABuilt 2002 · S/N 2843533N48RPClark Mitchell J · Parker, COBuilt 1978 · S/N 658-HN48SSiragusa Pamela L · Cypress, TXBuilt 1958 · S/N TD-40N48SJJohnston Stephen P · Hawley, MNBuilt 1948 · S/N 1466N48TDFoster Aviation LLC · Missoula, MTBuilt 1997 · S/N 123297N48WLAtkinson Matthew D · Theodore, ALBuilt 1978 · S/N AA5B0892N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099N4902LObrien William M · Aptos, CABuilt 1967 · S/N 28-4269N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222N4907ZChristie Ian A H · Limon, COS/N 22-8492N4908PJohnson Dalton S · Sterling, AKBuilt 1962 · S/N 18-7789N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490GRWarnock Tony J · Mobile, ALS/N 97N490RRegistered aircraftBuilt 1999 · S/N 490RN4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394N4910LPeake Alexander · Tacoma, WABuilt 1967 · S/N 28-4275N4910PWilkens Jacob James · Eagle River, AKBuilt 1962 · S/N 18-7832N4911FFreed Michael L · Sylmar, CABuilt 1976 · S/N 28-7725035N4911LMccown Brian W · Janesville, CABuilt 1967 · S/N 28-4276N4912FNab LLC · Wichita, KSBuilt 1976 · S/N 28-7715079N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460N4913LHaven Mark · Springfield, TNBuilt 1967 · S/N 28-4278
Back to AD 80-04-03 R2