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.

N8860GBlack Spruce Aviation LLC · Hermon, MEBuilt 1966 · S/N 15062960N8861GMiller Andy D · Marana, AZS/N 15062961N8861SJump Brian · Watsonville, CAS/N 15062161N8861UBlanchard Donald P Jr · Napoleonville, LABuilt 1965 · S/N 17252775N8862SBarber Theodore C Trustee · Spanish Fork, UTS/N 15062162N8862UChase Tim W · Kearney, MOBuilt 1965 · S/N 17252777N8863BMollere Michael E · Marion, TXS/N 36563N8863UBoatman Robert G · Great Falls, MTBuilt 1965 · S/N 17252778N8863XDupuis Logging Inc · Polson, MTBuilt 1961 · S/N 18253263N8864TRegistration Pending · Murdo, SDRegistration pendingBuilt 1960 · S/N 52764N8865BRegistration Pending · Wentzville, MORegistration pendingBuilt 1958 · S/N 36565N8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLS/N 15062965N8865URegistration Pending · Parsons, KSRegistration pendingBuilt 1965 · S/N 17252780N8865XBeerman Paul L · Fort Wayne, INBuilt 1961 · S/N 18253265N88666Vincze Andras · Anchorage, AKBuilt 1957 · S/N 32778N8866SZimmer Linda S · Hillsboro, ILBuilt 1965 · S/N 15062166N8866TTrachta Stanley J · Tucson, AZBuilt 1960 · S/N 52766N8867BCowan Rena E · Pleasant Hill, ORBuilt 1958 · S/N 36567N8867GDavis Robert M · Liberal, KSBuilt 1966 · S/N 15062967N8867SCooper-White Michael L · Orrtanna, PABuilt 1965 · S/N 15062167N8867TCusimano Louis C · Montauk, NYBuilt 1960 · S/N 52767N8867UHoffman Robert E · Blossvale, NYBuilt 1965 · S/N 17252782N8868SMeriwether John N · Prairie Village, KSBuilt 1965 · S/N 15062168N8868TKlein Ryan L · Tijeras, NMBuilt 1960 · S/N 52768N8868UMuller Robert J · River Falls, WIBuilt 1965 · S/N 17252784N8869TDonaldson Lucas Paul · Owyhee, NVS/N 52769N8869XAshley Heating And Air Conditioning · Wasilla, AKBuilt 1961 · S/N 18253269N886ABWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 17281516N886CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283126N886CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281341N886EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12813N886KHLexi Air LLC · Boise, IDBuilt 1977 · S/N 21061727N88717Copp Mathew J · Cumberland, MEBuilt 1969 · S/N 18260100N8871BSing Clifford J Trustee · Idaho Falls, IDBuilt 1958 · S/N 36571N8871GHukill Warren J · Oakland, CABuilt 1966 · S/N 15062971N8871UWichmann William C · Owasso, OKBuilt 1965 · S/N 17252787N8871XRegistered aircraftBuilt 1961 · S/N 18253271N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972N8872SAeronautical Technical Service Inc · Collierville, TNS/N 15062172N8873BPathfinder Aerospace LLC · Raeford, NCBuilt 1958 · S/N 36573N8873GHarris David J · Aguila, AZBuilt 1966 · S/N 15062973N8873UOlafsen George F · Greeneville, TNBuilt 1965 · S/N 17252789N8874GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062974N8874TFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1960 · S/N 52774N8875TDelahunty Brian E · Ocala, FLBuilt 1960 · S/N 52775N8875UDunaire LLC · Mechanicsburg, PAS/N 15078009N8876BBeryl Aviation LLC · Omaha, NEBuilt 1958 · S/N 36576N8876XBowen Gabriel J · Salt Lake City, UTBuilt 1960 · S/N 18253276N88778Hubbard Austin L · Somerton, AZS/N R172-0128N88779Drexler Daniel L · Harrison, TNS/N R1720132
Back to AD 79-10-14 R1