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.

N4870TBailey Charles G · Phoenix, MDBuilt 1972 · S/N 32-7200026N4871SLaingkids LLC · Lewes, DES/N 32-7100017N4872SBlocker James Deric · Cave Creek, AZS/N 32-7140054N4874SShores Financial LLC · Thayer, ILBuilt 1971 · S/N 32-7100022N4876SLedford Roland S · Borger, TXBuilt 1971 · S/N 32-7140057N4877SRegistered aircraftBuilt 1970 · S/N 32-7100001N4878SGarmin International Inc · Salem, ORBuilt 1971 · S/N 32-7100002N4879SWilliams Michael J · Mount Laurel, NJBuilt 1970 · S/N 32-7100003N4881SGuerin Brian J · Walnut Creek, CABuilt 1970 · S/N 32-7100005N4883SKipp Thomas H · Chardon, OHBuilt 1970 · S/N 32-7100007N4884SLeto Aviation LLC · Delaware, OHBuilt 1971 · S/N 32-7100008N4885SEm & Rb Aviation Group LLC · Tampa, FLBuilt 1971 · S/N 32-7100009N4886SW & K Enterprise LLC · Lewisville, TXFirst renewal noticeBuilt 1971 · S/N 32-7100010N4887SSlater Michael C · Stillmore, GABuilt 1971 · S/N 32-7100011N4889STiger Wings LLC · Hoover, ALBuilt 1971 · S/N 32-7100013N4892SF&G Polk Aviation LLC · Babson Park, FLBuilt 1971 · S/N 32-7140058N4895SFoster Bryan A · Malabar, FLBuilt 1971 · S/N 32-7100024N48VZPrecision Jet Service Inc · Stuart, FLBuilt 1973 · S/N 32-7300044N4907FVirginia Cherokee LLC · Leesburg, VAS/N 32-7640122N492AGBounds Lee S · Pflugerville, TXS/N 32-40228N493CAMccann James M · Ennis, MTBuilt 1967 · S/N 32-346N4960FLc Aviation LLC · Fort Meade, FLS/N 32-7640123N49SFBcr Aviation LLC · Chantilly, VABuilt 1978 · S/N 32-7940019N5014SGandy Austin T · Channelview, TXS/N 32-7100018N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098N511AGIc Johnson LLC · Belton, SCBuilt 1967 · S/N 32-496N514CMHoward Darrell C · Lafayette, LABuilt 1972 · S/N 32-7240063N518DPN518dp LLC · Spruce Pine, NCBuilt 1966 · S/N 32-765N5201SVancuren Maryann · Owasso, OKBuilt 1970 · S/N 32-40885N5202SWilliams Christopher Lee · Wallingford, KYBuilt 1970 · S/N 32-40886N5205SAgrivation LLC · Indianola, IABuilt 1969 · S/N 32-40894N5207SOhio Air Enterprises LLC · Lancaster, OHBuilt 1969 · S/N 32-40898N520JWHangar 6 LLC · Saint Augustine, FLS/N 32-7940119N5215SFive Generation Flyers LLC · Melbourne, FLBuilt 1970 · S/N 32-40909N5216SSale Reported · Spearfish, SDSale reportedBuilt 1970 · S/N 32-40910N5221S3a LLC · Trussville, ALS/N 32-40915N5229SInk International Inc · Lawrenceville, GABuilt 1970 · S/N 32-40933N523CDOswald Brandon M · Chesapeake, VABuilt 1975 · S/N 32-7500027N5242STanakon Inc · Fairbanks, AKBuilt 1970 · S/N 32-40930N5246SPapa Kilo Aviation LLC · Palm Beach, FLBuilt 1970 · S/N 32-40950N5247FBasha Joseph W Jr · Alexandria, LAS/N 32-7740002N5251SHegarty Joseph L · Sioux Falls, SDBuilt 1970 · S/N 32-40954N5252SFkf LLC · Imperial, NEBuilt 1970 · S/N 32-40934N5258SPace Aviation LLC · The Woodlands, TXBuilt 1970 · S/N 32-40955N5259SSquier Robert J · Royal Oak, MIBuilt 1970 · S/N 32-40939N5262SSalls Robert A · Glen Mills, PABuilt 1971 · S/N 32-7140040N5263TBackroads Aviation LLC · Holdrege, NEBuilt 1972 · S/N 32-7240102N5265SEagle Aeronautics LLC · Chicago, ILBuilt 1971 · S/N 32-7140044N5295THayley Douglas Aviation Inc · Auburn, ALFirst renewal noticeBuilt 1972 · S/N 32-7240104N533TRiser LLC · Wimberley, TXBuilt 1966 · S/N 32721
Back to AD 74-18-13