OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,231

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-05-05-R1')
    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-05-05-R1')
  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.

N3861TQuast Felix J · Delano, MNBuilt 1978 · S/N F-118N3861VVan Zant Mark · Zionsville, INBuilt 1949 · S/N 18748N3862JDoyle Ethan Mackenzie · Nunda, NYBuilt 1966 · S/N 15065162N3862LSainsbury James L · Milton, WIBuilt 1965 · S/N 17254031N386331941 Historical Aircraft Group Museum DBA · Geneseo, NYS/N 5-1016N3863KMclean Robert M Jr · Darlington, MDS/N 3563N3863ROkeefe Dennis G · Cincinnati, OHBuilt 1966 · S/N 17255363N3863SRegistration Pending · Walker, MNRegistration pending, pending cancellationBuilt 1963 · S/N 17251063N38640Mccutchan Anthony L · Collinsville, OKBuilt 1941 · S/N 5-1025N38645Wright Cecil A · Sanford, FLS/N 5-1030N3864KAndersen Allen E · Sandy Valley, NVBuilt 1948 · S/N 3564N3864LDelvalle Dean · Schertz, TXBuilt 1965 · S/N 17254033N3864RR Thimesch Construction LLC · Spivey, KSS/N 17255364N3865JAlbert Bruce F · Dallas, TXBuilt 1966 · S/N 15065165N3865LRibeiro Marcos Felix · Okeechobee, FLS/N 17254034N3865SIndy Air Sales LLC · Anderson, INBuilt 1963 · S/N 17251065N38660Southern Ohio Tractor LLC · Hillsboro, OHBuilt 1941 · S/N 5-1049N3866KAircraft Partner Holdings Inc Trustee · BerlinBuilt 1948 · S/N 3566N3866LLamb Daniel A · Cheyenne, WYBuilt 1966 · S/N 17254035N3866SKnutson Steven O · Wickenburg, AZBuilt 1963 · S/N 17251066N3867JOmura Alexander K · Missoula, MTBuilt 1966 · S/N 15065167N3867LDorsey Levi Rondall · Demorest, GABuilt 1965 · S/N 17254036N3867RHowser Timmy L · Batavia, OHBuilt 1966 · S/N 17255367N3867SMakee Markus J · Painesville, OHBuilt 1964 · S/N 17251067N3867VMurat Armand · Granger, INBuilt 1949 · S/N 18754N38687Geiger William G · Park City, UTBuilt 1948 · S/N 7195N38691Dye Benjamin L · Union Springs, NYBuilt 1946 · S/N 7AC-2369N3869RErl Don L · Medford, WIBuilt 1966 · S/N 17255369N386WCCoyle Whitney J · Edgewater, FLBuilt 2016 · S/N 001N3870HGuenther Mary J · Port Charlotte, FLBuilt 1947 · S/N 4571N3870JLucido Frank · Vacaville, CABuilt 1966 · S/N 15065170N3870KUlmer Bryce D · Locust Grove, GAS/N 3570N3870LStraub Brian L · Queensbury, NYBuilt 1965 · S/N 17254039N3870SCherryhill Aviation Inc · Freetown, INBuilt 1963 · S/N 17251070N3872LMaletich Steven J · Las Vegas, NVBuilt 1965 · S/N 17254041N3872RS&Sa Aviation LLC · Colby, KSBuilt 1966 · S/N 17255372N3872SNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17251072N38734Ringer Daniel L · Bremen, INBuilt 1941 · S/N 7204N3873RFoster William G Jr · Sunnyvale, CABuilt 1966 · S/N 17255373N3874EMelton James A · Conway, ARBuilt 1946 · S/N 7AC-7101N3874RMartig Glenn A · Lino Lakes, MNBuilt 1966 · S/N 17255374N38754Borer Dylan Gray · Virginia Beach, VABuilt 1946 · S/N 7231N38757Beinhauer Richard G · Naperville, ILS/N 7234N3875KLemke Brian · Joliet, ILBuilt 1948 · S/N 3575N3875LBazemore Robert J · Butler, GAS/N 17254044N3875SFlying M Enterprises · Loomis, NEBuilt 1963 · S/N 17251075N3875VBlaedow Kyle R · North Pole, AKBuilt 1975 · S/N 15076643N3876KWilson Stephen A · Granbury, TXBuilt 1948 · S/N 3576N3876LWoerle Edward R · Rossville, TNS/N 17254045N3876RTriple Farms DBA · Sikeston, MOBuilt 1966 · S/N 17255376
Back to AD 94-05-05 R1