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.

N9505DJutzi Curtis E · Ridgefield, WABuilt 1958 · S/N 22-6420N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185N9505JConnors Paul J II · Murrieta, CABuilt 1966 · S/N 28-3626N9505LClark Gabrial Scott · Humble, TXBuilt 1972 · S/N AA5-0105N95063Dugan Jason · Wellington, TXBuilt 1969 · S/N 28-25794N95069Tower Aviation Of Reading Inc · Reading, PABuilt 1969 · S/N 28-25797N9506JEspinal Branhder · Union, NJBuilt 1966 · S/N 28-3627N95071Lund Jonathan J · Glencoe, MNBuilt 1969 · S/N 28-25798N9507DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6422N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N95080Johnson Patrick W · Toney, ALBuilt 1969 · S/N 28-25800N95084Lyons Nathaniel R · Fort Scott, KSBuilt 1969 · S/N 28-25801N95089Moll Michael J II · Mechanicville, NYBuilt 1969 · S/N 28-25804N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9508DLewis Stephen A III · Fleming, GABuilt 1958 · S/N 22-6423N9508JGandas Aero Inc · Eagan, MNS/N 28-3629N9509DMorrison Jim · Grandview, TXBuilt 1958 · S/N 22-6424N9509JStevens Sheldon D · Clark, SDBuilt 1966 · S/N 28-3630N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N950TECrutchfield Randolph E · Scottsdale, AZBuilt 2003 · S/N 10229N95105Airbud Aviation LLC · Morristown, NJBuilt 1969 · S/N 28-25806N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N95111Tiny Tin Aviation LLC · Groveland, FLBuilt 1969 · S/N 28-25808N9511JGomez Alexandro · Riverside, CABuilt 1966 · S/N 28-3633N9511KMoore Matt R · Nashville, TNS/N 28-7625182N95121Preston Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28-25814N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487N9512DFerrell Alan B · Arlington, OHBuilt 1958 · S/N 22-6428N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190N9512JArapahoe Flight Club LLC · Colorado Springs, COBuilt 1966 · S/N 28-3634N9512SBlack Daniel L · Spicewood, TXBuilt 1965 · S/N 7GCBA21N95133Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25818N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191N9513JGlorioso Richard · Plant City, FLBuilt 1966 · S/N 28-3635N9513LMott Terry W · Hampton, IABuilt 1972 · S/N AA5-0213N95147Ramirez Ricardo A · San Antonio, TXBuilt 1969 · S/N 28-25822N9514DAdams David D · West Ossipee, NHBuilt 1958 · S/N 22-6430N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192N9514JDu Bois Aviation Inc · Chino, CABuilt 1966 · S/N 28-3637N9514LBiller Mary Catherine · Columbus, OHBuilt 1973 · S/N AA5-0214N95151Gonzalez-Pinto Carmelo · San Antonio, TXBuilt 1969 · S/N 28-25823N95154Cen Inc · Sheridan, WYS/N 28-25825N95157Smutek Brian D · Mio, MIBuilt 1969 · S/N 28-25828N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846N9515DElmer Charles F · Saint Clair Shores, MIBuilt 1958 · S/N 22-6439N9515JBowman Alex T · Virginia Beach, VABuilt 1966 · S/N 28-3638
Back to AD 79-10-03 R2