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.

N92544Walther Newell A · Wasilla, AKBuilt 1946 · S/N 12-73N92548Pulliam Richard W · Henryetta, OKBuilt 1973 · S/N 17261584N9254HShipley Donald E · Alpine, TXBuilt 1975 · S/N 17266049N9254KBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7690237N9254SHolmes Jeffrey T · Oxford, CTBuilt 1975 · S/N M-1751N9254VLeyden Jar LLC · Greeneville, TNS/N 690066N9255CD&J Aviation LLC · Apopka, FLBuilt 1978 · S/N 28-7890393N9255DNorstrom Hans P · Wasilla, AKBuilt 1958 · S/N 18-6548N9256CBluegrass Aviation LLC · Clarksville, TNBuilt 1978 · S/N 28-7890394N9256DGonitzke Ross J · Detroit Lakes, MNBuilt 1995 · S/N 2890227N9256GGeib Gary D · Lake Tapawingo, MOS/N 476 DAF-2N9256MLone Star Magni Gyro Inc · Taylor, TXBuilt 1966 · S/N 3453N9256VDirschka Paul · Blandford, MABuilt 1969 · S/N 690067N9256XBird Acquisition LLC DBA · Phoenix, AZBuilt 1995 · S/N 4496002N92570Becker Steven H · Prescott, AZBuilt 1973 · S/N 17261586N92576Oman Ronald G · Chugiak, AKBuilt 1946 · S/N 12-106N9257CAcorn Aviation LLC · Saint Charles, ILBuilt 1978 · S/N 28-7890395N9257JWojtecki Chris R · Florissant, COBuilt 1966 · S/N 28-3333N9257MMouser Ryan D · Paragould, ARBuilt 1966 · S/N 3454N9257PBrooks Laura · Palmer, AKBuilt 1970 · S/N 18-8900N9258CBack Forty Flying Club Inc · Roanoke, INBuilt 1995 · S/N 2843002N9258JHummingbird Avaition LLC · Columbus, INBuilt 1966 · S/N 28-3334N9258NKma Aircraft Dream LLC · Osteen, FLBuilt 1995 · S/N 28-43014N92595Bearfight Aviation LLC · Dover, DEBuilt 1973 · S/N 17261591N9259HBooke Phillip Austin · Anniston, ALS/N 17266053N9259JDave Flight LLC · Mccook, NEBuilt 1966 · S/N 28-3335N925CBDhani Errol · Locust Grove, GABuilt 1973 · S/N 17262826N925DGNwi Drones LLC · Chesterton, INBuilt 1960 · S/N 24-1870N925ERCrosswell Joe D · Springtown, TXS/N 385-72N925HEWatson James C · Boerne, TXBuilt 1989 · S/N 491N925JLLudwig Jerry F · West Ossipee, NHBuilt 2004 · S/N 22439N925MKOates Douglas E · Elgin, SCBuilt 1966 · S/N 28-3325N925NEriksson Kurt R · Soldotna, AKBuilt 1978 · S/N 18-7909007N925PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843288N925RSHall Jeffrey I · Broken Arrow, OKBuilt 2004 · S/N 1111N925TARutan Aircraft Flying Experience · Waller, TXBuilt 1992 · S/N S 60N925TEHarris David A · Cleves, OHBuilt 2001 · S/N 10204N9260SChristiansen Dee W · Kerrville, TXBuilt 1975 · S/N MB-781N9260TCanoace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8616033N9260VBravo Aero LLC · Concord, NCBuilt 1969 · S/N 690069N92617Stahl Raifen · Anchorage, AKBuilt 1973 · S/N 17261594N9261DBales Carson E · Wasilla, AKBuilt 1958 · S/N 18-6555N9261HSchrom Frederick A · Carlisle, PABuilt 1975 · S/N 17266054N9261JLear Steven J · Rockville, INBuilt 1966 · S/N 28-3337N9261MPickett Trina M · Riverside, CABuilt 1966 · S/N 3455N9261PUdell Brian · Queen Creek, AZS/N 18-8901N9262HAero Maintenance Inc · Vancouver, WAS/N 17266055N9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1975 · S/N 17266056N9263JHarrod Andrew A Jr · El Segundo, CABuilt 1966 · S/N 28-3339N9263LSkyhawk Flying Club Inc · Franklin Grove, ILBuilt 1996 · S/N 2843023
Back to AD 79-10-03 R2