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.

N9472FJunell Sonny Brian · Midlothian, TXBuilt 1988 · S/N 18280201N9472HMulder Terry A · Appleton, WIBuilt 1976 · S/N 17266171N9472MValentine Kurt J · Apple Valley, MNBuilt 1970 · S/N 21059372N9472NHuang Sophie M · Newcastle, WABuilt 1981 · S/N 18504363N9472TWilliams Chad R · Jamestown, INBuilt 1960 · S/N 57272N9473BMulholland Thomas C Trustee · Orange Cove, CABuilt 1958 · S/N 55273N9473CWild America Aviation And Holding Co LLC · Wilmington, DEBuilt 1955 · S/N 31871N9473MOpie Milton J III · White Lake, MIBuilt 1970 · S/N 21059373N9473ZGoldstein Jeffrey Edward · Dix Hills, NYBuilt 1998 · S/N 18280165N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833N9474CAndrews David L · Redvale, COBuilt 1955 · S/N 31872N9474TWalker James O · Lovell, WYBuilt 1960 · S/N 57274N9474UMay Randall T · Maquon, ILBuilt 1976 · S/N 15078422N9474XKronner Prototypes Inc · Roseburg, ORFirst renewal noticeBuilt 1961 · S/N 21057774N94751Ishawooa Air LLC · Cody, WYBuilt 1978 · S/N 18266500N94753Thornton Shawn Wayne · Cheyenne, WYBuilt 1978 · S/N 18266502N94757Deters John Lloyd · Spring Grove, MNBuilt 1978 · S/N 18266504N9475CGlover Street Investors LLC · Winthrop, WABuilt 1955 · S/N 31873N9475EBerzinis Wayne T · Windham, MEBuilt 1979 · S/N 17272275N9475FLewis Steve · Canyon, TXBuilt 1998 · S/N 18280153N9475MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700695N9475RVon Imhof Rudi F · Anchorage, AKBuilt 1985 · S/N U20606872N9475UGerlach Brett C · American Fork, UTBuilt 1976 · S/N 15078423N9476AFoust Kal E · Lenox, MIBuilt 1950 · S/N 15471N9476BHigher Calling LLC · Johnstown, COBuilt 1958 · S/N 55276N9476FF & M Miya LLC · Hanford, CABuilt 1998 · S/N 18280208N9476HHelicopter Partners Inc · Wellington, FLBuilt 1975 · S/N 17266172N9476TRegistered aircraftSale reportedBuilt 1960 · S/N 57276N9476USantos Enderson Rafael Teixeira Dos · Aledo, TXBuilt 1976 · S/N 15078424N9476XMcdonald Air LLC · Indianapolis, INBuilt 1985 · S/N 18268536N94772Kamal Rafi · Mountain View, CABuilt 1978 · S/N 18266507N9477ATriesenberg Stephanie · Grand Rapids, MIBuilt 1949 · S/N 15298N9477BMilson Stuart A · Midlothian, TXBuilt 1958 · S/N 55277N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562N9477URegistration Pending · Delta Junction, AKRegistration pendingBuilt 1976 · S/N 15078425N9478EColeman Richard · Menominee, MIS/N 17272276N9478GExecutive Security Solutions LLC · Moody, ALBuilt 1974 · S/N 18263397N9478T4cl Inc · Wilmington, DEBuilt 1960 · S/N 57278N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679N947AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13565N947CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281974N947ETGranite State Aerial Topography LLC · Wolfeboro, NHBuilt 1973 · S/N U20602271N947VATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13491N94800Trick Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18266512N9480BAlexis Aviation LLC · Greenwell Springs, LABuilt 1958 · S/N 55280N9480DKent State University · Stow, OHBuilt 1985 · S/N 172RG1180N9480EMoyer Aviation Inc · Tobyhanna, PABuilt 1979 · S/N 17272277N9480HMoynihan Patrick J · Lakeville, MNBuilt 1975 · S/N 17266173N9480UColeman Stephen A · Wakefield, RIBuilt 1976 · S/N 15078428N94810Kaski Brian · Battle Ground, WABuilt 1978 · S/N 18266515
Back to AD 79-10-14 R1