OpenAirDocs.org
AD 74-18-13

Registered aircraft · 1,642

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:74-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
  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.

N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077N1027FFilarski Darryl M · Grosse Ile, MIBuilt 1971 · S/N 32-7140036N1029XBaden Frederick Richard · Mc Arthur, OHBuilt 1975 · S/N 32-7540181N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951N103RRLancaster Flyers LLC · Fenwick Island, DEBuilt 1979 · S/N 32-7940097N10480Piper 66 LLC · Kirksville, MOBuilt 1966 · S/N 32-279N1049XValleyside Farm LLC · Woodstock, CTBuilt 1975 · S/N 32-7540132N1054QTaylor Hauling II LLC · Laurel, MSBuilt 1977 · S/N 32-7740045N105DYYeager Daniel C · Iowa City, IABuilt 1966 · S/N 32-467N105TCMark Johnson And Sons Plumbing LLC · Ruston, LABuilt 1979 · S/N 32-7940163N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015N1062UNathan John K · Seabrook, TXS/N 32-40070N1069XEntelechy One LLC · Wichita, KSBuilt 1975 · S/N 32-7540134N106NAVann-Tage Point Aviation LLC · New Castle, DES/N 32-704N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099N108WMMoran William J · Media, PABuilt 1978 · S/N 32-7840187N1099JLee'S Sea Air Inc · Kiana, AKBuilt 1967 · S/N 32-40274N109ATAguillard Robert N · Memphis, TNBuilt 1974 · S/N 32-7540042N10PJMiller Kenneth R · Russellville, KYBuilt 1967 · S/N 32-40285N1102NWorld Class Athletic Surfaces Inc · Leland, MSBuilt 1968 · S/N 32-40756N111AJBergin Donald M · Ormond Beach, FLBuilt 1972 · S/N 32-7200041N111FCWoody Air LLC · Vero Beach, FLBuilt 1968 · S/N 32-1030N112WMInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 32-7140001N1132QWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7740046N113HMAkins Tal M · Register, GABuilt 1976 · S/N 32-7640084N1140XReaper LLC · Britton, MIBuilt 1975 · S/N 32-7540147N1146HLtk Air Inc · North Wilkesboro, NCBuilt 1976 · S/N 32-7740031N1154XKelley Jay D · Lake Havasu City, AZS/N 32-7540149N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150N116BKDacy Roy W · Rockport, TXS/N 32-782N1180XK & K Aero Inc · Wilmington, DEBuilt 1975 · S/N 32-7540152N120DMWestfall Aviation LLC · Reno, OHBuilt 1973 · S/N 32-7340122N121HEJarrett Air LLC · Ashland City, TNBuilt 1979 · S/N 32-7940127N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105N122KTRustair Inc · Anchorage, AKS/N 32-7940190N122TEBouchillon James R · Hanahan, SCBuilt 1972 · S/N 32-7340044N123BEBald Moutain Aviators · Fredericktown, MOBuilt 1967 · S/N 32-40271N123LUSutton Aircraft Salvage LLC · Palmer, AKS/N 32394N123MFAronhalt Daniel E · Columbus, INBuilt 1968 · S/N 32-1069N123YAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 32-7940258N1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingBuilt 1972 · S/N 32-7200034N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579N1297HHop A Chopper Inc · Dover, DES/N 32-7700010N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112N129SCSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 32-7440057
Back to AD 74-18-13