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.

N758RLRegistered aircraftBuilt 1979 · S/N R1723299N758RNDavis Evan · Haddonfield, NJBuilt 1979 · S/N R1723301N758RSStewart Jon L · Walker, MNBuilt 1979 · S/N R1723305N758RVLejeune Thad · Eunice, LABuilt 1979 · S/N R1723308N758RXBuss Rhonda K · Hustisford, WIS/N R1723310N758SYMasser Management Inc · Leck Kill, PABuilt 1980 · S/N R1723335N758TAStonehouse William L · Clovis, CABuilt 1980 · S/N R1723337N758TJSilverstein Bradley · Derby, KSBuilt 1980 · S/N R1723345N758TKBookout Samantha · Louisville, MSBuilt 1980 · S/N R1723346N758TNStevenson Aviation LLC · Harrisville, UTBuilt 1980 · S/N R1723349N758TSNiemiec Luke · Assonet, MABuilt 1980 · S/N R1723353N758TTLawson Paul L · Vancouver, WABuilt 1980 · S/N R1723354N758TXMehn Michael J · Berlin, WIBuilt 1980 · S/N R1723357N758UCL&S Adventure LLC · Rocklin, CAS/N R1723362N758UHKobesky Jeffrey · Dunkirk, MDBuilt 1980 · S/N R1723367N758VSWieden Air LLC · Owasso, OKBuilt 1980 · S/N R1723400N758VUParlet Brian C · Banning, CABuilt 1980 · S/N R1723402N758VWSimon Ilene F · San Mateo, CABuilt 1980 · S/N R1723404N758WBFinity Engineering LLC · College Place, WABuilt 1980 · S/N R17203409N758XBLet The Fur Fly · Payson, AZBuilt 1981 · S/N R1723431N758XSG & A LLC · Eagle River, AKBuilt 1981 · S/N R1723446N75BJTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 34-7570114N75ETMeyers Martin R · Murfreesboro, TNBuilt 2002 · S/N 1185N75JTArtemis Aviation Group LLC · Kalispell, MTS/N 75-3822N75NXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 33701660N75PWPapa Whiskey LLC · Darien, CTBuilt 1984 · S/N 25-0806N75RVBas Part Sales LLC · Greeley, COS/N 34-7570188N7606VDahdah Kurt J · Agawam, MABuilt 1977 · S/N R1722311N76076Elite Airplanes LLC · Fort Myers, FLS/N 17268114N76091Riverside Flight Academy Inc · Riverside, CAS/N 17268121N7609CBergstrom Aircraft Inc · Pasco, WABuilt 1976 · S/N 34-7670097N761DBOne Two Air LLC · Traverse City, MIBuilt 1978 · S/N 34-7970014N761ESummers Robert B · Owasso, OKS/N LES-029N762MBlaisdell Frederick C · Anderson, CABuilt 1978 · S/N 28R-7931015N7650FPinnacle Air Charter Inc · Blair, NEBuilt 1976 · S/N 34-7770061N7654JGarrison Trading LLC · Prescott, AZBuilt 1969 · S/N 28R-31054N7654TD Scott Smith Dvm Pa · Mountain Home, ARBuilt 2000 · S/N 1019N7654VRene Ronald M · Linden, NCBuilt 1977 · S/N R1722312N765ESWetzig Rodney L Trustee · San Angelo, TXBuilt 2009 · S/N ES-207N765MKMeyers Mark · Santa Rosa Valley, CABuilt 1983 · S/N 25-0756N766SAN766sa LLC · Sheridan, WYBuilt 2000 · S/N 1101N767DKAbbott Donald K · Gallatin, TNBuilt 1948 · S/N 2319N7681FLowrance Kenneth D · Saint Louis, MOBuilt 1976 · S/N 34-7770066N769JJTwo Winds Aviation LLC · East Setauket, NYBuilt 2002 · S/N 3449250N769TTBrawndair Geminus LLC · Chesapeake, VABuilt 1975 · S/N 34-7570012N76BTEstes David Edward · Kennesaw, GAS/N 33701935N76DBarrett Todd · Palm Harbor, FLS/N 1176N76HFRgp Aviation LLC · The Villages, FLBuilt 1976 · S/N 33701729N76PBPlastic Bottle Corporation · Libertyville, ILBuilt 1978 · S/N 34-7970067N76WCGolf Aero Corp · Arlington, TXBuilt 1975 · S/N 34-7670053
Back to AD 81-13-10 R1