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.

N555YDYoder Philip G Trustee · Dublin, OHBuilt 1977 · S/N E-1048N555ZZUnited States Air Force · Rio Vista, CABuilt 1953 · S/N G-290N5561UAllen Calvin L · Mico, TXBuilt 1990 · S/N CE-1436N55626Compton Randel D · Gulf Breeze, FLBuilt 1955 · S/N 34-95N5562DZimwin Enterpises LLC · Austin, TXS/N D-5142N5562ZGordon Reed T · Troup, TXBuilt 1990 · S/N CE1467N5565XHenry Michael Todd Trustee · Manhattan Beach, CABuilt 1990 · S/N CE-1485N55674Frog Air LLC · Amarillo, TXBuilt 1990 · S/N E-2542N5569DYniguez Rudy · Redding, CABuilt 1957 · S/N D-5123N5569NReverie Aviation LLC · Burbank, CABuilt 1990 · S/N E-2529N556CTWilliamson Terry W Jr · Pratt, KSS/N D-7007N5570DFletcher Jerry W · Yuma, AZS/N D-5102N5571CHarrison Steven D · Rolla, MOBuilt 1989 · S/N CE-1347N5571DReuland Robert C · West Windsor, VTBuilt 1989 · S/N CE-1405N5573DDeyoung Robert E · Napa, CABuilt 1957 · S/N D-5125N5575DKirkwood Joe D · Amarillo, TXBuilt 1957 · S/N D-5280N5577DJust Plane Vintage LLC · Mountain Home, ARBuilt 1957 · S/N D-5129N5578DBurkholder Camilles M · Lake Arrowhead, CABuilt 1957 · S/N D-5119N5579MTbc Capital Management LLC · Phoenix, AZS/N CE-1394N557DBMentor One LLC · Englewood, FLS/N G-789N557PAPlatinum Leasing LLC · Fate, TXBuilt 1981 · S/N P-580N557RRadle Alexander Peter · Flower Mound, TXBuilt 1955 · S/N D-4190N557SASouthard Dennis W Trustee · Tulsa, OKBuilt 2002 · S/N E-3457N5581TChristenson Timothy M · Scituate, MABuilt 1989 · S/N CE-1350N5582XAlpe Holding LLC · Van Nuys, CABuilt 1989 · S/N CE-1353N5583DHanks Dustin Maxwell · Milton, FLBuilt 1957 · S/N D-5158N5584DBenson Robert W III · Wichita Falls, TXBuilt 1957 · S/N D-5110N5585KMacias Aviation LLC · Canadian, TXBuilt 1989 · S/N CE-1385N5585YBlacklock Beech Boys LLC · Langlois, ORS/N CE-1389N5588DCarson Air Service Inc · Jackson, MSS/N D5177N5589DForrester Dale E · Scotland, PABuilt 1957 · S/N D-5166N558CBFrancis Scott P · Montclair, VAS/N TC-1800N558PSouth Electrical Inc · Laurinburg, NCBuilt 1982 · S/N TJ-421N558RSAyelet Aviation LLC · Mackinac Island, MIBuilt 1977 · S/N TK-67N5591DHarrison John C · Northport, MIBuilt 1957 · S/N D-5152N5591VCortese Michael C · South Chatham, MABuilt 1989 · S/N E-2501N5593CSouth Coast Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1989 · S/N E-2493N5593DOhaike Richard O · Mansfield, TXBuilt 1957 · S/N D-5165N5594CNovember Inc · Murfreesboro, TNBuilt 1991 · S/N E-2685N5596DBas Part Sales LLC · Greeley, COBuilt 1957 · S/N D-5124N5597DReetz Bernard A · Discovery Bay, CABuilt 1957 · S/N D-5144N5598GNorth River Investments Inc · Palmetto, FLBuilt 1990 · S/N EA-503N5599DSale Reported · Merritt Island, FLSale reportedBuilt 1957 · S/N D-5131N5599PAd Ventures LLC · Camden, DEBuilt 1989 · S/N CE-1344N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170N559TSuperbird Icc LLC · Mitchell, SDBuilt 1961 · S/N TC-108N55AEFreer Lawrence C III · Puyallup, WABuilt 1966 · S/N TE-84N55BDMclenaghan Alvin N · Phoenix, AZBuilt 1952 · S/N D-3156N55BNInternational Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N TC-1572N55BUBlue Side Up LLC · Oxford, CTBuilt 1978 · S/N TC-2138
Back to AD 99-05-13 R1 WD