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.

N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931N5680YSchildberg Gregory M · Casey, IABuilt 1965 · S/N 18-8292N5681QSteixner Jessica M · Madison, TNBuilt 1965 · S/N 3039N5681SHillcrest Aviation LLC · Midland, TXBuilt 1966 · S/N MA-91N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495N5681ZCalvert Scott R · Pequannock, NJBuilt 1962 · S/N 22-9508N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046N56822Tanner Timothy S · Norton, KSBuilt 1973 · S/N 28R-7435047N56823Fly Tu9 LLC · Vancouver, WABuilt 1973 · S/N 28R-7435048N56828Gillette Daniel R · Chillicothe, ILBuilt 1973 · S/N 28-7425048N5682LLahlum Steven R · Warroad, MNBuilt 1969 · S/N AA1-0082N5682QNagel Mildred J · Akron, OHS/N 697N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496N5682WRiggin Flight Service Inc · Madison, SDBuilt 1962 · S/N 28-938N56831Burns Robert A · Fort Myers, FLFirst renewal noticeBuilt 1973 · S/N 28-7415015N56834Maslonka Bradley James · Prior Lake, MNBuilt 1973 · S/N 28R-7435049N56836Spj Aviation Holdings LLC · Bentonville, ARBuilt 1973 · S/N 32-7440030N5683WYanta Chris · Rockport, TXBuilt 1962 · S/N 28-940N5683ZPalmenteri Louis · Rhome, TXBuilt 1962 · S/N 22-9512N56847Nepsund Michael L · Park Rapids, MNBuilt 1973 · S/N 28-7415017N56849Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 28-7415018N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756N5684WSeverino Racli · Closter, NJBuilt 1963 · S/N 28-948N5684ZMuehlberg Stephen E · Newcastle, OKBuilt 1962 · S/N 22-9514N56853Maxair Complex Flight LLC · Murfreesboro, TNBuilt 1973 · S/N 28R-7435050N5685LFritz Frank M · Milwaukee, WIBuilt 1969 · S/N AA1-0085N5685PWalker Richard E · Quanah, TXBuilt 1959 · S/N 24-757N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125N5685UTres Amigos Flying Club LLC · Redding, CABuilt 1969 · S/N 28-26482N5685WRempel Steven P · Prague, OKBuilt 1962 · S/N 28-953N56860Horst Michael D · Chambersburg, PABuilt 1973 · S/N 28-7415019N56861Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 28-7405035N56864Odom Joseph L Jr · Lake Mary, FLBuilt 1973 · S/N 28R-7435052N5686LBresson Kyle M · Roxbury, CTBuilt 1969 · S/N AA1-0086N5686PGray Gary L · Frederick, OKBuilt 1959 · S/N 24-758N5686QBolton Nicolas · Murfreesboro, TNBuilt 1965 · S/N 699N5686UHobbs Stanley T · Middleburg, FLBuilt 1969 · S/N 28-26483N5686WPromedical Inc · Pfafftown, NCBuilt 1962 · S/N 28-954N56874Styer David B · Pendleton, ORBuilt 1979 · S/N 467N5687LDedominici Kenneth · Vero Beach, FLS/N AA1-0087N5687QRegistered aircraftBuilt 1965 · S/N 3042N5687SRobbins Warren N · Chandler, AZBuilt 1966 · S/N MB-127N5687YBrouse Dan T · Magnolia, TXBuilt 1965 · S/N 27-2805N56887Leavitt Teyvin M · Coeur D Alene, IDS/N 28-7425059N56888Ameer & Zaki Aircraft Solutions LLC · Lewes, DEBuilt 1973 · S/N 28R-7435056N56889Red Choochoo LLC · Madison, INBuilt 1973 · S/N 28R-7435057N5688HSheradin Roland R · Cape Coral, FLBuilt 1949 · S/N 16-300N5688LDolan John C · Sequim, WAS/N AA1-0088N5688STanneberg Larry · Coulee City, WABuilt 1966 · S/N MB-128N5688TJoe Koch Construction Inc · Youngstown, OHBuilt 1980 · S/N 480-2
Back to AD 81-18-04 R2