AD 79-10-14 R1

Registered aircraft · 56,582

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-14-R1')
    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-14-R1')
  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.

N8897GShore Gerry · Inez, TXBuilt 1966 · S/N 15062997N8897STutak Peter B · Indianapolis, INFirst renewal noticeS/N 15062197N8897TZweigle Zachary John · Redding, CAS/N 52797N8897URobison Stephen K · Frederick, MDBuilt 1976 · S/N 15078018N8898BThompson Christopher L · Durango, COS/N 36598N8898QNorthrop Grumman Systems Corp · El Segundo, CABuilt 1976 · S/N U20603561N8898XSargent Matthew M · Glenwood, IABuilt 1961 · S/N 18253298N8899BBradberry Mason P · Wichita Falls, TXS/N 36599N8899UYoon Kerry D · Franklin, TNBuilt 1965 · S/N 17252820N8899XJohnston Thomas D · Heyworth, ILBuilt 1961 · S/N 18253299N889BABarr Air Patrol LLC · Mesquite, TXBuilt 1972 · S/N 18261204N889ESDalissandro Michael Douglas · Hampton, NHBuilt 1970 · S/N 18260448N889JBeasley William D Sr Trustee · Big Lake, AKS/N 50145N889SDMedary Aviation LLC · Brookings, SDBuilt 2025 · S/N 172S13322N889SLCunningham Richard Scott · Bedford, TXBuilt 1958 · S/N 50226N889SPLeading Edge Aviation Inc · Spencer, IABuilt 2002 · S/N 172S9088N889TVD & P Gammill Farms · Marked Tree, ARBuilt 1979 · S/N 18053109N88ABBrown James L · Athens, ALBuilt 1973 · S/N 17262739N88BLBrewer Jim L · Loco, OKS/N 206-0118N88CZThree Holer LLC · Clayton, GABuilt 1972 · S/N 18261382N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476N88GMField Drew H · Dallas, TXBuilt 1972 · S/N 150-73318N88HQAviation Capital Management LLC · San Jose, CABuilt 1973 · S/N 18262714N88HSShields Edwin G · York, SCBuilt 1968 · S/N 15069271N88JAGc Aviation Services-1 LLC · Miamisburg, OHBuilt 2001 · S/N 172S8776N88JDRichardson H L · Reform, ALBuilt 1978 · S/N 18266643N88KMTsukii Toshikazu · Tucson, AZBuilt 1977 · S/N 177RG1181N88KNRegistration Pending · Santa Rosa, CARegistration pendingBuilt 1966 · S/N 15065181N88KWDonnell James C · Crowville, LABuilt 1966 · S/N 17254367N88MALowry Michael L · Chesterton, INBuilt 1957 · S/N 34691N88MLProstar Flight Services LLC · Bozeman, MTBuilt 1979 · S/N 18267701N88NESorjen Inc · Indian Trail, NCBuilt 2023 · S/N 18283242N88NGBakke Dale W · Yankton, SDBuilt 1977 · S/N 177RG1223N88PBBraswell Jerrold W · Dillingham, AKS/N 207-00498N88PKGray Farms Inc · Albany, ORBuilt 1971 · S/N 18260772N88RBWarner David J · Englewood, OHBuilt 1972 · S/N 18261282N88RKJkg LLC · Idaho Falls, IDBuilt 1966 · S/N 18256967N88SQBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2021 · S/N 18283137N88SYYamashita Bruce · Honolulu, HIBuilt 1969 · S/N 17258613N88WTFlying L Aircraft Inc · Fort Denaud, FLBuilt 1950 · S/N 15438N89005Singh Fiyaad · Ocoee, FLBuilt 1997 · S/N 17280084N8900BMathews Denis W · Quanah, TXBuilt 1958 · S/N 36700N8900TSkyote LLC · Boise, IDBuilt 1960 · S/N 52800N8901BThompson Douglas P Trustee · Alton Bay, NHBuilt 1958 · S/N 36701N8901XHilde Justin · Statesboro, GABuilt 1961 · S/N 18253301N8902BLeonard William L · Gettysburg, PABuilt 1958 · S/N 36702N8902TShort Steven A · Neillsville, WIBuilt 1960 · S/N 52802N8902VFlycarolina LLC · Concord, NCS/N 17264259N8903XGreene Bruce · Asheville, NCBuilt 1961 · S/N 18253303N8904VWaymaker Aviation LLC · Yukon, OKBuilt 1974 · S/N 17264261
Back to AD 79-10-14 R1