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.

N7714WCrosswinds Flight Center Inc · Drums, PABuilt 1964 · S/N 28-1718N7715DIriarte Christopher P · Grosse Ile, MIBuilt 1957 · S/N 22-5389N7715GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259415N7715NK Heart Aviation LLC · Choudrant, LABuilt 1968 · S/N 28-5162N7715WFoster Kenneth D · Saint Maries, IDBuilt 1964 · S/N 28-1720N77160Fahmy Bishoy F · Fraser, MIBuilt 1973 · S/N 28-7425111N7716GFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259416N7716NPyanov Mark · Clinton, MSS/N 28-5163N7716WWood Burton T · Richmond Hill, GABuilt 1964 · S/N 28-1721N7717GJohnson Eric C · Turtle Lake, NDBuilt 1970 · S/N 17259417N7717HJohnson Paul C · Tower, MNBuilt 1946 · S/N 12-610N7717NAdirondack Flying Club LLC · Rome, NYBuilt 1968 · S/N 28-5160N7717VCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496120N7717WFouse Timothy · Kittanning, PABuilt 1964 · S/N 28-1722N7718NKlinedinst D Eric · Carlisle, PABuilt 1968 · S/N 28-5027N7718PVan Develde Robert K · Troy, MIBuilt 1961 · S/N 24-2931N7718WClyde Fliers Inc · Fremont, OHBuilt 1964 · S/N 28-1724N7719WKnudson Douglas E · Morris, ILBuilt 1964 · S/N 28-1725N7719XBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4496130N771BZOne Bz LLC · Clarklake, MIBuilt 2012 · S/N 12846N771JNSteiner Martin A · Bellaire, OHS/N 680041N771JSRhcp Inc · Virginia Beach, VABuilt 1989 · S/N 004N771MBMathis Alan L · Moultrie, GAS/N M-1851N771MRSmith Nathan · Palmer, AKBuilt 1967 · S/N 87N771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 2841154N771SHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 3543N771WSCampbell Reginald G · Hilo, HIS/N 28-24767N7720DBarnhill Jerry D · Longville, LABuilt 1957 · S/N 22-5394N7720GZulu Jets LLC · Boerne, TXBuilt 1970 · S/N 17259420N7720WLagrange LLC · East Helena, MTBuilt 1964 · S/N 28-1726N7720YEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 4496132N7721BHill Jack D · Tulsa, OKBuilt 1989 · S/N 590RN7721DRenick Tyler C · Wichita Falls, TXBuilt 1957 · S/N 22-5395N7721GWurtsboro Airpark LLC · Wurtsboro, NYS/N 17259421N7721JJgm Aviation LLC · Spring, TXBuilt 2009 · S/N 72111N7721NRome Nicholas S · Olathe, KSBuilt 1969 · S/N 28-5167N7721WKosobud Timothy J · Adams, WIBuilt 1964 · S/N 28-1727N77222Davis Sam Alan · Wendell, NCBuilt 1973 · S/N 17262487N7722GKnaack Roland · Cumming, GABuilt 1970 · S/N 17259422N7723DLutz Roald F · Sandia Park, NMBuilt 1957 · S/N 22-5397N7723NFord Charles D · Clifton, TNFirst renewal noticeBuilt 1968 · S/N 28-5166N7724GWind Walker LLC · Tucson, AZBuilt 1970 · S/N 17259424N7724PWay Steven J · Colleyville, TXBuilt 1961 · S/N 24-2937N7725NHangar Twenty Two Aviation LLC · Athens, TXBuilt 1968 · S/N 28-5169N7726DClaypool Bruce W · Bethel, AKBuilt 1957 · S/N 22-5402N7726POcallaghan David · Bonney Lake, WAS/N 24-2940N7726TWildwood Aerospace LLC · Cabot, ARBuilt 2003 · S/N 4057N7726WJrw Flight LLC · Huntsville, MOBuilt 1964 · S/N 28-1733N7727GSkyhawk Air LLC · Brunswick, GABuilt 1970 · S/N 17259427N7727WAukee Isaac J · Ironwood, MIBuilt 1964 · S/N 28-1734
Back to AD 79-10-03 R2