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.

N875LBeaman David · Knoxville, TNBuilt 1977 · S/N AA5B0672N8760CReindl Thomas A · Algonquin, ILBuilt 1976 · S/N 28-7615126N8760MRegistration Pending · Cheney, WARegistration pendingS/N M-548N8761MJohnson Gregory J · Port Orange, FLS/N M-549N87621Shackelford Gary L · Parrish, FLBuilt 1949 · S/N 869N8762DEpperson James R · Sand Springs, OKBuilt 1958 · S/N 22-5946N8762EPrewitt Russell · Statham, GABuilt 1976 · S/N 28-7625156N8762NKlyc Aviation LLC · Lake City, FLBuilt 1969 · S/N 28-25582N8763EBodwell Keith J · West Cornwall, CTS/N 28-7615160N8764CMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7690160N8764EFa40 Plane LLC · New Port Richey, FLBuilt 1976 · S/N 28-7690202N8764GStrait Media LLC · Anchorage, AKS/N 15062864N8764J374dk Aviation LLC · Sand Springs, OKBuilt 1972 · S/N AA5-0116N8765CLatitude Aviation LLC · Spring, TXBuilt 1976 · S/N 28-7690161N8765EMoore Alex W · Deep Gap, NCBuilt 1976 · S/N 28-7690203N8765FSmith Nelson · Brighton, IAS/N 28-7790266N8765HN8765h LLC · Carthage, NCBuilt 1993 · S/N 1246N8766DRatliff Steven L · Spring Grove, PABuilt 1958 · S/N 22-5952N8767DGriffith Scott G · Newnan, GABuilt 1958 · S/N 22-5953N8767NAbernathy Larry D · Vernon, TXBuilt 1969 · S/N 28-25591N8768FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 62-0092N8768NHammonds Benjamin J · Newcomerstown, OHS/N 28-25589N876TBHenderson Tyler J · Goodland, KSBuilt 1999 · S/N 20363N876TUDudley Aviation Services LLC · Wilmington, DEBuilt 2005 · S/N 7030N8771CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690163N8773CScott Ansell E · San Diego, CAS/N 28-7690164N8773NBeen Flyin LLC · Colchester, CTBuilt 1969 · S/N 28-25597N8774DKeeler Michael E · Riverdale, MIS/N 22-5962N8775NPerez Jeremiah · Fort Worth, TXBuilt 1969 · S/N 28-25599N8776DThielen Andrew W · Marion, IABuilt 1958 · S/N 22-5964N8777NDaniel Adam Christopher · Sanford, NCBuilt 1969 · S/N 28-25601N8778MSchroemer Theodore J · High Point, NCBuilt 1963 · S/N M-208N8779NNorth Little Rock Air Inc · North Little Rock, ARBuilt 1969 · S/N 28-25604N877DAWest Prairie Aircraft LLC · Weiner, ARBuilt 1969 · S/N 28-25877N877GTSumner Gary · Knoxville, TNBuilt 1976 · S/N AA5A0267N877MAMason Rory L · Auburn, NEBuilt 1966 · S/N 28-3674N87806Tackett Russell G · Wilder, IDBuilt 1946 · S/N 12-7N8781DRowe David R · Homer, AKBuilt 1958 · S/N 18-6310N8782FDinger Kevin L · Naples, FLBuilt 1962 · S/N 0107N8783NGustafson Randolph W · Wisconsin Rapids, WIBuilt 1969 · S/N 28-25616N87844Baker Brady Brian · South Hero, VTBuilt 1977 · S/N 139N8784NBates James L · Reisterstown, MDBuilt 1969 · S/N 28-25621N87857Qualitair LLC Trustee · MichelstadtS/N 32N8785DSalter Phlip G · Beaumont, TXBuilt 1958 · S/N 18-6322N8785N85n Corp · Oak Hill, VABuilt 1969 · S/N 28-25622N8786Kiloecho Trnsport LLC · Tucson, AZBuilt 1974 · S/N 929N8786C8786c LLC · Cleburne, TXBuilt 1976 · S/N 28-7615129N8786DMikkelsen Timothy O · Wasilla, AKBuilt 1958 · S/N 18-6323N8786ELuv 2 Fly Ada LLC · Ada, OKBuilt 1976 · S/N 28-7615162N8786NSorenson Kyle F · Deaver, WYBuilt 1969 · S/N 28-25772
Back to AD 79-10-03 R2