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.

N6AHHurlbut Arthur G · Canton, NYBuilt 1992 · S/N AH-1N6ALTelfeyan John · Little Compton, RIBuilt 2002 · S/N 5042N6BPSale Reported · Stockton, CASale reportedS/N 1823N6BQBeard Bradley A · Hanford, CABuilt 1998 · S/N 348-320-57-5PN6CFFalter Charles B · Cumberland, MDBuilt 1983 · S/N 640N6DJRice Johnny D · Rosharon, TXBuilt 2002 · S/N 24330N6ETSumner Gary · Knoxville, TNBuilt 1978 · S/N GA7-0004N6FGSmith Timothy S · Kinston, NCBuilt 1974 · S/N 28-7425297N6GTVanguard Squadron Inc · Tea, SDBuilt 1983 · S/N 811-1N6HMHenning Nancy E · Hardinsburg, KYBuilt 1972 · S/N 362-72N6HNTalbott Philip A · Galena, OHBuilt 1971 · S/N 172-60326N6HYGbh Aviation · Santa Monica, CABuilt 2000 · S/N 2056N6JPrewitt Scott S · King City, CABuilt 1980 · S/N 2112N6KPPhillips Keith E · Port Orange, FLBuilt 1974 · S/N 01N6KTHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3016N6MBSierra Whiskey Aircraft LLC · Oakland, CABuilt 1968 · S/N 17257279N6MXHale Mitchell D · Palmer, AKS/N 18-6650N6NGAvalle Carlos A · Livermore, CABuilt 1983 · S/N 180N6NHStephens Timothy D · Springfield, MOBuilt 1966 · S/N 28-3698N6NSWestern Flying Club Inc · Burlington, NCBuilt 1978 · S/N 28-7990206N6PFSoplanda Matthew J · Willow, AKBuilt 1952 · S/N 18-2007N6PUMoreno Juan T · Stockbridge, GABuilt 2002 · S/N 25038N6RRegistered aircraftBuilt 1999 · S/N 21946N6SBFranklin Gary · Willow Beach, AZS/N 1080N6SYKirkpatrick Andrew T · Corpus Christi, TXBuilt 1975 · S/N AA5B-0210N6TDCapouch Michael J · Medaryville, INBuilt 1975 · S/N 18-7509108N6TVTravelaire Service Inc · Wilmington, DES/N 17275278N6UULoerzel James E · Arlington Heights, ILBuilt 2005 · S/N 25887N6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676N6WNDart Gregory G · Mayville, NYS/N 198N6XAFlying Farmers LLC · Dalhart, TXBuilt 1997 · S/N 1366N6YQBeek Dudley E · Miami, FLBuilt 1994 · S/N 451N6YTCassinelli Steven W · Oceanside, ORBuilt 2002 · S/N 2198N6ZHarris Hayden H · Chelsea, MIBuilt 1980 · S/N JM-2N6ZPAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274020N6ZTLewis Eddy L · Cortez, COBuilt 1957 · S/N 18-5824N700Dailey Jeffrey D · Weirton, WVBuilt 1971 · S/N 317-71N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179N7000RJilek Peter Andrew · River Falls, WIBuilt 1966 · S/N 28-21693N7000WIndy Air Sales LLC · Anderson, INBuilt 1962 · S/N 28-671N7001DOwens Eldon J · Arimo, IDS/N 22-4894N7001WBrinc LLC · Lancaster, PABuilt 1963 · S/N 28-673N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180N7003BByrd Kyle E · Unionville, MOBuilt 1956 · S/N 22-4253N7003PAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 24-2148N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183N7004FSouthern Vector Aerospace LLC · Huntsville, ALS/N 28-7790176N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704N7004REasley Leroy · Novelty, MOFirst renewal noticeBuilt 1966 · S/N 28-21698
Back to AD 79-10-03 R2