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.

N90DDBas Part Sales LLC · Greeley, COS/N 32-7940072N9107KBeidoun Bassam A · Auburn Hills, MIBuilt 1977 · S/N 32-7840029N911SAIntensive Medical Inc · Clermont, FLBuilt 1976 · S/N 32-7640059N913CBecker Claus · West Palm Beach, FLBuilt 1975 · S/N 32-7640030N914MGHolman Larry E · Cleveland, GABuilt 1970 · S/N 32-1281N9220CDixon Aviation LLC · Oakland, MDBuilt 1978 · S/N 32-7840091N9269CMcmillin George T · Bradenton, FLBuilt 1978 · S/N 32-7800002N926BBBb Air · Stuart, FLBuilt 1978 · S/N 32-7840085N927DMGoat Rancho LLC · Euless, TXS/N 32-40225N9297C831 Aviation LLC · Salinas, CABuilt 1978 · S/N 32-7840093N934PHRossell Holdings LLC · Astoria, ORBuilt 1974 · S/N 32-7540059N936BWTriple J Aviation LLC · Mcconnelsville, OHBuilt 1967 · S/N 32-921N93PNHawkins Steven L · Grand Prairie, TXBuilt 1974 · S/N 32-7440091N9442CElevate Aviation LLC · Rathdrum, IDBuilt 1978 · S/N 32-7840098N945JKSweetair Aviation · West Monroe, LABuilt 1971 · S/N 32-7140039N9494CChristensen Robert R · Mattawa, WABuilt 1978 · S/N 32-7840099N94PLucas Matthew A · Mission Viejo, CABuilt 1969 · S/N 32-40660N951GTK And M Aviation LLC · Palm Harbor, FLBuilt 1979 · S/N 32-7940036N9561KRouth Kipp D · New Richland, MNBuilt 1976 · S/N 32-7640086N9599CDomenico Joseph A · Saint Germain, WIBuilt 1978 · S/N 32-7840104N95RAKennedy Crosswind LLC · Wellsburg, IABuilt 1973 · S/N 32-7440054N9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTBuilt 1978 · S/N 32-7840106N9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCBuilt 1978 · S/N 32-7840107N9657CFrantz Jeffery T Jr · Frankfort, ILS/N 32-7840109N9675CRegistered aircraftBuilt 1978 · S/N 32-7840110N9695CTrhb Enterprises LLC · Danville, PABuilt 1978 · S/N 32-7840112N96JBSigman Bruce A · East Brunswick, NJBuilt 1969 · S/N 32-40722N96MLM & M Aero LLC · Wilmington, DEBuilt 1978 · S/N 32-7940009N97219Deull Jonathan S · Cornwall, NYBuilt 1978 · S/N 327840131N9725CPowell Mark · Grandville, MIBuilt 1978 · S/N 32-7840114N9729CEffingham Eta LLC · Effingham, ILBuilt 1978 · S/N 32-7840115N973SFInternational Air Services Inc Trustee · Carson City, NVS/N 32-7940074N9768CHansen Kurt C · Washington, UTBuilt 1978 · S/N 32-7840116N9794CTaylor Aero Flights Inc · Wilmington, DEBuilt 1978 · S/N 32-7840117N9795CFernett Willard Shane · Peyton, COBuilt 1978 · S/N 32-7840118N97HRRoberts Harold S DBA · Spartanburg, SCBuilt 1965 · S/N 32-73N9884KSalt Air Inc · Wilmington, DEBuilt 1977 · S/N 32-7840031N989ASSkupin Charles G · Riverview, MIBuilt 1978 · S/N 32-7840201N98CTRote William E · San Marcos, CABuilt 1965 · S/N 3222N998MMHardcastle Eric · Holly Springs, NCBuilt 1968 · S/N 32-1035N99ESGorsuch Larry · Richland, WABuilt 1968 · S/N 32-1020N99MGChaffee Michael D · Big Rapids, MIBuilt 1969 · S/N 32-40727
Back to AD 74-18-13