OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N21791Colson Kevin A · Andover, KSBuilt 1974 · S/N 17264021N21799Brownell John P Jr · Prattville, ALBuilt 1974 · S/N 17264025N2179TKroeger William R · Plattsmouth, NEBuilt 1972 · S/N 28-7205024N2179UFlorea Byron · Carencro, LABuilt 1963 · S/N 341N217AWHobart Aviation Inc · Akron, OHS/N 28-7125332N217JAFlying Colors Airparts Inc · Leesburg, FLS/N 17275623N217JBMccoy Robert G Jr · Marshville, NCBuilt 2002 · S/N 5122N217LMCanada Christopher W · Freeport, FLBuilt 1966 · S/N 28-21972N217SLegacy Leasing Group Inc · Wilmington, DEBuilt 2003 · S/N 05N21802Owen Michael C · Seaside, CABuilt 1978 · S/N 28-7990059N21803Morgan Edward · Gaithersburg, MDBuilt 1978 · S/N 28-7990060N21804Sharpe Alexander F · Camarillo, CABuilt 1974 · S/N 17264026N21809Eckerson Dean H · Benicia, CABuilt 1974 · S/N 17264028N2180EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28-7916165N2180RRoan Paul J · Clive, IABuilt 1969 · S/N 28-5479N2180TDe Bella Richard M Sr · Blackwood, NJBuilt 1971 · S/N 28-7205027N2180WGerges Amir · Arlington, TXS/N M-1563N2180YAstro Aviation LLC · Cross Plains, TNBuilt 1979 · S/N 28-7990383N21819Middlesex Aviation Partners LLC · Bellingham, MABuilt 1974 · S/N 17264029N2181BJao Robert V · Kailua, HIBuilt 1978 · S/N 28-7916114N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124N2182CSkyhunter LLC · Yonkers, NYS/N 17702749N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163N2183TSkies Unlimited LLC · Clinton Township, MIBuilt 1971 · S/N 28-7205026N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032N2184BPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7990125N2184TFisher Global LLC · Conway, ARBuilt 1971 · S/N 28-7205028N21857Top Air · Salt Lake City, UTBuilt 1978 · S/N 28-7990062N2185BHeirborne Again LLC · West Bridgewater, MABuilt 1978 · S/N 28-7990126N2185EMckenzie Owen R Jr · Burlington, NCBuilt 1978 · S/N 17271182N2185WHoward Pamela A · Goldthwaite, TXBuilt 1974 · S/N MB-696N2185XHendricks Robert H · Chico, CABuilt 1979 · S/N 28-7990366N21866Donthineni Rakesh · Oakland, CABuilt 1978 · S/N 28-7990063N2186THutchins Christopher E · Venice, FLBuilt 1971 · S/N 28-7205038N21878Lie Chris E · Kotzebue, AKBuilt 1974 · S/N 17264038N2187TRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1971 · S/N 28-7205039N21887Gilheany Robert V · Hicksville, NYBuilt 1974 · S/N 17264039N2188RN2188r LLC · Pittsburgh, PABuilt 1969 · S/N 28-5481N21893Western Territory Flyers LLC · Fairfax, CABuilt 1974 · S/N 17264040N2189QBlue Hen Aviation Services LLC · Easton, PABuilt 1979 · S/N 28-7990298N2189RSchrage James A · Danville, INBuilt 1969 · S/N 28-5482N2189TTulsa Aviation Group Leasing LLC · Claremore, OKBuilt 1971 · S/N 28-7205041N2189WJohnson Jay W · Wichita, KSBuilt 1976 · S/N M-1892N2189ZWeltin Gregory G · Kennebunk, MEBuilt 1981 · S/N 28-8190285N218CPPlumb J Charles · Westlake Village, CABuilt 1997 · S/N 635N218EABauer Todd A · Kenmare, NDBuilt 1970 · S/N 17259583
Back to AD 79-10-03 R2