AD 79-10-14 R1

Registered aircraft · 56,582

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.

N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MOBuilt 1975 · S/N 17265622N6877ASchenck Alan E · Clarinda, IABuilt 1956 · S/N 28977N6877EBell Connor C · Maple Valley, WABuilt 1959 · S/N 56377N6877HKoenig Ned · New Bremen, OHBuilt 1975 · S/N 17265623N6877XSwick Gerald K · Murfreesboro, TNBuilt 1960 · S/N 17247777N6878XLinkinhoker Craig W · Carpentersville, ILBuilt 1960 · S/N 17247778N6879EWilliams James W · Friendsville, TNS/N 56379N6879MCohen Robert · Buda, TXBuilt 1975 · S/N 18263884N6879XRegistration Pending · Farr West, UTRegistration pendingBuilt 1960 · S/N 17247779N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592N687BASvetfur Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11581N687CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N 18282288N687RTFvx Research · Greenville, DEBuilt 2012 · S/N 18282350N687SPBmg Aviation Inc · Bloomington, INBuilt 1999 · S/N 172S8098N6880EBartel Anthony E Jr · Ridgecrest, CABuilt 1959 · S/N 56380N6880MKing Dale C · Simi Valley, CABuilt 1975 · S/N 18263876N6881EInternational Air Services Inc Trustee · Carson City, NVS/N 56381N6881XWestmoreland Dennis F · Snyder, TXBuilt 1960 · S/N 17247781N6882FHernandez Kevin F · Redmond, ORBuilt 1966 · S/N 15063482N6883AOswego Joint Venture · Tchula, MSBuilt 1956 · S/N 28983N6883GSchroeder David C · Norfolk, NEBuilt 1970 · S/N 15072383N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625N6884XBaked Industries Inc · Yuba City, CAFirst renewal noticeBuilt 1960 · S/N 21057664N6885EHeiser Reggie · Polson, MTBuilt 1959 · S/N 56385N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626N6886EHadley David C · Herriman, UTBuilt 1959 · S/N 56386N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627N6886MJohnson Bill J · Canton, GABuilt 1975 · S/N 18263879N6887ABradshaw Gary E · Warfordsburg, PABuilt 1956 · S/N 28987N6887EPatton Martin O · North Ridgeville, OHS/N 56387N6887GMassuet Nancy O · Sunrise, FLBuilt 1970 · S/N 15072387N6888ESteinhausen Darrell · Torrington, WYBuilt 1959 · S/N 56388N6888HN6888h LLC · Wayne, NJS/N 17265628N6889GKozlowski James · Zeeland, MIBuilt 1970 · S/N 15072389N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289N6889XSchler Joseph B · Reno, NVBuilt 1960 · S/N 17247789N688AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2008 · S/N 172S10821N688CABetter Southlake Properties LLC · Pagosa Springs, COS/N 17262505N688DDPropit Inc · Wilmington, DES/N 17251057N688DWRegistration Pending · Concord, NHRegistration pendingBuilt 2000 · S/N 17280949N688JFCrothers Travis · Madison, MSBuilt 1968 · S/N 18259510N688KTGlore Reilly P · Olympia, WABuilt 1972 · S/N 18261187N688PAJoe P Fassio · Union, WABuilt 1953 · S/N 25535N688PGGo Blue Sky LLC · Trinity, TXBuilt 2024 · S/N 18283258N688WBaum Eldon L Jr · Wellsville, PABuilt 1956 · S/N 28695N6891EOakes Stephen · Joshua Tree, CAS/N 56391N6891FN6891f LLC · Woodruff, SCBuilt 1966 · S/N 15063491N6891HRegistration Pending · Uvalde, TXRegistration pendingBuilt 1975 · S/N 17265630N6892FDent Kelly J · Locust Grove, GABuilt 1966 · S/N 15063492N6892GDetroit Public Schools Community District · Detroit, MIS/N 15072392
Back to AD 79-10-14 R1