OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-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:85-02-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.

N515VVGolden Age N515vv LLC · Norwalk, IABuilt 2025 · S/N 4496620N5160ZWend Roger W · Charlotte, MIBuilt 1961 · S/N 22-8814N5161PN5161p LLC · Upland, CABuilt 1958 · S/N 24-177N5162PHorton Melody A · Diamondhead, MSBuilt 1958 · S/N 24-178N5163PReynolds David A · Blacksburg, VAS/N 24-179N5164PUpton John B · Lakeland, FLBuilt 1958 · S/N 24-180N5164ZEast Texas Aircraft Engines LLC · Palestine, TXS/N 22-8819N5166ZTuttle Anthony G · Walnut Cove, NCBuilt 1961 · S/N 22-8824N5167PSoutheast Airways LLC · Gainesville, GABuilt 1958 · S/N 24-184N5167ZRamsdell Edmun · Modesto, CABuilt 1961 · S/N 22-8825N5168ZBrown Noah M · Tyler, TXS/N 22-8826N5169PStockdale Alexander Ian · Los Banos, CAS/N 24-187N5169ZManning David G · Greenville, NCBuilt 1961 · S/N 22-8829N516NSCavorite Aviation LLC · Lehi, UTS/N 447995098N5170PBosch Christopher J · Bloomington, MNBuilt 1958 · S/N 24-188N5172ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8836N5173PColorado Aviation Group LLC · Colorado Springs, COS/N 24-192N5173ZSvenningse Joshua J · Menomonie, WIBuilt 1961 · S/N 22-8837N5174ZSale Reported · Spearfish, SDSale reportedBuilt 1961 · S/N 22-8838N5178ZUnderwood Robert D Jr · Randolph, NYBuilt 1961 · S/N 22-8842N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199N517EASchafer Erich S · Fremont, MIBuilt 1975 · S/N 27-7554125N5180PN5180p LLC · Willow Springs, MOBuilt 1958 · S/N 24-201N5180ZScheer Paul G · Portland, ORBuilt 1961 · S/N 22-8846N5181PFritz Joseph L · Eufaula, OKBuilt 1958 · S/N 24-202N5182PThede Dondi I · Marshall, WIBuilt 1958 · S/N 24-203N5184ZCox Ronnie · Whitesburg, GABuilt 1961 · S/N 22-8851N5185ZTroy Michael J · Albion, NYS/N 22-8852N5186ZBearer Ronald C · Wimauma, FLBuilt 1961 · S/N 22-8853N5187ZCottrell Mark C · Leitchfield, KYS/N 22-8854N5188YElliott William R · Reno, NVBuilt 1962 · S/N 27-2235N5189ZNorthwest Florida State College · Niceville, FLBuilt 1961 · S/N 22-8856N518CMTreakle Robert W · Austin, TXFirst renewal noticeBuilt 1967 · S/N 30-1594N5191ZFlickinger Charles P · Hermitage, PABuilt 1961 · S/N 22-8859N5193ZSchlosser Joseph V · Rockford, MNBuilt 1961 · S/N 22-8862N5194PBighorn Bifrost LLC · Sheridan, WYS/N 24-218N5194ZTinsman Anthony L · Hartford, ARBuilt 1961 · S/N 22-8863N5195PWilliamsen Wesley · Benedict, NEBuilt 1958 · S/N 24-219N5197ZPalmer Ralph Jr · Howard City, MIS/N 22-8867N5199ZLeister Tyler W · Norfolk, VABuilt 1961 · S/N 22-8869N51BGProctor Stephen Patrick · White Lake, MIS/N 24-3017N51DSCulbertson William T · Helena, MTBuilt 1959 · S/N 24-1201N51GCCragg Gordon E · Georgetown, TXBuilt 1966 · S/N 27-3516N51HPJ R'S Downwind Aviation Inc · Lantana, FLBuilt 1974 · S/N 27-7405412N51JNNaylor Aviation LLC · Scotch Grove, IABuilt 1978 · S/N 27-7854128N51TRRomero Anthony A · Tucson, AZS/N 20-681N51VBPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496616N5201ZNunn Adam L · Abilene, TXBuilt 1961 · S/N 22-8871N5203PFischer Steven A Trustee · Cary, ILBuilt 1958 · S/N 24-226N5203ZWeigel Gary R · Valley City, OHBuilt 1961 · S/N 22-8873
Back to AD 85-02-05 R1