AD 79-10-14 R1

Registered aircraft · 56,582

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-14-R1')
    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-14-R1')
  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.

N736LXTaylor Tom M · Tulsa, OKBuilt 1977 · S/N R1722622N736MC3 Pandas LLC · Farmington, NMBuilt 1977 · S/N R1722626N736MDBrown Tyler Cooper Trustee · Anchorage, AKBuilt 1977 · S/N R1722627N736MFTurnagain Airventures LLC · Anchorage, AKBuilt 1977 · S/N R1722629N736MKDavis Rodger C · Anchorage, AKBuilt 1977 · S/N R1722633N736MLH & L Acquisitions LLC · Flushing, MIBuilt 1977 · S/N R1722634N736MNSeidler Matthew J · Anchorage, AKBuilt 1977 · S/N R1722635N736MPDarby Air Ltd · Lincolnshire, ILBuilt 1977 · S/N R1722636N736MTLowe John H · Tifton, GABuilt 1977 · S/N R1722640N736MVMyers Aviation Inc · Oshkosh, WIS/N R1722642N736MWWestern Radio Services Co · Prineville, ORBuilt 1977 · S/N R1722643N736MYLandry Cheryl A · Mendon, MABuilt 1977 · S/N R1722645N736NCGully Justin T · Anoka, MNS/N R1722649N736NEMahoney Daniel P III · Locust Grove, VABuilt 1977 · S/N R1722651N736NFFhr Inc · Honolulu, HIBuilt 1977 · S/N R1722652N736NHCi Aviation LLC · Broadview Heights, OHBuilt 1977 · S/N R1722654N736NKMaine Air Physician Services LLC · Machias, MEBuilt 1977 · S/N R1722656N736NNM2 Aviation LLC · White Lake, MIBuilt 1977 · S/N R1722659N736NPMbn Leasing LLC · Dover, DEBuilt 1977 · S/N R1722660N736NQAs In The Key Aviation LLC · Marathon, FLBuilt 1977 · S/N R1722661N736NWG Force LLC · Las Vegas, NVBuilt 1977 · S/N R1722667N736NYTerry Mark Benjamin · Henderson, NCBuilt 1977 · S/N R1722669N736NZColey Steven J · Baker City, ORBuilt 1977 · S/N R1722670N736PBWoods Joyce M Trustee · Albuquerque, NMBuilt 1977 · S/N R1722671N736PCMoore Glen O · Carson City, NVBuilt 1977 · S/N R1722672N736PDMiner'S Outdoor Adventures LLC · Hermantown, MNBuilt 1977 · S/N R1722673N736PEBohannon Ronald D · Newburgh, INBuilt 1977 · S/N R1722674N736PHReynolds Thomas J · Dillon, MTBuilt 1977 · S/N R1722677N736PKA&R In The Clouds LLC · Myrtle Beach, SCBuilt 1977 · S/N R1722679N736PLSims Charles R Jr · Tuscumbia, ALS/N R1722680N736PMBennett James P · Milford, DEBuilt 1977 · S/N R1722681N736PPLuksch Daniel C · Murfreesboro, TNS/N R1722683N736PQRegistration Pending · John Day, ORRegistration pendingS/N R1722684N736PRM3 Aviation LLC · Wausau, WIS/N R1722685N736PWTheno Steven M · Coupeville, WABuilt 1977 · S/N R1722690N736PYTurbine Financial Group LLC · Ogden, UTS/N R1722692N736QAQuintana Cesar A · Sunny Isles Beach, FLS/N R1722694N736QBHambrick Joseph G · Carthage, TXS/N R1722695N736QCKirtland Aero Club · Kirtland Afb, NMS/N R1722696N736QFWilliams Mitchell L · Chickasha, OKBuilt 1977 · S/N R1722699N736QGG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N R1722700N736QNSkjonsberg Robert A · New Effington, SDS/N R1722706N736QSWerme Eric Brian · King George, VABuilt 1977 · S/N R1722710N736QYWanken Troy F · Shelby, MTFirst renewal noticeBuilt 1977 · S/N R1722716N736RCAtwood William E · Millersville, MDBuilt 1977 · S/N R1722720N736RFBiz Flyers LLC · Great Falls, MTBuilt 1977 · S/N R1722723N736RHJabavu Aviation LLC · Cedar Hill, TXBuilt 1977 · S/N R1722725N736RKRegistered aircraftBuilt 1977 · S/N R1722727N736RPExtter Aviation LLC · Parker, COS/N R1722731N736RRWatts Glenn L · Anchorage, AKBuilt 1977 · S/N R1722733
Back to AD 79-10-14 R1