OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N964MAMosier Marty R · Durham, NCBuilt 1984 · S/N EA-442N964PBonanza 964 LLC · Davie, FLBuilt 1976 · S/N E-800N964SBlankenship Shawn W · Theodosia, MOBuilt 1964 · S/N D-7493N964THBeck Roger M Trustee · Goode, VAS/N D-2116N9650YZorn Marc E · Sherman Oaks, CABuilt 1962 · S/N D-7081N9651RSchwartz Alan · Hurleyville, NYBuilt 1960 · S/N TD-348N9651YBeech O Sphere LLC · Casper, WYFirst renewal noticeBuilt 1962 · S/N D-7069N9653RColorado Northwestern Community College · Rangely, COBuilt 1960 · S/N TD-343N9653YRoberts Chance A · Hooper, UTBuilt 1962 · S/N D-7086N9654YSchwerd Robert E · Prescott, AZBuilt 1962 · S/N D-7073N9655YHenry Brian J · Napa, CABuilt 1962 · S/N D-7071N9656RGlenn Jeff P · Billings, MTBuilt 1960 · S/N TD-331N9657YLimor Yoram · Brentwood, CABuilt 1962 · S/N D-7072N9658YNolf Ruben C · Vancouver, WABuilt 1962 · S/N D-7075N9659YR & N Associates Worldwide Inc · Port Orange, FLBuilt 1962 · S/N D-7076N965BWIkarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N TC-2286N965QHamilton Richard D Jr · Catawba, NCBuilt 1961 · S/N D-6843N9660YCrawford Russell W · Hickory Creek, TXS/N D-7087N9662YBerry Brian R · Tahlequah, OKBuilt 1962 · S/N D-7078N9663RCaruso Matteo · Hockessin, DEBuilt 1960 · S/N DH-245N9664R5pm LLC · Reston, VABuilt 1960 · S/N DH-246N9669NLoudakis George · Stuart, FLBuilt 1958 · S/N BA-382N9669REngram Matt · Branson, MOS/N BA-495N9669YFlorida Aero Group Inc · Wilmington, DEBuilt 1962 · S/N TC-397N966DEHubbard Richard O · Fort Worth, TXBuilt 1981 · S/N E-1865N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120N9670YWild Blue Aviation LLC · Eagle Rock, MOBuilt 1962 · S/N D-7091N9673YSale Reported · Lakeside, MTSale reportedBuilt 1962 · S/N D-7094N9675RBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1989 · S/N E-2503N9675YKarpenke Christopher · Rochester, NYBuilt 1962 · S/N D-7093N967EAMercury Air LLC · Torrance, CABuilt 2004 · S/N E-3567N9680YSmutny Joseph Robert · Downers Grove, ILBuilt 1963 · S/N D-7106N9681YHampson Robert J Jr · Oro Valley, AZBuilt 1962 · S/N D-7098N9683LBorn Mark · Rockwall, TXBuilt 1963 · S/N TC-414N9683YButler Billy D · Hilger, MTBuilt 1969 · S/N TE-693N9685YSmd Air LLC · Cleveland, OHBuilt 1963 · S/N D-7107N9688ZZimmerman Gerald M · Savannah, GAS/N D-7108N968PBank Of Utah Trustee · Salt Lake City, UTS/N E-3464N9690RDove Enterprises LLC · Wilmington, DEBuilt 1960 · S/N BA-494N9693YHodges Christopher · Loganville, GABuilt 1962 · S/N D-7103N9695RKimmel Frank S III · Greenwood, MSBuilt 1960 · S/N TC-1N9696YSonoran Sunset Realty LLC · Scottsdale, AZBuilt 1962 · S/N D-7104N9697YAfterburner Aviation LLC · Lewes, DEBuilt 1963 · S/N TD-526N969CCAllerton Paul F · Cottage Grove, MNBuilt 1958 · S/N D-5531N969DCHuntley David W · San Antonio, TXBuilt 1968 · S/N TC-1169N969MGRas Aviation LLC · Elyria, OHS/N TD-553N969QLindbergh Aviation LLC · Linden, MIBuilt 1961 · S/N TD-495N969RAFox Valley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-317N969VInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N D-9051N969YKarika Thomas · Merritt Island, FLBuilt 1972 · S/N E-322
Back to AD 99-05-13 R1 WD