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.

N9731XPoe David A · Big Sandy, TXBuilt 1962 · S/N 21058031N9735XPascal LLC · Des Moines, WAS/N 21058035N9738XAdelman Timothy B · Stevensville, MDBuilt 1961 · S/N 21058038N9741XHalbert Larry E · Jacksonville, FLBuilt 1961 · S/N 21058041N9746XAgent West Insurance Inc · Hurricane, UTBuilt 1962 · S/N 21058046N9749XNeal Daniel A · Winchester, TNBuilt 1962 · S/N 21058049N9752XBirdman Aviation LLC · Indianapolis, INBuilt 1962 · S/N 21058052N9758XHernandez Luis Ignacio · Naples, FLBuilt 1962 · S/N 21058058N9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLBuilt 1962 · S/N 21058059N9760XGubler Joseph A · Fairhaven, MABuilt 1962 · S/N 21058060N9762XMcdonald Daniel P · Canon City, COBuilt 1962 · S/N 21058062N9765XBaer Monte Wayne · Ronan, MTS/N 21058065N9767XRohde Ronald L · Mariposa, CABuilt 1962 · S/N 21058067N9769XEnos Miller · Rexford, MTS/N 21058069N9770XGonzalez Brendan M · Mount Pleasant, IAS/N 21058070N9777XKelner B Kelly · Bradley, ARBuilt 1962 · S/N 21058077N977RHHernandez Raul · San Antonio, TXS/N 57432N9780XReid Bill · White Hills, AZS/N 21058080N9781XCrouch Lee · Kansas City, MOBuilt 1962 · S/N 21058081N9785XLuy-Cordova Jesus S · Douglas, AZS/N 21058085N9786XAir Ric LLC · Mobile, ALBuilt 1962 · S/N 21058086N9789XJohns Richard B IV · Temecula, CABuilt 1962 · S/N 21058089N9790XPhenix LLC · Dayton, WABuilt 1962 · S/N 21058090N9793XMiller Andy D · Marana, AZS/N 21058093N9794XLeingang Mark J · Olympia, WABuilt 1962 · S/N 21058094N9796XHulett George A · Woodland Hills, CABuilt 1962 · S/N 21058096N9797XDeckpro LLC · Rexburg, IDBuilt 1962 · S/N 21058097N9811HArnaud Eldon · Fort Lauderdale, FLBuilt 1960 · S/N 21057667N988MVMiller James A · Granada Hills, CABuilt 1967 · S/N T210-0284N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690
Back to AD 76-14-07 R2