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.

N94901Liberty University · Lynchburg, VABuilt 2013 · S/N 172S11273N94908Robert E Carroll Logging Inc · Ebony, VAS/N 18266531N9490CBell Scott Walker · Greeley, COBuilt 1955 · S/N 31888N9490DMehrer Fritz J · El Cajon, CAS/N 172RG1185N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177N9490XStrode Farms Inc · Owensboro, KYBuilt 1985 · S/N 18268538N9490YKearins John M · North Hampton, NHBuilt 1969 · S/N 20700110N94916Milne Dave · Snohomish, WABuilt 1978 · S/N 18266534N94918Urfer Kenneth M · Sparks, NVBuilt 1978 · S/N 18266535N9491AWonder Aviation LLC · Nashville, TNBuilt 1950 · S/N 15559N9491BGuess Jonathan M · Pineville, LABuilt 1958 · S/N 55291N9491CTerhune Keith B · Crosby, TXS/N 31889N9492BPack Charles · Millington, TNBuilt 1958 · S/N 55292N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178N94937Kidder Robert S · Burlington, KYBuilt 1978 · S/N 18266539N94938Kalaiselvan Arunram · Richland, GAS/N 18266540N9493ABrooks Charles W Jr · Hesperia, CABuilt 1949 · S/N 15314N9493BRowe Chad A · Fairbanks, AKBuilt 1958 · S/N 55293N9493CBlue Thunder LLC · Ketchum, IDBuilt 1955 · S/N 31891N9493TCorwin Bert C · Rapid City, SDBuilt 1960 · S/N 57293N9493XAce Pools · Choctaw, OKS/N 18268539N9493ZCcf Ventures Inc · Bangor, MEBuilt 1981 · S/N U20606527N94940Shurley Billy R · Cabot, ARBuilt 1978 · S/N 18266541N94944Jav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266542N94946Van Duzer John P · Alpine, CABuilt 1978 · S/N 18266544N9494ASmiley Neil G · Clover, VABuilt 1950 · S/N 15475N9494LRegistration Pending · French Village, MORegistration pendingS/N 57294N9494NMaine Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1981 · S/N 18504365N9494UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078442N9495BFry John W · Vinita, OKBuilt 1958 · S/N 55295N9495DEichholz Kenneth D · Cordova, TNBuilt 1985 · S/N 172RG1187N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180N9495XLafranchi Logan Michael · Calistoga, CABuilt 1961 · S/N 21057795N9496APrice Robert M · Seattle, WAS/N 15317N9496CGust Dale A · Boise, IDBuilt 1955 · S/N 31894N9496HKoropp Michael L · Anchorage, AKBuilt 1977 · S/N 18503442N9496MRegistered aircraftBuilt 1970 · S/N 21059396N9496THudson Willis C · Hendersonville, NCBuilt 1960 · S/N 57296N9496XPaz Nicolas · La Verne, CABuilt 1961 · S/N 21057796N9497EAivcon Inc · Charlevoix, MIBuilt 1984 · S/N 18268420N9497MJomama Aviation LLC · Kalispell, MTBuilt 1970 · S/N 21059397N94986United States Air Force (Owner) · Usaf Academy, COBuilt 1978 · S/N 18266552N9498AEvans Earl J · Oglethorpe, GABuilt 1949 · S/N 15319N9498BKluenker Charles H · Roseville, CABuilt 1958 · S/N 55298N9498EBowker Neal H · Tucson, AZS/N 18263915N9498GSak III LLC · Miller, SDS/N 18801503TN9498MVoorhies Jon · Atascadero, CABuilt 1970 · S/N 21059398N9498YRamsgate Ltd · Sedalia, COBuilt 1981 · S/N 21064522N94992Mac Air Corp · Benton, KSBuilt 2013 · S/N 18282359N94993Meyer Michael S · Marietta, GABuilt 1978 · S/N 18266556
Back to AD 79-10-14 R1