AD 81-13-10 R1

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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.

N262AKKempton Alan R · Lutz, FLS/N 25-0593N262BBFive Four November Inc · Littleton, COBuilt 1980 · S/N 25-0474N262CMyers Thomas · Hot Springs, ARBuilt 1981 · S/N 25-0520N262CDSig Awy Inc Trustee · Wilmington, DEBuilt 2003 · S/N 1310N262EZN262ez LLC · Canton, OHBuilt 1984 · S/N 25-0808N262GMRochester Air Center LLC · Canandaigua, NYS/N 1129N262JKPeachtree Aviation Inc · Woodstock, GABuilt 1981 · S/N 25-0584N262MBMurray Adventures LLC · Dallas, TXBuilt 1982 · S/N 25-0655N262MPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2004 · S/N 1425N262RVT & J Air LLC · Wilmington, DEBuilt 1980 · S/N 25-0382N262RWMakino Kazuya · Fountain Valley, CABuilt 1982 · S/N 25-0649N262VFBaker Geoffrey D · Philomath, ORBuilt 1983 · S/N 25-0759N262WDWyoming Development LLC · Cheyenne, WYS/N 25-0580N262WEN262we LLC · Akron, OHS/N 25-0687N2630SDuquette Stephen R · Fenton, MIBuilt 1968 · S/N 337-0930N2632SAvialogia Inc · Wilmington, DES/N 337-0932N2633SAir Apparent LLC · Santa Rosa, CAFirst renewal noticeBuilt 1968 · S/N 337-0933N263CDHayon Ilan · Oakland Park, FLS/N 1308N263DBZulu Murphy LLC · Oklahoma City, OKS/N 25-2022N263HBTakahashi Hector · Livingston, NJBuilt 2003 · S/N 1369N2645SVenice Group LLC · Hopkinton, NHS/N 337-0945N2648SRegistration Pending · Albuquerque, NMRegistration pendingBuilt 1968 · S/N 337-0948N265E&S Management LLC · Miami, FLBuilt 1975 · S/N P3370232N2651VHagl Aviation LLC · Sunray, TXBuilt 1976 · S/N R1722226N2657S57 Sierra LLC · Houston, TXBuilt 1968 · S/N 337-0957N2663SMaclean Kenneth J · Northborough, MABuilt 1968 · S/N 337-0963N2664SMcclain Daniel S · Enon Valley, PABuilt 1968 · S/N 337-0964N2666SHageness Hartley · Rugby, NDBuilt 1968 · S/N 337-0966N2669SWilliams Kent A Jr · Kissimmee, FLBuilt 1968 · S/N 337-0969N266RVHuelskamp Thomas L · Fowler, KSBuilt 2009 · S/N 22480N2672SJja Transportation LLC · Springville, UTBuilt 1968 · S/N 337-0972N2679SJordan Richard L · Memphis, TNBuilt 1968 · S/N 337-0979N267CDTsp Aviation LLC · North Fort Myers, FLBuilt 2003 · S/N 1284N267JSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1976 · S/N 347670332N2684VReims Rocket LLC · Tempe, AZBuilt 1976 · S/N R1722227N268ACPafford David A · Floydada, TXBuilt 1998 · S/N 25-2024N2694CCranford Billy J · Wasilla, AKBuilt 1971 · S/N 33701378N2694SMock Joseph R · Huntsville, TXS/N 337-0994N2698MBearce Larry James Jr · Solon, IABuilt 1977 · S/N 28R-7803139N269CDMclaughlin John · Palm Harbor, FLBuilt 2002 · S/N 1204N26PHHuff Peter C · Mckinney, TXBuilt 1993 · S/N 60N2704VVorderbruggen Gary J · Garden Valley, CABuilt 1976 · S/N R1722228N2706ESj Construction Group LLC · New Berlin, ILS/N 1497N2711YAnn Arbor Air LLC · Plymouth, MIBuilt 2002 · S/N 1211N2719CBrown Kevin Charles · Round Rock, TXBuilt 1977 · S/N 28R-7803034N2744MCas Aviation LLC · Warwick, RIBuilt 1977 · S/N 28R-7803142N2751MWktr Inc · Cocoa Beach, FLBuilt 1977 · S/N 34-7870092N275CDTyler John G IV · Sandy, UTBuilt 2002 · S/N 1208N275RSMonaco Aviation LLC · Duluth, MNBuilt 2003 · S/N 1280N276DBN276db LLC · Mesa, AZBuilt 1976 · S/N 34-7670238
Back to AD 81-13-10 R1