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.

N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448N415RGalyon Aviation LLC · Sweetwater, TNBuilt 1958 · S/N TD-161N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290N41606My Flight LLC · Cypress, TXS/N 287415291N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124N4160JIvy James E · Alba, TXS/N 28-22489N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490N4161PRegistered aircraftBuilt 1999 · S/N 2843309N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003N4163JLoera Josa · Laredo, TXS/N 28-22493N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128N41648Russell Matthew M · Niantic, CTBuilt 1974 · S/N 28-7415304N41649Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7415305N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N41650Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415306N41657Morton Zac D · San Antonio, TXBuilt 1974 · S/N 28-7415308N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200N4165ZHollingsworth Lloyd Dan · Anchorage, AKBuilt 1965 · S/N 18-8346N41667Lewis Clifton Jack · North Branch, MIBuilt 1974 · S/N 28-7415116N41669Hogan Daniel L · Chapel Hill, NCBuilt 1974 · S/N 28-7415312N4166MWoolace James L · North Pole, AKBuilt 1947 · S/N 12-3065N41674Swift Museum Foundation Inc · Athens, TNBuilt 1942 · S/N 101N41677Northern Aviation LLC · Palmer, AKBuilt 1973 · S/N 585-73N41678Dodge Donald V · Newnan, GAS/N 586-73N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318N4167ZGolden Arrow Aviation Inc · Wilmington, DEBuilt 1965 · S/N 18-8349N41684Nenahlo Thomas L · Anchorage, AKS/N 588-73N4168HCordell Brad · Port Charlotte, FLBuilt 1995 · S/N 1263N4168JTwigg Donald A · Cumberland, MDBuilt 1966 · S/N 28-22503N41691Whiteknucle Aerobatics Inc · Blacksburg, VABuilt 1973 · S/N 591-73N41695Guilfoyle Robert J · Shepherd, MTBuilt 1973 · S/N 593-73N4169FRoelker Randall S · San Antonio, TXBuilt 1976 · S/N 28-7715007N4169XNusom William J · Hollis Center, MEBuilt 1969 · S/N 347N416HPKt7 Aviation LLC · Katy, TXBuilt 1963 · S/N 28-1437N416JLCondren Ryan · Sunnyvale, TXBuilt 1967 · S/N 28-23944N416RBWhite Jared William · Grass Valley, CABuilt 1972 · S/N 95
Back to AD 79-10-03 R2