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.

N55682Ufer Mark · Sherburn, MNBuilt 1973 · S/N 32-7340108N5571JHildebrandt Eric A · Cocoa, FLS/N 32-997N5575JHarrison Matthew · Benton, ILBuilt 1968 · S/N 32-1036N55776Jordan John R · Brawley, CABuilt 1973 · S/N 32-7340137N5579JFlyinahrens LLC · Webster Groves, MOBuilt 1968 · S/N 32-1024N5581JKts Spar Bay LLC · Coral Gables, FLBuilt 1968 · S/N 32-1038N5583J5150 Ventures LLC · Effingham, ILBuilt 1968 · S/N 32-1043N5584JDelano James B · Laverne, CABuilt 1968 · S/N 32-1044N55856Alpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1973 · S/N 32-7340143N5585JPhb Aviation Inc · Melbourne Beach, FLBuilt 1968 · S/N 32-1027N5590JWilliams John S · Cleveland, TXBuilt 1968 · S/N 32-1050N5592JHyden Josh Vander · Beulah, MIBuilt 1968 · S/N 32-1056N5594JGirdler Robert L · Sunrise, FLBuilt 1968 · S/N 32-1061N55957Blumie Thomas C · Jewett City, CTBuilt 1973 · S/N 32-7340148N5596JJenny LLC · Hudsonville, MIBuilt 1968 · S/N 32-1037N5598JMakfly LLC · Chardon, OHBuilt 1968 · S/N 32-1065N55AFRegistration Pending · Terre Haute, INRegistration pendingS/N 32-864N56088Wild River Flying Club Inc · Saint Croix Falls, WIBuilt 1973 · S/N 32-7340154N56095Jk Aviation LLC · Manteca, CABuilt 1973 · S/N 32-7340157N56131Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 32-7300052N56143Sisson Virginia B · Houston, TXBuilt 1973 · S/N 32-7340163N56155Blackmon Ethan T · Hot Springs, ARS/N 32-7300053N56177Bartsch Terry L · Nerstrand, MNBuilt 1973 · S/N 32-7340164N56194Eds Aloft Inc · Mooresville, NCBuilt 1973 · S/N 32-7300055N561PKKlopchic Peter G · Seattle, WABuilt 1973 · S/N 32-7340124N56277Lightfoot John A · Hagerstown, MDBuilt 1973 · S/N 32-7300056N5627VAraujo Richard · Westport, MAS/N 32-7740070N56285Knots And Attitudes LLC · Wimberley, TXBuilt 1973 · S/N 32-7340168N562CAG Gil Aviation Services LLC · Pompano Beach, FLBuilt 1977 · S/N 32-7840043N56309Des Jardins Richard T · St Joseph, MIBuilt 1973 · S/N 327300059N56320Merry Peter · Franklin, TNBuilt 1973 · S/N 32-7300057N56340Mja Aviation LLC · Channahon, ILBuilt 1973 · S/N 327340173N56367N56367 LLC · Manassas, VABuilt 1973 · S/N 32-7300058N56392Ricottilli Stanley L · Mill Creek, WVBuilt 1973 · S/N 32-7300060N563PRPope County Aviation LLC · Russellville, ARS/N 32-7200027N563VWRichen Owyn · Seattle, WABuilt 1968 · S/N 32-1029N56477Divelbiss Donald S · Fredericktown, OHBuilt 1973 · S/N 327300063N56510Brocon Aviation LLC · West Des Moines, IABuilt 1973 · S/N 327340187N56527Kappel Kyle D · Crossville, TNBuilt 1973 · S/N 32-73-40189N56613Cochran Earnest · Texarkana, TXBuilt 1973 · S/N 32-7440009N56631Kalbfell Kenneth · Fallbrook, CABuilt 1973 · S/N 32-7440010N56655White James T · Ardmore, ALBuilt 1973 · S/N 32-7440012N56684Hickory Air Associates Inc · Granite Falls, NCBuilt 1973 · S/N 32-7400004N5668VDrb Transport Inc · Alma, MIBuilt 1977 · S/N 32-7740071N56709Vola Acosta LLC · Lake Forest, CABuilt 1973 · S/N 32-7440020N56728Morris Air LLC · Tillar, ARBuilt 1973 · S/N 32-7440021N56766Elliott Scott · Holmes, NYBuilt 1973 · S/N 32-7400008N56793Dodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 32-7400009N56824Roberts Jeremy · Draper, UTBuilt 1973 · S/N 32-7440029N56836Spj Aviation Holdings LLC · Bentonville, ARBuilt 1973 · S/N 32-7440030
Back to AD 74-18-13