OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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.

N3755UHendrickson Justin R · Twin Falls, IDBuilt 1963 · S/N 18255155N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255N37566Aviation Specialty Services LLC · Beaufort, NCBuilt 1967 · S/N 337M0157N3756DAnderson Daren J · Almond, WIS/N 34456N3756JLong Donald R · Seneca, SCBuilt 1966 · S/N 15065056N3756UKlinger Cattle Co Inc · Friona, TXBuilt 1958 · S/N 51263N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075N3757SWiller Sebastian · Calhoun, GABuilt 1963 · S/N 17250957N3758DStrother John G · Kenai, AKBuilt 1957 · S/N 34458N3758FTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTS/N 17255253N3758LN3758l LLC · Titusville, FLBuilt 1965 · S/N 17253927N3758RDrager Timothy L · Pottstown, PABuilt 1966 · S/N 17255558N3758SMorris Philip N · Edgewood, NMBuilt 1963 · S/N 17250958N3759SBudd Stephen C · Lake City, FLBuilt 1963 · S/N 17250959N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259N375FDepartment Of The Interior · Boise, IDBuilt 1980 · S/N U20605750N375HPCraig E Rappe · Wasilla, AKBuilt 1976 · S/N 18503235N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251N375LARegistered aircraftBuilt 1965 · S/N 17252722N375MASteinhardt Clark R Jr · Green Bay, WIBuilt 1999 · S/N 172S8077N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252N375PWRyan Adrian B · Anchorage, AKBuilt 1979 · S/N 18503965N375WVictory Holdings LLC · Anacortes, WABuilt 1978 · S/N 18503598N375YVBisono Pablo R · San Juan, PRBuilt 1974 · S/N 17262930N3760JWeeks Ryan A · Sneads Ferry, NCBuilt 1966 · S/N 15065060N3760SPorter Charles T III · Seymour, TXBuilt 1963 · S/N 17250960N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260N3761LBas Part Sales LLC · Greeley, COS/N 17253930N3761SBucks Flight Academy LLC · Cashion, OKBuilt 1963 · S/N 17250961N37624Lowe David M · Sacramento, KYS/N 20668N3762DSteves Aircraft · Lakeport, CABuilt 1956 · S/N 34462N3763RPrimo Aviation LLC · Collierville, TNBuilt 1966 · S/N 17255563N3763SGriffn Jared · Sheridan, ARBuilt 1963 · S/N 17250963N3763UHunter James C · Shelton, WABuilt 1964 · S/N 18255163N3764SKarashchuk Yaroslav P · Georgetown, KYS/N 17250964N3765JSatanta Flying Service Inc · Satanta, KSS/N 15065065N3765RLevin Robert · Roseburg, ORBuilt 1966 · S/N 17255565N3765SKennedy Patrick M · Great Barrington, MABuilt 1971 · S/N 17701629N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265N3766DFree Range LLC · Missoula, MTS/N 34466N3766LSygnet Lenard M · Pottstown, PABuilt 1965 · S/N 17253935N3766RHarrigan Patrick · Hickory, NCBuilt 1968 · S/N 337-1034N3766VHaile Kempton Crosby · Warrenton, VABuilt 1975 · S/N 15076612N3766YPyanov Mark · Clinton, MSS/N 21058266N3767JHalbur Wesley D · Heron Lake, MNBuilt 1966 · S/N 15065067N3767SDickehut Donna · Cloverdale, INBuilt 1963 · S/N 17250967N3768D3di LLC · Elizabeth, WVBuilt 1957 · S/N 34468N3768JWheeler Kevin M Trustee · Comstock Park, MIBuilt 1966 · S/N 15065068N3768RStretz Scott P · Lees Summit, MOBuilt 1966 · S/N 17255568N3768VHaynes Robert K · Pilot Point, TXBuilt 1975 · S/N 15076614
Back to AD 79-10-14 R1