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.

N7159BHightower Michael L · Eureka, MTS/N 22-4384N7159PAdams George D · Franklin, INFirst renewal noticeBuilt 1960 · S/N 24-2325N7159YPepmiller Scott C · Panama City Beach, FLS/N 30-177N715JYAirspace Aviation LLC · Valleyford, WABuilt 1951 · S/N 20-595N7161KFleehearty Aaron T · Mooresville, INBuilt 1951 · S/N 20-682N7161PMaurer Bruce C · Power, MTBuilt 1960 · S/N 24-2327N7163YBoyd John W · Milton, WABuilt 1963 · S/N 30-184N7164YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-185N7166YCollum Aviation LLC · Milton, FLBuilt 1963 · S/N 30-187N7167YThomas Thomas J · Lewisburg, WVBuilt 1963 · S/N 30-188N7168PSchober Brian S · Scottsdale, AZBuilt 1960 · S/N 24-2336N7170PDalton Dennis P · Walsenburg, COBuilt 1960 · S/N 24-2338N7171YHeinrich Steven W · Conroe, TXBuilt 1963 · S/N 30-191N7172PBarksdale Kevin L · Moore, OKBuilt 1960 · S/N 24-2340N7173ZAir Kraft Spraying Inc · Timber Lake, SDBuilt 1964 · S/N 25-3041N7175KTaildragger Aero LLC · Saint John, WABuilt 1951 · S/N 20-677N7175PNewton Roger N Jr · Marerro, LABuilt 1960 · S/N 24-2344N7177POverstreet Robert S · Clarksville, VABuilt 1964 · S/N 24-3635N7178PN9271p LLC · Pahrump, NVBuilt 1960 · S/N 24-2347N7179PHedgpeth H Brent · Bothell, WABuilt 1960 · S/N 24-2348N717AUPiper Aircraft Inc · Vero Beach, FLS/N 4496655N717TATwin C Aviation Inc · Chapel Hill, NCBuilt 1966 · S/N 30-1030N717WSCutting Edge Sales LLC · Santa Fe, NMBuilt 1961 · S/N 27-415N7180P352 Aviation LLC · Clermont, FLBuilt 1960 · S/N 24-2349N7180YAl-Banna Emad R · Huntingtown, MDBuilt 1963 · S/N 30-200N7181PStrydom Cornelis F · Liberal, KSS/N 24-2350N7181YEagle Aeronautics LLC · Chicago, ILS/N 27-8054021N7182YMccue John M · Tuttle, OKS/N 30-206N7183KRabourn John P · Spokane, WABuilt 1963 · S/N 30-207N7184PWilson Brian E · Lecanto, FLBuilt 1960 · S/N 24-2354N7185PMack Darryl T · Matteson, ILBuilt 1960 · S/N 24-2355N7186YHill Mark T · Gloucester, VAS/N 30-210N7187YAircore LLC · Apache Junction, AZBuilt 1963 · S/N 30-211N7188PBackcourse Flyers Inc · Powell, TNS/N 24-2358N7188YRegistration Pending · Christiansted, VIRegistration pendingBuilt 1963 · S/N 30-212N7189PTofan Ray · National City, CABuilt 1960 · S/N 24-2359N7189YHesano Joseph M · Rockford, ILBuilt 1963 · S/N 30-213N718JRFlytwincos LLC · Las Vegas, NVBuilt 1964 · S/N 30-276N718MWescon Margin Inc · Wilmington, DEBuilt 1979 · S/N 27-8054011N7190BKing Tyler Brooks · Saint Stephen, SCBuilt 1956 · S/N 22-4385N7190YMiller Kevin · Collegedale, TNBuilt 1963 · S/N 30-214N7191PRamineni Raja · Fort Mill, SCBuilt 1961 · S/N 24-2361N7191ZDunn Blake C · Bristol, COBuilt 1964 · S/N 25-3076N7192PBest Equipment Leasing LLC · Bakersfield, CABuilt 1960 · S/N 24-2362N7192ZAce Aeromotive Inc · Miami, FLS/N 25-3079N7193PSzczawinski Anthony J · Elko, NVFirst renewal noticeBuilt 1960 · S/N 24-2363N7194BBooker Louis E Jr · Pinetop, AZBuilt 1956 · S/N 22-4390N7196YAircraft & Aviation Professionals LLC · Coldwater, MIS/N 30-220N7198ZPiedmont Soaring Society · Clemmons, NCBuilt 1964 · S/N 25-3095N7199PLee Jeffrey L · Cameron, MTBuilt 1961 · S/N 24-2370
Back to AD 85-02-05 R1