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.

N38996Cherokee Kling LLC · Monroe, CTBuilt 1977 · S/N 32-7740104N3899WMauldin Brett · Madison, GABuilt 1966 · S/N 32-845N3900WStuart Deed Pendell · Elkhart, INBuilt 1966 · S/N 32-846N3904WEyler Neale · Goddard, KSBuilt 1966 · S/N 32-850N3906WRegistered aircraftBuilt 1966 · S/N 32-852N3907WParks Craig W · Stephenville, TXBuilt 1967 · S/N 32-915N3909WMargolien Brooks · Orange, MABuilt 1967 · S/N 32-855N3912WFrankie Dixon · Cookeville, TNBuilt 1967 · S/N 32-858N3914WGiermek Peter T · Olean, NYS/N 32-860N3915XKb Aviation LLC · Lewes, DEBuilt 1975 · S/N 32-7540182N3916WSpiritaire Inc · Saint Louis, MOBuilt 1967 · S/N 32-919N3917WAir Tipton Inc · Tipton, IAS/N 32-1058N3919WAir First LLC · Kalispell, MTS/N 32-865N3921WJohnson Roger D · Fort Meade, FLBuilt 1967 · S/N 32-868N3922WSteffey John · Saint Augustine, FLBuilt 1967 · S/N 32923N3924WFrazier Shannon Leo · De Witt, IABuilt 1967 · S/N 32-871N3925WFrench Nathan E · Wilmington, NCS/N 32-924N3930WAvionics Holding Group LLC · Salisbury, NCBuilt 1967 · S/N 32-878N3933WHall James A III · Lagrange, KYBuilt 1967 · S/N 32-882N3934WStudio Jet Inc · Valley Village, CABuilt 1967 · S/N 32-883N3935WAmbrosio Phillip · Saint Louis, MOBuilt 1967 · S/N 32-884N3936WStahl Michael Ray Jr · Pleasant City, OHS/N 32-928N3937WBowen Wesley B · Dothan, ALBuilt 1967 · S/N 32-886N3938WAugust Aero LLC · Kalispell, MTBuilt 1967 · S/N 32-887N3941XBroshchan Ruslan · Jackson, MSBuilt 1975 · S/N 32-7640001N3942WLarkin Jason · Zeeland, MIBuilt 1967 · S/N 32-931N3943WCox Aviation LLC · Debord, KYBuilt 1967 · S/N 32-892N3944WCatlin Flying Service LLC · Twisp, WABuilt 1967 · S/N 32-932N3945WSouth Bay Aviation Inc · Torrance, CAS/N 32-894N3945XKatoozian Kambiz · Kirkland, WABuilt 1975 · S/N 32-7640002N3950MScifly LLC · San Diego, CAS/N 32-7840075N3950WQctr Parts LLC · Big Rapids, MIBuilt 1967 · S/N 32-899N3951WRiebecing Karl F · Whitefish, MTBuilt 1967 · S/N 32-900N39569Jayo LLC · Winston Salem, NCBuilt 1978 · S/N 32-7840167N3957WPorter Casey · Bluffton, SCBuilt 1967 · S/N 32-906N39600Inlet Shores Aviation LLC · Ponce Inlet, FLBuilt 1978 · S/N 32-7840169N3960WTaylor Ryan · Lakeland, FLBuilt 1967 · S/N 32-939N39613Ferrando James P · San Pedro, CABuilt 1978 · S/N 32-7840170N39626Drm Air Group Inc · Lewes, DEBuilt 1978 · S/N 32-7840171N39671N39671 Aviation LLC · Wilmington, DEBuilt 1978 · S/N 32-7840175N3968WDiamond C Aviation Llcj · Gentry, ARBuilt 1967 · S/N 32-917N3969WFix Edward L · Beavercreek, OHBuilt 1967 · S/N 32-909N3971RResnick Quinn A · Lake Park, FLBuilt 1966 · S/N 32-635N3971WJma Aero LLC · Reedsville, PABuilt 1967 · S/N 32-881N3972WMills Charles H · Ashburn, VABuilt 1967 · S/N 32-889N39771Ainley Alan · Paragould, ARBuilt 1978 · S/N 32-7840177N3980WJohnson Ralph W · Shelbyville, TNBuilt 1967 · S/N 32-948N3981WDream LLC · Middletown, DEBuilt 1967 · S/N 32-950N3982WStrassfield Justin · Moyock, NCBuilt 1967 · S/N 32-951N3986WDelaware Flyers Inc · Fort Wayne, INBuilt 1967 · S/N 32-957
Back to AD 74-18-13