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.

N8019BColonial Air Inc · New Bedford, MAS/N 29819N8019FLyman Kenneth R · Livermore Falls, MEBuilt 1966 · S/N 15064119N8019LSleeping Giant Flying Club Inc · Helena, MTBuilt 1967 · S/N 17256219N8019XWarren Edwin W · East Dorset, VTBuilt 1961 · S/N 17248519N8019ZGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1965 · S/N U206-0419N801ALWestbank Fishing LLC · Kiln, MSBuilt 2000 · S/N 18280767N801EPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13591N801PAAnson Air LLC · Sugar Land, TXBuilt 2008 · S/N 17281518N801TCSturgeon N C · Midland, TXBuilt 2000 · S/N 20608103N801THSouth Dakota State University · Brookings, SDBuilt 2022 · S/N 172S12801N801XPAmel Donald · Burleson, TXBuilt 1979 · S/N R1723200N80202Barber Chester M · Haleyville, ALBuilt 1975 · S/N 17266442N80205Olear Inc · Evansville, INS/N 17266444N80208High Country Aviation LLC · Lyman, WYBuilt 1975 · S/N 17266446N8020AOakleaf Dan L · Hartford, SDBuilt 1952 · S/N 20872N8020TVintage Aero LLC · Brownwood, TXBuilt 1960 · S/N 56720N80210Atlanta Air Academy LLC · Kennesaw, GABuilt 1975 · S/N 17266448N80213N80213 LLC · Wilmington, DEBuilt 1975 · S/N 17266449N80214Delta Capital Inc · Blair, NEBuilt 1975 · S/N 17266450N80218Tom Hassenfritz Equipment Co Inc · Mount Pleasant, IABuilt 1975 · S/N 17266453N8021SKoehn Mark W · Elkader, IAS/N 15061621N8021TSale Reported · Irvine, CASale reportedBuilt 1960 · S/N 56721N8021XPatterson Roland O · Semmes, ALBuilt 1961 · S/N 17248521N80229Fischer Alfred M DBA · Genoa City, WIS/N 18503105N8022ABackus John · Norton Shores, MIBuilt 1952 · S/N 20874N8022GAaron Arthur Harrison · Gold River, CABuilt 1970 · S/N 177RG0022N8022XAzzalin Giorgio · Jacksonville, FLBuilt 1953 · S/N 30637N80230Fly Nh Aviation LLC · Bow, NHBuilt 1975 · S/N 17266461N80238Hess Garrett J · Fullerton, CABuilt 1975 · S/N 17266466N80239Borreson Anthony · Mariposa, CABuilt 1975 · S/N 17266467N8023SBalles Jeffrey J Sr · Hunker, PABuilt 1965 · S/N 15061623N8023TKown Phyllis L · Hamilton, ALBuilt 1960 · S/N 56723N80246Lincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17266473N80248Mtm Deland LLC · Deland, FLBuilt 1975 · S/N 17266475N8024BHatchie River Aviation LLC · Kalispell, MTS/N 29824N8024GRedwing Aviation LLC · San Antonio, TXBuilt 1970 · S/N 177RG0024N8024SOmlid Robert L · Watford City, NDBuilt 1965 · S/N 15061624N8024XRay Jonathan S · Richland, WABuilt 1961 · S/N 17248524N80251Harrison Social Flites Inc · Harrison, OHBuilt 1975 · S/N 17266477N80254On Glideslope LLC · Middletown, DEFirst renewal noticeBuilt 1975 · S/N 17266479N80256Dew Farms Inc · Ulysses, KSS/N 18503109N8025EMission Aviation Fellowship · Nampa, IDBuilt 1978 · S/N 17272119N8025FFurlong Kelly L · Athens, ALBuilt 1966 · S/N 15064125N8025GN8025g C177rg LLC · Jeffersonville, INBuilt 1970 · S/N 177RG0025N8025SBranch Timothy · Russellville, ARBuilt 1965 · S/N 15061625N8025TAerial Advertising Services · San Jose, CAS/N 56725N80263Breton Yacht Co LLC · Schenectady, NYBuilt 1975 · S/N 17266484N80267Bisson James H · Piercefield, NYBuilt 1975 · S/N 17266486N8026FCardoza Bren J · Port Hueneme, CABuilt 1966 · S/N 15064126N8026LSayers Carl D · Vidalia, LABuilt 1967 · S/N 17256226
Back to AD 79-10-14 R1