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.

N518CACompass Aviation Inc · Shelby, NCBuilt 1979 · S/N 17273049N518ERoland Kenneth R · Tell City, INS/N R-G-H-1N518PLMoore David P Trustee · Chattanooga, TNBuilt 1975 · S/N AA5B-0144N518RMWinkelmann Pete J · North Fond Du Lac, WIBuilt 2002 · S/N 60099N518SWGilchrist Robert T · White Salmon, WABuilt 1955 · S/N 18-4389N518TPos LLC · Glencoe, MOS/N 3466N518TCBedell Gary L · Henderson, NVBuilt 2001 · S/N 9932CCN518TRCorrina Cumulus LLC · Kalispell, MTBuilt 2001 · S/N 22518N5190LKing Samantha M · Mcdonough, GABuilt 1967 · S/N 28-4479N5190SRobinson Richard D · Montclair, CABuilt 1970 · S/N 28-7105050N5190TMhe Aviation LLC · Las Vegas, NVBuilt 1967 · S/N 141N5191Murray Stewart · Capay, CABuilt 1968 · S/N 432N5191HPearce David W Trustee · Anchorage, AKBuilt 1949 · S/N 14-509N5191JN5191j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273724N5191LGravley Kevin · Wiggins, MSBuilt 1967 · S/N 28-4480N5191RKlein Alan D · Hudson, WIBuilt 1974 · S/N 17263408N51920Wilkinson Edward H · Aspers, PABuilt 1980 · S/N 17274377N5192HAlexander Steve T · Wasilla, AKS/N 14-510N5192LKirkpatrick William J · Tyrone, PAS/N 28-4481N5192SCxo Time Builder LLC · Magnolia, TXBuilt 1970 · S/N 28-7105052N5192VStippich James A · Panama City, FLS/N 172RG0464N5192XDavis Wayne W · Wakefield, RIBuilt 1969 · S/N 180N51930Garrett Jeff S · Waco, TXBuilt 1980 · S/N 17274378N51931Jones Donald T Jr · Barrigada, GUBuilt 1980 · S/N 17274379N5193ER&R Aero Services LLC · Eden Prairie, MNS/N 17271763N5193HClear Skies Avionics Inc · Clearwater, FLBuilt 1975 · S/N 17265368N5193LC And H Aviation LLC · Madison, MSBuilt 1967 · S/N 28-4482N5193RHaralson Aviation Inc · Elberton, GABuilt 1974 · S/N 17263410N5193SEagle Christopher S · Columbus, GABuilt 1970 · S/N 28-7105053N5194FSanders Flight Training Center Inc · Jasper, ALBuilt 1979 · S/N 17273125N5194HGottschalk Jon R · Stuart, FLBuilt 1949 · S/N 14-494N5194KHowe'S Flight Concepts LLC · Visalla, CAFirst renewal noticeBuilt 1980 · S/N 17274005N5194LByham Shawn Grant Charles · Santa Margarita, CABuilt 1967 · S/N 28-4483N5194MSunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N ME-17N5194RFitzke Lee J Trustee · Lakeville, MNBuilt 1974 · S/N 17263411N5194WHarris Kenneth G · Port Saint Lucie, FLBuilt 1961 · S/N 28-229N51952Jandd One LLC · Bozeman, MTBuilt 1980 · S/N 17274381N51958Mike'S Aircraft Shop Inc · Corpus Christi, TXBuilt 1980 · S/N 17274383N5195ESix Ten Ventures LLC · Grand Prairie, TXBuilt 1978 · S/N 17271764N5195HFowler Raymond D · Homer, AKBuilt 1949 · S/N 14-496N5195SToby Aviation Inc · Pigeon Forge, TNBuilt 1970 · S/N 28-7105055N5195WQuenzer Floyd N · Fresno, CABuilt 1961 · S/N 28-230N51960Xin Han Aviation LLC · Atwater, CABuilt 1980 · S/N 17274384N5197ETspy Services Inc · Wilmington, DEBuilt 1978 · S/N 17271765N5197FKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1976 · S/N 28-7790086N5197HSullivan Edward A · Remsenburg, NYBuilt 1975 · S/N 17265370N5197JEide Paul · Moses Lake, WAFirst renewal noticeBuilt 1981 · S/N 17275000N5197KN5197k LLC · Cheyenne, WYBuilt 1980 · S/N 17274007N5197LSeuferer Kevin J · Osceola, IABuilt 1967 · S/N 28-4487N5197RMedia Stew LLC · Carson City, NVS/N 17263414
Back to AD 79-10-03 R2