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.

N5829SRegistration Pending · Scandia, KSRegistration pendingBuilt 1965 · S/N D-7728N582BSievers Gilbert H · Medina, OHBuilt 1948 · S/N D-1601N582SBHardy Gordon H · Belmont, CABuilt 1978 · S/N TJ-172N582TAWiday John P · El Cajon, CABuilt 1979 · S/N TJ-191N582TMArnst Jodi M · Clio, MIBuilt 1974 · S/N E-582N5830KAmigliore Gary E · Anaheim, CABuilt 1965 · S/N D-7890N5831KWright Scott M · Tulare, CABuilt 1965 · S/N D-7840N5831RBroome Adam H · Chapel Hill, NCBuilt 1983 · S/N E-2096N5831SDangberg Dennis C · Wayne, NES/N D-7731N5832KSutton Sean A · Fort Lauderdale, FLBuilt 1965 · S/N D-7843N5832SRoutt Thomas · Norfolk, VABuilt 1964 · S/N D-7729N5833KFostvedt Kim C · Elkhorn, NEBuilt 1965 · S/N D-7844N5833SDelp William H · Doral, FLBuilt 1964 · S/N D-7744N5834CRainey Chris D · Justin, TXBuilt 1951 · S/N D-2786N5834KVandagriff Phillip H · Kingwood, TXBuilt 1965 · S/N D-7845N5835KAdee Bret L · Toronto, SDBuilt 1965 · S/N D-7846N5835SStiles David W · Saint Petersburg, FLBuilt 1964 · S/N D-7734N5836CCohen Barry M · Streetman, TXBuilt 1952 · S/N D-2788N5838CRiley Daniel B · Valparaiso, INBuilt 1951 · S/N D-2790N5838KSullivan Jesse G · Yukon, OKBuilt 1965 · S/N D-7838N5839CDepew Gerald R · Oak Ridge, TNBuilt 1951 · S/N D-2829N5839SFox Alan D · Cherry Hill, NJBuilt 1964 · S/N D-7736N583MGZazworsky John D Jr · Mechanicsburg, PABuilt 1978 · S/N D-10177N583TFMitchell Larry L · Lodi, CABuilt 1972 · S/N TC-1452N5840KFrogmore V-Tail LLC · Beaufort, SCBuilt 1965 · S/N D-7850N5840SBergstrom Aircraft Inc · Pasco, WABuilt 1965 · S/N D-7896N5841KJones David E · Corsicana, TXBuilt 1965 · S/N D-7852N5841SLow Pass Aviation Inc · Wilmington, DEBuilt 1965 · S/N TC-839N5842KSander John B · Knoxville, TNBuilt 1965 · S/N D-7853N5844SFilips Roger F · Spencer, NEBuilt 1964 · S/N D-7741N5845SCircle City Balloon Rides LLC · Indianapolis, INBuilt 1964 · S/N D-7739N5846CDangberg Dennis · Wayne, NEBuilt 1951 · S/N D-2798N5846KMcclendon Jon L · Kilgore, TXBuilt 1965 · S/N D-7847N5847SRegistered aircraftBuilt 1965 · S/N D-7742N5848CRochna Stephen John · Fallon, NVBuilt 1951 · S/N D-2800N5848KCater Benjamin · Fresno, CABuilt 1965 · S/N D-7891N5849KRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1965 · S/N D-7881N584DSRose Michael · Prescott, AZBuilt 1981 · S/N TJ-343N584MBCenterline Holdings Inc · Camden, DES/N TK-151N5853SMillen Scott R · Fallbrook, CABuilt 1964 · S/N D-7746N5854SKarl Herrmann Inc · Afton, WYBuilt 1965 · S/N TC-846N5855TAkland Konrad R · Missoula, MTBuilt 1979 · S/N TC-2261N5857KN5857k LLC · Carlsbad, NMS/N TC-806N5858JPezza Cecile A · Brook Haven, NYBuilt 1965 · S/N D-7860N5858PMatherne David M · Houma, LAS/N TJ446N585KGWhitgo LLC · Lucas, TXS/N E-3413N585MJCostanzo Aviation Inc · Bethany Beach, DEBuilt 1977 · S/N E-1195N5863JWehkamp Dave L · Ingalls, KSBuilt 1965 · S/N D-7861N5864JMccarthney Rickcliffe D · Woodbine, NJBuilt 1965 · S/N D-7863N5865CMacdonald Kaitlyn A · Dillon, MTBuilt 1951 · S/N D-2817
Back to AD 99-05-13 R1 WD