OpenAirDocs.org
AD 81-13-10 R1

Registered aircraft · 4,000

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.

N11RPN11rp LLC · Brecksville, OHBuilt 1978 · S/N 28R-7803241N11WSAviation Trust Company LLC · Oklahoma City, OKS/N P3370017N11XTKacur John Edward Sr · Halethorpe, MDBuilt 2000 · S/N 1103N11YNN3412w LLC · Lithia, FLS/N 34-8070059N12158Caccavale John J · Oakdale, NYBuilt 1978 · S/N JC1N1216VKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N R1722143N121HPPk Flyer LLC · Lancaster, CABuilt 1956 · S/N 3643N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340N1221VLovely John E · Rich Creek, VABuilt 1976 · S/N R1722145N1225MMarlin Roger · Morgan Hill, CABuilt 1971 · S/N 33701425N122DZFitzpatrick Nolan · Urbandale, IABuilt 2004 · S/N 1465N122FAFox Alpha LLC · Londonderry, NHBuilt 2004 · S/N 1452N122JHValentine Terence S · Glennallen, AKBuilt 1966 · S/N R-172-0086N122WB2sea2it LLC · Ossining, NYBuilt 1973 · S/N 33701487N122XPWatch Ya Head Aviation 1 LLC · Zionsville, INS/N R1722055N1233VFlybuy Investments LLC · Natchitoches, LAS/N R1722147N123ANSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 1379N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015N123ASCarlson Jonathan J · Hernando, MSBuilt 1981 · S/N 1N123CGLmadif LLC · Kaukauna, WIBuilt 2003 · S/N 1317N123MBSpinner Family Lp · White City, ORS/N R1722836N1240VHeink Philip · Lexington, KYBuilt 1976 · S/N R1722150N1243VAlexander Arlene Myers · Sandwich, MABuilt 1976 · S/N R1722151N1246VGifford Jeremy C · Stephenville, TXBuilt 1976 · S/N R1722152N124DNRegistered aircraftS/N 337M0349N124WLHomeland Aviation LLC · Shreveport, LABuilt 1979 · S/N R1723082N1258SN76bt LLC · Lynnfield, MAS/N 33701894N1258VSutton Aircraft Salvage LLC · Palmer, AKS/N R1722154N125FLAll Star Capital LLC · Concord, NCBuilt 1980 · S/N 34-8170025N125SFCovino John M · Ashland, MABuilt 2005 · S/N 1593N1265CDbg Aviation · Roscoe, ILBuilt 2003 · S/N 1291N1266MBeta Flight LLC · Queen Creek, AZS/N 33701266N1268CKnight Russell P · East Greenwich, RIBuilt 2003 · S/N 1283N1268VFuller Joshua · Jackson, WYBuilt 1976 · S/N R1722155N1271VSpur International LLC · Spring Hill, TNS/N R1722156N1275MAdams Charles P · New London, NHBuilt 1970 · S/N 33701275N1277MWilliams Richard A · Brookhaven, GABuilt 1970 · S/N 33701277N127CDRegistered aircraftBuilt 2000 · S/N 1027N1281Cirrusazflmi LLC · Midland, MIBuilt 2005 · S/N 1581N1281MWadleigh John M · Marana, AZBuilt 1970 · S/N 33701281N1284CCirrus N1284c LLC · Oakland Park, FLBuilt 2003 · S/N 1321N1287C907th Flight Squadron Inc · Wilmington, DEBuilt 2003 · S/N 1311N1288MRagsdale Michael R · Eustis, FLS/N 33701288N1288VRegistration Pending · Wallace, CARegistration pendingS/N R1722159N128CDMetamorphosis Publishing LLC · Hamilton, MTBuilt 2000 · S/N 1024N128FAWe So Fly LLC · Edgemoor, SCBuilt 2004 · S/N 1470N128JFFloyd Stephen M · Spotsylvania, VABuilt 2003 · S/N 1316N1290XJr Aviation LLC · Benton, KSBuilt 1963 · S/N 163N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309
Back to AD 81-13-10 R1