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.

N71675Sea To Summit Aero LLC · Mertzon, TXBuilt 1969 · S/N 18259713N71678Mitchell Flying Service LLC · Cushing, OKBuilt 1969 · S/N 18259714N7167ATucker Tim · Hopkinsville, KYBuilt 1956 · S/N 29267N7167FSteinhoff Daniel P · Santa Rosa, CABuilt 1966 · S/N 15063767N7167XMckissack Douglas R · Pooler, GABuilt 1961 · S/N 15059267N71685Hamilton Thomas S DBA · Priest River, IDBuilt 1969 · S/N 18259718N7168ERampton Curtis D · Reno, NVBuilt 1959 · S/N 52168N7168GDurbin John W · Lovington, ILBuilt 1969 · S/N 17258868N7168MWindh Steven R · Reedley, CABuilt 1958 · S/N 55468N7168SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15067868N71699Grit Ventures LLC · Throckmorton, TXBuilt 1969 · S/N 18259722N7169TBrent Ephron D · Arriba, COBuilt 1959 · S/N 46769N716CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281711N716EPEpic Flight Academy Inc · New Smyrna Beach, FLBuilt 2016 · S/N 172S11728N716HPState Of Ohio · Columbus, OHBuilt 2005 · S/N 18281581N716LULiberty University · Lynchburg, VABuilt 2012 · S/N 172S11180N716MCWing & A Prayer LLC · Wilmington, DEBuilt 2005 · S/N 18281717N716MTColvin Mariann · Round Rock, TXBuilt 2001 · S/N 18281037N716MWDirty Side Down Aviaton LLC · Georgetown, TXBuilt 2000 · S/N 17280871N716PCPcfo Air LLC · Plymouth, MNBuilt 2021 · S/N 18283159N716SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12557N716SPExec 1 Aviation II LLC · Ankeny, IABuilt 2000 · S/N 172S8645N716THFairmont State University · Fairmont, WVBuilt 2017 · S/N 172S12008N71705Wilson Alfred C · Salisbury, NCBuilt 1969 · S/N 18259724N7170EMcknight Thomas N · Fredericksburg, TXBuilt 1959 · S/N 52170N7170GSs Skyways LLC · Becker, MNBuilt 1969 · S/N 17258870N7170XMccardle Guy D · Burnham, PABuilt 1961 · S/N 15059270N71710Warp Six Aviation LLC · Manitowoc, WIBuilt 1969 · S/N 18259725N7171EPhillips John · Vernal, UTBuilt 1959 · S/N 52171N7171QMcnamara Bradley W · Seattle, WABuilt 1972 · S/N 17260471N7171SGuerra Carrie E · Lompoc, CABuilt 1976 · S/N 18265077N71726Mayes John · Carson City, NVBuilt 1969 · S/N 18259730N7172EGibson James T · Brookhaven, MSBuilt 1959 · S/N 52172N7172QRounds Agronomy LLC · Pierre, SDS/N 17260472N7172SLovaas Darryl G Trustee · Crescent City, CABuilt 1967 · S/N 15067872N71731Brisson Michael Paul · Enterprise, ALBuilt 1969 · S/N 18259733N71735Dinota Dominick · Wallkill, NYBuilt 1969 · S/N 18259735N71736Nixon Leland Bryan · Stapleton, ALBuilt 1969 · S/N 18259736N7173ADuke Billy L · Ormond Beach, FLBuilt 1956 · S/N 29273N7173EMcpherson David R · Sturgis, SDBuilt 1959 · S/N 52173N7173GSale Reported · Haiku, HISale reportedBuilt 1969 · S/N 17258873N7173MCronin Larry D · Mountain Home, IDBuilt 1958 · S/N 55473N7173QWesterly Av Group LLC · Westerly, RIS/N 17260473N7173TDidier Thomas · Port Washington, WIS/N 46773N71748Altom Marvin L · Reno, NVS/N 18259737N7174ESuazo Tito L · Glendale, AZBuilt 1959 · S/N 52174N7174GMaloney John T · Deer Park, NYBuilt 1969 · S/N 17258874N7174SBelasco Thomas D II · Bridgeport, WVBuilt 1967 · S/N 15067874N7174TPaddock Spencer · Palmer, AKBuilt 1960 · S/N 46774N7174XMcdaniel John P III · Marianna, FLS/N 15059274
Back to AD 79-10-14 R1