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.

N78512United States Air Force Academy Aero Club · Usaf Academy, COBuilt 1969 · S/N 17257646N78513Reeder Gary T · Galena, OHBuilt 1968 · S/N 17257647N78515Becker Jarrod L · Selfridge, NDBuilt 1968 · S/N 17257648N78517Johnson Kevin R · Gladstone, ORBuilt 1968 · S/N 17257650N7851NWilson Steven Alfred Trustee · Runnells, IABuilt 1969 · S/N 28-5307N7851VJensen Jared E · Preston, IDS/N 2814N7851WJl Wings LLC · Prosper, TXBuilt 1964 · S/N 28-1870N78520Jdb Aviation Inc · Merritt Island, FLBuilt 1968 · S/N 17257651N78523Sunderman Randy · Norfolk, NEBuilt 1968 · S/N 17257653N78525Aero II Inc · Spartanburg, SCBuilt 1969 · S/N 17257655N78526Miklus Michael III · Saint Georges, DEBuilt 1968 · S/N 17257656N7852NDelatte Joseph S · Gonzales, LABuilt 1969 · S/N 28-5309N7852VCobb Brian P · Tucson, AZBuilt 1964 · S/N 2815N7852WSouthall David S · Poquoson, VABuilt 1964 · S/N 28-1871N78531Goodridge Flying Club Inc · Goodridge, MNBuilt 1968 · S/N 17257658N78538Drover Michael A · Winter, WIBuilt 1968 · S/N 17257660N7853CDue West Aviation LLC · Brandon, SDBuilt 1975 · S/N 28-7690086N7853HAlaska Department Of Fish And Game · Nome, AKBuilt 1946 · S/N 12-754N7853NLong Nels B · Caledonia, OHBuilt 1969 · S/N 28-5310N78542Tolmachev Nikolay A · Anchorage, AKBuilt 1968 · S/N 17257661N78548Bakalar Flying Club Inc · Columbus, INBuilt 1968 · S/N 17257662N7854GNeuschaefer George H · White Hills, AZBuilt 1970 · S/N 17259554N7854JMilstead Eric N · Tampa, FLBuilt 1966 · S/N 28-3736N7854PSarpy Aviation LLC · Hysham, MTBuilt 1962 · S/N 18-7869N78553Shop Branch Equipment Co Inc · Marble Falls, TXBuilt 1968 · S/N 17257666N78558Lindemann Robin · Anchorage, AKS/N 12-3933N7855GAlpenglow Air 3 LLC · Anchorage, AKBuilt 1970 · S/N 17259555N7855SCse Aviation LLC · Plymouth, MABuilt 1975 · S/N 28-7515331N7855VRyan Willam R · Jupiter, FLS/N 2818N78564Damico Anthony R · Anchorage, AKBuilt 1947 · S/N 12-3939N7856GMitchell Lindsey T · Chesnee, SCBuilt 1970 · S/N 17259556N7856N56 November LLC · Brighton, COBuilt 1969 · S/N 28-5313N7856VLampkin Derrick J · Bethesda, MDBuilt 1964 · S/N 2819N7856WN7856w LLC · Shelocta, PABuilt 1964 · S/N 28-1876N78574Johns Robert A · Anchorage, AKBuilt 1947 · S/N 12-3950N78575Hoppe Nicholas J · Big Lake, AKBuilt 1947 · S/N 12-3951N78579Hamilton George D · Bandera, TXBuilt 1968 · S/N 17257673N7857DHeinze Bill · Ashley, MIBuilt 1957 · S/N 22-5507N7857GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259557N7857NKranz Charles Leroy · Milbank, SDS/N 28-5314N7858DRegistration Pending · Raleigh, NCRegistration pendingBuilt 1957 · S/N 22-5508N7858WBeans Steven T · Cozad, NEBuilt 1964 · S/N 28-1879N78590Obrien Connor J · Mulino, ORBuilt 1968 · S/N 17257676N78596Oshea Thomas F · Hamilton, NJBuilt 1968 · S/N 17257678N78598Schaefer Joseph P · Weyerhaeuser, WIS/N 17257680N7859DMurray Craig W · Raymond, WABuilt 1957 · S/N 22-5509N7859GAviators LLC · Casco, WIBuilt 1970 · S/N 17259559N7859NNls Real Estate LLC · Irving, TXBuilt 1969 · S/N 28-5317N785ASA S Flight Academy LLC · Lantana, FLBuilt 1974 · S/N 17262954N785DKFoxes Asset Group LLC · Caddo Mills, TXBuilt 1980 · S/N M-2250
Back to AD 79-10-03 R2