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.

N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172N8286NAyyildiz Erol · Glen Rock, NJBuilt 1969 · S/N 28-25503N8287Holloway Earnie G · Bonner Springs, KSBuilt 1972 · S/N 5231931N8287BCostanti Nicolas J · Medford, ORS/N 18-7609048N8287JBurnett Stephen B · Granby, MOBuilt 1979 · S/N VAC-133-79N8287NBetik Patrick G · Grapevine, TXS/N 28-25504N8288EGomez Cierra D · Jasper, ALS/N 17272174N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237N8288JRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1979 · S/N VAC-134-79N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072N8289JCummings Steven R · League City, TXS/N VAC-135-79N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080N828JPCarney William F · Gallatin, TNBuilt 1957 · S/N 185460N828LSKelly Ryan · New York, NYBuilt 1977 · S/N AA5A-0406N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373N828MCHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-4615N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168N82905Reese Melissa A · Soldotna, AKBuilt 1977 · S/N 18-7709197N82907Law Offices Of David Henderson · Anchorage, AKBuilt 1978 · S/N 18-7909031N8290JSchaaf Rodney B · Bowman, NDBuilt 1979 · S/N VAC-136-79N8290NHorne Larry E · Suffolk, VABuilt 1969 · S/N 28-25508N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8290WCastles James D · Portland, ORBuilt 1965 · S/N 28-2452N82912Barrows Stuart L · Eagle River, AKBuilt 1977 · S/N 18-7709195N82918Herman Brant · Fairbanks, AKBuilt 1977 · S/N 18-7809024N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177N8291JWorth William A · Anthony, NMBuilt 1979 · S/N VAC-137-79N8291NPeters Rodney A Jr · Hayward, WIBuilt 1969 · S/N 28-25509N8291WVoll Dorothe A · Corona, CABuilt 1965 · S/N 28-2454N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009N8292EP&N Corp · Marion, IAS/N 17272178N8292JBrent Scott Properties Lp · Eagle, COS/N VAC-138-79N8292WPinegar Kevin R · Brighton, MIBuilt 1965 · S/N 28-2455N8293CMcchargue Robert W II · Talkeetna, AKS/N 18-4114N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179N8293NPaul Harvey B · Kongiganak, AKBuilt 1969 · S/N 28-25511N82942Kemp Kerm R · Southwest Ranches, FLBuilt 1977 · S/N 18-7809027N82945Brewer William B Jr · Fairbanks, AKBuilt 1977 · S/N 18-7809029N82946Class A Coaches LLC · Missoula, MTBuilt 1977 · S/N 18-7809030N82947Mann Jacob A · Wheatland, WYBuilt 1978 · S/N 18-7909032N82949Mcbride Peter M · Basalt, COBuilt 1978 · S/N 18-7909033N8294JDowning John T · Tucker, GAFirst renewal noticeBuilt 1979 · S/N VAC-140-79N8294LAts Tennessee Inc · Oneida, TNBuilt 1982 · S/N 28-8316011N82951Av Enterprises Inc · Bozeman, MTBuilt 1978 · S/N 18-7909035N82953Sky Fox Aircraft LLC · Queen Creek, AZBuilt 1980 · S/N 28-8190088N82956Holmes James E · Klamath Falls, ORBuilt 1979 · S/N 18-7909034N8295EFrump Leasing Inc · Newburgh Heights, OHS/N 17272181
Back to AD 79-10-03 R2