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.

N98203Rfb Cherokee LLC · Perkinston, MSBuilt 1969 · S/N 28-26099N98205Uhlemeyer Douglas · O Fallon, MOBuilt 1969 · S/N 28-26102N98208Anderson James D · Tecumseh, MIBuilt 1969 · S/N 28-26105N9820WMcgahan Merrill M · Kenai, AKS/N 28-23322N98210Hancock Ricky L · Anchorage, AKBuilt 1969 · S/N 28-26106N98212Alpha Aviation Group LLC · Clawson, MIBuilt 1969 · S/N 28-26108N98218Engleman Roy J · Mcalester, OKBuilt 1969 · S/N 28-26114N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721N9821UCoquimbo Capital Holdings LLC · Sandy, UTBuilt 1976 · S/N AA5A0221N98222Diol Ranjit S · Dowagiac, MIBuilt 1969 · S/N 28-26117N98223Lustig Keith C · Clyde, MIBuilt 1969 · S/N 28-26118N98226Whited Ronald Glenn · Tampa, FLS/N 28-26120N9822UMoyer Curtis · Bedford, INBuilt 1976 · S/N AA5A0222N9822VJohnson Mark W · Valrico, FLBuilt 1974 · S/N 17264515N9822YMontana Aviation Tryst LLC · Kalispell, MTBuilt 1961 · S/N 7GCB-57N98237Pierce Teddy D · Savannah, MOBuilt 1969 · S/N 28-26125N98239Sushko Michael S · Plymouth, MNS/N 28-26126N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623N9823UMorrow Robert C · Edgewater, FLBuilt 1976 · S/N AA5A0223N98240Petersen Amos I · Iowa City, IAS/N 28-26127N98241Lh Investments Inc · Albany, ORBuilt 1969 · S/N 28-26129N98242Husbands Klayton P · Bosque, NMBuilt 1969 · S/N 28-26130N98244Kingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26002N98249Tramper Air LLC · Rockford, MIBuilt 1969 · S/N 28-25972N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624N9824UPurpose Flight International LLC · Wilmington, DEBuilt 1976 · S/N AA5A0224N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269N98257Fly High Aviation LLC · Miami, FLBuilt 1969 · S/N 28-25954N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725N98263Myers Bobby L · Brookhaven, MSBuilt 1969 · S/N 28-26132N98265Dickey Hugh B III Dr · Rock Hill, SCBuilt 1969 · S/N 28-26134N98266Lockhart Ralph E Jr · Beverly, OHBuilt 1969 · S/N 28-26135N98268Baldassari Roy L · Lawrenceville, NJBuilt 1969 · S/N 28-26137N98269B&R Aircraft LLC · Wadsworth, OHBuilt 1969 · S/N 28-26138N9826WWestrup Gregory W · Greensburg, INBuilt 1967 · S/N 28-23329N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272N98273Ortner Russell · Apopka, FLBuilt 1969 · S/N 28-26141N9827DQuality Aviation Inc · Marana, AZS/N 22-6717N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727N9827UFiedler William K · Greensboro, GABuilt 1976 · S/N AA5A0227N9827YRegistration Pending · Sweet Home, ORRegistration pending, pending cancellationBuilt 1960 · S/N 50N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625N9828UAble Gary N · Houston, TXBuilt 1976 · S/N AA5A0228N98293Je Aircraft Repair LLC · Wasilla, AKBuilt 1969 · S/N 28-26150N98297Black Hawk Flight Progress LLC · Cedar Falls, IABuilt 1969 · S/N 28-26254N98298Parsons Mark E · Le Roy, WVBuilt 1969 · S/N 28-26154N9829JInflight Corp · Chaffee, MOBuilt 1980 · S/N 17273928
Back to AD 79-10-03 R2