OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N88315Uscola Merle J · Wasilla, AKBuilt 1974 · S/N 766-74N8831NAllen Aviation LLC · Mansfield, MABuilt 1969 · S/N 28-25682N88322North County Flight Training Inc · Carlsbad, CAS/N 767-74N88329Collins Aviation LLC · Tillar, ARBuilt 1974 · S/N 112-74N8832JN597w Llp · Arnold, MDBuilt 1965 · S/N 28-2788N88345Walker Norman K · Anchorage, AKFirst renewal noticeBuilt 1974 · S/N 769-74N88352Morris Charles R III · Charlotte, NCBuilt 1974 · S/N 116-74N8835DBrocke Rodney A · Bay City, MIBuilt 1958 · S/N 22-6005N88364Adamson Rex E · Cody, NEBuilt 1974 · S/N 117-74N88365Mertens Trusty E · Presho, SDS/N 772-74N88368Fitch Keagan M · Philip, SDBuilt 1974 · S/N 118-74N8836JSonic Skunk Works LLC · Houston, TXBuilt 1965 · S/N 28-2793N8837DComanche Bloom Enterprises LLC · Purcellville, VABuilt 1958 · S/N 22-6007N8837JJerry Wachtel N · Carleton, NEBuilt 1965 · S/N 28-2794N8837NAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1969 · S/N 28-25688N88384Wingit Holdings LLC · Mannford, OKBuilt 1974 · S/N 774-75N88385Skywords Advertising LLC · Lantana, FLBuilt 1974 · S/N 775-75N8838JSchlensig Randall D · Anthem, AZBuilt 1965 · S/N 28-2795N8839888398 LLC · Fremont, OHBuilt 1974 · S/N 776-75N8839DHunter Houston W Jr · Marrero, LABuilt 1958 · S/N 22-6009N8839JPadgett John E · Austin, TXS/N 28-2796N8839NCooper Thomas J · Henderson, NVBuilt 1969 · S/N 28-25690N883CFolkers Daniel E · Norwalk, IABuilt 1973 · S/N 28-7325345N883MMoffett James D · North East, MDBuilt 1969 · S/N 28-26047N883RVMann Allen W Trustee · Post Falls, IDBuilt 1993 · S/N 21677N883TCCoughlin Brian T · Cazenovia, NYBuilt 2023 · S/N 001N88401Kimball Clayton Scott · Richland, WABuilt 1974 · S/N 122-75N88405Mulhern Georgia · Waddell, AZS/N 784-75N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691N88412Rider Shawna · Anchorage, AKS/N 779-75N88417Alaska Department Of Fish And Game · Fairbanks, AKS/N 123-75N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798N8841WRegistration Pending · Dilley, TXRegistration pendingBuilt 1964 · S/N 28-10390N8841YHoffman Avery E · Bethel, AKBuilt 1973 · S/N 18-7309025N88421Dular Emil M · Elizabethtown, KYBuilt 1974 · S/N 785-75N88424Iowa Aerial Advertising LLC · Perry, IAS/N 305-75N88425Klamar Spraying Inc · Gatzke, MNBuilt 1974 · S/N 786-75N8842CTerry Jay F · Rome City, INBuilt 1953 · S/N 22-1455N8842DVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1958 · S/N 22-6012N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799N8843JDiorio Christopher J · Melba, IDS/N 28-2801N88443Jkt LLC · Douglas, WYBuilt 1974 · S/N 130-75N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N88451Williams Charles S · Pearland, TXS/N 131-75N88458Cole John R · Greenfield, INBuilt 1975 · S/N 790-75N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803N88465Castleberry Inc · Ekalaka, MTBuilt 1974 · S/N 791-75N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804
Back to AD 79-10-03 R2