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.

N43998Tailwind Aviation LLC · Royersford, PABuilt 1977 · S/N 32-7740105N4403TTyrrells Trails LLC · Fairbanks, AKS/N 32-7240076N44087Little Island Roofing · Stuart, FLBuilt 1974 · S/N 32-7440143N44130Cotton John M III · Windham, NHBuilt 1974 · S/N 32-7400047N4417TBimini Bullet LLC · Lakeland, FLBuilt 1972 · S/N 32-7200021N4418TRankin Kevin K · Vandalia, OHBuilt 1972 · S/N 32-7240079N4425TBooth Aviation LLC · Fort Worth, TXS/N 32-7240080N44295Caribbean Aviation Lc · Miami, FLBuilt 1974 · S/N 32-7440149N4429XPearls Pilot LLC · Jefferson City, MOBuilt 1975 · S/N 32-7640021N44328Riddle Bruce C · Franklin, NCBuilt 1974 · S/N 32-7440150N44369T&B Aviation LLC · City Of Industry, CAS/N 32-7440151N44494N44494 LLC · Peachtree City, GABuilt 1974 · S/N 32-7440156N444LCPiper Cherokee LLC · Leesburg, VABuilt 1977 · S/N 32-7740047N444NAPittman Deryl Trustee · Morgantown, INBuilt 1971 · S/N 32-7140043N444RMSky Taxi LLC · Fort Payne, ALBuilt 1969 · S/N 32-40730N44560Niewenhuis Larry D · Grand Ledge, MIBuilt 1974 · S/N 32-7440160N44588N44588 LLC · Vero Beach, FLBuilt 1974 · S/N 32-7400050N44601Talon Aero LLC · Bowling Green, OHBuilt 1974 · S/N 32-7440162N44618Word Howard W Trustee · Kula, HIBuilt 1974 · S/N 32-7400051N44661Family Flyer Six LLC · Columbus, INBuilt 1974 · S/N 32-7540002N44685Sundance Air Charter LLC · Portland, ORFirst renewal noticeBuilt 1974 · S/N 32-7440168N4468XHalf Nuts LLC · Boiling Springs, PABuilt 1975 · S/N 32-7640024N44747Goldenburg Timothy A · Ypsilanti, MIBuilt 1974 · S/N 32-7500001N44782Alsup Jonathan S · Tok, AKBuilt 1974 · S/N 32-7500002N44783Family Eye Care Center LLC · Elkins, WVBuilt 1974 · S/N 32-7540004N44813Olusanya Babajide A · Cherry Hill, NJBuilt 1974 · S/N 32-7540006N4483TWaterboy Aviation LLC · Richlandtown, PABuilt 1972 · S/N 32-7240072N44851King Air Inc · Naknek, AKS/N 32-7740107N4485XL & A Bennett Second Family Lp · Renton, WAS/N 32-7640026N448MJWilson Darrell Gene III · Mcpherson, KSBuilt 1966 · S/N 32-772N44944Karimi Enterprises LLC · Myrtle Beach, SCBuilt 1977 · S/N 32-7740113N44990Fineran James V III · Towson, MDBuilt 1977 · S/N 32-7840002N44DZWanted Poster Owners Group LLC · York, PABuilt 1973 · S/N 32-7300046N44JYAcre LLC · Abilene, KSBuilt 1969 · S/N 32-40637N4508RMcmichael Timothy J · Rock Hill, SCBuilt 1979 · S/N 32-7940245N4513QBobcat Aviation LLC · Northfield, MNBuilt 1977 · S/N 32-7740066N4518TBnr Aviation LLC · Lawrenceville, GABuilt 1972 · S/N 32-7200022N451JSend North · Anchorage, AKBuilt 1965 · S/N 32-254N451NKSink Craig S · Queen Creek, AZBuilt 1973 · S/N 327340027N4556FReindeer Aviation LLC · Bloomfield Hills, MIBuilt 1976 · S/N 32-7600022N4571TVandeventer Matthew S · Dillingham, AKS/N 32-7200023N4577XFairhaven LLC · Meridian, MSBuilt 1975 · S/N 32-7600004N4584TLion Air LLC · South Heart, NDBuilt 1972 · S/N 32-7240087N4598TSikora Justin E · Jupiter, FLBuilt 1972 · S/N 32-7200024N4599XStar Marianas Air Inc · Saipan, MPBuilt 1975 · S/N 32-7640040N464SPMeshik Ground Service LLC · Port Heiden, AKBuilt 1974 · S/N 32-7440159N4699SStrike Allen P · Flint, MIBuilt 1969 · S/N 32-1158N469BKClark John Wayne · Lexington Park, MDBuilt 1969 · S/N 32-1156N46WFFoy William N · Murfreesboro, TNS/N 32-971N4726SN4726s LLC · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-1165
Back to AD 74-18-13