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.

N5040MHulme Aviation LLC · Gilbert, AZBuilt 1978 · S/N MB-895N5041CEngelhardt John · Porter, TXBuilt 1950 · S/N D-2303N5042BPowell Jerry R · Kokomo, INBuilt 1955 · S/N D-4309N5042CVehrs Larry A · Independence, ORBuilt 1950 · S/N D-2304N5043BRegistered aircraftBuilt 1955 · S/N D-4310N5045BChi Yang · Lafayette, COFirst renewal noticeS/N D-4323N5047BHenderson Lester W · Lafayette, LABuilt 1955 · S/N D-4317N5048CKemp Steve W · Albuquerque, NMBuilt 1950 · S/N D-2377N5049BQualitair LLC Trustee · MichelstadtBuilt 1955 · S/N D-4311N504BYeagley Daun E II · Wilmington, OHBuilt 1948 · S/N D-1526N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26N504SJAmerican Bonanza Society Air Safety Foundation Inc · Wichita, KSBuilt 1981 · S/N E-1849N5050LFrederick Benjamin J · The Woodlands, TXBuilt 1977 · S/N E-986N5050XGrevatt Douglas E · Norwalk, CTBuilt 1952 · S/N D-3150N5051BNiksadat Abbas · San Jose, CABuilt 1955 · S/N D-4313N5053BWalline Christopher · Mcpherson, KSS/N D-4332N5055BN5055 B Partners · Long Beach, CABuilt 1955 · S/N D-4331N5055CTaylor Kenneth R · Seminole, OKBuilt 1950 · S/N D-2317N5056BWelsh Kevin J · Roseburg, ORBuilt 1955 · S/N D-4352N5056XN5056x LLC · Troy, OHS/N E-3456N5057BRuther Dennis A · Lake Havasu City, AZS/N D-4358N5059BMcleod Lee · Derby, KSBuilt 1955 · S/N D-4266N505BLeyda Aaron M · Bartlesville, OKBuilt 1948 · S/N D-1528N505GEWgm Solutions LLC · Mart, TXBuilt 1971 · S/N P-186N505JMAndriopulos Salguero Inc · Hialeah, FLBuilt 1979 · S/N P-493N505KBBrowder Mark E · Charlotte, NCBuilt 1976 · S/N TC-2004N505TTWebber James F · Arvin, CABuilt 1972 · S/N E-376N5060BBolin William E · Smithville, OHBuilt 1955 · S/N D-4329N5061BNettrour Jerry · Floresville, TXBuilt 1955 · S/N D-4265N5062BHarris Beth · Albuquerque, NMBuilt 1955 · S/N D-4351N5063CMoore Israel T · Pasco, WABuilt 1950 · S/N D-2325N50650Horstman Edward B · Bigfork, MTBuilt 1937 · S/N 143N5065CYonge Robert R · Ocala, FLBuilt 1950 · S/N D-2327N5066BBond Family Limited Partnership · Oriental, NCS/N D-4386N5067BMerritt John H K · Avondale Estates, GABuilt 1955 · S/N D-4387N5068BZulu LLC · Hattiesburg, MSS/N D-4363N5068CImagine Help · Oxnard, CABuilt 1950 · S/N D-2330N5069CMugleston Tim H · Waldport, ORS/N D-2331N506HPPedden Patrick M · Fort Wayne, INBuilt 1969 · S/N D-9073N5070BRyan Paul · Brea, CABuilt 1955 · S/N D-4349N5070KSmith Alice B · Escondido, CAS/N G-65N5071CWalker Rhan E · Pleasant Hill, MOBuilt 1950 · S/N D-2333N5072BCopeland Patrick N · Madisonville, TNFirst renewal noticeBuilt 1955 · S/N D-4359N5073BRisk Andrew David · Camarillo, CABuilt 1955 · S/N D-4370N5073CInternational Air Services Inc Trustee · Carson City, NVS/N EA-667N5073MMajeste Air LLC · Loveland, COBuilt 1978 · S/N P-473N5074CJ & S Aviation LLC · Scottsdale, AZS/N D-2336N5074MFaddis Ray K · Kingwood, TXBuilt 1978 · S/N M-2051N5074NSchaller Lee W · New Athens, ILS/N 6680N5074TPate Michael G · Pontotoc, MSS/N MA-322
Back to AD 99-05-13 R1 WD