OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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.

N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126N4162MSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2008 · S/N 1877N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299N4163BHarrop Blake N · Willard, UTBuilt 2006 · S/N 884163N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003N4163JLoera Josa · Laredo, TXS/N 28-22493N41641Gunderson Roger · Fort Collins, COBuilt 1999 · S/N 2843276N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128N41648Russell Matthew M · Niantic, CTBuilt 1974 · S/N 28-7415304N41649Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7415305N4164HRobertson James I · La Pine, ORBuilt 1978 · S/N 24-0623N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N4164YBoard Of Trustees · Savoy, ILBuilt 2000 · S/N 2843317N41650Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415306N41657Morton Zac D · San Antonio, TXBuilt 1974 · S/N 28-7415308N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291N4165MJones Donald T · Barrigada, GUS/N 12-3066N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200N4165ZHollingsworth Lloyd Dan · Anchorage, AKBuilt 1965 · S/N 18-8346N41667Lewis Clifton Jack · North Branch, MIBuilt 1974 · S/N 28-7415116N41669Hogan Daniel L · Chapel Hill, NCBuilt 1974 · S/N 28-7415312N4166CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N R18200334N4166FStalworth Leasing Inc · Burr Ridge, ILBuilt 1999 · S/N 2843263N4166HBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843119N4166MWoolace James L · North Pole, AKBuilt 1947 · S/N 12-3065N4166RRogers John K · Statesboro, GABuilt 2026 · S/N 92273N41672Kansas Aviation Museum · Wichita, KSBuilt 1949 · S/N T1-3CSN41674Swift Museum Foundation Inc · Athens, TNBuilt 1942 · S/N 101N41677Northern Aviation LLC · Palmer, AKBuilt 1973 · S/N 585-73N41678Dodge Donald V · Newnan, GAS/N 586-73N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318N4167ZGolden Arrow Aviation Inc · Wilmington, DEBuilt 1965 · S/N 18-8349N41681Ralston Michael J · Calhoun, GABuilt 1973 · S/N 397-73N41683Ferraro Jeffrey T · Mckinney, TXS/N 976-73N41684Nenahlo Thomas L · Anchorage, AKS/N 588-73N41686Atx Aero LLC · Austin, TXBuilt 1973 · S/N 398-73N41688Breunig Gerald S · Newark, ILBuilt 1973 · S/N 977-73N4168GWeishaar Walter E · Shafter, CABuilt 1995 · S/N 3536N4168HCordell Brad · Port Charlotte, FLBuilt 1995 · S/N 1263N4168JTwigg Donald A · Cumberland, MDBuilt 1966 · S/N 28-22503N4168YThree Point LLC · Lacon, ILBuilt 1976 · S/N 1185-77N4168ZRc Aviation LLC · Grimes, IABuilt 2000 · S/N 3246169N41691Whiteknucle Aerobatics Inc · Blacksburg, VABuilt 1973 · S/N 591-73N41693Glasford John T · Rapid City, SDBuilt 1973 · S/N 979-73N41694Damiano Charles J · Orcutt, CABuilt 1973 · S/N 400-73N41695Guilfoyle Robert J · Shepherd, MTBuilt 1973 · S/N 593-73N41696Aaa Aviation LLC · Donalsonville, GABuilt 1973 · S/N 116-73N41698Collier James R · Castle Rock, COBuilt 1973 · S/N 980-73
Back to AD 81-18-04 R2