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.

N3843VKown W B · Hamilton, ALBuilt 1949 · S/N 18730N3844QSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 17259944N3844YManarin Roland R · Lakemont, GABuilt 1964 · S/N 21058344N3845DTeam Gateway LLC · Lewes, DEBuilt 1957 · S/N 34545N3845QMacon Flying Club Inc · Macon, MOBuilt 1971 · S/N 17259945N3845RDelaney Patrick James · Marion, TXS/N 17255341N3845Y1st Due Emergency Response Solutions LLC · Bartlett, KSS/N 21058345N3846DAshiku Phillip · Ukiah, CABuilt 1957 · S/N 34546N3846LElicker Sheldon L · Auburn, CABuilt 1966 · S/N 17254015N3846RSampson Corey · Newnan, GABuilt 1966 · S/N 17255346N3846VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1949 · S/N 18733N3847DPrice David W · Lynn Haven, FLBuilt 1957 · S/N 34547N3847JEscue James C · Brownsville, TNBuilt 1966 · S/N 15065147N3847YLee Justin W · Maud, TXBuilt 1964 · S/N 21058347N3848LHarrod Group Inc · Ellaville, GABuilt 1966 · S/N 17254017N3848QWestwind Flyers LLC · Friday Harbor, WABuilt 1971 · S/N 17259948N3848RGunter Jeffrey W · Demorest, GAS/N 17255348N3849DMellor Bradford A · Spanish Fork, UTS/N 34549N3849JGamble Marty · Crofton, KYBuilt 1966 · S/N 15065149N3849QSmetana Louis V III · Blair, NEBuilt 1971 · S/N 17259949N3849RSims Charles H · Soldotna, AKBuilt 1966 · S/N 17255349N3849UKashi Joseph L · Soldotna, AKBuilt 1963 · S/N 336-0149N3849VPaulas Daniel · Petaluma, CAS/N 18736N384MCAero-Tech Services Inc · Lancaster, PABuilt 2007 · S/N 172S10438N384MESj Flyers LLC · San Jose, CABuilt 2000 · S/N 172S8569N384MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605272N3850RKelley Patrick W · Charlo, MTBuilt 1966 · S/N 17255350N3850SFoss Sterling D · Basin, WYBuilt 1963 · S/N 17251050N3850VFlorida Air Tours Inc · Merritt Island, FLBuilt 1949 · S/N 18737N3850YPoole Vernon N · Melstone, MTBuilt 1964 · S/N 21058350N3851DSale Reported · Darby, MTSale reported, pending cancellationBuilt 1957 · S/N 34551N3851UMcintyre Lester Blake · Fountain Run, KYS/N 336-0151N3851VTexas Air Corps · Bullard, TXBuilt 1949 · S/N 18738N3851YMckie-Voerste Travis K · Chatsworth, GABuilt 1964 · S/N 21058351N3852CWilson Kirk B · Glennallen, AKBuilt 1954 · S/N 31000N3852LMountain Wings LLC · Salem, WVBuilt 1965 · S/N 17254021N3852QOwens Wilbur · Rch Palos Vrd, CAS/N 17259952N3852RChristman Mike G · Wasilla, AKBuilt 1966 · S/N 17255352N3853DMccabe Ryan · Las Vegas, NVS/N 34553N3853G3853g LLC · Umatilla, FLBuilt 1967 · S/N U206-0853N3853YRafter Bar B LLC · Ashland City, TNBuilt 1964 · S/N 21058353N3854CAnderson Clint T · Corsicana, TXBuilt 1954 · S/N 31002N3854DTjp@Jax Inc · Zephyrhills, FLBuilt 1957 · S/N 34554N3854QHafford Jay T · Stevenson, WAS/N 17259954N3854USkymaster Stc LLC · Mena, ARBuilt 1963 · S/N 336-0154N3854YJames Wilson Smith Enterprises LLC · Athens, GABuilt 1964 · S/N 21058354N3855GMoore David · Lexington, TXBuilt 1967 · S/N U206-0855N3855JWiley Phillip W · New Martinsville, WVBuilt 1966 · S/N 15065155N3855RAircraft Investment Group LLC · Cookeville, TNBuilt 1966 · S/N 17255355N3855VKeiths Aviation Training LLC · Altus, OKS/N 18742
Back to AD 79-10-14 R1