OpenAirDocs.org
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.

N758JRTownsend Robert J · Leavenworth, WABuilt 1979 · S/N R1723137N758JTEdwards Thomas G Trustee · Jacksonville, ORBuilt 1979 · S/N R1723139N758JZReaka Dean James Trustee · Troy, MOBuilt 1979 · S/N R1723145N758KCMccormick Robert C · Vlg Of Lakewd, ILBuilt 1979 · S/N R1723148N758KFMorgan Kenneth J · Norridgewock, MEBuilt 1979 · S/N R1723151N758KMStrong Janet L · Vancouver, WABuilt 1979 · S/N R1723157N758KRKairys Steven A · Encino, CABuilt 1979 · S/N R1723161N758KVAk Denali Group LLC · Anchorage, AKBuilt 1979 · S/N R1723165N758LCDepino Damian P · Dummerston, VTBuilt 1979 · S/N R1723172N758LEBernheim Karen M · Sisters, ORBuilt 1979 · S/N R1723174N758LJPeery William R · Beckley, WVBuilt 1979 · S/N R1723178N758LMSwenson Karine · Anchorage, AKBuilt 1979 · S/N R1723181N758LNLittle 8 Mile Ranch LLC · Missoula, MTBuilt 1979 · S/N R1723182N758LPTony Joe Aviation LLC · Sheridan, WYBuilt 1979 · S/N R1723183N758LRWood Tyler J · Creston, CABuilt 1979 · S/N R1723185N758LWTeton Leasing LLC · Pocatello, IDBuilt 1979 · S/N R1723190N758LYDixon Craig S · Rimrock, AZBuilt 1979 · S/N R1723192N758MHFantasy Flyer LLC · Ojai, CABuilt 1979 · S/N R1723201N758MNTritt Scott W · Bolivar, OHBuilt 1979 · S/N R1723206N758MPPickle Brad R · Pottsboro, TXBuilt 1979 · S/N R1723207N758MQSarkissian Hovannes · Pasadena, CABuilt 1979 · S/N R1723208N758MSRegistered aircraftBuilt 1979 · S/N R1723210N758MTTurbine Financial Group LLC · Ogden, UTBuilt 1979 · S/N R1723211N758MVCarson Flying Feeders LLC · Carson, IABuilt 1979 · S/N R1723213N758MWHaddock Debra E · Shelby, NCBuilt 1979 · S/N R1723214N758MYMcclellan Steven D · Blackfoot, IDBuilt 1979 · S/N R1723216N758MZMowry Valetta J · Greensburg, PABuilt 1979 · S/N R1723217N758NAManabe Osamu · Kapolei, HIBuilt 1979 · S/N R1723218N758NBMcdonald Sporting Goods · Murfreesboro, TNBuilt 1979 · S/N R1723219N758NCWatkins Herbert L Jr · Durango, COS/N R1723220N758NFBoeing Employees Flying Association · Renton, WABuilt 1979 · S/N R1723223N758NJNoble Investments LLC · Naples, FLBuilt 1979 · S/N R1723226N758NLDc Aero LLC · Ramona, CABuilt 1979 · S/N R1723228N758NVKirk Blackstone LLC · Las Vegas, NVBuilt 1979 · S/N R1723237N758NYHall Associates LLC · Homer, AKS/N R1723240N758PDWilliams Gary L · Hastings, NEBuilt 1979 · S/N R1723244N758PHFarguson David M · Pasadena, CAS/N R1723248N758PKSkyking Aviation LLC · Obion, TNBuilt 1979 · S/N R1723250N758PTTkj Equipment LLC · El Dorado Hills, CABuilt 1979 · S/N R1723258N758PXWiley'S Little Red Wagon LLC · Osseo, MNBuilt 1979 · S/N R1723262N758QCMccray B F Jr · Manchester, OKBuilt 1979 · S/N R1723267N758QEThomason Land Co · Garden City, TXBuilt 1979 · S/N R1723269N758QNCessna 172xp LLC · Wilmington, DES/N R1723277N758QPBarbee Donald L · Columbus, OHBuilt 1979 · S/N R1723278N758QVMidwest Aviation Inc · Mayfield, KYBuilt 1979 · S/N R1723284N758QX4-Gs Holding Co LLC · Cashmere, WABuilt 1979 · S/N R1723286N758QYRegistration Pending · Arlington, TXRegistration pendingBuilt 1979 · S/N R1723287N758QZDovy Aviation LLC · Houston, TXBuilt 1979 · S/N R1723288N758RCMattern Todd A · Yuma, AZBuilt 1979 · S/N R1723291N758RJWilliams Steven M · Cazenovia, NYBuilt 1979 · S/N R1723297
Back to AD 81-13-10 R1