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.

N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598N32990Trident Aircraft Leasing LLC · Easton, MDBuilt 1974 · S/N 28-7515285N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574N329PWalther Cameron R · Hallam, NEBuilt 1977 · S/N AA5A0329N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512N329RPPettis Loren K · Thomaston, GABuilt 2002 · S/N 24828N329TKaney Jeffrey J · Naples, FLBuilt 1953 · S/N 18-2443N32ADRobinson Helicopter Co · Torrance, CABuilt 1977 · S/N 0002N32AHLai LLC · Flowood, MSBuilt 1982 · S/N 1268N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249N32DHHighgate Aero Inc · Swanton, VTBuilt 2004 · S/N 4542004N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692N32ERWolfe Bruce · Fredericksburg, TXBuilt 1978 · S/N AA5B0905N32FNNoska Frank S IV · Wasilla, AKBuilt 2023 · S/N NOSEXP18-001N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026N32HHagaman John G Trustee · Alexandria, VABuilt 1967 · S/N 1512N32HLSmith Elmer A · Rancho Cucamonga, CAS/N 176N32HYRunzel Brothers Aviation LLC · Bensenville, ILBuilt 2000 · S/N 2102N32JBHeimat Corp · Lincoln, NEBuilt 1971 · S/N 473N32JLSanson William P Jr · Dodge Center, MNBuilt 1967 · S/N 28-4391N32JMMiller Biplane LLC · Moberly, MOBuilt 1973 · S/N JM001N32JVChrapczynski Daniel T · Sheffield Village, OHBuilt 1993 · S/N M-II-001N32KAFowlkes Preston L · Marfa, TXBuilt 2002 · S/N 2193N32KHN32kh LLC · Quincy, WAS/N 287790384N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454N32LSPerhach Andrew J · Seattle, WABuilt 1989 · S/N 1208N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023N32NCEcho 7 Systems LLC · Lewes, DEBuilt 1999 · S/N 21989N32QXSpacewalker 2 LLC · Ocala, FLS/N 32091N32RVTimbie Peter W · Palatka, FLBuilt 1997 · S/N 22253N32SAAmoretti Remor Vinicius · Gardena, CABuilt 1977 · S/N 28-7725174N32SHFuller Jon A · Goliad, TXS/N 0599
Back to AD 79-10-03 R2