OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N260RJHitterman James D · Metropolis, ILBuilt 1982 · S/N 1N26100Carey International Aviation Services LLC · Rockville Centre, NYBuilt 1977 · S/N AA5A0424N26103Williams Richard · Atlanta, GABuilt 1977 · S/N AA5A0426N26104Sumner Gary W · Knoxville, TNBuilt 1977 · S/N AA5A0402N26106Polymer Depot LLC · Delafield, WIBuilt 1977 · S/N AA5A0427N26114Flyinisme LLC · Saint Augustine, FLBuilt 1977 · S/N AA5A0433N26116Fasske Wayne · Crossville, TNBuilt 1977 · S/N AA5A0437N26120Houk David A Jr · Norton, OHBuilt 1977 · S/N AA5A0441N26122Smile Givers · Chico, CABuilt 1977 · S/N AA5A0443N26124Chapman Edward J DBA · Jordan, MNBuilt 1977 · S/N AA5A0444N26127Rose David Alan · Port Orange, FLBuilt 1977 · S/N AA5A0446N2612ZStewart Jon L · Walker, MNBuilt 1977 · S/N 1002-77N26130Bokkers Maike L · Mountain View, CABuilt 1977 · S/N AA5A0447N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443N26136Aoki Nidal · Porter, TXBuilt 1977 · S/N AA5A0452N2613PBraun Daniel R · Damascus, ORS/N 22-2948N26142Stamper George William III · Quinton, VABuilt 1977 · S/N AA5A0454N2614DRegistration Pending · Kerrville, TXRegistration pendingBuilt 1987 · S/N 0727N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292N26160Wilson William J · Houston, TXBuilt 1977 · S/N AA5A0455N26163Brown Michael D · Elk Grove, CABuilt 1977 · S/N AA5A0456N26165Moldt Richard W · Montrose, CAS/N AA5A0457N26167Mowery Ronnie G · Spencer, OHBuilt 1977 · S/N AA5A0461N26172Flying Tigers Flight School Ltd · Houston, TXBuilt 1977 · S/N AA5A0465N26179Richardson James D II · Bend, ORBuilt 1977 · S/N AA5A0468N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707N2617ZCroy Branden J · Kendallville, INBuilt 2001 · S/N 1301N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954N2619DInman Steve · Billings, MTBuilt 1952 · S/N 20771N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955N261DMOelmann Dennis J · Waverly, IAS/N 379N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697N261HHoward Clifford E · Auburn, WABuilt 1968 · S/N R.E.C.2N261XEvans Dennis · Naples, FLBuilt 2000 · S/N 60239N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471N2620CWhalen Shenandoah · Amelia, OHBuilt 1987 · S/N 0725N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091N2621KBasmajian Zachary Robert · Peoria, AZBuilt 1954 · S/N 54-2629N2621MWestern Oklahoma Aviation LLC · Clinton, OKBuilt 1977 · S/N 28-7816297N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202N2622HBurgess John H · Tower, MNS/N 001N2622MN2622m LLC · Rehoboth Beach, DEBuilt 1982 · S/N 0735MN2622TStenvers Aaron · Valley, NEBuilt 1991 · S/N 1823N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295N26234Compositec Inc · Manitowoc, WIS/N AA5A0458N26236Mcdonnel Jack Edward Jr · Woodsboro, TXBuilt 1977 · S/N AA5A0475N26237Registration Pending · Spokane, WARegistration pendingBuilt 1977 · S/N AA5A0476N26239Rice Grantland S · Boston, MABuilt 1977 · S/N AA5A0477N2623BWalton Indy R · Soldotna, AKS/N 5160N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959
Back to AD 79-10-03 R2