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.

N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261N9608JGomm Bruce J · Colfax, NDS/N 28-3754N9608MWaryas Robert A · Long Island, VAFirst renewal noticeBuilt 1967 · S/N 670107N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693N9608RB2 West Corporation · Winona, MNBuilt 1959 · S/N TD-291N9608UNorth Shore Aviation LLC · Honolulu, HIBuilt 1975 · S/N AA5-0808N9608WBright Skies Sales & Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-23061N9609HWilliams Marc A · Fallon, NVBuilt 1990 · S/N 1167N9609JAdams Donald J · Lock Haven, PABuilt 1966 · S/N 28-3755N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694N9609WCullen Michael R · Fort Mohave, AZBuilt 1967 · S/N 28-23062N960ACNaples Air Center Inc · Naples, FLBuilt 1990 · S/N 2841325N960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386N960GSStevens Chad M · Huntsville, ALBuilt 1964 · S/N 2858N960RSSouthard James E Jr · Charleston, SCBuilt 1975 · S/N AA5-0807N960RVHouse Gregory E · Sealy, TXBuilt 2001 · S/N 80006N960TEBeauregard Timothy · Haslet, TXBuilt 2004 · S/N 10239N960VSSauder Philip J · Peninsula, OHBuilt 1959 · S/N 18-6799N960WCStardust Aviation LLC · Farmingdale, NYBuilt 2000 · S/N 2843368N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020N96105Demon Air LLC · Palm City, FLS/N 17276023N9610BGoodman Aviation LLC · Choteau, MTBuilt 1990 · S/N 1169N9610CHageman Theron · Jay Em, WYBuilt 1991 · S/N 1171N9610DHicks Joseph O · Germanton, NCBuilt 1958 · S/N 22-6520N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695N9610RReynolds Kirk S · Skaneateles, NYBuilt 1959 · S/N TD-305N9610UMaschek Anthony Q · Harker Heights, TXBuilt 1975 · S/N AA5-0810N9611CSamrat Prithviraj Inc · Miami, FLBuilt 1997 · S/N 1N9611JStull Donald K · Catawba, NCBuilt 1966 · S/N 28-3761N9611UKingsley Paul A II · Idledale, COBuilt 1975 · S/N AA5-0811N9612DSoto Edward · Wasilla, AKBuilt 1958 · S/N 22-6522N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263N9612JReich Gregory N · Schwenksville, PABuilt 1966 · S/N 28-3810N9612UElizabeth B Hawley · Wichita Falls, TXBuilt 1975 · S/N AA5-0812N9612WJama Aviation LLC · Blaine, MNBuilt 1967 · S/N 28-23066N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264N9613JKraun Fred M · Fall City, WABuilt 1966 · S/N 28-3766N9613UGlenn Thomas Joel Hr · Fort White, FLS/N AA5-0813N9613WAir Wilma LLC · Tijeras, NMS/N 28-23067N9614EWeber William J · Durham, NCBuilt 1991 · S/N 1179N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265N9614JSkinner Roger · Delanson, NYBuilt 1966 · S/N 28-3767N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699N9614SFlatonia Veterinary Clinic Inc · Flatonia, TXBuilt 1966 · S/N 46N9614WByrne Matthew A · West Allis, WIBuilt 1967 · S/N 28-23069N9615DPeterson Thomas M · Park Rapids, MNBuilt 1959 · S/N 22-6525N9615RAlbright Frank · Elba, ALBuilt 1991 · S/N 1185N9615UKnutson Duane G · Brookings, SDBuilt 1975 · S/N AA5-0815N9616ABoyd Ronald J · Genoa, COBuilt 1990 · S/N 1170N9616JGarsteck Paula · Put In Bay, OHBuilt 1966 · S/N 28-3769
Back to AD 79-10-03 R2