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.

N5763ZCarlton Marvin R · Tomahawk, WIBuilt 1963 · S/N 22-9605N5764ZModra Anthony K · Fredonia, WIS/N 22-9606N5765PWomack Calvin E · Lakeside, TXBuilt 1959 · S/N 24-843N5766PMid Pacific Aero Services LLC · Honolulu, HIS/N 24-844N5767PMcdowra Christopher L · Paris, TXS/N 24-845N5768PBrooks David Paul · Mantorville, MNBuilt 1959 · S/N 24-846N5769ZFox John F Jr · Mc Cormick, SCS/N 22-9611N57716Fishers Flyings Pipers LLC · Broken Bow, NES/N 36-7660038N5771PWhisky Zulu Inc · Klamath Falls, ORBuilt 1959 · S/N 24-849N5771ZDavenport Brad E · Eagle River, AKBuilt 1963 · S/N 22-9613N57721Goltz Aviation LLC · Pembina, NDBuilt 1975 · S/N 36-7660044N57725Bretts Spray Service Inc · Onida, SDBuilt 1975 · S/N 36-7660047N5772PKasakoff Lloyd Abraham · Houston, TXBuilt 1959 · S/N 24-850N57738Quality Aviation Inc · Marana, AZBuilt 1975 · S/N 36-7660054N5773YMccabe Aero LLC · Grand Haven, MIBuilt 1965 · S/N 27-2902N57746Aircraft Montana LLC · Helena, MTBuilt 1976 · S/N 36-7660059N57749Registered aircraftSale reportedBuilt 1976 · S/N 36-7660065N5774ZLiming Danny O · Andrews, TXS/N 22-9610N57751Wood Flying Inc · Panhandle, TXBuilt 1976 · S/N 36-7660058N57758Aero Spraying Service Inc · Williston, NDS/N 36-7660072N5775PChelf James Michael · Cedar Park, TXBuilt 1959 · S/N 24-853N57772Deterding Jim · Pond Creek, OKBuilt 1976 · S/N 36-7660079N57775Snyder Spraying Serv Inc · Snyder, OKBuilt 1976 · S/N 36-7660089N57784Whitlock Holdings LLC · Honey Grove, TXBuilt 1976 · S/N 36-7660095N5778PHunton Hugh R II · Midlothian, TXBuilt 1959 · S/N 24-857N5778ZWhelan Cynthia Vs · Seneca, SCBuilt 1963 · S/N 22-9623N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858N5779ZSvec Adolph R · Marengo, ILBuilt 1963 · S/N 22-9624N577DPLustfeldt Gordon L · Normal, ILBuilt 1959 · S/N 24-848N5780PWall Scott · Franksville, WIBuilt 1959 · S/N 24-859N5780ZBergstrom Robert L · Amelia Court House, VABuilt 1963 · S/N 22-9625N57816North Texas Dusters & Sprayers Inc · Gainesville, TXS/N 36-7660122N57824West Central Ag-Air Inc · Fergus Falls, MNBuilt 1976 · S/N 36-7660132N5782PPaviation LLC · Lewes, DEBuilt 1959 · S/N 24-861N57830Mid Continent Aircraft Corp · Hayti, MOBuilt 1977 · S/N 36-7760003N57832Sherer Robert O · Hayes, SDBuilt 1977 · S/N 36-7760005N57834Aircraft Montana LLC · Helena, MTS/N 36-7760006N5783ZAlix Brian R · Valley Falls, NYBuilt 1963 · S/N 22-9627N57846Boardman Air Services LLC · Henderson, NEBuilt 1977 · S/N 36-7760017N5784PMiller Jeffery Allen · Menifee, CAS/N 24-863N57859Airmotive Service LLC · Brigham City, UTBuilt 1977 · S/N 36-7760029N5785PSmith Clyde R Jr · Lock Haven, PABuilt 1959 · S/N 24-864N5786PMckowan Sheila R · Chatsworth, CAS/N 24-865N5787YMarr Steven K · Saint Charles, MOBuilt 1965 · S/N 27-2917N5787ZFaust David E · Windber, PAS/N 22-9631N5788Knot Speed Ltd · Wilmington, DEBuilt 1966 · S/N 24-4580N57882Dakota Air Spray LLC · Huron, SDBuilt 1977 · S/N 36-7760044N57886Bernstein Timothy D · Faith, SDBuilt 1977 · S/N 36-7760048N5789DTripacer Bretheren LLC · Longview, WABuilt 1956 · S/N 22-4465N5789PNiche Pharmaceuticals LLC · Shorewood, MNBuilt 1959 · S/N 24-868
Back to AD 85-02-05 R1