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.

N860DMC & C Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1973 · S/N 32-7340169N8614NFarmers Bank Of Northern Missouri Na · Unionville, MOBuilt 1970 · S/N 32-7140006N8621NMcdonald Timothy Shane · Saint Jacob, ILBuilt 1970 · S/N 32-7140014N8622NPapp Adam P · Raleigh, NCBuilt 1971 · S/N 32-7140015N8625NJanicke Clayton R · Bird City, KSBuilt 1970 · S/N 32-7140018N8626NCf Aviation LLC · Wellington, FLBuilt 1970 · S/N 32-7140019N8629NN8629n Inc · Ooltewah, TNBuilt 1971 · S/N 32-7140022N8630NLowe Alexander · Wauwatosa, WIBuilt 1971 · S/N 32-7140023N8631NOwen Toy C · Anchorage, AKS/N 32-7140024N8634NWright David P Jr · Chandler, AZBuilt 1971 · S/N 32-7140027N8652NDavis Rick J · Los Lunas, NMBuilt 1971 · S/N 32-7240002N8656NN8656n LLC · Weston, NEBuilt 1971 · S/N 32-7200001N8658NOne Way Aviation LLC · Warner Robins, GAS/N 32-7240008N8660NRobbins Jode A · Cameron, WIFirst renewal noticeBuilt 1971 · S/N 32-7200002N8661NLyman Jared C · Plymouth, CABuilt 1971 · S/N 32-7240009N8666NTlc Aviation Ltd · Virginia Beach, VABuilt 1971 · S/N 32-7240013N8667NSky High Flyers Flying Club Inc · Holbrook, NYBuilt 1971 · S/N 32-7240012N8669NBauer Roger · Saint Germain, WIBuilt 1971 · S/N 32-7240015N8673NFuhrman Scott R · Meridian, IDBuilt 1971 · S/N 32-7240017N8674CLaney Ashley · Jacksonville, FLBuilt 1976 · S/N 32-7640070N8674NKesselring Aircraft Leasing Corp · Bayard, IABuilt 1971 · S/N 32-7240018N8676NBerger Kevin · Peachtree City, GABuilt 1971 · S/N 32-7240020N8677NCosgrove William E · Salt Lake City, UTBuilt 1971 · S/N 32-7240021N8678NGranberry Walter E · Lubbock, TXS/N 32-7240022N8682NSt Augustine Bluewater LLC · Saint Augustine, FLS/N 32-7240025N8683NAirwide LLC · Deerwood, MNBuilt 1971 · S/N 32-7240026N8684NTmi Aviation LLC · North Myrtle Beach, SCBuilt 1971 · S/N 32-7240029N8685NCummings Stephen · Fenton, MOS/N 32-7240030N8686NOgden Mark Thomas · Boerne, TXBuilt 1971 · S/N 32-7240031N8687NOpen Air LLC · Glendale, AZBuilt 1971 · S/N 32-7240032N8688NAerosky LLC · Holly Springs, NCBuilt 1971 · S/N 32-7240016N8689ESeufert Steven W · Chelmsford, MABuilt 1976 · S/N 32-7640074N8689NHewitt Donald R · Califon, NJBuilt 1971 · S/N 32-7240033N8694NCitadelle Holdings LLC · Palmetto Bay, FLBuilt 1971 · S/N 32-7200009N8698NUnder Bridge LLC · Wilmington, DEBuilt 1971 · S/N 32-7240045N8699NHolding Short LLC · Travelers Rest, SCBuilt 1971 · S/N 32-7240047N86AJMullins Mark C · Riverside, CABuilt 1972 · S/N 32-7200036N86CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 32-40957N8712EBec Industries LLC · Toms River, NJS/N 32-7600011N873ARRincon Jose Antonio · Santa Maria, CABuilt 1966 · S/N 32-817N8768KRegistered aircraftS/N 32-7340149N876EEEwing Robert A · Cedar Grove, NJBuilt 1971 · S/N 32-7100023N877DSEvans Ashley E · Elizabeth, COBuilt 1967 · S/N 32-40185N878MJJackson Air LLC · Paragould, ARBuilt 1976 · S/N 32-7640078N8791EKl&Z Farms LLC · Littleton, NCBuilt 1976 · S/N 32-7600012N8797BDalton Robert Frank · Jackson, CAS/N 32-40149N8797CMeadowlake Airpark LLC · Lenoir City, TNBuilt 1976 · S/N 32-7640071N888TMFive G Aviation LLC · Nampa, IDBuilt 1974 · S/N 32-7440132N8905NHigh Noon Leasing LLC · Anchorage, AKS/N 32-40690N8907NCrain Roan · Cookeville, TNS/N 32-40693
Back to AD 74-18-13