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.

N62350Flycarolina LLC · Concord, NCBuilt 1981 · S/N 17275255N62354Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275256N6235AStewart Madison F Co Personal Representative · Broken Arrow, OKS/N 33035N6235ELee William Lewis · Gilbert, AZS/N 46335N6235KCall One Inc · Clarinda, IABuilt 1975 · S/N 15077602N6235SRudnik Zachary A · Minto, NDBuilt 1967 · S/N 15067035N6235TCrystal Air Inc · Chattanooga, TNBuilt 2008 · S/N 17281515N6236MJlkd LLC · Lewes, DEBuilt 2008 · S/N 18282075N6237ESale Reported · Brandon, MSSale reportedS/N 46337N6237FPerea Joseph R · Albuquerque, NMBuilt 1975 · S/N 18264139N6237RBorden Jonathan Wilfred · Londonderry, NHS/N 15061537N6237TReinhardt Larry L · Clackamas, ORBuilt 1964 · S/N 15060937N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303N6238AExecutive Flight Institute LLC · Murrieta, CABuilt 2008 · S/N 172S10702N6238RRegistration Pending · Preston, IDRegistration pendingBuilt 1965 · S/N 15061538N6238TLocklear Benjamin M · Mangum, OKBuilt 1964 · S/N 15060938N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393N6239APara Plane Aviation Inc · Thomasboro, ILS/N 33039N6239DAerial Precision LLC · Entiat, WAS/N 17272657N6239EKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1958 · S/N 46339N6239FEckert Ted · Cedar Creek, TXBuilt 1979 · S/N 17273172N6239RBala Engineering Pllc · Hawkins, TXBuilt 1965 · S/N 15061539N6239TEvans Cliff D · Boulder Creek, CAS/N 15060939N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304N623APHartman Michael F · Montclair, CABuilt 1969 · S/N 15070915N623DWHtft LLC · Las Vegas, NVS/N 18281094N623EPApex Aviation LLC · Exeter, NHBuilt 1975 · S/N 18052616N623EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13097N623HBRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12397N623KWLanier Equipment Leasing LLC · Gainesville, GABuilt 2013 · S/N 172S11269N623RTTextron Aviation Inc · Wichita, KSS/N 18283363N623SPAtp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 172S8614N623UTTextron Aviation Inc · Wichita, KSS/N 18283362N623WTChasteen Tom · Tavernier, FLBuilt 1963 · S/N 205-0328N62400Henline Matthew · Honolulu, HIBuilt 1972 · S/N 18261290N62405Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17275263N62407Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275264N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718N6240EDgcg Properties LLC · Casa Grande, AZBuilt 1959 · S/N 46340N6241AAerial Messages Leasing Co · Longwood, FLBuilt 1956 · S/N 33041N6241ERuijne Leo L · Plainview, TXS/N 46341N6241FBucks Mont Masonry Inc · Green Lane, PABuilt 1975 · S/N 18264141N6241NSt Croix Recreation LLC · Mulberry, FLS/N 18267807N6241RHayhurst Shane R · Winfield, PABuilt 1965 · S/N 15061541N6241TArm 4 Aviation LLC · Blanchard, IABuilt 1964 · S/N 15060941N62425Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 17275267N62429Fowler Cary D · Hayti, MOBuilt 1981 · S/N 17275268N6242EDenson Randy A · Meridian, IDBuilt 1958 · S/N 46342N6242FAzul Services LLC · Bozeman, MTBuilt 2008 · S/N 172S10701N6242GSpencer Aviation Inc · Delaware, OHBuilt 1970 · S/N 15071742
Back to AD 79-10-14 R1