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.

N77PLVrooman Lawrence M · Winterville, NCBuilt 1957 · S/N 225793N77SLSanders Wiley C Jr · Troy, ALBuilt 1967 · S/N 30-1654N77YACrew Sourcing Inc · Wilmington, DEBuilt 1954 · S/N 23-61N7800DGoff Harold G · Brandon, FLS/N 22-5444N7801DWebb John M · Chugiak, AKBuilt 1957 · S/N 22-5445N7803DFako John · Binghamton, NYS/N 22-5447N7803PNoguess James E · Deming, NMS/N 24-3064N7804DSchneider Kenneth H · Newark Valley, NYBuilt 1957 · S/N 22-5448N7804PFisher B Barton · Bowman, NDBuilt 1962 · S/N 24-3023N7805DMoretti Anthony · Deming, NMBuilt 1957 · S/N 22-5450N7805PN6760s LLC · Brooklyn, NYBuilt 1962 · S/N 24-3073N7805YN7805y LLC · Winchester, VAS/N 30-884N7806DHillegeist Tracy L · Beverly, KSS/N 22-5453N7806PSpires Kenneth G · Seville, OHBuilt 1962 · S/N 24-3025N7806YHhozapnv-LLC · Las Vegas, NVBuilt 1965 · S/N 30-885N7807YMcv2021 LLC · Saint Augustine, FLBuilt 1965 · S/N 30-886N7808YKleiner Daniel S · Aliso Viejo, CABuilt 1965 · S/N 30-887N780ACSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301967N780NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496502N7810DPetro Jerry R · Williamsburg, VABuilt 1957 · S/N 22-5456N7810PCompass Aviation LLC · Lagrange, GABuilt 1962 · S/N 24-3030N7811BThomason David C · Olathe, KSBuilt 1952 · S/N 20-808N7811DGardner Thomas R · Summerville, SCBuilt 1957 · S/N 22-5457N7811PLitz Mark C · Mission Viejo, CABuilt 1962 · S/N 24-3031N7812MAerial Farmer LLC · Missoula, MTS/N 27-3508N7813DBurkhart Galen L · Portland, ORFirst renewal noticeBuilt 1957 · S/N 22-5459N7815YPinhoc Inc · Winter Garden, FLBuilt 1965 · S/N 30-747N7817DRike James O · Kittery Point, MEBuilt 1957 · S/N 22-5463N7817PGoff Mark A · Grand Blanc, MIBuilt 1962 · S/N 24-3037N7818PJohnson Herbert A · Evart, MIBuilt 1962 · S/N 24-3038N7818YCooney Daniel E · Wrightwood, CABuilt 1965 · S/N 30-895N7819YCobabe Ronald Bruce · Boerne, TXBuilt 1965 · S/N 30-896N781LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 4496369N781NDRainier Flight Service LLC · Renton, WABuilt 2016 · S/N 4496395N7820PCowlin Nathan · Hollywood, SCBuilt 1961 · S/N 24-2665N7820YComa Pipe LLC · Wilmington, DEBuilt 1965 · S/N 30-897N7821PTucker Engineering Associates Inc · Locust, NCS/N 24-3040N7822DTwinco Leasing LLC · Yacolt, WABuilt 1957 · S/N 22-5468N7822PTrue Airspeed Aviation LLC · Albany, GABuilt 1962 · S/N 24-3041N7823BBombardo Joseph V · Clermont, FLBuilt 1953 · S/N 20-1048N7823DBurnopp Jacob A · Evington, VABuilt 1957 · S/N 22-5469N7824DWhitaker Samuel M · Brooklet, GABuilt 1957 · S/N 22-5470N7826YInternational Air Services Inc Trustee · Carson City, NVS/N 30-800N7827DThree Legged Hog Aviation LLC · Boise, IDBuilt 1957 · S/N 22-5473N7827PRowan Christopher James · Sparks, NVBuilt 1962 · S/N 24-3047N7827YEpton Richard Charles · Senoia, GABuilt 1965 · S/N 30-902N7828DDyer Royal J · Melrose, NYBuilt 1957 · S/N 22-5474N7828PBvv Aviation LLC · Ben Wheeler, TXBuilt 1962 · S/N 24-3048N7828YVan Laak James E · Poquoson, VAS/N 30-903N7829PSpring Mountain Technologies LLC · Schwenksville, PABuilt 1962 · S/N 24-3049
Back to AD 85-02-05 R1