OpenAirDocs.org
AD 76-14-07 R2

Registered aircraft · 930

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:76-14-07-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:76-14-07-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.

N9407TBodin Logan T · Lake Charles, LAS/N 57207N9407XDriggers Kenneth Jerry · Rialto, CABuilt 1961 · S/N 21057707N9409TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57209N9410XHendrix Philip R · Corpus Christi, TXS/N 21057710N9411XDiy Aerial LLC · Watkinsville, GABuilt 1960 · S/N 21057711N9414XSproul Lee E Jr · Lincoln, RIBuilt 1961 · S/N 21057714N9415XGarcia-Koren Maria J Personal Representative · Albuquerque, NMS/N 21057715N9417XBentley Ross M · Saint Helena, CABuilt 1961 · S/N 21057717N9419TPieper Mike D · Chandler, OKBuilt 1960 · S/N 57219N9422TGraves Frank C · Nocona, TXBuilt 1960 · S/N 57222N9422XLittle Bird Airways LLC · Hamburg, NYBuilt 1962 · S/N 21057722N9424TGill Melvin L Jr · Nashville, TNS/N 57224N9425TBlue Skies Flying Services LLC · Blandon, PABuilt 1960 · S/N 57225N9426XBradley Brunhilde K Trustee · Litchfield Park, AZBuilt 1961 · S/N 21057726N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416N9430TRmb Leasing Inc · Dover, DEBuilt 1960 · S/N 57230N9433TDoyle Victoria L · Salem, ORBuilt 1960 · S/N 57233N9434TChurch Philip M · Statesville, NCBuilt 1960 · S/N 57234N9438TBray Max W Jr · Dora, ALBuilt 1960 · S/N 57238N9439XBallard Richard D · Juneau, AKBuilt 1961 · S/N 21057739N943AHHaley Keith · Tonawanda, NYBuilt 1981 · S/N 21064377N9441TDevil Dusters Inc · Artesia, NMBuilt 1960 · S/N 57241N9441XMurphy Peter D · Santa Fe, NMBuilt 1961 · S/N 21057741N9445THale Tom · Browns Valley, CABuilt 1960 · S/N 57245N9449XBelk Pritchard Properties LLC · Broken Arrow, OKBuilt 1961 · S/N 21057749N9450XDavila R · Runge, TXS/N 21057750N9451XRegistered aircraftS/N 21057751N9453THansen Jerry E · San Antonio, TXBuilt 1960 · S/N 57253N9457XRoss Karen F · Marion, TXBuilt 1961 · S/N 21057757N9458TWasp Air LLC · Hamilton, MTBuilt 1960 · S/N 57258N9458XAnderson William B · Rogers, ARBuilt 1961 · S/N 21057758N9463TMcbee Kenneth H · Pasadena, TXBuilt 1960 · S/N 57263N9464THansen Peter J · Collierville, TNBuilt 1960 · S/N 57264N9468TBas Part Sales LLC · Greeley, COS/N 57268N9468XBg Family Lp · Edinburg, TXS/N 21057768N9469XMurdoch Nathan B · Nehawka, NEBuilt 1961 · S/N 21057769N9470XPerry Edward Glen · Brigham City, UTS/N 21057770N9471XVincent Equipment LLC · Grand Junction, COBuilt 1961 · S/N 21057771N9472TWilliams Chad R · Jamestown, INBuilt 1960 · S/N 57272N9474TWalker James O · Lovell, WYBuilt 1960 · S/N 57274N9474XKronner Prototypes Inc · Roseburg, ORBuilt 1961 · S/N 21057774N9476TRegistered aircraftSale reportedBuilt 1960 · S/N 57276N9478T4cl Inc · Wilmington, DEBuilt 1960 · S/N 57278N9481X2310 Woodcrest LLC · Freeland, PABuilt 1961 · S/N 21057781N9485XBruckman Monty D · Edgewood, NMBuilt 1961 · S/N 21057785N9486XSchilling Aviation Services LLC · Salina, KSBuilt 1961 · S/N 21057786N9489TRegistered aircraftRegistration pendingBuilt 1960 · S/N 57289N9489XRegistration Pending · Libby, MTRegistration pendingS/N 21057789N9493TCorwin Bert C · Rapid City, SDBuilt 1960 · S/N 57293N9494LRegistration Pending · French Village, MORegistration pendingS/N 57294
Back to AD 76-14-07 R2