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.

N1465ALarsen Caesar S · Pleasanton, CABuilt 1951 · S/N 22-372N1469AJohnson Steven C · Cheyenne, WYBuilt 1952 · S/N 22-377N146PWilliams Mike C · Sonora, TXS/N 24-366N1471AJames Norris J · Kannapolis, NCBuilt 1952 · S/N 22-378N1472ASmith Wesley P · Donnelly, IDBuilt 1952 · S/N 22-379N1474ARichard Waldren LLC · Newberg, ORS/N 22-385N1474PMccormick Robert E · Selah, WAS/N 23-541N1478ABehr Casper J · Neavitt, MDBuilt 1952 · S/N 22-392N1479AOlson Phillip Francis · Tenino, WABuilt 1952 · S/N 22-391N147ECAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1963 · S/N 27-2399N1480CJohnson Mark A · Thousand Oaks, CABuilt 1953 · S/N 22-1203N1481AViseur Michael E · Tulsa, OKBuilt 1952 · S/N 22-389N1482CKnutsen Wayne R · Thompson, NDBuilt 1953 · S/N 22-1205N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148N148TTBoard Of Trustees Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496428N1491ASale Reported · Lone Jack, MOSale reportedBuilt 1952 · S/N 20-840N1492AKessler David Keith · Mineral Wells, TXBuilt 1952 · S/N 22-400N14934Csc Delaware Trust Co Owner Trustee · Wilmington, DEBuilt 1966 · S/N 27-3178N1494AHelton Tom H · Santa Ana, CABuilt 1952 · S/N 22-398N1495ARamos Benjamin · Yuma, AZS/N 22-402N1497ASlagle Steven D · Auburn, WABuilt 1952 · S/N 22-417N1498ASpivey Larry B · Milledgeville, GABuilt 1952 · S/N 22-403N149PCSubick Leonard · Spring City, PABuilt 1966 · S/N 27-3534N14FCJwc59 LLC · Newnan, GABuilt 1959 · S/N 24-924N14GSKerner Robert · La Vergne, TNBuilt 1971 · S/N 27-4637N14YPHubbard Scott Edward Jr · Deatsville, ALBuilt 1962 · S/N 24-3246N1501ASchaus Richard M · Schoolcraft, MIBuilt 1951 · S/N 20-685N1502AInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N 20-686N1502PCarey Daniel F · Long Beach, NYBuilt 1954 · S/N 22-2366N1503PRegistered aircraftBuilt 1954 · S/N 22-2367N1504AHise Kevin E · Rock Rapids, IABuilt 1951 · S/N 20-688N1506PStevens John P · Hernando, FLBuilt 1954 · S/N 22-2370N1507PWagner Rickey J · Stacy, MNBuilt 1954 · S/N 22-2372N1508ARegistered aircraftS/N 20-694N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678N150PFParagon Flight Training Co · Fort Myers, FLBuilt 2022 · S/N 4496545N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23N1514AMatthews Byron Kim · Hooper, UTS/N 20-703N1516ALampart Floyd R · Lake Clear, NYBuilt 1957 · S/N 20-706N1516PRichardson Sean W · Delta Junction, AKS/N 22-2381N1517ALong Doug J · Wolf Point, MTBuilt 1951 · S/N 20-707N1520ABush James R · Seattle, WABuilt 1951 · S/N 20-710N1522AAbbe Thomas E · Wasilla, AKBuilt 1951 · S/N 20-711N1526ACrow Robert M · Trapper Creek, AKBuilt 1951 · S/N 20-720N1526PBailey Mark T · Yelm, WAS/N 22-2391N1528PMa Ha Co Aero Corp · Ridgeville, INS/N 22-2393N1533APearson Trevor · San Ysidro, CABuilt 1951 · S/N 20-729N1533PHager John S · Big Island, VAS/N 22-2398N1534ADelta Charlie Aviation LLC · Glendale, AZS/N 20-730N1535AHerve Keith E · North Pole, AKBuilt 1951 · S/N 20-731
Back to AD 85-02-05 R1