OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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-03-R2')
    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-03-R2')
  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.

N9477JMatthews Byron Kim · Hooper, UTS/N 28-3593N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562N9477VMurnville Glenlove Flyers Ltd · Delaware, OHBuilt 1970 · S/N 700062N9479DGrote Neal Scott · Harrison, NEBuilt 1959 · S/N 18-6822N947TESkyway V LLC · Naples, FLBuilt 2003 · S/N 10226N947TTPucciariello Alexander A · Punta Gorda, FLBuilt 2000 · S/N 3947N9480CDave Gross Inc · Midland, TXBuilt 1978 · S/N 28-7816480N9480EMoyer Aviation Inc · Tobyhanna, PABuilt 1979 · S/N 17272277N9480HMoynihan Patrick J · Lakeville, MNBuilt 1975 · S/N 17266173N9480J217 Moriarty LLC · Stonewall, MSBuilt 1966 · S/N 28-3597N9481JRuffner Samuel D · Powder Springs, GABuilt 1966 · S/N 28-3598N9481KHepp Investments LLC · Warrens, WIBuilt 1976 · S/N 28-7615205N9482CSchuetz Ray · Davie, FLBuilt 1978 · S/N 28-7816481N9482DHanley Company LLC · Littleton, COBuilt 1958 · S/N 18-6734N9483CCnczilla Co · Royersford, PABuilt 1978 · S/N 28-7816482N9484HN9484h LLC · Wheeling, ILBuilt 1975 · S/N 17266175N9484KDoll Electric Co Inc · South Lake Tahoe, CABuilt 1976 · S/N 28-7615206N9484VHannon Fredrick W · Punta Gorda, FLBuilt 1970 · S/N 700064N9485JBlakely Jerry II · Coeur D Alene, IDBuilt 1966 · S/N 28-3602N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837N9486CRhodes Ryan · Dallas, TXBuilt 1978 · S/N 28-7890415N9486JJames Andy K · Shallowater, TXBuilt 1966 · S/N 28-3603N9486KAerial Avionics Inc · Modesto, CABuilt 1976 · S/N 28-7615207N9487JElmenhurst Daniel D · Walla Walla, WABuilt 1966 · S/N 28-3604N9487KInverted Air LLC · Mesa, AZBuilt 1976 · S/N 28-7690254N9488DClear Prop Aviation LLC · Sioux City, IABuilt 1959 · S/N 18-6740N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629N9488JSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 28-3605N9489JIndiana County Flying Club Inc · Blairsville, PABuilt 1966 · S/N 28-3606N948DBBoard David N · Moundsville, WVBuilt 1963 · S/N 22-7600N948RVGeer Roy R · Fort Worth, TXBuilt 2004 · S/N 82021N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057N948WDAndrews Aviation Two LLC · Temple, TXBuilt 2010 · S/N 71660N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177N9491JRoy Thomas M Jr · Carbondale, ILBuilt 1966 · S/N 28-3609N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178N9492VRivera Jaime · San Antonio, TXBuilt 1970 · S/N 700066N9493DJack Browns Seaplane Base Inc · Winter Haven, FLBuilt 1958 · S/N 18-6745N9493JHayes Enterprises · Glendale, AZBuilt 1966 · S/N 28-3611N9494DReder Monte D · Miles City, MTBuilt 1958 · S/N 18-6746N9494JRuiz Serge · Montgomery, TXS/N 28-3613N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180N9495VSoccer Goals LLC · Christoval, TXBuilt 1970 · S/N 700067N9496DCavu Clearing LLC · Center Harbor, NHBuilt 1958 · S/N 18-6748N9496VEvans Richard I · Elko, NVS/N 700050N9497JShushnar Gary J · Irvine, CABuilt 1966 · S/N 28-3737N9498JBrantley Hugh L · Hazlehurst, GAS/N 28-3738N9498LRaber Jonathan L · Baltimore, MDBuilt 1972 · S/N AA5-0238N9498VMoonshiner Aviation LLC · Austin, TXBuilt 1970 · S/N 700068N949CDDupont Samuel F C · Mount Solon, VABuilt 1978 · S/N 17270883
Back to AD 79-10-03 R2