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.

N7713KNottorf Eric W · Keller, TXBuilt 1950 · S/N 20-535N7713PFoster Mica J · Derby, KSBuilt 1961 · S/N 24-2926N7713YDarragh Jeff · Fort Myers, FLBuilt 1965 · S/N 30-802N7714DZapata James A · Fallbrook, CABuilt 1957 · S/N 22-5388N7714ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1966 · S/N 25-3877N7715DIriarte Christopher P · Grosse Ile, MIBuilt 1957 · S/N 22-5389N7715ZMiller Aviation Inc · Norton, KSBuilt 1966 · S/N 25-3878N7716PWhite Donald R · La Ward, TXFirst renewal noticeBuilt 1962 · S/N 24-2929N7716ZBig Aerial Sign Service LLC · Delano, MNBuilt 1966 · S/N 25-3881N7717VCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496120N7718AScud Air 18a LLC · Morgan, UTBuilt 1975 · S/N 27-7554040N7718PVan Develde Robert K · Troy, MIBuilt 1961 · S/N 24-2931N7719KHillegeist Tracy L · Beverly, KSBuilt 1950 · S/N 20-541N7719PSchidlowsky Michael · Otis, MABuilt 1961 · S/N 24-2932N7719XBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4496130N7720DBarnhill Jerry D · Longville, LABuilt 1957 · S/N 22-5394N7720YEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 4496132N7720ZAnderson Joel M · Starkweather, NDBuilt 1966 · S/N 25-3886N7721DRenick Tyler C · Wichita Falls, TXBuilt 1957 · S/N 22-5395N7722ZCentral California Soaring Association Inc · Avenal, CABuilt 1966 · S/N 25-3889N7723DLutz Roald F · Sandia Park, NMBuilt 1957 · S/N 22-5397N7725KKansas State University Salina · Salina, KSBuilt 1950 · S/N 20-547N7725PTully Martin · Idalou, TXBuilt 1961 · S/N 24-2939N7726DClaypool Bruce W · Bethel, AKBuilt 1957 · S/N 22-5402N7726KMcdonald Walter S · Park City, UTFirst renewal noticeBuilt 1950 · S/N 20-548N7727PTaylor Aviation LLC · Corning, ARBuilt 1961 · S/N 24-2941N7728KPolkowske Leroy A · La Jara, COS/N 20-550N7728YArr Enterprises Inc · Yorkville, ILBuilt 1965 · S/N 30-817N7729PPendergast Gary · Clermont, FLBuilt 1961 · S/N 24-2943N7729YFogle Neil · Conroe, TXBuilt 1965 · S/N 30-818N7730PCox Paul G · Bryce, UTBuilt 1962 · S/N 24-3107N7730ZRubbert Jan · Upham, NDBuilt 1966 · S/N 25-3904N7731PSchwehm Karl E · Roach, MOS/N 24-2945N7732KReeves Figueroa Marion Richard · Newmarket, NHBuilt 1950 · S/N 20-555N7732PMckenney Michael P · Spring, TXBuilt 1961 · S/N 24-2946N7732YPurcell David S · Chandler, AZBuilt 1965 · S/N 30-821N7733PKeller Kevin M · Sylvania, OHBuilt 1961 · S/N 24-2947N7734DPurcell Michael F · Ashfield, MABuilt 1957 · S/N 22-5411N7734YRussell R Bruce · Clayton, GABuilt 1965 · S/N 30-824N7735DSmith Aviation LLC · Springer, OKS/N 22-5412N7735PVickers Tim F · Huntingdon, TNBuilt 1961 · S/N 24-2949N7735ZRonald W Gray DBA · Hooker, OKBuilt 1966 · S/N 25-3911N7736PJmj Aviation LLC · Kalispell, MTS/N 24-2950N7737DRinker Kraig G · Winlock, WABuilt 1957 · S/N 22-5414N7737PFlying Ankers LLC · Saint Marys, OHS/N 24-2951N7738KGallagher William James · Chalfont, PAS/N 20-561N7738YAristizabal Leonardo · Van Nuys, CABuilt 1965 · S/N 30-828N7739DSchelnick Charles M · Fredericksburg, TXBuilt 1957 · S/N 22-5416N7739PBloom James R · Port Matilda, PABuilt 1961 · S/N 24-2953N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144
Back to AD 85-02-05 R1