OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N4774AJewett Robert A · Wasilla, AKBuilt 1956 · S/N 22-3923N4774EZhao Dan · New York, NYBuilt 1978 · S/N 17271639N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079N4775DHetrick-Price Willow · Anchorage, AKBuilt 1979 · S/N 17272357N4775LWadkins Chris H · Plummer, IDBuilt 1967 · S/N 28-4109N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132N47768Registered aircraftBuilt 1977 · S/N 28-7816133N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641N4776JKimbrough Paul E · Millcreek, UTBuilt 1967 · S/N MB-221N4776LHitt John C · Plano, TXBuilt 1967 · S/N 28-4110N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137N4777JHowell Michael A · Parsons, KSBuilt 1967 · S/N MB-224N4777LRoss Charles B · Anchorage, AKBuilt 1967 · S/N 28-4111N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643N4778LGarrett Russell K · Hazen, NDS/N 28-4112N477BGParker Dennis A · Charlevoix, MIBuilt 1977 · S/N AA5A0364N477CHCsi Flight Services LLC · Mcminnville, ORBuilt 2004 · S/N 3729N477DKPhilippi Ranches Inc · Hermiston, ORS/N 2160N477LLLima Lima LLC · Lander, WYBuilt 1968 · S/N 18-8755N4780APenn Flyers LLC · Greensburg, PABuilt 1956 · S/N 22-3931N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140N4782GSeguin Elliot · Rosamond, CABuilt 1968 · S/N 77N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204N4783Haire Kenneth H · Star City, ARS/N 93N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141N4783LSikka Dhruv · Lutz, FLBuilt 1967 · S/N 28-4118N4783PBush Robert Edward · Mead, WABuilt 1977 · S/N AA5B-0526N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220N4784LDelta Sierra LLC · Naples, FLBuilt 1967 · S/N 28-4119N4785FSoaring Society Of Boulder Inc · Boulder, COBuilt 1962 · S/N 18-7906N4785LTranswestern Air Service Inc · Golden, COBuilt 1967 · S/N 28-4120N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651N4786LZayas Omar · Fontana, CABuilt 1967 · S/N 28-4122N4787AStock Matthew D · Clarence, NYBuilt 1956 · S/N 22-3938N4787ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271652N47880Halmon Henry W · Manvel, TXBuilt 1997 · S/N 2500N47881Griffin Jack D · Hamilton, OHBuilt 1977 · S/N 28-7816151
Back to AD 79-10-03 R2