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.

N22LJWolgat Alexander M · White Lake, MIBuilt 1971 · S/N LJVS10565N22NKTitcomb Isaac Stephen · Deland, FLBuilt 2017 · S/N 001N22VERegistered aircraftBuilt 2002 · S/N 138N22WTGarcia Roberto P · Spring Hill, FLBuilt 1946 · S/N 18977N22XFMassel Stephen E · Edgewater, FLBuilt 2021 · S/N 6-3611N22XXHeath Michael A · Barnet, VTBuilt 1958 · S/N 36982N22ZCMarker Michael M Jr · Los Lunas, NMBuilt 1981 · S/N 1990N23001Henshaw Edward C · Vian, OKBuilt 1968 · S/N 15068672N23009Hopkins Francis · Wilmington, DEBuilt 1968 · S/N 15068675N2300DEmbry Aero Ltd · Greenville, ILBuilt 1952 · S/N 20452N2300VClay Ernest P · Huntington, WVBuilt 1948 · S/N 14536N23012De La Fuente Carlo H · Lompoc, CAS/N 15068676N23015Schalk Rudolph A · Morgan Hill, CABuilt 1968 · S/N 15068678N23017Kopacz Keith P · Saint Thomas, VIS/N 15068680N23018Andrews University · Berrien Springs, MIBuilt 1968 · S/N 15068681N23025John R Roberts Jr · Homestead, FLBuilt 1968 · S/N 15068686N23027Stapleton Jerry L · Jacksonville, FLBuilt 1968 · S/N 15068687N2302HEnigma Aircraft LLC · Benton Harbor, MIBuilt 1946 · S/N 2927N2302KHartman Alfonse A · Mc Alpin, FLBuilt 1947 · S/N 5029N2302NAnimal Eye Clinic Of Pensacola LLC · Pensacola, FLBuilt 1947 · S/N 12542N2303DDemar Aviation LLC · Spotsylvania, VABuilt 1952 · S/N 20455N2303UMurtha John P · Baldwin, WIBuilt 1963 · S/N 17249903N23046Thomas Jaclyn L · Carrollton, OHBuilt 1968 · S/N 15068697N2304EHeitz John · Manvel, TXBuilt 1946 · S/N 7AC-5878N23051Gradle Roger Thomas · Fairhope, ALS/N 15068700N23056Veltman Ine · Mayodan, NCBuilt 1968 · S/N 15068703N23059Smoketown 150 Club LLC · New Holland, PABuilt 1968 · S/N 15068705N2305BDoyal William T · Visalia, CAS/N 3605N2305DKupchak Bruce · Bridgeville, DES/N 20457N2305KScimone Michael J · Wildwood, MOS/N 5032N2305VN2305v LLC · Grand Haven, MIBuilt 1948 · S/N 14541N23064Cherry Creek School District No #5 · Greenwood Village, COBuilt 1968 · S/N 15068707N23068Pike Mark D · Victorville, CABuilt 1968 · S/N 15068709N2306BBandrowicz Leon A · Lindenhurst, NYBuilt 1948 · S/N 3606N2306KSchlosser Joseph V · Rockford, MNBuilt 1947 · S/N 5033N23070Building Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1968 · S/N 15068711N23076Alvarado Victor A · Douglas, AZBuilt 1968 · S/N 15068714N2307BMoyer Alan L · Perkasie, PABuilt 1948 · S/N 3607N2307DSunderland Paul · Savannah, GAS/N 20459N2307EAbel Brandon R · Henderson, NVBuilt 1946 · S/N 7AC-5882N2307KStory Jeffrey A · Colorado Springs, COBuilt 1947 · S/N 5034N2307UCowgar Jeremy N · Norton, OHBuilt 1962 · S/N 17249907N2307VKarel Benjamin R · Stillwater, MNBuilt 1948 · S/N 14543N23083Gilstrap Stanley C · Inola, OKBuilt 1968 · S/N 15068717N23085Flightwave 77 LLC · Dearborn Heights, MIBuilt 1968 · S/N 15068719N2308UMarsh Hank K · Joseph, UTBuilt 1956 · S/N 29528N2308VInverted Aero LLC · Spring Hill, FLBuilt 1948 · S/N 14544N23096Pilot Pros Inc · Miami, FLBuilt 1968 · S/N 15068722N23098Saddler Darrell L · Elk City, OKS/N 15068723N2309VDahlke Philip H · Smyrna, GABuilt 1948 · S/N 14545
Back to AD 94-05-05 R1