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.

N8198YRoss Brian L · Eagle River, WIBuilt 1966 · S/N 30-1317N8199CKiokun Edward I · Mekoryuk, AKBuilt 1954 · S/N 22-2304N819ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496538N819JBChance Billy M · Normangee, TXS/N 22-6693N81ARTredway Robert J · Prescott, AZBuilt 1954 · S/N 22-2364N81LLJma Aviation LLC · Lakin, KSBuilt 1959 · S/N 24-1338N81LSPedulla Rich · Wyalusing, PAS/N 22-6770N81MDTt Twins LLC · Fayetteville, GABuilt 1964 · S/N 30-512N8200PSix Five Papa Inc · Temple, NHBuilt 1963 · S/N 24-3452N8201CSheard Scott R · Chugiak, AKS/N 22-2306N8201YTorqmation Inc · Houston, TXS/N 30-1320N8202CMoore Sharkie A · Houston, TXBuilt 1954 · S/N 22-2307N8203PDell John J · Saint Clair Shores, MIBuilt 1963 · S/N 24-3455N8203YMn98 LLC · Belview, MNBuilt 1966 · S/N 30-1322N8204YBlue Steele LLC · Barnegat, NJBuilt 1966 · S/N 30-1324N8205CHasting Grant William · Covington, WAS/N 22-2310N82067Knutson Wayne R · Thompson, NDS/N 25-2792N8206CCalvert Charles W · Ranger, TXBuilt 1954 · S/N 22-2311N8206PMente Charles E · Ocala, FLS/N 24-3458N8206YBauer Electric Inc · Winona, MNBuilt 1966 · S/N 30-1331N8207YTwinkie Air LLC · Colville, WAS/N 30-1333N8208PGallacher Edwin T · Salt Lake City, UTBuilt 1963 · S/N 24-3460N8208YAirswiss Inc · Wilmington, DEBuilt 1966 · S/N 30-1334N8209PFox Black Enterprises Inc · Kilmarnock, VABuilt 1963 · S/N 24-3461N820AEkroot Jordan M · Grand Marais, MNBuilt 1951 · S/N 22-123N820TOneil John M · Leicester, NCFirst renewal noticeBuilt 1959 · S/N 24-1102N8210PJohnson James E · Calhoun, LABuilt 1963 · S/N 24-3463N8211YMccoy Darren T · Caledonia, MIBuilt 1966 · S/N 30-1338N8212PTweeddale Thomas Allan · Denton, TXBuilt 1963 · S/N 24-3465N8213YBoomer Joshua G · Floyds Knobs, INBuilt 1966 · S/N 30-1340N8215PAme LLC · Kalispell, MTBuilt 1963 · S/N 24-3468N8215YGlassburn Teresa L · Winthrop, WAS/N 30-1343N8216YMedia Stew LLC · Carson City, NVS/N 30-1344N8217PDanilchuk Phillip A · Auburn, GAS/N 24-3470N8217YMaledy John Trustee · Salem, MOBuilt 1966 · S/N 30-1345N8219YDurden Julian F Jr · Twin City, GABuilt 1966 · S/N 30-1347N821ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496539N821GMHoosier Aviation LLC · Terre Haute, INBuilt 1957 · S/N 23-1247N8220PParsell Scott · Katy, TXBuilt 1963 · S/N 24-3473N8221PMoreau Donald G · Dayton, TXBuilt 1963 · S/N 24-3474N8221YBill Kennedy Aviation LLC · Stuart, FLBuilt 1966 · S/N 30-1349N8222PWeirich Joseph J · South Milwaukee, WIBuilt 1963 · S/N 24-3475N8224YWoodard Earl G Jr · Danville, GABuilt 1966 · S/N 30-1353N8226YC P L Air LLC · Middletown, DEBuilt 1966 · S/N 30-1356N822BWAa-Aero Inc · Fairfield, NJBuilt 1981 · S/N 44-8195009N822REEaton Ray · Zeeland, MIBuilt 1964 · S/N 22-9802N82305Akima Logistics Services LLC · Usaf Academy, COBuilt 1976 · S/N 25-7656070N8234YBurkey Jeffrey C · Stuart, FLBuilt 1966 · S/N 30-1360N8235PZiesman Ernest D · Henderson, NVBuilt 1963 · S/N 24-3488N8235YLyons Kenneth L · Port Neches, TXS/N 30-1361
Back to AD 85-02-05 R1