OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,401

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.

N115JLShakesby Paul S · Puryear, TNBuilt 1965 · S/N 263N115JRTobago4 LLC · Lawrenceville, GABuilt 1989 · S/N 937N115KMDoherty Sean V · Dunnigan, CABuilt 1999 · S/N B026N115MWBarretta Peter A III · Port Deposit, MDBuilt 1994 · S/N 82037/CN115NSprauer Constance D · Kensington, NHS/N 608N115NSMascher Lynn Scott · Chino Valley, AZBuilt 1970 · S/N 18-8910N115RVCaas Inc · Wilmington, DEBuilt 1998 · S/N 24228N115SGAileron Aviation LLC · Knoxville, TNBuilt 2001 · S/N 1316-2001N115WCDougherty Caroline J · Bethel, PABuilt 1993 · S/N 1001N115WTWray Robert J · Abilene, TXBuilt 2008 · S/N 1144N115XTStaley Ronald L · Lebanon, ORBuilt 2002 · S/N 2216N11600Nolan James B · Chandler, AZBuilt 1975 · S/N 17702354N11608Aircraft Trade Group LLC · Scandia, MNBuilt 1975 · S/N 17702357N1161ALindemann Robin · Anchorage, AKS/N 18-2691N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312N11625Oil Region Aviators LLC · Titusville, PABuilt 1975 · S/N 17702360N11626Frantz Ellen C · Abbeville, GABuilt 1974 · S/N 15075580N1162CReemts Randy G · Alexandria, MNBuilt 1977 · S/N 17702678N1163EKnik Flying Club LLC · Anchorage, AKS/N 987-77N1163FMid-Tenn Aero Club Inc · Franklin, TNBuilt 1979 · S/N 17272962N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396N11645Tango Bravo Air LLC · Nederland, COBuilt 1972 · S/N 344-72N11647Ronsman Harry · Talkeetna, AKBuilt 1972 · S/N 345-72N11650Dupuis Charles Jr · Breaux Bridge, LABuilt 1972 · S/N 839-72N11657Morgan Jacob R · Salem, INBuilt 1972 · S/N 347-72N11658Lorenz William D · Benson, MNBuilt 1972 · S/N 234-72N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872N11668Cummings Arthur J · Delta Junction, AKS/N 349-72N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77N1166LNovack Edward A · Cairo, NYBuilt 1965 · S/N 328N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180N11673Clobes Warren J · Evansville, WIBuilt 1972 · S/N 356-72N11676Stone Air LLC · Carrollton, GABuilt 1972 · S/N 236-72N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295N1168LDepaul Thomas J · Juneau, AKBuilt 1966 · S/N 330N1168PLangford Michael J · Middletown, MDS/N 3703N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N116AJJewett Chris E · Lexington, SCBuilt 2004 · S/N DC03N116ARLower Timothy C · Las Cruces, NMBuilt 1997 · S/N 24850N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094N116BBretana Charles Jr · Prescott, AZS/N E006N116BWButler Ross W · Jackson, CABuilt 2001 · S/N 24986N116CCCrawford E Clarke · Flagstaff, AZBuilt 1992 · S/N 824N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985N116ESOlson Edward H · Elizabeth, COBuilt 2021 · S/N 5N116FLMerdes Gordon B · Corpus Christi, TXBuilt 1974 · S/N 18-7509029
Back to AD 79-10-03 R2