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.

N5391PWilliams Keith A · Pahrump, NVS/N 24-442N5391YHeartland Aviation Inc · Alliance, NEBuilt 1963 · S/N 27-2467N5392ZSteed Brian · Winnsboro, SCBuilt 1961 · S/N 22-9162N5394PHanneman Michael W · Abilene, TXBuilt 1958 · S/N 24-445N5396ZCollins Dennis L · Richland, WABuilt 1961 · S/N 22-9166N5397PGregg George H · Vandergrift, PABuilt 1958 · S/N 24-448N5397ZSchutze Richard P · Ojai, CABuilt 1961 · S/N 22-9167N5398PB2w Corp · Winona, MNBuilt 1958 · S/N 24-449N53ABuller Gregory M · Germantown, TNBuilt 1953 · S/N 20-926N53ACPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654146N53PAFrench Edward L · Soldotna, AKBuilt 1953 · S/N 22-1621N54000Entropic Synergies LLC · Visalia, CAS/N 25-7405573N54004Sobey Peter L · Aurora, OHBuilt 1974 · S/N 27-7405354N5403PSwartwood Scott S · Colorado City, COBuilt 1958 · S/N 24-457N5404PClough Robert A · Grass Lake, MIBuilt 1958 · S/N 24-458N5405PJohnson Sidney · Madison, MNBuilt 1958 · S/N 24-459N5406PDerksen Ronald E · Xenia, ILBuilt 1958 · S/N 24-460N5406YKillam Rodney A · Carlinville, ILBuilt 1963 · S/N 27-2481N5406ZRains Kenneth W Jr · Lebanon, TNFirst renewal noticeBuilt 1961 · S/N 22-9178N54072Dewitt Gary D · Encinitas, CABuilt 1974 · S/N 27-7405382N54075Pilot Pros Inc · Miami, FLBuilt 1974 · S/N 27-7405385N54077Geo Mar Co Aviation Ltd · Clyde, OHBuilt 1974 · S/N 27-7405389N54089Island Birds Inc · St Thomas, VIBuilt 1974 · S/N 27-7405390N5408PZero Eight Papa LLC · Dublin, OHBuilt 1958 · S/N 24-462N54092Harper-Smith Michael · Tarzana, CABuilt 1974 · S/N 27-7405405N54097Piper Nia 1 LLC · Doylestown, PABuilt 1974 · S/N 27-7405408N5409PReinaudi Gael · New York, NYBuilt 1958 · S/N 24-463N54109Gilmores Glorious Goods LLC · Lewes, DEBuilt 1974 · S/N 27-7405421N5410ZHillhorst Kenneth E · Rocky Mount, NCBuilt 1961 · S/N 22-9183N5411PLarson Andrea S · Wasilla, AKBuilt 1958 · S/N 24-465N5413ZBehr Casper J · Neavitt, MDBuilt 1961 · S/N 22-9186N5414ZNess Jon D · Lakeville, MNBuilt 1961 · S/N 22-9187N54155Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7405452N5417PMoran Patrick D · Pleasanton, CABuilt 1958 · S/N 24-471N5417ZLack James A · Homer, AKBuilt 1961 · S/N 22-9190N5418ZWare Joseph B · Angleton, TXBuilt 1961 · S/N 22-9191N54195Decruz Peter John · Hattiesburg, MSBuilt 1974 · S/N 27-7405472N54198Valiair Lc Trustee · Casper, WYS/N 27-7405474N5419PTrease Marvin R · Elwood, NEBuilt 1958 · S/N 24-473N5420ZAthey Jeff R · Friendswood, TXBuilt 1961 · S/N 22-9193N54221Emission-Air Inc · Lexington, NCBuilt 1974 · S/N 27-7554014N54224Coosa Air LLC · Rome, GABuilt 1974 · S/N 27-7554017N54225Jpr Capital LLC · San Juan, PRBuilt 1974 · S/N 27-7554018N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032N5423PPapp Frank J · Fort Mohave, AZBuilt 1959 · S/N 24-477N5423ZBergstrom Lindsay B · Plymouth, MNS/N 22-9197N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039N5424PHerreid William L Jr · Prairie Du Chien, WIBuilt 1958 · S/N 24-478
Back to AD 85-02-05 R1