OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeBuilt 1965 · S/N 18051539N273CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282354N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732N273TYRaven Aviation LLC · Lexington, KYBuilt 1965 · S/N 15061468N2740CKangas Michael C · Big Lake, AKS/N 26284N2740LLightsey Aviation LLC · Jacksonville, FLS/N 17255940N2740UHarowicz Richard J · Mountain Top, PABuilt 1963 · S/N 17250340N2740VTheo Enterprises LLC · New Castle, DEBuilt 1975 · S/N 177RG0677N2741CGifford Gary W · Lighthouse Point, FLBuilt 1954 · S/N 26285N2741DGott Michael C · Fairbanks, AKBuilt 1952 · S/N 25283N2741UNickel Aviation LLC · Williamstown, NJBuilt 1963 · S/N 17250341N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284N2742LFisher Corey · Ardmore, OKBuilt 1967 · S/N 17255942N2742QKibler James · Indialantic, FLBuilt 1967 · S/N 18257942N2742UPembroke Farm LLC · Conowingo, MDBuilt 1963 · S/N 17250342N2742XCallaway Scott T · Soldotna, AKBuilt 1965 · S/N 18051542N2743C43charlie LLC · Nicollet, MNBuilt 1954 · S/N 26287N2743DBoies Ranch Inc · Wells, NVS/N 25285N2743FRiddle Danny M Trustee · Ruby Valley, NVBuilt 1965 · S/N 18256843N2743GFleetwood Jack · Hutto, TXBuilt 1959 · S/N 52043N2743JColman Scott · Tampa, FLBuilt 1976 · S/N 21061690N2743LBarnes Earl E · Live Oak, FLBuilt 1967 · S/N 17255943N2743QSzigeti David J · Gaylordsville, CTBuilt 1967 · S/N 18257943N2743UArmstrong John Kyle · Lovington, NMBuilt 1963 · S/N 17250343N2743XErb Weston Scott Trustee · Wasilla, AKBuilt 1965 · S/N 18051543N2744DTaylor Rock P · Wasilla, AKBuilt 1952 · S/N 25286N2744FTyson Jacob N · Molena, GABuilt 1965 · S/N 18256844N2744GShelton Jeffrey A · Denali Park, AKS/N 52044N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644N2744KLucas Greg C · Elmore City, OKS/N 18053057N2744UFladager Daryl W · Peerless, MTS/N 17250344N2744WWilhelm LLC · Denver, COFirst renewal noticeBuilt 2004 · S/N 172S9644N2745JRegistered aircraftBuilt 1974 · S/N A1500581N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586N2745QAero Docs LLC · Butte, MTBuilt 1967 · S/N 18257945N2745SGobble Larry L · Williamson, GABuilt 1967 · S/N 15066645N2745UMidfield Aviation LLC · Caldwell, IDBuilt 1963 · S/N 17250345N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587N2746DWheeler Evan L · North Pole, AKBuilt 1952 · S/N 25288N2746GMchugh Rick M · Enumclaw, WABuilt 1959 · S/N 52046N2746JGelatt Joseph · Wasilla, AKS/N A1500582N2746LBeavers Timothy · Charlotte, NCBuilt 1967 · S/N 17255946N2746SBryant Stan M · Derby, KSBuilt 1967 · S/N 15066646N2747CBirtic George J · Belgrade, MTS/N 26291N2747DFrei Russell M · Grangeville, IDBuilt 1952 · S/N 25289N2747JRamstad Phillip J Trustee · Anchorage, AKBuilt 1969 · S/N 185-1497N2747LGuistwhite Brian K · Etters, PABuilt 1967 · S/N 17255947N2747QMosier Michael J · Kalamazoo, MIBuilt 1967 · S/N 18257947N2747RWilliams Dwight M · Paragould, ARS/N 18280343
Back to AD 79-10-14 R1