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.

N3483WSale Reported · Lubbock, TXSale reportedBuilt 1966 · S/N 32-361N3485WKemp James A · Deland, FLBuilt 1966 · S/N 32-363N3486WSteele Jackie L · London, KYBuilt 1966 · S/N 32-364N3488WLiberty University School Of Aeronautics · Lynchburg, VABuilt 1966 · S/N 32-367N348RPWright-Piros Ruth · Carlisle, IABuilt 1979 · S/N 32-7940186N3492WMyers Andrew John · Wadsworth, OHS/N 32-372N3493WVerser James A · Greers Ferry, ARBuilt 1966 · S/N 32-373N3494WHarrison Brett A · Fishers, INBuilt 1966 · S/N 32-374N3497WRobb Kirk C · Abingdon, ILBuilt 1966 · S/N 32-377N3498WKanz Robin Lea · Woodway, TXBuilt 1966 · S/N 32-378N3499WAviator Solutions LLC · Oregonia, OHBuilt 1966 · S/N 32-379N34DLAdlava LLC · Dover, OHBuilt 1966 · S/N 32-527N34JCA2b Aviation LLC · Newark, OHBuilt 1978 · S/N 32-7840198N34MALk Air Inc · Arlington, WAS/N 32-40219N3500WAerotyne International LLC · Prattville, ALBuilt 1966 · S/N 32-381N3501WObrien Matthew A · North Platte, NEBuilt 1966 · S/N 32-382N3502WN3502w LLC · Stephenville, TXBuilt 1966 · S/N 32-383N3510WWhite Frank M · Haines, AKBuilt 1966 · S/N 32-392N3513WFrankiewicz Victor J · Chrisman, ILBuilt 1966 · S/N 32-396N3514WBattaglia Anthony · Moosic, PABuilt 1966 · S/N 32-397N3515WHetherington Michael R · Fairbanks, AKS/N 32-398N3520WLyttle John W Jr · Chehalis, WABuilt 1966 · S/N 32-404N3523WRamunni Andrew R · Medina, OHBuilt 1966 · S/N 32-408N3524WDiaz Albert · Ocean Springs, MSS/N 32-409N3525WDavis Micihael K · Madison, GABuilt 1966 · S/N 32-411N3526WN3526w Holding LLC · Harlem, GABuilt 1966 · S/N 32-412N3527XSzmagala Taras G Jr · Bentleyville, OHBuilt 1975 · S/N 32-7540163N3534WSmittys Garage LLC · Fairmount, INBuilt 1966 · S/N 32-421N3539WPicard Joerg · Grand Rapids, MIBuilt 1966 · S/N 32-605N3541WFlying Horsemen Aviation LLC · Lyons, MIS/N 32-427N3542WRockwall 6 LLC · Royse City, TXBuilt 1966 · S/N 32-428N3546WMelander Dan · Summit, MSBuilt 1966 · S/N 32-433N3547WNatwick Joel T · Port Alsworth, AKS/N 32-434N3552WTwo Sixty Aviation LLC · Wilmington, NCBuilt 1966 · S/N 32-439N3553WVarn Samuel G · Thomasville, GABuilt 1966 · S/N 32-441N3554WPerkins Chas L · Warsaw, MOBuilt 1966 · S/N 32-442N3555WF&F Aviation LLC · Worthington, OHS/N 32-443N3559CDelta Blue Line LLC · Collierville, TNBuilt 1979 · S/N 32-7940279N3559WSherlin Grover W · Garland, TXBuilt 1966 · S/N 32-448N355JHEmm USA Inc · Lewes, DEBuilt 1973 · S/N 32-7340116N3561WSchulz Beverly A · Merrill, WIBuilt 1966 · S/N 32-451N3564WWemyh Air LLC · Krum, TXBuilt 1966 · S/N 32-454N35659Steele Aviation Inc · Walnut Cove, NCS/N 32-7940280N3565MSix 5 Mike LLC · Shreveport, LABuilt 1978 · S/N 32-7840067N3569WFossum Richard F · Salado, TXBuilt 1966 · S/N 32-461N3571WJtw Financail Services · Norfolk, NEBuilt 1966 · S/N 32-463N3573WRay Blake · Midland, TXBuilt 1966 · S/N 32-466N3574RGarner Financial Management Inc · Franklin, TNBuilt 1979 · S/N 32-7940287N3576WEllison David L · Stockbridge, GABuilt 1966 · S/N 32-469N3579WGuzman Anthony J · Hacienda Heights, CABuilt 1966 · S/N 32-472
Back to AD 74-18-13