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.

N354DJN354dj LLC · Gulfport, MSBuilt 1980 · S/N D-10326N354DPShaffer John · Virginia Beach, VABuilt 1966 · S/N D-8309N354DRRadwanski D · Westmont, ILBuilt 1978 · S/N D-10102N354DZDachnowicz Peter A · Avon, CTBuilt 1972 · S/N D-9336N354FBCleared Direct LLC · Portland, ORFirst renewal noticeBuilt 1962 · S/N D-6961N354JMountain V-Tail LLC · Denver, COS/N D-7857N354KPTri County Flying Club Llp · Estelline, SDBuilt 1964 · S/N D-7612N354LCDelos Anesthesia Services Pc · Barstow, CABuilt 1966 · S/N D-8161N354MMission Aviation LLC · Billings, MTBuilt 1964 · S/N D-7516N354PFBillen Jerome · Hodges, SCBuilt 1972 · S/N D-9313N354ZFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLBuilt 1952 · S/N D-3287N3550BKearney Steven R · Brook, GABuilt 1954 · S/N D-3757N3552BSignal Flow Solutions LLC · Ellis, KSBuilt 1954 · S/N D-3759N3554R3554r LLC · Shickley, NEBuilt 1965 · S/N M-728N355ADSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N TC-2409N355GRGilson Steve · Covington, LABuilt 1957 · S/N D-5328N355PTasaair LLC · Wellington, FLBuilt 1979 · S/N TC-2273N355SAReddy James N Trustee · Port Orange, FLBuilt 2000 · S/N E-3357N355WBWhite River Aviation LLC · Midway, ARBuilt 1966 · S/N TE-287N3564BMach 4 Missions · Middleton, TNBuilt 1954 · S/N CH-114N3568RKohl William H · Tipton, IABuilt 1965 · S/N M-743N3569RAviation Investment & Recreation Inc · Battle Creek, MIBuilt 1965 · S/N M-750N356HCai Tech LLC · Greenwood, DEBuilt 2004 · S/N E-3566N356TRegistered aircraftBuilt 1960 · S/N DH-270N3570PTimbie John E · Keystone Heights, FLBuilt 1965 · S/N M-751N3571RHyde Craig C · Sonoma, CABuilt 1965 · S/N M-849N3572ADavis Robert D · Independence, ORBuilt 1969 · S/N TC-1306N3577RMorton Douglas L · Pasadena, CABuilt 1965 · S/N M-777N3579RGrice Robert D Jr · Wayne, ILBuilt 1965 · S/N M-769N357DRegis Frederic · Denver, COBuilt 1967 · S/N D-8562N357JTClub Bo A36 LLC · Helena, MTBuilt 1979 · S/N EA-51N357SHill V35 LLC · Nashville, TNBuilt 1967 · S/N D-8679N357TSSmith Thomas W · Enid, OKBuilt 1951 · S/N D-2785N357WMMentor Partners Inc · Springfield, ILBuilt 1960 · S/N BG-357N3581BSpink Todd A · Mesquite, TXBuilt 1954 · S/N CH-41N3581ROpheim Robert M · Duluth, MNBuilt 1965 · S/N M-754N3582RAuterman Daniel · Fithian, ILBuilt 1965 · S/N M-770N3583RKing Jamie Marie · Kintnersville, PAS/N M-759N358ALlewellyn Development LLC · Charlotte, NCBuilt 1978 · S/N D-10163N358BWard Mike · Carnesville, GABuilt 1957 · S/N D-5013N358PBN358pb LLC · Amarillo, TXBuilt 1977 · S/N TJ-90N358SBolla Bruce B · San Francisco, CABuilt 1967 · S/N D-8671N358SANelson Robert M Jr · Plano, TXBuilt 1998 · S/N E-3192N358TCEclipse Air Works LLC · Harker Heights, TXS/N TC2398N3590AHill Lonnie R · Gainesville, GABuilt 1969 · S/N TC-1312N3593RHoskins Earl R · Bryan, TXFirst renewal noticeBuilt 1965 · S/N M-757N3594AFlying Fur Animal Rescue · Kintnersville, PABuilt 1969 · S/N D-9072N3595ALogistics Consulting LLC · Wilmington, DEBuilt 1969 · S/N TE-776N3595RTutor Bobby J · Mansfield, TXBuilt 1965 · S/N M-784N359BFelder Charles G · Corcoran, CABuilt 1957 · S/N D-5049
Back to AD 99-05-13 R1 WD