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.

N5HRRay Tanner Motors Inc · Phoenix, AZFirst renewal noticeBuilt 1980 · S/N 18267523N5HVOppegard Nicholas D · Eagle River, AKBuilt 1958 · S/N 55366N5JPWard Russell S · Kingman, AZS/N 15065872N5JTTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1972 · S/N 33701468N5LPMeeks Trevor · Vineburg, CABuilt 1950 · S/N 19695N5LQCollignon William A Jr · Muscle Shoals, ALBuilt 1969 · S/N 33701202N5LSE&K Aero LLC · Friendswood, TXBuilt 1969 · S/N 18259862N5PCKeck Kevin W Trustee · Meridian, IDBuilt 1977 · S/N 18265656N5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5QUnusual Attitudes LLC · Thomas, OKBuilt 1982 · S/N 18268247N5RBBanasik Associates Inc · Columbus, OHBuilt 1976 · S/N 177RG0968N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N5RZBbz Consulting LLC · Cody, WYBuilt 1974 · S/N 33701554N5SCGarrett John R II · Waxhaw, NCS/N 18261939N5SUFlorida Skymaster LLC · Cape Coral, FLBuilt 1969 · S/N 337-1134N5VAVirginia Department Of Aviation · Richmond, VABuilt 1976 · S/N U20603223N5VEMurphee Koby T · Spirit Lake, IDBuilt 1976 · S/N 18264950N5YXRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1981 · S/N 17275266N5ZBBlue Aviation Inc · Venice, FLFirst renewal noticeBuilt 1972 · S/N 18261631N5ZXPush Pull LLC · Lewes, DEBuilt 1977 · S/N P3370273N5ZZLeirer Von O · Los Gatos, CABuilt 1977 · S/N 18265840N60002Kirmeyer Dana L · Calhoun City, MSBuilt 1968 · S/N 15069998N6000ARichards John M · Oregon City, ORBuilt 1956 · S/N 28600N6000LDoherty Douglas E · Nome, AKBuilt 1955 · S/N 31877N6000RKreisler Curt A · Plantation, FLBuilt 1965 · S/N 17253669N6000VTextron Aviation Inc · Wichita, KSS/N 172S13603N60016Meassick Steven F · Mount Horeb, WIBuilt 1968 · S/N 15070005N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002N6001GN6001g LLC · Wheeling, ILBuilt 1969 · S/N 15071501N6001JBullard Daniel C · Dallas, TXBuilt 1971 · S/N A1500301N60024Esker William D · White Mtn Lk, AZBuilt 1968 · S/N 15070011N60026Lareaux Jon R · Calumet, MIBuilt 1968 · S/N 15070013N60028Mesner Steven M · Tomah, WIBuilt 1968 · S/N 15070015N6002BWard William O · Pocatello, IDBuilt 1956 · S/N 34002N6002JSeibert John E · Anchorage, AKBuilt 1975 · S/N 18263607N6002RZelner Gregory M · Merritt Island, FLBuilt 1965 · S/N 17253671N6003260032 LLC · Jackson, MIBuilt 1968 · S/N 15070019N6003BHenley Alan · Hoover, ALS/N 34003N60040Registration Pending · Cottage Grove, MNRegistration pendingBuilt 1968 · S/N 15070026N6004GLiberty University Aviation Dept · Lynchburg, VABuilt 1969 · S/N 15071504N6004RSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253673N6004TIrwin Donald L · Emporia, KSBuilt 1964 · S/N 15060704N60050Elsen Paul D · Winnebago, ILBuilt 1968 · S/N 15070035N60051Compass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283355N60052Onofre- Trejo Ray · Chicago, ILBuilt 1968 · S/N 15070037N60053Textron Aviation Inc · Wichita, KSS/N 172S13650N60056Jones Edward · Mechanicsburg, PABuilt 1968 · S/N 15070041N6005AClark Lewis R Trustee · Lansing, MIBuilt 1956 · S/N 28605N6005BConnected Air LLC · Danvers, MABuilt 1956 · S/N 34005N6005GCrockett Guy S · Louisville, KYBuilt 1969 · S/N 15071505
Back to AD 79-10-14 R1