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.

N9750JBaltz Aviation Services LLC · Mercer, WIBuilt 1967 · S/N 28-3897N9750LLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1986 · S/N 17276608N9750QPurdy Adrian · Missouri City, TXBuilt 1975 · S/N 17265789N9751JR&A Aviation LLC · Flower Mound, TXBuilt 1967 · S/N 28-3944N9751MSchott Milbert F · Richland Center, WIBuilt 1967 · S/N 670045N9751UCox Glenn E · Denton, NEBuilt 1976 · S/N AA5A-0151N97528Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276308N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012N9752CAero-Sphere Inc · Longmont, COBuilt 1978 · S/N 28-7816524N9752UBg Aero Ltd Co · Coyle, OKBuilt 1976 · S/N AA5A-0152N9753UJ&M Aviation LLC · Atkinson, NEBuilt 1976 · S/N AA5A-0153N9753WSeppala Matthew T · Hortonville, WIS/N 28-23236N9754DLaney Charles A · Maiden, NCS/N 22-6668N9754MZiaja Rebecca · Virginia Beach, VABuilt 1967 · S/N 670048N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227N9755JDesroches John · Scottsdale, AZS/N 28-3947N9755WAncheta Kai A · Anchorage, AKBuilt 1967 · S/N 28-23239N9756JJackson Robert L · Leesburg, VABuilt 1967 · S/N 28-3948N9757JCarbiener Diane M · Kewanee, ILBuilt 1967 · S/N 28-3949N9757LGasper Joseph · New Port Richey, FLBuilt 1972 · S/N M-1378N9757UFairchild James C · Pinson, TNS/N AA5A-0157N9757WTld And Company LLC · Trenton, FLBuilt 1967 · S/N 28-23241N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N9758DEvans Michael K · Nome, AKS/N 22-6672N9758JKiarsis Stephen G · West Wareham, MABuilt 1967 · S/N 28-3950N9759JLazy H LLC · Carleton, NEBuilt 1967 · S/N 28-3951N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121N975BSSaurdiff Benjerman D · Two Rivers, AKBuilt 1979 · S/N 302-79N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718N975DGPhillips Duke · Hyattville, WYBuilt 2000 · S/N 2112N975LEBlue Borracho LLC · Manitou Springs, COBuilt 1975 · S/N 28-7690001N975LLWoodhouse William H · Power, MTS/N 975N975SGage Christopher R · Truckee, CABuilt 1999 · S/N 1263-99N976Green Alexander · Germantown, TNBuilt 1985 · S/N 673N9760CStreet Steven J · Rochester, MIBuilt 1978 · S/N 28-7816526N9760DDavis Michael P · Midway, UTBuilt 1959 · S/N 22-6675N9760JHanks Cathy J · Danville, KYBuilt 1967 · S/N 28-3953N9760MNeal Alan B · Cherry Valley, CABuilt 1967 · S/N 670054N9760UFitzgerald John P · Pittsburgh, PABuilt 1976 · S/N AA5A-0160N9760WRegistered aircraftBuilt 1967 · S/N 28-23244N9761PBig Q Aviation Corporation · Helena, MTBuilt 1975 · S/N 18-7609025N9761WRivera-Osorio Karolina · Monroe, NYS/N 28-23245N9762DMarshall Marcus D · Georgetown, TXBuilt 1959 · S/N 22-6677N9763JShaffer Timothy R · Marion, IABuilt 1967 · S/N 28-3958N9763MWaldren Paden · Garden Valley, CABuilt 1967 · S/N 670057N9764MSilcott Robert W III · Fairview, OKBuilt 1967 · S/N 670058N9764WMich John D · Fort Morgan, COBuilt 1967 · S/N 28-23250N97650Updraft LLC · Kissimmee, FLS/N 17276218N9765DPatey Daniel J · Lakewood, CABuilt 1959 · S/N 22-6680N9765JPinson Cassandra · Chandler, AZBuilt 1967 · S/N 28-3960
Back to AD 79-10-03 R2