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.

N8447XHill Gregory J · York, PABuilt 1961 · S/N 17248947N8447ZKorenko Kirk A · Granite Bay, CABuilt 1963 · S/N 205-0447N84488Wheeler Michael T · Chicago, ILBuilt 1973 · S/N 18261872N84489Rinkenback Keven H · Kailua-Kona, HIBuilt 1970 · S/N 17258491N8448GMidwest Aviation Services LLC · Kendallville, INBuilt 1965 · S/N 15062548N8448MMohamed Jaleel · Dallas, TXBuilt 1969 · S/N A1500148N8448UGillis Christopher Paul · Fredericksburg, VABuilt 1964 · S/N 17252348N8448XPritchard Jason T · Blaine, WAS/N 46615N84492Robinson William D · Greer, SCBuilt 1973 · S/N 18261874N84497N84497 LLC · Omaha, NEBuilt 1974 · S/N 18801989TN8449EJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272204N8449JSchaff James F · Gakona, AKBuilt 1967 · S/N 15066349N8449MCopper River Airmotive LLC · Copper Center, AKBuilt 1969 · S/N A1500149N8449SHollensbe Brant W · West Des Moines, IABuilt 1965 · S/N 18256549N844KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12810N844PTPatterson James M · Eagle, IDBuilt 1972 · S/N 17261129N84507Weston Marcia K · Palestine, TXBuilt 1973 · S/N 18261881N84508Goodwin Reginald J O · Clancy, MTBuilt 1973 · S/N 18261882N8450EWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17272205N8450LElghammer Garrott W · Niles, MIBuilt 1968 · S/N 17256650N8450MChoquette Marc J · Juneau, AKBuilt 1969 · S/N A1500150N8450UJust-Plane-Fun LLC · Searcy, ARBuilt 1964 · S/N 17252350N84510Levine Peter D · Bisbee, AZBuilt 1969 · S/N 17258503N84511Lands Brian Lee · Blacklick, OHBuilt 1969 · S/N 17258504N84515Abbott Sean N · South Paris, MES/N 17258507N84518Ropp Dennis A · Albany, ORS/N 17258509N8451MDelalat Shariar · San Diego, CABuilt 1970 · S/N A1500151N8451QRunway Three Aviation LLC · Kalispell, MTBuilt 1976 · S/N U20603309N8451TTop Hand Inc · Laurel, MTBuilt 1959 · S/N 52351N8451XHorn Jamie D · Spicewood, TXBuilt 1961 · S/N 17248951N8451ZHagelstein Ele C · Sanderson, TXBuilt 1963 · S/N 2050451N84529Eckert Philip · Paso Robles, CABuilt 1969 · S/N 17258512N8452LParr Terri M · Catlin, ILBuilt 1968 · S/N 17256652N8452MHigh Flight LLC · Mount Pleasant, SCS/N A1500152N8452THarris Jerry A · Nampa, IDBuilt 1959 · S/N 52352N8452UGibson Gregory I · Ivel, KYS/N 17252352N8452XLas Gaviotas 409 LLC · Safford, AZBuilt 1961 · S/N 17248952N84531Northumberland Flying Club Inc · Gansevoort, NYBuilt 1969 · S/N 17258513N8453GBelue Gaythan D · Rogersville, ALBuilt 1965 · S/N 15062553N8453MWard Charles B · Salcha, AKBuilt 1976 · S/N 18264608N8453SHarvey Paul E · Richmond, MES/N 18256553N8453TSheridan Keith · Ottawa, ILBuilt 1959 · S/N 52353N8453USappah Guy · Lusby, MDBuilt 1964 · S/N 17252353N84541Stack Kenneth J · Carnegie, PABuilt 1969 · S/N 17258516N84544Cruz Pedro · Tampa, FLBuilt 1969 · S/N 17258517N8454MSp Leasing LLC · San Jose, CABuilt 1976 · S/N 18264609N8454ZParker Larry C · Roswell, NMBuilt 1963 · S/N 205-0454N8455JBentz Jack E · Huntington, WVBuilt 1967 · S/N 15066355N8455LYoumans Ronald E · Baxley, GABuilt 1968 · S/N 17256655N8455SWhite Noah Jay · Prairie Du Chien, WIBuilt 1965 · S/N 18256555
Back to AD 79-10-14 R1