OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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:94-20-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  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.

N5618KLundin Michael D · Magnolia, DEBuilt 1964 · S/N D-7379N5619KGood Natured Creations LLC · Tucson, AZS/N D-7380N561TSierra Alpha Air LLC · Piqua, OHBuilt 1961 · S/N D-6731N5624KWilson Robert J Jr · Gaithersburg, MDBuilt 1964 · S/N D-7382N5624SKin-Air Inc · Hendersonville, TNFirst renewal noticeBuilt 1966 · S/N D-8168N5625KChung Thomas · Stanwood, WABuilt 1964 · S/N D-7385N562ELMirman Charles B · Pinehurst, NCBuilt 1970 · S/N D-9174N5633SQualitair LLC · MichelstadtBuilt 1966 · S/N D-8330N5635GFlyair Flight Academy LLC · Flint, TXBuilt 1956 · S/N D-4666N5635SRhodes Stephen · Hayti, MOBuilt 1966 · S/N D-8174N5637SSzarek Carson · San Diego, CABuilt 1966 · S/N D-8160N563DBPavel John F Jr · Seattle, WABuilt 1967 · S/N D-8510N5640KHowe Eric · Fishers, INBuilt 1964 · S/N D-7397N5641STitan Realty Inc · San Diego, CABuilt 1966 · S/N D-8182N5642DMaag Dallas · Nampa, IDBuilt 1957 · S/N D-5222N5646KSst Solutions LLC · New River, AZBuilt 1964 · S/N D-7309N5648KDale James B · Skaneateles, NYBuilt 1964 · S/N D-7585N5649KRyan Good Aviation LLC · Sioux Falls, SDS/N D-7401N564TOgle Jason S · Norris, TNBuilt 1961 · S/N D-6744N5651KStubblefield Daniel · Chino Hills, CABuilt 1964 · S/N D-7402N5657KWatson Robin G · Eastsound, WABuilt 1964 · S/N D-7593N5661KShockey David Allen · Deland, FLBuilt 1964 · S/N D-7592N5662KGiddings Melvin J Jr · Vacaville, CABuilt 1964 · S/N D-7588N5668KMonroe Shannon · Bellevue, WABuilt 1964 · S/N D-7601N5669KYankee Airmen Inc · Torrance, CABuilt 1964 · S/N D-7656N5676KDevlin Jeff M · Seattle, WABuilt 1964 · S/N D-7602N567RSSpitler Robin C · Statesboro, GABuilt 1967 · S/N D-8575N567UPDodson Robert B · Harvard, ILBuilt 1957 · S/N D-5010N5689DKelly G L · Blacksburg, VAS/N D-6482N5691KRegistration Pending · Shady Shores, TXRegistration pendingBuilt 1964 · S/N D-7619N5692KBeyer Greg R · Buffalo, MNBuilt 1964 · S/N D-7621N5693KTateshima Satoshi · Los Angeles, CABuilt 1964 · S/N D-7625N5696KLokey Kenneth R · Austin, TXBuilt 1964 · S/N D-7628N5697KMerimont Aviation LLC · Dyersburg, TNBuilt 1964 · S/N D-7620N5698KSmith Ronald E · Jefferson, TXBuilt 1964 · S/N D-7622N5699KMoore Joseph M · Santa Barbara, CABuilt 1964 · S/N D-7603N56EEStansfield Tod A · Elm Grove, WIBuilt 1961 · S/N D-6703N56JLSea Air Inc · Wilmington, DEBuilt 1977 · S/N D-10094N56VTColvin Clu DBA · Big Cabin, OKBuilt 1956 · S/N D-4506N56WHSteamboat Ridge LLC · Kaiser, MOBuilt 1967 · S/N D-8395N5703KBean Billy R · Nashville, ARBuilt 1964 · S/N D-7511N5704VRon Eldridge Properties LLC · Nicholasville, KYBuilt 1966 · S/N D-8082N5706VMullin Sheryl M · Monroe, GABuilt 1966 · S/N D-8093N5707KCoeur Jeffrey James · Gulf Shores, ALBuilt 1964 · S/N D-7505N570TWilcox Robbie Craig · Smithville, MOBuilt 1961 · S/N D-6747N5710VOdell Stephen H · Thousand Oaks, CABuilt 1966 · S/N D-8087N5713KJennings James H · Clovis, NMBuilt 1964 · S/N D-7513N5715KChase Brandon C · Plains, KSBuilt 1964 · S/N D-7510N5719KJohns Ricky · Joliet, ILBuilt 1964 · S/N D-7517N5719VFox Will E · Los Alamos, NMBuilt 1966 · S/N D-8092
Back to AD 94-20-04 R2