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.

N5204ZGodbey Patrick E T · St Simons Island, GABuilt 1961 · S/N 22-8874N5205PCope N H · Lamesa, TXBuilt 1958 · S/N 24-228N5206PHyde Roy Wiliam · Sacramento, CABuilt 1958 · S/N 24-229N5206YHart Lewis W DBA · Rexburg, IDBuilt 1962 · S/N 27-2254N5206ZFord Dustin D · Clear Brook, VABuilt 1961 · S/N 22-8876N5207PRisi John D · Erie, COS/N 24-231N5208PDale Snooks One On One Inc · Mancelona, MIBuilt 1958 · S/N 24-232N5208ZArnold Tyler S · Montgomery, LAS/N 22-8878N520AZSaydun LLC · Richardson, TXBuilt 1966 · S/N 27-3424N520MSH2 Link Co · Chino, CABuilt 2006 · S/N 4496230N5211PCedar Mark P · Cherokee, IABuilt 1958 · S/N 24-236N5212ZYetter Mark A · Georgetown, PABuilt 1961 · S/N 22-8884N5213YFlying High Again LLC · Mount Juliet, TNBuilt 1962 · S/N 27-2261N5216YGv Air Inc · Medford, ORBuilt 1962 · S/N 27-2264N5217PLevezow Steven M · Manawa, WIBuilt 1958 · S/N 24-244N5219ZGarrett Joe · Saint Jacob, ILBuilt 1961 · S/N 22-8894N521EEMhg Leasing LLC · Edgewood, KYBuilt 1979 · S/N 27-7954067N521MWGruetzmacher Marcus Collin · Denton, TXFirst renewal noticeBuilt 1960 · S/N 24-1978N5220PStancil Thomas E III · Winterville, NCBuilt 1958 · S/N 24-247N5220YHart Robert D · The Villages, FLBuilt 1962 · S/N 27-2269N5222PGharazeddine Raja N · Kaplan, LABuilt 1958 · S/N 24-249N5222ZSaltzman John D · Gilbert, AZBuilt 1961 · S/N 22-8897N5225ZLamon Bruce G · Castle Rock, WABuilt 1961 · S/N 22-8901N5226PGoodin Jacob P · Knob Noster, MOBuilt 1958 · S/N 24-256N5226YSale Reported · Miami, FLSale reportedBuilt 1963 · S/N 27-2275N5226ZHale Michael E · Grass Valley, CABuilt 1961 · S/N 22-8902N5227PBranch Antonio D · Lakewood, OHBuilt 1958 · S/N 24-257N5227ZPayne Robert A · Duluth, MNBuilt 1961 · S/N 22-8903N5228PFtf Group LLC · Galt, CABuilt 1958 · S/N 24-258N522CAC-140 Company LLC · Milton, FLBuilt 1971 · S/N 27-4711N522CBVancil Jon D · Collierville, TNBuilt 1960 · S/N 24-1939N522DNLinett Michael J · Elsmere, DEBuilt 1959 · S/N 226587N522ESkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 27-2495N522TJMathis Michael W · Miller, MOBuilt 1959 · S/N 24-1130N522WRegistration Pending · Valparaiso, INRegistration pendingBuilt 1958 · S/N 24377N5230PMeyer Richard S · El Paso, TXBuilt 1958 · S/N 24-260N5231ZKawasaki Clyde H · Carson City, NVS/N 22-8908N5232ZGilmore Thomas E · Mesa, AZBuilt 1961 · S/N 22-8910N5234PLevay Brad A · Mohave Valley, AZS/N 24-264N5236PCheyne Dewolfe · Cave Creek, AZS/N 24-266N5236YSvh Flying Operations LLC · Mooresville, NCBuilt 1963 · S/N 27-2289N5236ZPlank Larry B · Perkins, OKBuilt 1961 · S/N 22-8916N5238ZMayer David J · Ingleside, ILS/N 22-8918N5239PWall Robert D · Ocala, FLBuilt 1958 · S/N 24-270N5239ZMellor Brad A · Spanish Fork, UTBuilt 1961 · S/N 22-8919N5240PWeber Rodney D · Apple Valley, CABuilt 1958 · S/N 24-271N5240ZReise Robert A · Meredith, NHBuilt 1961 · S/N 22-8920N5242PPennacchio Leo Trustee · Santa Rosa, CABuilt 1958 · S/N 24-273N5242ZLund Thomas S · Boulder, COBuilt 1961 · S/N 22-8924N5243PR & O Aviation LLC · Middleville, MIBuilt 1958 · S/N 24-274
Back to AD 85-02-05 R1