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.

N9957XHutchison Robert T · Big Lake, AKBuilt 1961 · S/N 185-0157N99583Motz Gary A · Bemidji, MNBuilt 1985 · S/N 17276471N99589Kingsky Flight Academy LLC · Lakeland, FLBuilt 1985 · S/N 17276472N9958AChase Kevin J · Anchorage, AKFirst renewal noticeBuilt 1950 · S/N 19318N9958BSouthern Aircraft Leasing LLC · Montgomery, ALS/N 34358N9958EAirtauk LLC · Montauk, NYBuilt 1975 · S/N 18264018N9958HCity Of Albuquerque · Albuquerque, NMBuilt 1981 · S/N 18268143N9958NShimpa Michael A · Maple Grove, MNBuilt 1975 · S/N 18052613N9958TKonefal Arthur J · Fairbanks, AKBuilt 1960 · S/N 18253058N99598Registration Pending · Argyle, TXRegistration pendingBuilt 1985 · S/N 17276474N9959ANelson Jayson A Trustee · Caldwell, IDBuilt 1950 · S/N 19319N9959BHackamore Equipment LLC · Prairie City, SDBuilt 1957 · S/N 34359N9959ETyler Matthew S · Lakeside, CABuilt 1975 · S/N 18264019N9959HThibault William N · Newport Beach, CABuilt 1981 · S/N 18268144N9959RRusyniak Anthony J · Syracuse, NYBuilt 1986 · S/N U20607000N9959XMiller Keith D · Pittsburgh, PAS/N 1850159N9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeBuilt 1982 · S/N 21064648N995CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280319N995JAN995ja LLC · Ft Lauderdale, FLBuilt 1974 · S/N 17263989N995NABucher Devin V · Kalispell, MTBuilt 1966 · S/N 17255575N995SBRossi Randall A · Georgetown, TXBuilt 1974 · S/N 18262473N995VZMeyerowitz Noah A · Great Barrington, MABuilt 1974 · S/N 177RG0478N995WWMoore Aviation Inc · Beaver Falls, PABuilt 1999 · S/N 17280720N99606Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276478N9960BSouthern Aircraft Leasing LLC · Montgomery, ALBuilt 1957 · S/N 34360N9960EArklamiss Aviation LLC · Ruston, LAS/N 17272299N9960NBoemer Steven E · El Cajon, CABuilt 1982 · S/N 18504377N9960RInternational Air Services Inc Trustee · Carson City, NVS/N U20607001N9961ERuryk Jonathan D · Pineville, LABuilt 1979 · S/N 17272300N9961VCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17264579N9962ESynergy Financial Services Inc · Vancouver, WABuilt 1975 · S/N 18264022N9962MFox Aircraft LLC · Bethel, AKS/N 20700765N9962TWh72 LLC · Lincoln, NEBuilt 1960 · S/N 18253062N9963EDenski David T · Plymouth, MIBuilt 1979 · S/N 17272301N9963NWoodward Aviation LLC · Alpine, TXBuilt 1975 · S/N 18052618N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649N9964CTakle Management LLC · Bethany, OKBuilt 1964 · S/N 18255519N9964EJansen Christopher · Stilwell, KSBuilt 1975 · S/N 18264024N9964HBuchanan Gary · Jay, FLFirst renewal noticeBuilt 1981 · S/N 18268148N9964KState Of Wisconsin Department Of Administration · Madison, WIBuilt 2009 · S/N 18282146N9964LHess Garrett J · Fullerton, CABuilt 1986 · S/N 17276652N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650N9965ARobertson Francis E · Hibbing, MNBuilt 1950 · S/N 19325N9965BTuma Tom · Cut Bank, MTS/N 34365N9965PAmeriflyers Of Texas Inc · Addison, TXBuilt 2008 · S/N 172S10822N9965XNistler Matt J · Three Forks, MTBuilt 1961 · S/N 185-0165N9966BKimbrell Heath · Quinlan, TXS/N 34366N9966NBeeson John Charles · Palmer, AKBuilt 1975 · S/N 18052621N9966TItalio River Adventures LLC · Yakutat, AKBuilt 1960 · S/N 18253066N9966VLeisner David L · Palmer, AKBuilt 1974 · S/N 17264584
Back to AD 79-10-14 R1