OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N6894JPiontek Theodore J · Housatonic, MABuilt 1976 · S/N 28-7690422N6894UShonrock Clinton O · Los Alamos, NMBuilt 1963 · S/N 2598N6894WSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 28-21053N6895NLadd Noel Joseph Espinosa · Edmond, OKBuilt 1968 · S/N 680132N6895PDavis Jack J · Rifle, COBuilt 1960 · S/N 24-2029N6895UWoodward Jeffery F · Viroqua, WIBuilt 1963 · S/N 2599N6895WSale Reported · Brighton, COSale reportedBuilt 1965 · S/N 28-21054N6896HBuiqui Aerospace Corp · Kissimmee, FLBuilt 1975 · S/N 17265635N6896NHarding Ronald D · Spokane, WABuilt 1968 · S/N 680165N6897BCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1956 · S/N 18-5084N6897CSchumann Donald A · Naperville, ILBuilt 1978 · S/N 28-7890384N6897UStyer David B · Pendleton, ORBuilt 1963 · S/N 2601N6897WMcdowell Robert D · Snohomish, WABuilt 1965 · S/N 28-21059N6898HS J Holding LLC · Wilmington, DES/N 17265636N6898NMcdonald John A · Dublin, OHBuilt 1968 · S/N 680133N6899FLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7725081N6899NStearns Lloyd Bernard · Georgetown, TXBuilt 1968 · S/N 680167N6899UMayo Clayton E · Ten Mile, TNBuilt 1963 · S/N 2603N689BTDoell Brad J · Elsie, NEBuilt 1977 · S/N 28-7890132N68BAllen April E · Green Cove Springs, FLBuilt 1976 · S/N AA5A-0182N68BDBuiqui Aerospace Corp · Kissimmee, FLBuilt 1980 · S/N 17273907N68CSTrojen Properties LLC · Joplin, MOS/N 988N68DEMazzoni Dennis · Mays Landing, NJBuilt 1974 · S/N 745-74N68DGDellar Randy Roger · Wasilla, AKS/N 1208-95N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006N68EEBurtt John B · Pierson, MIBuilt 1975 · S/N 18-7509087N68FSistrunk Donald M · Ragley, LABuilt 1956 · S/N 22-4107N68GJDc Foote & Associates Inc · Camarillo, CAS/N 28-7425210N68HKPomeroy Andy Lee · Seattle, WABuilt 2004 · S/N 60323N68JCCapps Jon T · Bentonville, ARBuilt 1975 · S/N AA5-0801N68KBKeller Bros Airport Inc · Lebanon, PABuilt 1961 · S/N 24-2467N68LHGottschall James W · Highland, WIBuilt 1990 · S/N 434N68LKKing Larry E Jr · Wenatchee, WABuilt 1968 · S/N 18-8642N68MABig Creek Flyers LLC · Lewes, DEBuilt 2004 · S/N 2277N68MCAlpha Enterprises · Burley, IDBuilt 1981 · S/N 8-0004N68QCobb Lee C · Van Alstyne, TXBuilt 1971 · S/N OHB-1970N68RLSlutz David E · Morristown, TNBuilt 1979 · S/N AA5A0865N68SBLucey William E · Salisbury, NCBuilt 1984 · S/N 562N68VCammack Daniel P · Colorado Springs, COBuilt 1967 · S/N 28-4552N69007Jj Kramer Aviation LLC · Vero Beach, FLS/N 2933N6900DMahoney Shane · Auburn, WABuilt 1957 · S/N 22-4827N6900JCaruso Jerry W Jr · Kingsbury, NYBuilt 1976 · S/N 28-7615393N6900NBond William E · Elk River, MNBuilt 1968 · S/N 680168N6900PMyer Charles G · Forest Lake, MNBuilt 1960 · S/N 24-2034N6900URegistered aircraftBuilt 1964 · S/N 2695N6900WHall William Brent · Tulia, TXBuilt 1965 · S/N 28-21063N6901ASpence Stephen L · Anchorage, AKBuilt 1956 · S/N 29001N6901HRieser Steven E II · Baltimore, OHS/N 17265637N6901NRagsdale James W · Geneva, FLS/N 680134N6901QCbus Flight LLC · Pickerington, OHBuilt 1967 · S/N MB-265
Back to AD 79-10-03 R2