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.

N3581WCloud Richard D · Lafayette, LABuilt 1966 · S/N 32-474N3584WSeek Stephen E · Valles Mines, MOS/N 32-478N3585WRodriquez Nat III · Odessa, TXBuilt 1966 · S/N 32-479N3589WCfi Aero LLC · Riverside, CABuilt 1966 · S/N 32-484N358BTRorabaugh Kenneth P · Sunrise, FLS/N 32-40051N3590WAgoston Thomas M Trustee · Liberty Twp, OHBuilt 1966 · S/N 32-485N3592WFoothills Aviation Inc · Pickens, SCBuilt 1966 · S/N 32-488N3593WGriffin Julie A · Locust Grove, GABuilt 1966 · S/N 32-489N3594JWxs Flying LLC · Mesa, AZS/N 32-7840095N3595WStanley Shawn G · Lorton, VABuilt 1966 · S/N 32-491N3596WAbdelqader Hamza Faris · Beaufort, SCBuilt 1966 · S/N 32-492N3598WSwiss Eagles Inc · Las Vegas, NVBuilt 1966 · S/N 32-495N35CWTimoney James M · Auburn, MEBuilt 1979 · S/N 32-7940170N3601WPrecision Landings Inc · Wilmington, DEBuilt 1966 · S/N 32-498N3602WJeswald Joseph M · Buffalo, NYBuilt 1966 · S/N 32-500N3607WOceanstate Flying Club Inc · Little Compton, RIBuilt 1966 · S/N 32-506N3608WHand Andy A · Waco, TXBuilt 1966 · S/N 32-507N3609WConverse James Robert · Port Saint Lucie, FLBuilt 1966 · S/N 32-509N3612WKard Aviation LLC · Greenville, SCBuilt 1966 · S/N 32-513N3613WTurner Travis · Chetek, WIS/N 32-514N361RPRocha Aviation LLC · Prescott Valley, AZBuilt 1973 · S/N 32-7440046N3620WSemler Jason M · Cambridge, MNBuilt 1966 · S/N 32-521N3629WFly Code Repeat LLC · Lewes, DEBuilt 1966 · S/N 32-531N3630WScarborough Robert T · Yuma, AZBuilt 1966 · S/N 32-532N3634WCarey Nicholas Isaac · Clarkston, WABuilt 1966 · S/N 32-536N3635WSwieter Avionics LLC · Waverly, IAS/N 32-537N36361Smith Robert Ervin III · Mountain Top, PABuilt 1978 · S/N 32-7840158N36364Gordon Security Solutions LLC · Chester Springs, PABuilt 1978 · S/N 32-7840159N3637WStruck Dennis L · Spirit Lake, IABuilt 1966 · S/N 32-539N3638WCherokee Six LLC · Williamson, GABuilt 1966 · S/N 32-540N3639WYoungpeter David L · Spencerville, OHBuilt 1966 · S/N 32-542N363RCWilliams Eric S · Miami, FLS/N 32-40438N3641MSweet Water Air LLC · Kissimmee, FLBuilt 1978 · S/N 32-7840068N3641WMitchell Jeffrey Scott · Donalsonville, GABuilt 1966 · S/N 32-544N3642WMasia Matt D · Paso Robles, CABuilt 1966 · S/N 32-545N36440Aircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 32-7840162N3645WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-549N3646WWap Air LLC · Newburgh, INBuilt 1966 · S/N 32-550N3647WNichols Robert H Jr · Normandy, TNBuilt 1966 · S/N 32-551N3649WTurbo Six LLC · Wilmington, DEBuilt 1966 · S/N 32-554N364MCLesser Antilles Corp Trustee · Wilmington, DEBuilt 1973 · S/N 32-7300039N3651WTraxler Christopher V · Russia, OHBuilt 1966 · S/N 32-556N3652WValiair Limited Co Trustee · Casper, WYS/N 32-557N3656WNuvision Heaqlth Center · Macomb, MIBuilt 1966 · S/N 32-562N3658WFlying 20 Club Inc · Springfield, ILBuilt 1966 · S/N 32-564N36615Booth Warren Russell · Doylestown, PABuilt 1978 · S/N 32-7840166N3661WPrete Vincent A · Jim Thorpe, PABuilt 1966 · S/N 32-568N3664WSuffoletto Gregory · Hamburg, NYBuilt 1966 · S/N 32-572N3665WWitham Chris · Cathedral City, CABuilt 1966 · S/N 32-573N3669WDocken Marvin O · Omaha, NEBuilt 1966 · S/N 32-578
Back to AD 74-18-13