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.

N9544WStrawn Randy A · Atlanta, TXBuilt 1967 · S/N 28-22975N95450Piper Aire LLC · Shell Knob, MOBuilt 1969 · S/N 28-25963N95454Butler Byron D · Acworth, GABuilt 1969 · S/N 28-25968N95455Juszkiewicz Jack · El Paso, TXBuilt 1969 · S/N 28-25969N95459Folsom James · Lawrenceburg, KYBuilt 1969 · S/N 28-25970N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870N9545DFaught Jeffrey R · Bismarck, NDBuilt 1958 · S/N 22-6462N9545LMoore Walter Robert · Bradentone, FLBuilt 1974 · S/N AA5-0655N9545WBouthillier Mark W · Tonawanda, NYBuilt 1967 · S/N 28-22976N95461Bradford Murvin L · Hensley, ARS/N 28-25971N95463Licata Paul Z · Mexico, MOBuilt 1969 · S/N 28-25704N9546DTripacer Leasing LLC · Lauderhill, FLBuilt 1958 · S/N 22-6463N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219N9546WSale Reported · Van Nuys, CASale reportedBuilt 1967 · S/N 28-22978N95471Herrington Herbert A · Gallatin, TNBuilt 1969 · S/N 28-25452N95473Bohling Anthony W · Auburn, NEBuilt 1969 · S/N 28-25981N95476Bollinger Aaron · Norfolk, VABuilt 1969 · S/N 28-25985N95477Wills Thomas J · Plainfield, ILBuilt 1969 · S/N 28-25986N95479Wilson Scott E · Fostoria, OHBuilt 1969 · S/N 28-25988N9547DStoltz Michael A · Portland, ORS/N 22-6464N9547JFranz Stanley · Yakima, WABuilt 1966 · S/N 28-3676N9547KAviles Hector J · Rancho Cucamonga, CAS/N 28-7615211N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575N95481North Texas Aeronautics LLC · Fort Worth, TXBuilt 1969 · S/N 28-25989N9548JMulder Timothy D · Shafter, CABuilt 1966 · S/N 28-3677N9549HBenson Edward A · San Antonio, TXBuilt 1975 · S/N 17266221N9549LAmbrose Martin S · Springfield, MABuilt 1974 · S/N AA5-0549N954JHWings Over Texas LLC · Denton, TXBuilt 1975 · S/N 17266220N954LTWc Flight LLC · Higgins, TXBuilt 1993 · S/N 1252N954SCBair James R · Lucas, IABuilt 2021 · S/N JA1711116N954TGm Aviation LLC · Phillips, WIS/N 18-8649N954TEBabin Michael K Jr · Cresson, TXBuilt 2004 · S/N 10233N9550BMccall Freddie W · Brewton, ALBuilt 1981 · S/N 172RG0872N9550JRodriguez Gerald · West Hempstead, NYBuilt 1966 · S/N 28-3680N9550LSale Reported · Colorado Springs, COSale reportedS/N AA5-0550N9551BLopes Gaston A · Dallas, TXS/N 172RG0873N9551DHhd Aviation LLC · Hamilton, OHS/N 22-6468N9551JKemp Richard · Manassas, VABuilt 1966 · S/N 28-3681N9552AAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280531N9552HZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1975 · S/N 17266223N9552JStrong Dennis L · Minocqua, WIBuilt 1966 · S/N 28-3682N9552KWing Flying Club Inc · Lees Summit, MOBuilt 1976 · S/N 28-7690258N9552LHollin Myron · Guilford, INBuilt 1974 · S/N AA5-0674N9552SSmith Ranch Inc · Broadus, MTBuilt 1965 · S/N 42N9552VRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17264354N9553JStanley James C · Farmington, NMBuilt 1966 · S/N 28-3683N9553WRich Harold W · Fort Worth, TXBuilt 1967 · S/N 28-22989N9554DChase 13 LLC · Wilmington, DES/N 22-6471N9554LWilson Tyler · Blooming Prairie, MNBuilt 1974 · S/N AA5-0676N9554VCavu LLC · Fort Collins, COBuilt 1974 · S/N 17264356
Back to AD 79-10-03 R2