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.

N64AFVermont Flight Academy · South Burlington, VTBuilt 1997 · S/N 17280069N64AJN64aj LLC · Winterset, IAS/N 18052364N64BBBlazey Brian I · Palmyra, NYBuilt 1967 · S/N 15066150N64CASwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 17275269N64CVValle Richard · Wellington, FLBuilt 1963 · S/N 205-0508N64DBFyrberg Forest M · Oakland, MES/N 180-52084N64EFHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17262871N64JAJet Air Inc · Iowa City, IABuilt 2001 · S/N 17281065N64PDPapa Delta LLC · Eddyville, KYBuilt 1979 · S/N 17272996N64PWM&G Aircraft Management LLC · Aurora, ORBuilt 2024 · S/N 172S13212N64RBBurnett Ramon R · Alpine, CABuilt 1968 · S/N 18258811N64RKKoril Richard A · Overgaard, AZBuilt 1964 · S/N 18255686N64SN81c Corp LLC · Wilmington, DES/N P3370179N64SFSafe Flight Instrument Corp · White Plains, NYBuilt 1977 · S/N 17268706N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345N64TJRcs Farms Inc · Hereford, TXBuilt 1975 · S/N 18264148N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959N64WGM&G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12753N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666N65006Delvalle Enterprises Inc · Sandpoint, IDBuilt 1957 · S/N 34597N6500ASwartz Walter J · Hadley, MABuilt 1957 · S/N 32397N6500FMoore Howard W · Camden, TNBuilt 1966 · S/N 15063100N6500SSpitfire USA Ltd · Rockville, MDBuilt 1967 · S/N 15067300N6501ERobinson James W · Henderson, NVBuilt 1959 · S/N 56001N6501FHoward James S · Arlington, TXS/N 15063101N6501TPuls Eric S · Ft Rucker, ALBuilt 1960 · S/N 17901N6501XFisher John P · Surprise, AZBuilt 1960 · S/N 57501N6501YLively Charters Inc · Summerland Key, FLBuilt 1981 · S/N 21064412N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670N65025Killian Larry D · Hampton, ARS/N R172-0123N6502SPetrosyan Joseph · Rancho Cordova, CABuilt 1967 · S/N 15067302N65032Vavrek Holly Kay · Palm City, FLBuilt 1982 · S/N 17275672N6503ABrown Paul N · Eustace, TXBuilt 1956 · S/N 32400N6503DManubay John M · Sinking Spring, PABuilt 1979 · S/N 17272834N6503EDos Disparos LLC · Shallowater, TXBuilt 1984 · S/N 18268371N6503FStockton Ketron J · Bulls Gap, TNBuilt 1973 · S/N A1500446N6503SElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1967 · S/N 15067303N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736N65040Mc Creery Aviation Co Inc · Mcallen, TXS/N 17275673N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674N6504EDietrich Robert R · Elizabeth, COBuilt 1980 · S/N 18504051N6504GHoward David D · Winner, SDBuilt 1970 · S/N 15072004N6504MSobien Andrew J III · Mountain Home, IDBuilt 1975 · S/N 18263734N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678N6505AKenmonth Craig M · Fairbanks, AKBuilt 1956 · S/N 32402N6505EHeman Darrick L · Blue Springs, MOBuilt 1959 · S/N 56005N6505FCoffman Curtis M · Lakeside, ORBuilt 1966 · S/N 15063105
Back to AD 79-10-14 R1