OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N170LSchaible Peter J · Springfield, VABuilt 1954 · S/N 26252N170LCMacy Richard M · Lebanon, NEBuilt 1955 · S/N 26928N170LEArends Brian H · Mahomet, ILS/N 18271N170LMGlastonbury Michael C · Sioux Falls, SDS/N 18457N170MBCoffman Richard A II · Hernando, MSBuilt 1950 · S/N 19203N170MSMidstate Aviation Inc · Ellensburg, WAFirst renewal noticeBuilt 1953 · S/N 26085N170MWN88tg LLC · Fairbanks, AKBuilt 1952 · S/N 25411N170NDau Jason E · Fairbanks, AKBuilt 1955 · S/N 26899N170PBFancher Scott · Granite Falls, WABuilt 1950 · S/N 19800N170PPBarry Stephen J · Beaverton, ORBuilt 1955 · S/N 26695N170PRHicks Arch A · Oxford, NCBuilt 1953 · S/N 25686N170PSMcgavock Edward A · Columbus, WIBuilt 1951 · S/N 20152N170PTSabos Anthony J · Bolingbrook, ILBuilt 1950 · S/N 19300N170PYYates James H · Edmond, OKBuilt 1951 · S/N 19949N170RBChristiansen Aviation LLC · Wilmington, DES/N 172S11130N170REBerbig Daniel J · Anchorage, AKBuilt 1953 · S/N 25922N170RHBas Part Sales LLC · Greeley, COBuilt 1947 · S/N 18030N170RKBelphegor LLC · Madison, WIBuilt 1953 · S/N 26053N170RPDejesus Kennet J · Troy, OHBuilt 1953 · S/N 25865N170RSWilson Benjamin A · Shawnee, KSBuilt 1950 · S/N 19611N170RWSchroth Ian C · Gustavus, AKS/N 18406N170SBMacbean Stanley F Trustee · Orem, UTBuilt 1952 · S/N 25140N170SKNottingham John F · Covington, LABuilt 1979 · S/N 17273173N170SLSimmons Kenton L · Van Alstyne, TXBuilt 1948 · S/N 18138N170SPSweatt Jeffrey · West Terre Haute, INBuilt 1981 · S/N 17275097N170STDow Jeff W · Port Hadlock, WABuilt 1948 · S/N 18666N170TCGammelin Robert · Alta, WYBuilt 1949 · S/N 19183N170TDHoyt Nicholas J · Port Orchard, WABuilt 1954 · S/N 26488N170TPNorthrop John · Fairfield, CAFirst renewal noticeBuilt 1950 · S/N 19609N170UJohnson Thomas C · Roseau, MNBuilt 1953 · S/N 25858N170UWBlocher Kristyn A · Tumwater, WABuilt 1948 · S/N 18403N170VPocock Milne David · Cal Nev Ari, NVBuilt 1952 · S/N 20656N170VWPratz Chris · Ellensburg, WABuilt 1952 · S/N 20592N170WRFinkel Charles M · Taylorsville, NCBuilt 1954 · S/N 26450N170WSSikorski Bradley · Colorado Springs, COBuilt 1950 · S/N 19490N170WYLarsen Michael S · Cody, WYBuilt 1954 · S/N 26592N170YPocock Milne D · Cal Nev Ari, NVBuilt 1953 · S/N 25882N17101Vasquez Juan E · Miami, FLBuilt 1972 · S/N 15073623N17102North Timothy · Milton, WVBuilt 1976 · S/N 17702503N17106Tate Daron D Trustee · Pasco, WABuilt 1972 · S/N 15073627N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410N1710FValley Aviators Inc · Williston, NDBuilt 1966 · S/N 17255105N1710GNational Test Pilot School · Mojave, CAS/N 18282011N1710KCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13178N1711CNorthern Flyway LLC · Anchorage, AKBuilt 1953 · S/N 30411N1711WBogaard Jeffery D · Kansas City, MOBuilt 1966 · S/N 18257108N1712CGrant Douglas E Jr · Chubbuck, IDBuilt 1953 · S/N 30412N1712DRichter Ty G · Buffalo, SDBuilt 1951 · S/N 20155N1712QMischief Makers LLC · Tuscaloosa, ALBuilt 1971 · S/N 15073012N1712SNorth Carolina Dept Of Enviroment & Natural Resour · Raleigh, NCBuilt 2005 · S/N 18281620
Back to AD 79-10-14 R1