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.

N75SFKlein Neal S · Newberg, ORBuilt 1969 · S/N 18259658N75SMSummit Aviation Adventures LLC · Fairplay, COBuilt 1963 · S/N 18254675N75TCMorales Luis · Florence, ORBuilt 1977 · S/N 17268913N75TRHale Mitchell D · Chugiak, AKS/N 18502790N75USJbh Air LLC · Kent, WABuilt 2000 · S/N 18280925N75VAPfingsten Thomas H · Peachtree City, GABuilt 1968 · S/N 18051936N75WCCedar Valley Air LLC · Lehi, UTS/N 15076045N75WGHenry David Greer Sr · Waco, TXBuilt 1978 · S/N 18266297N75YAHayes David M · Edgewood, TXBuilt 1965 · S/N 21058665N7600HArslanian Brian Haroutun · Brookhaven, GABuilt 1972 · S/N 18261288N7600JBuchanan Jamie · Deforest, WIBuilt 1976 · S/N 18264689N7600MTitan Construction LLC · Pinedale, WYBuilt 1959 · S/N 55900N7600NKeller Douglas O · West Linn, ORBuilt 1977 · S/N U20603704N7600TXin Han Aviation LLC · Atwater, CABuilt 1960 · S/N 47200N7600VRegistration Pending · Phillipsburg, KSRegistration pendingBuilt 1976 · S/N 177RG0886N7600XDemurat Bryan F · Casselberry, FLBuilt 1960 · S/N 17248100N76015Aldea Aviation Partners LLC · Encino, CABuilt 1976 · S/N 17268091N76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeBuilt 1976 · S/N 17268092N76019Grimley Robert J · Palermo, NJS/N 17268093N7601ACranor Clayton · North Pole, AKS/N 32498N7601GWright Carl E · Conesville, OHS/N 17259301N7602GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259302N7602SLarson Peter M Trustee · Antioch, ILBuilt 1976 · S/N 18265250N7602TColeman David R · Limerick, MEBuilt 1959 · S/N 47202N7602XBurkett Anthony E · Rock Hill, SCS/N 17248102N76032Brown Jeffrey A · Wellington, ALBuilt 1976 · S/N 17268097N7603ANoble Raymond D · East Windsor, CTBuilt 1956 · S/N 32500N7603GFelstead R Keith Trustee · Medina, NYBuilt 1970 · S/N 17259303N7603SBobcat Trucking Inc · New Braunfels, TXBuilt 1976 · S/N 18265251N7603TMurphy Brian K · La Crosse, WIFirst renewal noticeS/N 47203N76044Williams Cecil R · Clarksville, TNBuilt 1976 · S/N 17268101N76047Registration Pending · Muskogee, OKRegistration pendingBuilt 1976 · S/N 17268103N7604FKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1979 · S/N 17273262N7604MVaughn David Rex · Spur, TXBuilt 1959 · S/N 55904N7604SCloud Nine Management LLC · Orlando, FLBuilt 1976 · S/N 18265252N7604TWestern Nebraska Technical College · Scottsbluff, NEBuilt 1960 · S/N 47204N7604UWings Flight Enterprises Inc · Danville, KYBuilt 1975 · S/N 15077766N76053Ape LLC · Birmingham, ALBuilt 1976 · S/N 17268106N76056Bormuth Alan R · Morganton, NCBuilt 1976 · S/N 17268108N7605FPromise Road Aviation Inc · Pendleton, INBuilt 1979 · S/N 17273263N7605SAdco Land Corp · Richmond, VABuilt 1976 · S/N 18265253N7605URyan Air Inc · Anchorage, AKBuilt 1978 · S/N 20700443N7605XCastleberry Robert F · Sanford, NCS/N 17248105N7606MDellechaie Frank · South Lake Tahoe, CABuilt 1959 · S/N 55906N7606SAnthony Judith A Trustee · Kerrville, TXBuilt 1976 · S/N 18265254N7606TFord Edsel W · Mustang, OKBuilt 1959 · S/N 47206N7606VDahdah Kurt J · Agawam, MABuilt 1977 · S/N R1722311N7606XRegistered aircraftS/N 17248106N76076Elite Airplanes LLC · Fort Myers, FLS/N 17268114N7607EPowerbelt LLC · Glendale, CABuilt 1978 · S/N 17272115
Back to AD 79-10-14 R1