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.

N4814CKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275868N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366N4814ESchwartz Andrew T · Bethesda, MDS/N 18503879N4814UHash Marshall T · Inglis, FLBuilt 1963 · S/N 2050514N4815Ober John A · Candor, NYS/N 18053056N4815CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276453N4815DBodeen Lance A · Eagle River, AKBuilt 1958 · S/N 34915N4816RA&C Ag Aviation Inc · Unadilla, GABuilt 1975 · S/N 18802336TN4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388N4817DWirt James · Goldsby, OKBuilt 1958 · S/N 34917N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367N4818XSchmitt Justin M · Shawneetown, ILBuilt 1966 · S/N 15064868N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367N4819NSilva Robert · Davis, CABuilt 1979 · S/N 18267391N4819QPuryear Rodney K · Pampa, TXBuilt 1976 · S/N 18802556TN481CGGill Christopher W · Aiken, SCBuilt 1971 · S/N 15073054N481CPBlue Water Aviation LLC · Oakman, ALBuilt 2008 · S/N 18282048N481DGrey Goose LLC · Wasilla, AKBuilt 1957 · S/N 50255N481EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12250N481HWilliams Stephen C · Georgetown, MEBuilt 1961 · S/N 185-0116N481JCollins Jason · Mansfield, OHBuilt 1977 · S/N 21061580N481PMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1977 · S/N U20603684N481QAdams Eddie · Senath, MOS/N 18053060N481TRBowen Tim S · Robstown, TXBuilt 1978 · S/N U20604383N481USalter 11x LLC · Duluth, MNS/N 18504438N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369N4820EHogan Mark C · Sisters, ORBuilt 1979 · S/N 18503880N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368N4821USouth Side Corp · Loomis, NEBuilt 1963 · S/N 205-0521N4822DRegistered aircraftBuilt 1958 · S/N 34922N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370N4822NBalinski Stephen W · Lusby, MDBuilt 1979 · S/N 18267394N48233Miller Robert S · Mesa, AZBuilt 1968 · S/N 337M0294N48237Yoder Airways LLC · Fayetteville, GABuilt 1967 · S/N R172-0171N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391N4823XVon Bernewitz David A · Myersville, MDBuilt 1966 · S/N 15064873N4824FWheeler Michael P · Declo, IDBuilt 1966 · S/N U206-0524N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372N4824XPowell Kevin D · Nampa, IDS/N 15064874N4825DHitec Construction Services Inc · Lincoln, CABuilt 1958 · S/N 34925N4825EParis Enterprises LLC · Atlanta, GABuilt 1979 · S/N 18503883N4825FLober Richard M · Bishop, CABuilt 1966 · S/N U206-0525N4825NBlue 79 LLC · Loogootee, INBuilt 1979 · S/N 18267397N4826DTurbine Training Center Inc · Manhattan, KSBuilt 1958 · S/N 34926N4827DWebber David A · Delta Junction, AKBuilt 1958 · S/N 34927N4827UHagen Rainer · Irving, TXBuilt 1979 · S/N U20605119N4827XPpy Fly Corp · Atlanta, GAS/N 15064877N4828DNisbet William T · Driggs, IDBuilt 1958 · S/N 34928N4828PFlying Nam LLC · Sheridan, WYBuilt 1981 · S/N 17274828N4828XGillette David L · Carrollton, TXFirst renewal noticeBuilt 1966 · S/N 15064878
Back to AD 79-10-14 R1