OpenAirDocs.org
AD 81-07-11 R1

Registered aircraft · 733

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-07-11-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-07-11-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.

N340GBMbw Aviation LLC · Bay City, MIS/N 340A0618N340GCShupe David L · Dayton, NVS/N 340A-0369N340GGMarlowe Clifford Gray · Maxwelton, WVBuilt 1979 · S/N 340A0916N340GKRiv Desert Sun LLC · Phoenix, AZBuilt 1979 · S/N 340A0625N340GMElbitamerica Inc · Merrimack, NHBuilt 1976 · S/N 340A0202N340GSRelevance Capital Management LLC · Brentwood, TNBuilt 1972 · S/N 340-0183N340GTWow-We Wings LLC · Pawleys Island, SCBuilt 1981 · S/N 340A1249N340GWThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1979 · S/N 340A0706N340HCPropjet 210 Aviation Inc · Windsor, CAS/N 340A0638N340HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 340A1503N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228N340HWHartung Stefan · Greenville, SCBuilt 1976 · S/N 340A0265N340JOkla-Tex Energy Corp · Tyler, TXS/N 340-0171N340JCS O W Aviation LLC · Crystal River, FLBuilt 1979 · S/N 340A0801N340JDWescott Aviation LLC · Prospect, KYBuilt 1972 · S/N 340-0100N340JFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0451N340JJAmnr LLC · Shawnee, OKS/N 340-0040N340JLLechman Joseph · Agoura Hills, CABuilt 1982 · S/N 340A1543N340JMHunter Pilot Services LLC · Hollister, CABuilt 1978 · S/N 340A0640N340JPOlive Aviation LLC · Anchorage, AKBuilt 1973 · S/N 3400232N340JQLiu Qi · Saratoga, CAS/N 340A0279N340JSAsher Kenneth Edward · Durango, COBuilt 1979 · S/N 340A0661N340KRegistered aircraftBuilt 1979 · S/N 340A0792N340KCRegistered aircraftBuilt 1980 · S/N 340A0959N340KGAero Vulcan LLC · Moody, ALBuilt 1982 · S/N 340A1505N340KSDavieation III LLC · St Simons Is, GABuilt 1981 · S/N 340A1501N340KTN44fu LLC · Oklahoma City, OKBuilt 1977 · S/N 340A0356N340KYE Lite Aviation Inc · Cordova, TNBuilt 1978 · S/N 340A0622N340L310 Air Ltd · Seville, OHBuilt 1978 · S/N 340A0518N340LBSteed Dan E Trustee · Groom, TXBuilt 1972 · S/N 340-0053N340LEThree Forty LLC · Saint George, UTS/N 340A0233N340LHAviation Limited Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 340A0409N340LLFrank Leasing LLC · Scottsbluff, NES/N 340A1228N340LMCrawford William K · Indianapolis, INBuilt 1978 · S/N 340A0478N340LQDownwind Flight LLC · San Antonio, TXBuilt 1976 · S/N 340A0020N340LZWestern Radiation Oncology Assoc Pc · Great Falls, MTBuilt 1975 · S/N 340-0537N340MBRecon Real Estate Consultants Inc · El Paso, TXBuilt 1982 · S/N 340A1508N340ME58gp Wing LLC · Wilmington, DEBuilt 1978 · S/N 340A0550N340MFMerrill Farms · Corral De Tierra, CABuilt 1982 · S/N 340A1542N340MGN340mg LLC · Highlands Ranch, COS/N 340A0769N340MHFlying High Llp · Williston, NDBuilt 1981 · S/N 340A-1214N340MJAll-Star Executive Aviation Inc · Pomona, CABuilt 1993 · S/N 340A1521N340MKMilbern Aircraft Corporation · Brooklyn, NYBuilt 1982 · S/N 340A1541N340MLD & L Airlines LLC · West Chester, OHBuilt 1979 · S/N 340A0729N340MMRegistered aircraftS/N 340A0238N340MPPaxell Aviation LLC · Springdale, ARS/N 340A0359N340MSSprings1781 LLC · Colorado Springs, COBuilt 1979 · S/N 340A0760N340MWInternational Air Services Inc Trustee · Carson City, NVS/N 340A0101N340MYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A-0906N340NN-Number Inc · Santa Fe, NMBuilt 1982 · S/N 340A1540
Back to AD 81-07-11 R1