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.

N8077H8077h LLC · Southington, CTBuilt 1979 · S/N 28-8090067N8077NRodgers Wesley T · Enterprise, ALS/N 28-25328N8077QWakefield Robert · Toccoa, GABuilt 1979 · S/N 28-8090069N8077RIscovich Mario S · Thousand Oaks, CABuilt 1979 · S/N 28-8090070N8077ULeavitt Erin G · Lewiston, IDBuilt 1947 · S/N 12-1084N8077WN8077w Inc · Bloomfield Hills, MIBuilt 1979 · S/N 28-8090072N8077YMagenta Line LLC · Geneva, NYBuilt 1982 · S/N 32R-8213029N8078Tkg Aviation LLC · Denver, COBuilt 1977 · S/N 1-0054N80781P D H S Aerial Photography Inc · Spicewood, TXBuilt 1976 · S/N 17266745N80784Stamm David A · Lake Almanor, CAS/N 17266747N80785Campbell Air LLC · Angola, INBuilt 1979 · S/N 28-8090077N80788Bell Aa Flying Club Inc · Mechanicsburg, PABuilt 1976 · S/N 17266748N8078DStevenson William E · Sutton, AKBuilt 1957 · S/N 18-6061N8078G615dm LLC · Hazel Green, ALBuilt 1971 · S/N 177RG0078N8078PComanche Partners · Manhattan, MTFirst renewal noticeBuilt 1962 · S/N 24-3326N8078RKhozam George · Murrieta, CABuilt 1979 · S/N 28-8090073N8078ZL & A Bennett Second Family Lp · Renton, WAS/N 28-8090076N80790Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266749N80796Supina Mickey A · Prescott, AZBuilt 1946 · S/N 199N80797Neitz Frank · Bethel, AKS/N 17266750N80798Thomas Dean Properties LLC · O Fallon, MOBuilt 1976 · S/N 17266751N8079CFlying D Farm Inc · Kerhonkson, NYBuilt 1958 · S/N 18-3480N8079JTd Aviation LLC · Canton, GABuilt 1978 · S/N 6005667961184N8079WFox Michael · Winfield, KSBuilt 1965 · S/N 28-2168N8079YKaszuba Peter M · Bradenton, FLBuilt 1979 · S/N 28-8016049N807APTexas South Wind Aviation LLC · Kenedy, TXBuilt 1975 · S/N 28-7615086N807CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12629N807DAMays Gloriaj · College Station, TXBuilt 1977 · S/N 28-7816227N807DBAnderson Richard D · Trophy Club, TXBuilt 2019 · S/N 001N807DLLove Mike · Lufkin, TXBuilt 2009 · S/N 60009N807EHLindsey Daniel Rey · Clovis, NMS/N 1242N807EJBaldmans Aircraft Services LLC · Wilmington, DES/N 18-3519N807EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13181N807HDTubbs Jerry M · Manns Harbor, NCBuilt 1976 · S/N 17266730N807LELeading Edge Flight Academy LLC · Bend, ORBuilt 2005 · S/N 10807N807NVUnited Helicopter Leasing LLC · Honolulu, HIBuilt 1999 · S/N 0597N807PAAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9953N807RVMayerhofer Andrew M · Sugar Grove, ILBuilt 2004 · S/N 70604N807SPCawthon James B · Chelsea, ALBuilt 1999 · S/N 172S8111N807SVBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2021 · S/N 4496530N807TATigersair LLC · Amityville, NYBuilt 1966 · S/N 24-4568N807TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 2881700N807TMLidija LLC · Grass Valley, CABuilt 1980 · S/N 61P08468163446N807VROrton Thomas L · Clifford, MIBuilt 2007 · S/N 18281926N807WMGriswold George B III · Cedar Point, NCBuilt 1967 · S/N 28R-30186N807WTWindigo Transportation Inc · Waterloo, IABuilt 2017 · S/N CC19-0025N80800West Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17266752N80803Bradley Charles S · East Bethel, MNS/N 17266754N80807Wings Over Texas Holdings LLC · Denton, TXS/N 17266755N8080AChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016051
Back to AD 81-18-04 R2