OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3358JBlue Chip Enterprises Inc · Clayton, NCBuilt 1967 · S/N 15066058N3358RHaydukovich Steven J · Phoenix, AZBuilt 1967 · S/N 18258658N3358UBratcher Michael · Elizabethtown, KYS/N 18254758N3359FHughes John · Almira, WABuilt 1966 · S/N 18257359N3359JGaler Charles J · Irvington, ALBuilt 1967 · S/N 15066059N3359TDuquette Robert R · Elfrida, AZS/N 17700659N3359VArcher Lee R · Redondo Beach, CABuilt 1974 · S/N 15076473N335JCAlexander Melodie A · Lees Summit, MOBuilt 1956 · S/N 28785N335MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12879N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495N3360FLane Glen Allen Jr · Cocoa, FLBuilt 1966 · S/N 18257360N3360JStewart Roger · Lenexa, KSBuilt 1967 · S/N 15066060N3360RRoschi Nancy L · Stevensville, MTBuilt 1975 · S/N 18502874N3360SMohler Earl C · Bonita, CAS/N 21059160N3360UBailes Ernest J IV · Shepherd, TXBuilt 1963 · S/N 18254760N3360YFoote Jerry O · Unadilla, NYFirst renewal noticeBuilt 1962 · S/N 18254360N3361DDe Lint Marcus W · Cove, ORBuilt 1955 · S/N 32159N3361ROlson Bartlet · Merrimac, WIBuilt 1967 · S/N 18258661N3361TPew Aaron · Mesa, AZS/N 17700661N3361UKelleher Chuck W · Shelby, MTBuilt 1963 · S/N 18254761N3362FMunoz Mario · Scottsboro, ALBuilt 1966 · S/N 18257362N3362JLivingston Rod W · Tuttle, NDBuilt 1967 · S/N 15066062N3362RLight Jeffrey D · Woodville, VABuilt 1967 · S/N 18258662N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662N3362UGilliland Mcclaflin Wayne D · Powell, WYBuilt 1963 · S/N 18254762N3363DTodd Michael E · Yelm, WABuilt 1955 · S/N 32161N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518N3363REagles Flight LLC · Grove, OKBuilt 1967 · S/N 18258663N3363YCamlik Air LLC · Wausau, WIBuilt 1978 · S/N 21063145N3364DKtr Aviation LLC · Evans, COS/N 32162N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519N3364FCrouch Jeffrey Lane Jr · Grimesland, NCBuilt 1966 · S/N 18257364N3364JSlawski Michael E · Tucson, AZBuilt 1967 · S/N 15066064N3364SAir Deeken Ltd · Doylestown, OHBuilt 1969 · S/N 21059164N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664N3364UPalladino Frank · Castleton, NYBuilt 1963 · S/N 18254764N3364YSpeth Peter P · Peru, INBuilt 1962 · S/N 18254364N3365FTimlor Inc · Warrenton, ORBuilt 1966 · S/N 18257365N3365SWinger Cattle Co Inc · Johnson, KSBuilt 1969 · S/N 21059165N3366PLccc Enterprises Inc · Jupiter, FLBuilt 1966 · S/N 18257084N3366ST R Webster And Son Inc · Rexburg, IDBuilt 1969 · S/N 21059166N3366UAbraham Alan · Pilot Point, TXS/N 18254766N3366VMason Dave Q · San Marcos, CABuilt 1977 · S/N R1722251N3366YCrawford Stephen E · Corinth, TXS/N 18254366N3367RRegistered aircraftS/N 18502875N3367SSierra Co Llp · Wendell, IDBuilt 1973 · S/N 18502280N3367UKellogg David J · Marshall, MIS/N 18254767
Back to AD 79-10-14 R1