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.

N3671WOdean Steve · Palmer, AKS/N 32-580N3673MBeacon Park Pointe LLC · Orlando, FLBuilt 1978 · S/N 32-7840069N3675WWilson Ag Consulting LLC · Boise, IDBuilt 1966 · S/N 32-584N3677WGriffith Chad Wayne · Crosby, TXBuilt 1966 · S/N 32-586N3678MCometair LLC · Greensboro, NCBuilt 1978 · S/N 32-7840070N3678WDiamond B Farm Inc · Gamaliel, KYFirst renewal noticeBuilt 1966 · S/N 32-587N3680WBeachy Titus E · Altamont, TNBuilt 1966 · S/N 32-590N3683WHaure Pierre II · Rayne, LABuilt 1966 · S/N 32-593N3686WLadet William D · Las Vegas, NVS/N 32-596N3687WBluewater Marine Group Inc · Wilmington, DEBuilt 1966 · S/N 32-597N3692WMckimson Lance D · Wasilla, AKBuilt 1966 · S/N 32-603N3696WSantos Marc · Lincoln, RIBuilt 1966 · S/N 32-608N3703WGill James A · Gaithersburg, MDBuilt 1966 · S/N 32-616N370WCInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 32-7840196N3710WPdr LLC · Royal Palm Beach, FLFirst renewal noticeS/N 32-623N3713WRvn Trucking LLC · Tilden, NEBuilt 1966 · S/N 32-626N3716WRobb Air LLC · Escalon, CAS/N 32-629N3721WFiumerodo Flavio · Tarzana, CABuilt 1966 · S/N 32-633N3725WKosko Stanley G · Seattle, WABuilt 1966 · S/N 32-638N3727WTriple C Air LLC · Madison, GABuilt 1966 · S/N 32-640N3728WGalactic Air LLC · Ringoes, NJBuilt 1966 · S/N 32-641N3729WColeman James C III · Saint Augustine, FLBuilt 1966 · S/N 32-642N3730WEye South Equipment LLC · Greenwood, MSBuilt 1966 · S/N 32-644N3736WLarsen Christopher R · West Melbourne, FLBuilt 1966 · S/N 32-650N3737MMathur Arvind Kishore · Hemet, CABuilt 1978 · S/N 32-7840071N3737WVoss James S · Soldotna, AKS/N 32-651N3738WNewton Machine Co Inc · Charlotte, NCBuilt 1966 · S/N 32-652N3739WPacific Gold Aviation Association · Roseville, CABuilt 1966 · S/N 32-653N3742WRibas Daniel · Atascadero, CABuilt 1966 · S/N 32-656N3746WN3746w Corp · Wilmington, DEBuilt 1966 · S/N 32-660N37491Tuskegee Airmen National Historical Museum Inc · Detroit, MIS/N 32-7340177N3750WNichols John L · Parksville, NYS/N 32-664N3751WEthridge Lee C · Mount Pleasant, TXBuilt 1966 · S/N 32-665N3754WHam Aviation LLC · Maysville, KYBuilt 1966 · S/N 32-669N3755WMs Air LLC · Hickory, NCBuilt 1966 · S/N 32-670N3756WAranda Jarrod A · Vancouver, WABuilt 1966 · S/N 32-671N3757WSowden Nathan S · Annapolis, MDBuilt 1966 · S/N 32-672N3760WTonini Ryan · Huntsville, ALS/N 32-677N3763WDaise Nicklaus J · West Chester, PABuilt 1966 · S/N 32-681N3765WMazzochi James A · Hilton Head Island, SCBuilt 1966 · S/N 32-685N3772WBlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1966 · S/N 32-694N3779WAirmotive Service LLC · Brigham City, UTBuilt 1966 · S/N 32-701N3780WRaines Marshall A Jr · Whiteside, TNBuilt 1966 · S/N 32-702N3784WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 32-707N3786WDavis William K · Fredericksburg, VABuilt 1966 · S/N 32-709N3790WScudder Adam J · Orlando, FLS/N 32-715N3791WCherokee Trail Aviation LLC · Tontitown, ARBuilt 1966 · S/N 32-717N3792WFrazer Thomas · Warren, ARBuilt 1966 · S/N 32-719N3793WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 32-720N3795WWendt Aaron · Temecula, CABuilt 1966 · S/N 32-722
Back to AD 74-18-13