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.

N64THRaincross Aviation Services Inc · Wilmington, DES/N 22619N64TLWadsworth Harley C · Albuquerque, NMBuilt 2000 · S/N 21180N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959N64TZChapel Hill Flying Club DBA · Sanford, NCBuilt 1981 · S/N 28-8216081N64WLLawrence Brian · Seal Beach, CABuilt 1997 · S/N 9612N64YUCane Creek Aviation LLC · Asheville, NCBuilt 2004 · S/N 25997N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666N6500ERegistered aircraftBuilt 2005 · S/N 10246N6500JHorizon Aviation LLC · Brooks, GABuilt 1968 · S/N 28-4933N6500UWhitson Mark A · Houston, TXBuilt 1962 · S/N 2253N6501Ramirez Ricardo M · Camano Island, WAS/N 100-2N6501CGcbc LLC · Norman, OKBuilt 1978 · S/N 28-7816428N6501JAndersen Aviation LLC · Leavenworth, WAS/N 28-4934N6501RAbove Earth Aerospace LLC · Friendswood, TXBuilt 1974 · S/N M-1537N6501WStewarts Aircraft Service Inc · Waynesville, OHBuilt 1964 · S/N 28-20578N6502Keen Brandon M · Brunswick, MEBuilt 1962 · S/N 28-566N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670N6502JGanuza Diego J · Okeechobee, FLBuilt 1968 · S/N 28-5114N6502WMid American Pilot Association Inc · Lawrenceville, ILBuilt 1965 · S/N 28-20579N6503BSmith Gregory E · Manila, ARFirst renewal noticeBuilt 1957 · S/N 1170N6503DManubay John M · Sinking Spring, PABuilt 1979 · S/N 17272834N6503JTischler Keith Louris · Round Rock, TXBuilt 1968 · S/N 28-4938N6503UMooney 6503u LLC · Naples, FLBuilt 1962 · S/N 2257N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674N6504CBraddy James R Jr · Sunnyvale, TXBuilt 1978 · S/N 28-7890377N6504RJohn M Peters · Damascus, MDBuilt 1974 · S/N MB-716N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678N6505JWedel Dan P · Fairmont, MNBuilt 1968 · S/N 28-4941N6505UBell Keith O · Navarre, FLBuilt 1962 · S/N 2259N6505WOndracek Jack E · Port Orchard, WABuilt 1964 · S/N 28-20582N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681N6506AFallon Timothy R · Ithaca, NYBuilt 2005 · S/N 10247N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835N6506ULambert Isabelle O · El Paso, TXBuilt 1962 · S/N 2260N6506WRoehrig Michael A · Fairport, NYBuilt 1965 · S/N 28-20583N6507CBollum Justin Keith · Chevy Chase, MDS/N 28-7816533N6507RJoachim Peter · Grafton, WIBuilt 1974 · S/N MB-724N6507UBovey Dominic C · Sandpoint, IDBuilt 1962 · S/N 2261N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205N6508RSterling Creek LLC · Brookings, SDBuilt 1974 · S/N M-1583N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470N6509JRoot Rickey · Nederland, TXBuilt 1968 · S/N 28-4945N6509RHolzhauer Aviation Corp · Middletown, DEBuilt 1974 · S/N M-1584N650FLHarps Thomas B · Vilonia, ARBuilt 1971 · S/N 28-7125559N650TThompson Matt · Shawnee, KSBuilt 1958 · S/N TD-125
Back to AD 79-10-03 R2