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.

N7842DCasler Robert A · Phelps, NYBuilt 1957 · S/N 22-5492N7842GChildress Aviation LLC · Conway, ARBuilt 1970 · S/N 17259542N7842NBoon Andrea Elizabeth · Bloomingdale, NYBuilt 1969 · S/N 28-5297N78436Vp Aviation LLC · Woodstock, NYBuilt 1969 · S/N 17257616N7843GFlybarely LLC · Manitowoc, WIBuilt 1970 · S/N 17259543N7843NA10 Aviation LLC · Peachtree City, GABuilt 1969 · S/N 28-5298N78440Boeing Employees Flying Association · Renton, WABuilt 1968 · S/N 17257618N78441444.Com LLC · Wilmington, DEBuilt 1968 · S/N 17257619N78444Hupe John F · Wamego, KSBuilt 1968 · S/N 17257620N78445Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257621N7844GRedington James F · Hot Springs, VABuilt 1970 · S/N 17259544N7844WSaddy Rock · Henderson, NVS/N 28-1861N78456Deoudes Demitrios N · Anchorage, AKBuilt 1947 · S/N 12-1965N78458Heffley And Ruiz LLC · Waco, TXBuilt 1968 · S/N 17257624N7845DParr Richard · Pittsboro, NCBuilt 1957 · S/N 22-5495N7845GSolorio Inc · Mission, TXBuilt 1970 · S/N 17259545N7845MGilbert David L · Madison, SDBuilt 1946 · S/N 121516N7845PRawlins Everett R · Pedro, OHBuilt 1962 · S/N 24-3068N78461Lynam Leonard B · Walled Lake, MIBuilt 1968 · S/N 17257625N78463Hedges William P · Iliamna, AKBuilt 1947 · S/N 12-1974N78464Hernandez Jesse · Auburndale, FLS/N 17257627N78466Kubecka Donald · Seminole, TXBuilt 1947 · S/N 12-1978N7846DDrake Lewis · Murray, KYS/N 22-5496N7846NWelch Koby Adam · Bel Air, MDBuilt 1969 · S/N 28-5302N7846VPan Mi LLC · Toa Baja, PRBuilt 1964 · S/N 2809N7846WJohnpeer Kate M · Whittier, CABuilt 1964 · S/N 28-1864N78473Pps1 LLC · Duluth, MNBuilt 1947 · S/N 12-1984N7847DBuckner John L · Ragland, ALBuilt 1957 · S/N 22-5497N7847HEastern Iowa Gliders Inc · Muscatine, IABuilt 1946 · S/N 12-747N7847WErickson Richard M · Summerville, SCBuilt 1964 · S/N 28-1865N78482N78482 LLC · Granbury, TXS/N 17257632N78487Richardson David · Leitchfield, KYS/N 17257635N78489Tanner Richard L · Copperhill, TNBuilt 1968 · S/N 17257636N7848CZeitler Christopher · Middleton, WIBuilt 1975 · S/N 28-7690085N7848DChurchill Maverick B · Alliance, NES/N 22-5498N7848NRunions David W · Elon, NCBuilt 1969 · S/N 28-5304N7848VGreen Donald W · Las Vegas, NVS/N 2811N7848WStockman Richard Benjamin · Southaven, MSS/N 28-1866N78490Owens Neil L Jr · Tallapoosa, GAS/N 17257637N78491El Dorado Rentals Inc · El Dorado Springs, MOBuilt 1968 · S/N 17257638N78494Peterson Darwin D · Antler, NDBuilt 1968 · S/N 17257640N7849NZdravko Tyrone · Clearwater, FLBuilt 1969 · S/N 28-5305N7849VOkaeronut LLC · Ponca City, OKBuilt 1964 · S/N 2812N784CMEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1992 · S/N 626N784CRTurnipseed Kenny A · Sumner, TXS/N 17257629N784GTMarianas Air Transfer Inc · Tinian, MPBuilt 1977 · S/N 17268855N784REsmaili Farid · Woodstock, VAS/N 17271233N7850DPunt Matthew L · Wasilla, AKBuilt 1957 · S/N 22-5500N7850GWhitfield Robert O Jr · Hurdle Mills, NCS/N 17259550N7850NMach 3 LLC · Enid, OKBuilt 1969 · S/N 28-5306
Back to AD 79-10-03 R2