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.

N84TXBrooks Nathan · Manhattan, KSBuilt 2000 · S/N 80700N84VCExperimental Flight Test Solutions LLC · Seattle, WABuilt 2008 · S/N 71248N84VHWeber David A · Snohomish, WABuilt 2023 · S/N 73444N84WDFortman James · Vancouver, WABuilt 1986 · S/N 848N84WMErickson Lee A Trustee · Fargo, NDBuilt 1994 · S/N 1264N84WPJayanthi Venkata R · Columbus, OHBuilt 1978 · S/N 28-7911035N84WYHacds LLC · Missoula, MTBuilt 2013 · S/N 3184N84ZRomeo Aviation Ltd · East Sparta, OHBuilt 1959 · S/N TD-232N85007Sidell Joel R · Brighton, COBuilt 2010 · S/N 2000N8500DScootair LLC · Alburgh, VTBuilt 1957 · S/N 22-5727N8500QEilinger Richard L · Hertford, NCBuilt 1953 · S/N 22-1213N8500UGlobal First Capital Aviation Group LLC · Amarillo, TXS/N 20-0062N8500ZKreilich Jonathan E · Rogerson, IDBuilt 2002 · S/N 20-1003N8501DStrausser Brian J · Lower Burrell, PABuilt 1957 · S/N 22-5728N8501LSnider Scott E DBA · Turner, MTBuilt 1969 · S/N 25-4915N8501QLilly James E · Alamosa, COBuilt 2002 · S/N 200066N8502DConrad Dylan · Randolph, WIBuilt 1957 · S/N 22-5729N8502EJones Derick · Moultonborough, NHS/N 7GC-71N8502FOrtiz John Pasqual III · Loma Linda, CABuilt 2002 · S/N 20-1001N8502VAngel Aviation Inc · Peoria, AZBuilt 1973 · S/N 34-7350252N8502WWinker Kurt F · Los Lunas, NMBuilt 1963 · S/N 28-10003N8503Finney Michael E Trustee · Albany, INBuilt 1973 · S/N 910-73N8503CScites Robert W · Toney, ALBuilt 1953 · S/N 22-1215N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175N8503JClark T J · Saint George, UTS/N 20-0063N8503NKirkland Joseph Talmadge III · Memphis, TNBuilt 1969 · S/N 28-11223N8503YRoberti John O · Barre, VTBuilt 1967 · S/N 30-1662N8504LTexas Soaring Association · Midlothian, TXBuilt 1969 · S/N 25-4919N8505Lunetta Peter Joseph Jr · Niskayuna, NYBuilt 1973 · S/N 69-73N8505DRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 22-5732N8505GBailey John · Effingham, ILBuilt 1982 · S/N THA01N8505NMahffey Gary L · Parachute, COBuilt 1969 · S/N 28-11247N8505WMcnamara Kevin Jr · East Aurora, NYBuilt 1963 · S/N 28-10006N8505YCli Aerospace LLC · Appleton, WIBuilt 1968 · S/N 30-1665N8506NTiller Aviation LLC · Omaha, NES/N 28-11248N8506WWestenburg Garrett V · Porter, TXBuilt 1963 · S/N 28-10007N8506YWilliams Russell D · Rehoboth Beach, DEBuilt 1967 · S/N 30-1666N8507DFischer Duane A · New Baden, ILBuilt 1957 · S/N 22-5734N8507ERifenburg Brian K · Ward Cove, AKS/N 7GC-75N8507YWhiteley Robert L · Pittsburg, CABuilt 1967 · S/N 30-1667N8508CHobart Aviation Inc · Akron, OHBuilt 1976 · S/N 28R-7635164N8508DHuhndorf Joshua L · Port Ludlow, WABuilt 1957 · S/N 22-5735N8509DVeal Petra I · Sterling, AKBuilt 1957 · S/N 22-5736N8509WMoreno Rodrigo S · Phoenix, AZS/N 28-10010N850ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496568N850DFFlying J Services LLC · Jourdanton, TXBuilt 2001 · S/N 1019N850FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10376N850FSParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020072N850RSSeckerson Roy M · Jamestown, NDBuilt 1995 · S/N 850N850SPAviolease LLC · Vancouver, WABuilt 2001 · S/N 172S8758
Back to AD 81-18-04 R2