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.

N217SCJtfs LLC · Huntsville, ALBuilt 1999 · S/N E-3221N217SDSennas Ghost LLC · Missoula, MTBuilt 1942 · S/N 3098N2180DKent James · Somerton, AZBuilt 1953 · S/N D-3548N2180WGerges Amir · Arlington, TXS/N M-1563N2182DSchroeder Dorothy Louise · Milton Freewater, ORBuilt 1953 · S/N D-3529N2182LGadboys Jeffrey A · Naples, FLS/N TC-1996N2183LDarfus Jason D · Tracy, CABuilt 1976 · S/N E-969N2185DHamilton Gene A · Lockhart, TXS/N D-3532N2185WHoward Pamela A · Goldthwaite, TXBuilt 1974 · S/N MB-696N2186DStevens Neil Richard · Moravia, NYBuilt 1953 · S/N D-3533N2187DDavenport Joshua Troy · Roper, NCBuilt 1953 · S/N D-3534N2188TWeaver Aircraft Co · Carson City, NVS/N BG-188N2188WMccrea Justin M · Big Spring, TXS/N MC-258N2189DHoover Michael B · Ridgeland, WIS/N D-3536N2189WJohnson Jay W · Wichita, KSBuilt 1976 · S/N M-1892N218CGCourtney Melissa · San Diego, CABuilt 1980 · S/N E-1741N218EWHartwig Aerial Spraying Inc · Edgeley, NDBuilt 1961 · S/N TD-466N218PDMoye Robert W · Saint Augustine, FLS/N LF-48N218WBBird Jamie Aaron · Duluth, MNBuilt 1974 · S/N M-1554N2190DIntravaia Anthony J · Saint Louis, MOS/N D-3537N2190LSedine Aaron J · Cedar Springs, MIBuilt 1976 · S/N E-909N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078N2191DTips Daniel · Plano, TXBuilt 1953 · S/N D-3538N2191WNorton Daniel J · Osage City, KSBuilt 1974 · S/N MB-727N21934Thursby William T · Cedar Hill, TXBuilt 1942 · S/N 424N2194DAir Repair Inc · Easton, MDBuilt 1953 · S/N D-3541N2195DMauldin Gary W · Navajo Dam, NMBuilt 1953 · S/N D-3542N2196DWilewski Clifford R · Freeport, ILBuilt 1953 · S/N D-3543N21970Weaver Aircraft Co · Carson City, NVS/N BG-197N2197DKaiser Aviation LLC · Newman, ILBuilt 1953 · S/N D-3544N2197LJ Rougeau Rehab Inc · North Adams, MABuilt 1976 · S/N TC-2018N2197WSmothers Edward Jr · Owasso, OKBuilt 1974 · S/N MB-697N2199KRegistered aircraftBuilt 1951 · S/N D-2941N2199LCardamone-Rayner Mark · Manistique, MIBuilt 1976 · S/N E-968N219BYoungs William D Jr · Moravia, NYBuilt 1956 · S/N D-4522N219DKRegistered aircraftBuilt 1980 · S/N E-1599N219MLGelbard Dustin S · Lake Havasu City, AZBuilt 1966 · S/N TE-243N219QBoe John · Langdon, NDBuilt 1965 · S/N D-7790N219RPMorrow Dennis J · Houston, TXBuilt 1976 · S/N E-885N219ZCarroll Sean Terence · Saint Petersburg, FLBuilt 1964 · S/N TC-789N21BBSmartin Enterprises LLC · Phoenix, AZS/N TC-1690N21BCAmelse Troy · Chippewa Falls, WIBuilt 1980 · S/N EA-65N21CAJorgensen Bryan H · Wadsworth, OHBuilt 1946 · S/N A-250N21CHSievert Stephen L Sr · Plainfield, ILBuilt 1954 · S/N D-3724N21CNV-Tail Aero LLC · Troy, MIBuilt 1953 · S/N D-3459N21ETDepucchio Mark V · Plainville, CTBuilt 1976 · S/N E-889N21FDAldrich Jacob · Statesville, NCBuilt 1974 · S/N M-1621N21FHWalker Kevin D · Tres Pinos, CABuilt 1975 · S/N P-356N21JPDmmag LLC · Windermere, FLBuilt 1977 · S/N TE-1092N21KFFans Of Nola Corp · New Orleans, LABuilt 1976 · S/N TC-1926
Back to AD 99-05-13 R1 WD