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.

N8846AJolliff Travis L · El Paso, TXBuilt 1950 · S/N D-2501N8847MTravel Air LLC · Chico, CABuilt 1964 · S/N TD-575N8848MFly Shetland LLC · Lubbock, TXS/N D-7360N884DBMessiah Angel LLC · Pennsauken, NJBuilt 1949 · S/N D1600N884TPerryton Motor Co Inc · Perryton, TXBuilt 1965 · S/N D-7807N8850AGibson Lawrence D · Lakeland, FLBuilt 1950 · S/N D-2505N8851MBal-Kar Holdings Inc · Punta Gorda, FLBuilt 1964 · S/N D-7362N8852MAndys Auto Sales LLC · Caroline, WIBuilt 1964 · S/N D-7367N8853MBeaver Creek Aviation LLC · Clinton, OKBuilt 1964 · S/N D-7368N8857ADixon Kevin S · Denton, TXS/N D-2512N8857MDunn Brady · Gilmer, TXS/N M-597N8858ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1950 · S/N D-2513N8859MParylak Sean P · Colchester, CTBuilt 1964 · S/N M-598N8860AWilmoth Todd · Keystone Heights, FLBuilt 1950 · S/N D-2515N8861ABehnke Jonathan D · Gilbert, AZBuilt 1950 · S/N D-2506N8862MChavers Investments LLC · Cantonment, FLBuilt 1964 · S/N M-595N8863MBrainerd Philip S · Lake Placid, FLS/N M-599N8864MBlue Aviation LLC · Franklin, TNBuilt 1964 · S/N M-602N8865AJackson Robert K · Bay City, TXBuilt 1950 · S/N D-2520N8866MZayatz Carl A · Lansing, MIBuilt 1964 · S/N M-604N8867AThorson William D · Las Vegas, NVBuilt 1950 · S/N D-2522N8868MBas Part Sales LLC · Greeley, COBuilt 1964 · S/N M-606N8875MChestnutt Michael L · Clinton, NCBuilt 1964 · S/N M-619N8876MLohman Curtis · Shelby, MIBuilt 1964 · S/N M-618N88796American Flight Museum · Topeka, KSS/N BG-203N8879MN8879m LLC · Lakeview, NCS/N M-626N887BMNewman Matthew · Warwick, NYBuilt 1997 · S/N E-3122N887CAHerron Joe D · Burnet, TXBuilt 1976 · S/N E-864N887JKHenry Joseph · Paris, TXS/N E-3586N8880MAv8r Hub Inc · Jacksonville, FLS/N M-627N8883ALambson Roger S · Saint Ignatius, MTBuilt 1950 · S/N D-2538N8884MWomack David B · Hurst, TXBuilt 1964 · S/N M-633N8885MBulls Chris · Rising Fawn, GABuilt 1964 · S/N M-634N8887Ricciuti Martin R · Kansas City, KSS/N CH-84N8887MTcb Aviation Inc · Knoxville, TNBuilt 1964 · S/N M-631N8888AGrundmann Daniel J · South Jordan, UTBuilt 1952 · S/N D-3211N8889MLong Jarod H · Satsuma, ALBuilt 1964 · S/N M-635N888AOlivia Aviation LLC · Plymouth, MNBuilt 2000 · S/N E-3304N888AERegistered aircraftBuilt 1978 · S/N E-1323N888BSFrasca Thomas W · Champaign, ILBuilt 1956 · S/N DH-14N888DBEastern Stearman Inc Trustee · Leesburg, VAS/N D10076N888DWGoodman James D Trustee · Pomona, CABuilt 1962 · S/N D-7049N888EKExcalibur Knight One LLC · Miami, FLBuilt 1967 · S/N LC-263N888HDPham Doug · Irvine, CABuilt 1977 · S/N CE-748N888HPGreen Mountain State Aviation LLC · Cornwall, VTBuilt 1988 · S/N CE-1302N888JDThille Nicholas M · San Luis Obispo, CABuilt 1968 · S/N TD-720N888JRJones & Weaver Pc · Wheatland, WYBuilt 1978 · S/N E-1241N888JTNyerges James · Midland, TXFirst renewal noticeBuilt 1966 · S/N LP-21N888KWHink Ronald · Memphis, TXBuilt 1966 · S/N D-8219N888MBsa Vending · Rohnert Park, CABuilt 1981 · S/N EA-262
Back to AD 99-05-13 R1 WD