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.

N3832YMtfg LLC · Hayden, IDS/N 21058332N3835YCarlton Jeffery G · Great Falls, MTS/N 21058335N3837YRounds Chris · Waller, TXBuilt 1964 · S/N 21058337N3844YManarin Roland R · Lakemont, GABuilt 1964 · S/N 21058344N3845Y1st Due Emergency Response Solutions LLC · Bartlett, KSS/N 21058345N3847YLee Justin W · Maud, TXBuilt 1964 · S/N 21058347N3850YPoole Vernon N · Melstone, MTBuilt 1964 · S/N 21058350N3851YMckie-Voerste Travis K · Chatsworth, GABuilt 1964 · S/N 21058351N3853YRafter Bar B LLC · Ashland City, TNBuilt 1964 · S/N 21058353N3854YJames Wilson Smith Enterprises LLC · Athens, GABuilt 1964 · S/N 21058354N3857YLutz Matthew B · Jackson, TNBuilt 1964 · S/N 21058357N3859YMorse Donald W · Priest Lake, IDS/N 21058359N385TDHomestead Helicopters Inc · Missoula, MTBuilt 1965 · S/N T210-0072N3861YMiller Todd D · Fort Wayne, INBuilt 1964 · S/N 21058361N3866YMessina Jacob · Copley, OHBuilt 1964 · S/N 21058366N3867YGallagher Robert B · Rio Oso, CABuilt 1964 · S/N 21058367N3877YGonzo LLC · La Junta, COS/N 21058377N3878YRegistered aircraftBuilt 1964 · S/N 21058378N3880YLake Country Aviation LLC · Milledgeville, GABuilt 1964 · S/N 21058380N3881YNorton Tim C · Danville, VABuilt 1964 · S/N 21058381N3888YDodson Timothy A · Tulare, CABuilt 1964 · S/N 21058388N3890YEllsworth Joseph D Trustee · Salida, COBuilt 1964 · S/N 21058390N3891YCartwright Chris · Yuba City, CABuilt 1964 · S/N 21058391N3897YHmw LLC · Wilmington, DEBuilt 1964 · S/N 21058397N3901YCentruion Express LLC · North Port, FLS/N 21058401N3904YOtto William R · Ontario, CABuilt 1964 · S/N 21058404N3906YWildbur Mark B · Laramie, WYBuilt 1964 · S/N 21058406N3907YAckley John · Brownsville, TXBuilt 1964 · S/N 21058407N3916YMelagrano Jeffrey D · Scarsdale, NYBuilt 1964 · S/N 21058416N3921YThompson Steven J · Royse City, TXBuilt 1964 · S/N 21058421N3925YAbney Timothy D · Powell, OHS/N 21058425N3927YMackenzie Stuart D · Pearland, TXBuilt 1964 · S/N 21058427N3929YAinsworth Ryan · Portales, NMBuilt 1964 · S/N 21058429N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451N3954YStone Clifford F Jr · Corning, CABuilt 1964 · S/N 21058454N3956YWilliams John S · Fort Walton Beach, FLBuilt 1964 · S/N 21058456N3957YRegistration Pending · Midland, TXRegistration pendingBuilt 1964 · S/N 21058457N3959YRabeneau Dale · Copperopolis, CABuilt 1964 · S/N 21058459N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461N3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467N3968YDetray Michael S · Roy, WABuilt 1964 · S/N 21058468N3969YCayce Dick Lon Jr · Longview, TXS/N 21058469
Back to AD 76-14-07 R2