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.

N3344DBoyd David S · Brooklyn Park, MNBuilt 1975 · S/N P-344N3344LBlauner Peter D · Coatesville, PABuilt 1976 · S/N MC-467N3344MSmith Andrew L · Hillsboro, TXBuilt 1993 · S/N CE-1731N3345BR Farms LLC · Wilmington, DEBuilt 1994 · S/N E-2865N3345CCleveland John Horace · Sheffield, ALBuilt 1955 · S/N D-4011N3347CReid James D · Thomasville, NCBuilt 1955 · S/N D-4013N3348CLang Isaac M · Cumming, GABuilt 1955 · S/N D-4014N3349ADoherty David R · Thief River Falls, MNBuilt 1970 · S/N CE-306N334CHLittle River Aviation LLC · Tifton, GABuilt 1977 · S/N D9962N334CPRws Aviation LLC · Indianapolis, INBuilt 1977 · S/N E-1003N334DBrady Michael H Trustee · Healdton, OKBuilt 1993 · S/N CE-1756N334FCavu Aviation LLC · Hickory, NCBuilt 1961 · S/N BG-316N334HCCannon Harold · Utica, KYS/N 34-69N334HPN334hp LLC · Sheridan, WYBuilt 1974 · S/N CE-519N334JDGolden Bear Properties LLC · Lakeside, AZBuilt 1993 · S/N CE-1718N334JVTharp Donald J · Aurora, OHBuilt 1957 · S/N BG-366N334KWRoberts Dorel Lynn · Sheridan, WYS/N CE-523N334LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1956 · S/N G-813N334MBSutherland Scott G · Longmont, COBuilt 1982 · S/N CE-1012N334PBConway Brian · Denver, COBuilt 1990 · S/N CE-1543N334PCMagic Valley Auction LLC · Jerome, IDBuilt 1990 · S/N CE-1534N334PWGary Bass Restorations LLC · Monett, MOBuilt 1974 · S/N CE-488N334RN566rw LLC · Hensley, ARBuilt 1991 · S/N CE-1561N334RDWrob Aero LLC · Del Rio, TXBuilt 1978 · S/N CE-837N334RLButters Brewster S · Port Orange, FLBuilt 1963 · S/N G-12N334SESteeb Erik · San Luis Obispo, CABuilt 1987 · S/N CE-1111N334TFlying Crown Aviation LLC · Fond Du Lac, WIBuilt 1955 · S/N BG-138N334TRNachtigal Michael P · Ozark, MOBuilt 1990 · S/N CE-1499N334TTWeaver Aircraft Co · Carson City, NVBuilt 1958 · S/N GM-194N334TXMagic Mentor LLC · Canyon, TXS/N G-26N334UWalter Matthew Timothy · Bella Vista, ARBuilt 1992 · S/N CE-1685N3350CBale Paul C · Louisville, TNBuilt 1955 · S/N D4016N33511Annis Aviation LLC · Gray, GABuilt 1964 · S/N TC-800N3354C3 Points LLC · Comstock Park, MIS/N D-4020N3355CElkins Quentin D · Andersonville, TNBuilt 1955 · S/N D-4021N3358AWagner Richard L · Willis, TXBuilt 1969 · S/N D-9062N335BSmall & Co LLC · Omaha, NES/N D-4854N335DLarson Ken · Lake Havasu City, AZS/N P-129N335HPOlympus Leasing LLC · Bremerton, WABuilt 1992 · S/N CE1663N335JAAstrologo Joseph A Jr · Tullahoma, TNBuilt 1964 · S/N D-7576N335NMarple Scott D · Indianapolis, INBuilt 1964 · S/N D-7752N335PElvin Robert Brian · Grove, OKBuilt 1996 · S/N E-3005N335RAirdocs LLC · Atlanta, GABuilt 2000 · S/N E-3335N335TBJkh Enterprises LLC · Westfield, INBuilt 1987 · S/N CE1166N335TCSchnell Daniel · Sisters, ORBuilt 1966 · S/N D-8274N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338N335ZCosse Harold C · Euless, TXBuilt 1960 · S/N D-6484N3362CCarter Shauna C · Reeds Spring, MOS/N D-4029N3363CColburn Wayne · The Sea Ranch, CABuilt 1955 · S/N D4030N3364BDilley Darrel L · La Salle, COBuilt 1977 · S/N CE-734
Back to AD 99-05-13 R1 WD