OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N172RGMaxwell Don P II · Longview, TXBuilt 1979 · S/N 172RG0083N172RJRidgik George H · Jamestown, COBuilt 1974 · S/N 17263314N172RRFly Lugu LLC · Southwick, MABuilt 1973 · S/N 17261788N172RWD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272209N172SAHalbauer Peter · Hartford, WIBuilt 1969 · S/N 17258302N172SBBirmingham Flight Center LLC · Birmingham, ALBuilt 1976 · S/N 17267683N172SFTichy Joseph R · Napa, CABuilt 1984 · S/N 172RG1149N172SGLehner Raymond A Jr · North Fort Myers, FLBuilt 1973 · S/N 17261734N172SKCruz Orlando R · Houston, TXBuilt 1978 · S/N 17271308N172SNBukowski Robert · Hot Springs, ARBuilt 1969 · S/N 17258428N172SRDiaz Robert Dorantes · Coalinga, CAS/N 17267952N172SSWingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260696N172SXPersonal Aviation Inc · Poway, CABuilt 1979 · S/N 17273641N172SZPowell Terry · Sheridan, WYBuilt 1975 · S/N 17265508N172TBBelli Paul · Philadelphia, TNBuilt 1970 · S/N 17259584N172TCMeweber Consulting Inc · Atlanta, MIBuilt 1976 · S/N 17266662N172TDSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 17258939N172THDairy Air Inc · Wyoming, PABuilt 1972 · S/N 17261033N172TKRhinelander Flying Service Inc · Rhinelander, WIBuilt 1978 · S/N 17270406N172TLRegistration Pending · Katy, TXRegistration pendingBuilt 1977 · S/N 17269706N172TRSkoglund David L · Jamul, CAS/N 17269899N172TSVero Technical Support Inc · Pensacola, FLBuilt 1974 · S/N 17264582N172TXD & L Innovations LLC · Hendersonville, TNS/N 17271027N172UCEndeavour Flight Training Inc · Opa Locka, FLBuilt 1978 · S/N 17271911N172UFR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273703N172UZMp Aviation LLC · Ogden, UTBuilt 1980 · S/N 17274011N172VFish Air Aviation LLC · San Diego, CABuilt 1985 · S/N 17276469N172VFVictor Foxtrot LLC · Scott City, KSBuilt 1975 · S/N 17265334N172VKKatula Gerard · Pawleys Island, SCBuilt 1968 · S/N 17257009N172VTFly Vermont LLC · Swanton, VTS/N 17263231N172WLaraux Arthur · Bethel, AKBuilt 1971 · S/N 17260099N172WAHandrop Ronald S · Bonita, CABuilt 1979 · S/N 17273507N172WBTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 1978 · S/N 17270907N172WEEl Aero Services LLC · Elko, NVBuilt 1975 · S/N 17265192N172WJBlue Skies Flight Training LLC · Gainesville, FLBuilt 1972 · S/N 17260906N172WLLeveille Wade P · Douglas, MABuilt 1975 · S/N 17265300N172WMChaves Roosevelt Jr · Fontana, CAS/N 17275539N172WPAviair LLC · Wilmington, NCBuilt 1973 · S/N 17262635N172WRWind River Aviation LLC · Lawton, OKBuilt 1981 · S/N 17275113N172WSWoodstock Air LLC · Cincinnati, OHBuilt 1973 · S/N 17261328N172WTTison William A Jr · Boynton Beach, FLS/N 17266400N172WWStraight And Level Seaplanes LLC · Grand Island, FLBuilt 1976 · S/N 17267445N172YNewton Michael R · Creston, WABuilt 1974 · S/N 17263360N172YACf Images LLC · Fairfield, NJBuilt 1981 · S/N 17275080N172YHWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 17271130N172YYApr Aviation · Fresno, CABuilt 1974 · S/N 17263986N172ZMoss Mark A · El Dorado, CABuilt 1969 · S/N 17258726N1730PHolbrook Jonathan L · Morehead, KYS/N 22-2520N1731JRiverside Exteriors Inc · Post Falls, IDBuilt 1968 · S/N 28-24144N1731PLambert Wayne C · Canyon Lake, CABuilt 1954 · S/N 22-2521
Back to AD 80-04-03 R2