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.

N5467ZWilliams Mark L · Denham Springs, LABuilt 1962 · S/N 22-9246N54680Yanagida Kazuaki · Norco, CABuilt 1981 · S/N 17275035N5468HPrjc Properties LLC · Vonore, TNS/N 17265456N5468LStewart Kenneth R · Allen, TXBuilt 1973 · S/N AA5-0368N5468PThompson Kevin A · San Rafael, CABuilt 1958 · S/N 24-525N5468RCw Arborists Ltd · Killingworth, CTBuilt 1965 · S/N 17253027N5468WSitton David F · Mebane, NCBuilt 1962 · S/N 28-549N5468ZJensen Larry F · Millington, MIS/N 22-9247N5469HBonny Brad J · Sunnyside, WAS/N 18-60N5469KAviation Specialists Inc · Apison, TNBuilt 1980 · S/N 17274135N5469LHovanec Robert R · Mineral Ridge, OHBuilt 1973 · S/N AA5-0369N546ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281594N546BNavigation Leasing LLC · Castle Rock, COBuilt 2019 · S/N 2881105N546CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881279N546CWCentral Washington University · Ellensburg, WABuilt 2019 · S/N 2881104N546DKMcghee Billy H · Deland, FLS/N MB-616N546EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13538N546HPSwisher Aviation LLC · Auburn, NHBuilt 2017 · S/N 3290N546KWard Mark E · Brookfield, WIBuilt 2001 · S/N 18281013N546MCLeaseair LLC · Wilmington, DEBuilt 2000 · S/N 172S8376N546NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11045N546PSClimb LLC · Kalispell, MTBuilt 1999 · S/N 23836N546SCWessel Marvin E Jr · Camp Verde, AZBuilt 2009 · S/N MEW001SCN5470KSkye Aircraft LLC · Deland, FLBuilt 1980 · S/N 17274136N5470WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1962 · S/N 28-551N5470ZGordon Robert F · Collins, MOBuilt 1962 · S/N 22-9250N54715Apt Aero LLC · Port Angeles, WABuilt 1981 · S/N 17275038N5471LJc Investors Group LLC · Coral Springs, FLBuilt 1973 · S/N AA5-0371N5471PN5471p LLC · Roswell, GABuilt 1958 · S/N 24-528N5471WBartholomew Charles Scott · Newburyport, MABuilt 1962 · S/N 28-552N54728Vig Cheryl J · Opal, SDS/N 17275039N5472HBertrand Joel R Trustee · Anchorage, AKBuilt 1950 · S/N 18-64N5472RAnderson Craig D · Mission Viejo, CABuilt 1974 · S/N 17263544N5472TAdvantage Aviation Inc · Palo Alto, CABuilt 1972 · S/N 28R-7235234N5472ZBanks Steven R · Blue Springs, MOBuilt 1962 · S/N 229252N54733Gofastpilots LLC · Roswell, NMBuilt 1981 · S/N 17275042N54734Southern Arkansas University Tech · Camden, ARS/N 17275043N54739Skylens LLC · Hammond, LABuilt 1981 · S/N 17275045N5473DN1705r Inc · Cobb, CABuilt 1979 · S/N 17272579N5473HSkatvold Charles P · Moorhead, MNBuilt 1950 · S/N 18-63N5473LPlane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N AA5-0373N5473PBloyer Kelly G · Townsend, GABuilt 1959 · S/N 24-530N5473TTiernan Barton M · Anchorage, AKBuilt 1982 · S/N R18201876N5473WMathews Derek A · Burlington, KYBuilt 1962 · S/N 28-555N54741State Of Alaska · Anchorage, AKBuilt 1976 · S/N 18-7609052N54744Suncoast Aviation Of Swfl LLC · Fort Myers, FLBuilt 1981 · S/N 17275047N5474PKrnp Air Services LLC · Zeeland, MIBuilt 1958 · S/N 24-531N5474SHiggs Mark P · Monett, MOBuilt 1971 · S/N 28-7125128N54750Heartland Aviation Inc · Alliance, NES/N 18-7609053N54752Aerosync LLC · Miami, FLBuilt 1981 · S/N 17275048
Back to AD 81-18-04 R2