OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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.

N5099ZKaufold E Richard · Ridge, NYBuilt 1961 · S/N 22-8735N50GFHarrington Brian · Fountain Inn, SCBuilt 1950 · S/N 20-382N50JAAday B Joe · Las Cruces, NMBuilt 1979 · S/N 18-8009002N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50TPSoar Utah Inc · Heber City, UTS/N 25-2341N5100HBurnett Robert Bruce · Anchorage, AKBuilt 1948 · S/N 14-104N5100ZLawrence Richard J · Wooster, OHBuilt 1961 · S/N 22-8736N5102HCizek Joseph E · Wasilla, AKBuilt 1948 · S/N 14-106N51039Borge Michael J · Chandler, AZBuilt 1946 · S/N G144N5103HGarner Joseph A · Healy, AKBuilt 1948 · S/N 14-108N5103Z92nd West Aviation Inc · Lonoke, ARS/N 22-8739N5104ZGary L Morton · Palmer, AKBuilt 1961 · S/N 22-8740N5105ZKrumm Melvin L · Allegan, MIBuilt 1961 · S/N 22-8741N5106HMartinez Patrick F · Palmer, AKBuilt 1948 · S/N 14-111N5106ZDorsey James P · Bainbridge Island, WABuilt 1961 · S/N 22-8746N5108ZPfc Aviation Repair Inc · Wallingford, CTS/N 22-8748N5110HBuxton S · Mount Pleasant, SCBuilt 1948 · S/N 14-115N5111ZSlaughter Don Wayne · Farmville, NCBuilt 1961 · S/N 22-8751N5112HDefendorf Nelson W · Anchorage, AKS/N 14-118N5113GSnell Robert B · La Vernia, TXS/N 15-8N5113ZNielsen Jeffrey L · Harlan, IAS/N 22-8754N5114HReints Rydell J · Wasilla, AKBuilt 1948 · S/N 14-120N5115ZSager Charles J Jr · Wofford Heights, CABuilt 1961 · S/N 22-8756N5116HMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1948 · S/N 14-122N5117ZWroe Daniel · Denton, MDBuilt 1961 · S/N 22-8758N5118HDavis John C · Anchorage, AKS/N 14-124N5118ZToner Phillip A · Devine, TXS/N 22-8759N5119HChenoweth Tucker T · Talkeetna, AKS/N 14-125N5119LSnell Robert B · La Vernia, TXS/N 12-2366N511ZKFlying Devil Aviation LLC · Dover, DEBuilt 1946 · S/N 21009N5121HGilsdorf Jason M · Henning, MNBuilt 1947 · S/N 14-127N5121ZDahlberg Thomas K · Belvidere, ILBuilt 1961 · S/N 22-8762N5122ZDunn Kohlten Davis · Rexburg, IDBuilt 1961 · S/N 22-8763N5124HFowler Thomas J · Keller, TXBuilt 1948 · S/N 14-130N5124ZCummings Christopher K · Chalfont, PABuilt 1961 · S/N 22-8765N5126HBradbury Douglas · Pedro Bay, AKBuilt 1948 · S/N 14-135N5126ZAshley Emory R · Panacea, FLBuilt 1961 · S/N 22-8767N5127YAirborne Extreme LLC · Wasilla, AKBuilt 1962 · S/N 18-7895N5127ZPohland Charles A · Anchorage, AKBuilt 1961 · S/N 18-7765N5128ZMoore Merritt T II · Silver Creek, NYBuilt 1961 · S/N 22-8769N5129YCarter Ronald Lynn · Nenana, AKS/N 12-1554N512KCJunfer Flyers LLC · Wilmington, DEBuilt 2000 · S/N 9909CCN5130HCalkins David Martin · Anchorage, AKBuilt 1949 · S/N 14-141N5133HBlydenburgh Daniel R · Palmer, AKBuilt 1948 · S/N 14-144N5134HSquier John F · North Yarmouth, MEBuilt 1948 · S/N 14-143N5135HKinneen Simon N · Nome, AKBuilt 1948 · S/N 14-145N5136HMerrill Jerry R · Willow, AKBuilt 1948 · S/N 14-146N5137HKingdom Air Corps · Sutton, AKS/N 14-147N5137ZHill Glenn · Belle Mead, NJBuilt 1962 · S/N 22-9431N5139YB & B Equipment Inc · Cantwell, AKS/N 18-8038
Back to AD 99-01-05 R1