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.

N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056N4297QCritchfield David P · Paradise, CAS/N 17260197N4297ZAcadiana Cub LLC · Abbeville, LAS/N 18-8549N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058N4298QDarrach Todd I · Rhome, TXS/N 17260198N4298ZAugustine Ryan M · Talkeetna, AKBuilt 1967 · S/N 18-8555N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799N4299ZKauffman Loren C · Anchor Point, AKS/N 18-8558N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99N429DRConard John C · Minnetonka, MNS/N 60412N429EGCongalton Steve M · Rancho Cucamonga, CABuilt 1974 · S/N 28-7405188N429KERegistered aircraftBuilt 1998 · S/N 52352N42AKGerhardt David · Denver, COBuilt 1998 · S/N 1434N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941N42ARAtlantic Aircraft Holdings LLC · Bohemia, NYBuilt 1979 · S/N AA5B1285N42BLRainey Steven M · Rosamond, CAFirst renewal noticeBuilt 2003 · S/N 2899N42CMMazor Chris · Belleville, MIS/N 17266374N42DGHavard Gregory H · Conway, ARBuilt 1989 · S/N 1N42EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 1965 · S/N 15061252N42FYSchwartz David W · Labelle, FLBuilt 1998 · S/N 01N42GFGillespie Dennis M · Orange Park, FLBuilt 2001 · S/N 23925N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383N42KANorth Little Rock Air Inc · North Little Rock, ARBuilt 1966 · S/N 28-3702N42KRDonnelly Charles A · Browns Mills, NJBuilt 1977 · S/N 28-7716295N42KSSink Kreth H · Scott Depot, WVBuilt 1992 · S/N 2205N42PBPfister Mark A · Acworth, GABuilt 1960 · S/N 23-1895N42PEDennis Kevin M · Bend, ORBuilt 2007 · S/N 90804N42RRWalla Walla University · College Place, WAS/N ME-84N42SPCw Air LLC · Broken Bow, NEBuilt 1974 · S/N 28-7415437N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703N42WCN42wc LLC · Rehoboth Beach, DEBuilt 1990 · S/N 1531MN42WVHolley Donald J · Madera, CABuilt 1995 · S/N 20488N4300AHanna David B · Tonasket, WABuilt 1991 · S/N 001N4300MJones Paul · Wasilla, AKS/N 12-3232N4300PMontcalm-Mcdonald LLC · Mansfield, LAFirst renewal noticeBuilt 1959 · S/N 23-1801N4300RCab Air Inc · Columbia, NJBuilt 1974 · S/N 17263054N4300TPei-Ning Lo · Rowland Heights, CABuilt 1971 · S/N 28-7225128N43017Conn Farms Inc · Jeffersonville, OHBuilt 1974 · S/N 28-7415408N4301AStevens Constance I · Homewood, CAS/N 22-3651N4301JHarris Matthew P · Batavia, NYBuilt 1967 · S/N 28-22671N4301QSchneider Frederick I · Sault Sainte Marie, MIBuilt 1971 · S/N 17260201N4301RMeggers Roger D · Baker, MTBuilt 1974 · S/N 17263055N4301XDestination 55 LLC · Cave Springs, ARBuilt 1975 · S/N 28-7625008N4301ZRubbert Logan · Reynolds, NDS/N 18-8609N43020Blue Skies Flying Services Inc · Lake In The Hills, ILBuilt 1974 · S/N 28-7415409N43023Drs Sandra M Krokos And Thomas P Kislan Pc · Hazle Township, PABuilt 1974 · S/N 28-7415410N4302MNiver Mark A · Wasilla, AKBuilt 1947 · S/N 12-3234N4302TRiley Thomas J · West Grove, PABuilt 1983 · S/N 28-8316065N4302YLundstedt Gregory · Duncan, SCBuilt 1961 · S/N 23-2025
Back to AD 79-10-03 R2