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.

N5938BDocjosh Ltd LLC · Essex, NYBuilt 1956 · S/N 33938N5938TShihadeh Luke C · Wasilla, AKS/N 15060638N5939GMasek Ron J · Valley City, OHBuilt 1969 · S/N 15071439N5939RHester James T · Fayetteville, GAS/N 17253608N5939TAdkins Amanda J · Proctorville, OHBuilt 1964 · S/N 15060639N593CPCivil Air Patrol · Montgomery, ALS/N 18282178N593STN593st LLC · Bangor, MEBuilt 1985 · S/N 17276454N5940EHorton Bill · Derby, KSBuilt 1959 · S/N 17440N5940RBakrevski Lupcho · Valparaiso, INS/N 17253609N5941ERoxbury Public Schools · Succasunna, NJBuilt 1959 · S/N 17441N5941RChristian Stuart J · Erskine, MNS/N 17253610N5942GGsell Bruce · Southampton, NJBuilt 1969 · S/N 15071442N5942JNovember Sierra Aviation LLC · O Neill, NES/N A1500242N5942RL&L Ltd · Shoreview, MNBuilt 1965 · S/N 17253611N5943AFox Michael S · Glendale, AZS/N 28543N5943EPlane Zane LLC · Stuart, FLBuilt 1978 · S/N 17271969N5943GFlight Express LLC · Henry, TNBuilt 1979 · S/N 18266907N5943RGear Down Hangar LLC · Phoenix, AZBuilt 1965 · S/N 17253612N5943TMission Flight Academy · Redlands, CABuilt 1964 · S/N 15060643N5944GYakich Adam J · Fairfield, IABuilt 1967 · S/N 15068028N5944RLucas Heaven · Griffin, GABuilt 1965 · S/N 17253613N5944THills Jacob W · Lonepine, MTBuilt 1964 · S/N 15060644N5945EBaby 80 LLC · Chandler, AZBuilt 1959 · S/N 17445N5945RDamme Douglas A · Talmage, NEBuilt 1965 · S/N 17253614N5946AKessinger John · Independence, ORS/N 28546N5946JMillett Paul B · Claremore, OKBuilt 1979 · S/N 18267024N5946RElite Aeronautics LLC · Miami, FLBuilt 1965 · S/N 17253615N5946TEasmunt David P · Hardin, KYBuilt 1964 · S/N 15060646N5947ARoberts James L · Sedgwick, KSBuilt 1956 · S/N 28547N5947ESwenson Roger A · Pahrump, NVS/N 17447N5947GGregorzewski Richard D · Jasper, ALS/N 15071447N5947NGmm Records · Big Pine Key, FLBuilt 1972 · S/N 17260597N5947RDillon Aero Inc · Phoenix, AZBuilt 1965 · S/N 17253616N5947SStewart Edgar Alan · Glennallen, AKBuilt 1973 · S/N 18502169N5947TStewart Edgar A · Glennallen, AKBuilt 1964 · S/N 15060647N5948AVerdouw Andrew J · Georgetown, INBuilt 1956 · S/N 28548N5948ETlt Legacy LLC · Fort Worth, TXBuilt 1978 · S/N 17271972N5948F5c1 Ltd · Boerne, TXBuilt 1967 · S/N 21058948N5949FRead Travis E · Lumberton, TXBuilt 1967 · S/N 21058949N5949JAnderson Brian E · Castro Valley, CABuilt 1973 · S/N A1500401N5949TJoy Jeffrey · Pendergrass, GABuilt 1964 · S/N 15060649N5949VElkhorn Creek Aviation 3 LLC · Georgetown, KYBuilt 1954 · S/N 20920N594CF4cf Partnership · Fall River Mills, CABuilt 1966 · S/N 18256922N594CPCivil Air Patrol · Maxwell Afb, ALS/N 18282180N594PFBatten Franklin H · Randleman, NCBuilt 1974 · S/N 15076042N5950AVincent Anthony Jordan · Graham, KYBuilt 1956 · S/N 28550N5950GSmylie Michael Dean · Douglas, WYBuilt 1974 · S/N 18263310N5951ELlano Alfonso · Tucson, AZS/N 17271974N5951GWallace Grant R · Altoona, IABuilt 1969 · S/N 15071451N5951RSouth Seattle Community College · Seattle, WABuilt 1965 · S/N 17253620
Back to AD 79-10-14 R1