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.

N73298Castelan Luis E · Irving, TXBuilt 1976 · S/N 17267354N7329DCampbell Michael S · Ann Arbor, MIS/N 22-5117N7329FProflite Aero LLC · Easton, PABuilt 1968 · S/N 28-25237N7329GFive Guys Aviation LLC · Pendleton, SCBuilt 1970 · S/N 17259029N7329JWalser Air LLC · Warwick, RIBuilt 1968 · S/N 28-24683N7329PSlm Holdings LLC · Kalispell, MTBuilt 1961 · S/N 24-2507N7329WHohl Warren G · Albany, GABuilt 1963 · S/N 28-1200N732ACaraway Michael S · Decatur, TXBuilt 1993 · S/N 20321N732BJSendero Helicopters LLC · Bandera, TXBuilt 2005 · S/N 10837N732BNConn Teresa M · Fairfax, VABuilt 1960 · S/N 252N732CATrey Stroup Aviation LLC · Fort Pierre, SDBuilt 1966 · S/N 30-1086N732CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11568N732JBHenry Sean M · Savannah, GABuilt 1998 · S/N 60031N732NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843856N732RCCarter Ronald J · Benicia, CABuilt 2022 · S/N 70835N732UASonoran Aero LLC · Phoenix, AZBuilt 1968 · S/N 25-4658N732VFVictor Fox Aviation LLC · Newport Beach, CABuilt 1998 · S/N 18280296N732WAsher Mitchell J · Senoia, GABuilt 2009 · S/N 82000N732WDBig Picture Aviation Inc · Wheaton, ILBuilt 1980 · S/N 172RG0264N73306Boomer Aviation Inc · Fort Walton Beach, FLBuilt 1976 · S/N 17267361N73307Ftk Aviation LLC · Evans, GABuilt 1976 · S/N 17267362N7330BLogan Richard M · St Louis Park, MNBuilt 1977 · S/N A1520746N7330KFinke Michael C · Sewickley, PABuilt 1950 · S/N 20-231N7330PGenpack LLC · Hillsdale, NJBuilt 1961 · S/N 24-2509N7330WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1963 · S/N 28-1201N7330YJordan Terry L · Hugoton, KSBuilt 1964 · S/N 30-378N7330ZAlbertson James M · Slocomb, ALBuilt 1965 · S/N 25-3230N73311184 Flying Club Inc · Concord, CABuilt 1976 · S/N 17267364N73312Murray Air LLC · Patoka, ILBuilt 1976 · S/N 17267365N73317Bell Susan J · Georgetown, CABuilt 1976 · S/N 17267368N73318Lair De Rien Aviation Inc Trustee · Wilmington, DEBuilt 1976 · S/N 17267369N73319My Way Aviation LLC · Weston, FLBuilt 1976 · S/N 17267370N7331FGreenwood Stephen R · Salt Lake City, UTBuilt 1968 · S/N 28-25238N7331JRitchey David C · Hilliard, OHBuilt 1968 · S/N 28-24685N7331WBandit Aviation LLC · Batesville, MSBuilt 1963 · S/N 28-1091N7331YNeubert Erich S · Dana Point, CABuilt 1964 · S/N 30-292N73321Learn To Fly Nola LLC · New Orleans, LABuilt 1976 · S/N 17267372N73324Gulf Atlantic Airways DBA · Gainesville, FLBuilt 1976 · S/N 17267374N7332A4y Aviation LLC · Owasso, OKBuilt 1980 · S/N 32-8006049N7332JRegistration Pending · Peculiar, MORegistration pendingBuilt 1968 · S/N 28-24686N7332PArnold Christian M · Waltham, MABuilt 1961 · S/N 24-2511N7332WBarney Steven K · Bloomfield, NEBuilt 1963 · S/N 28-1202N7332ZHaggland James R · Fairbanks, AKBuilt 1966 · S/N 18-8401N73330Thornton Ralph · Oxford, ALBuilt 1976 · S/N 17267378N73331Dameron Cleveland F · Wicomico Church, VABuilt 1976 · S/N 17267379N73333Bonacker Steven C · Camdenton, MOBuilt 2018 · S/N 74478N73334Heavy Metal Air LLC · Farmingdale, NYBuilt 1976 · S/N 17267382N73338Einarson Flying Service · Intl Falls, MNS/N 17267386N7333FHickle William H · Inyokern, CAS/N 17273246N7333KGreen Francis E · Frankfort, NYBuilt 1950 · S/N 20-240
Back to AD 81-18-04 R2