OpenAirDocs.org
AD 79-08-06

Registered aircraft · 5,263

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-08-06')
    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-08-06')
  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.

N1002HSmith Michael S · Anchorage, AKBuilt 1997 · S/N 23038CN1007UKallam Jerry · Palmer, AKBuilt 1998 · S/N 23047CN1008WRay Jonas · Palmer, AKS/N 23022CN100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185N1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650N1018HGulf Air Group Inc · Crestview, FLBuilt 1980 · S/N R18201649N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833N101NEDarby Flying Corp · Homestead, FLBuilt 1973 · S/N 201N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475N101TVSky Helicopters Inc · Garland, TXBuilt 1998 · S/N 0475N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080N1023XBickley David R · Pocatello, IDBuilt 1975 · S/N 28-7510074N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035CN103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923N103KCLang Elmer N · Hemphill, TXBuilt 1979 · S/N 28-7911238N1047YDonato Deleonardis · Paulden, AZBuilt 1997 · S/N 25016CN10480Piper 66 LLC · Kirksville, MOBuilt 1966 · S/N 32-279N1048TTrotter Thomas J · Bremerton, WABuilt 1997 · S/N 23037CN1048XRaven Aircraft LLC · Waynesville, OHS/N 25043CN104DMMcalee Dennis E · Defiance, MOBuilt 1984 · S/N 1DMN105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483N105DYYeager Daniel C · Iowa City, IABuilt 1966 · S/N 32-467N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015N106JLinder Michael A · Arvada, COBuilt 1961 · S/N 24-2668N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416N106NAVann-Tage Point Aviation LLC · New Castle, DES/N 32-704N106RMAdvanced Aviation Solutions LLC · Jasper, INBuilt 1983 · S/N R18201932N107AKLazzaro Chris C · Solvang, CABuilt 1988 · S/N 4055CN107RHHenderson Robert T Jr · Sunny Isles Beach, FLBuilt 1977 · S/N R18200093N108SGVahsholtz Matthew James · Conroe, TXBuilt 1958 · S/N 24-149N10CRCarlile Aviation LLC · Peculiar, MOBuilt 1981 · S/N R18201808N10DTBernath Jacob D · Indianapolis, INBuilt 1978 · S/N TSB-1N10GRamsey Wayne · Abilene, TXBuilt 1979 · S/N R18201161N10NWLinzey David Wayne · Boone, NCBuilt 1963 · S/N 24-3548N10SGBranyan Tyson E · Cushing, OKBuilt 1960 · S/N 24-2112N10SYBellany Mark A · Freeville, NYS/N 7487CN10TUAction Aviation LLC · Idaho Falls, IDBuilt 1982 · S/N 18268195N110DGRawls Thomas R · Cincinnati, OHBuilt 1990 · S/N 1N110LFComanche Flyer Foundation Inc · Blaine, WAS/N 24-695N11131Gaglioti John · Monterey, CABuilt 1983 · S/N R18201942N11151Kowest Aviation LLC · Enid, OKBuilt 1959 · S/N 24-1631N111AJBergin Donald M · Ormond Beach, FLBuilt 1972 · S/N 32-7200041N111FCWoody Air LLC · Vero Beach, FLBuilt 1968 · S/N 32-1030N111FFGutierrez Isaias · Fontana, CAS/N R18200807N111LUSchaefer Robert Lee · Orange, CABuilt 1979 · S/N 28-7911091N111MBTinder John A · Rancho Cucamonga, CABuilt 1981 · S/N 28-8211003N111SLKaehlert Lottie DBA · Rifle, COS/N 24-2532N1126CBriggs Jonathan · Merritt Island, FLBuilt 1981 · S/N R18201689
Back to AD 79-08-06