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.

N164EGoodman Aircraft Inc · Wilmington, DES/N 6933N164RStigliano James II · Townsend, GAS/N D-2519N1650WGriffin Michael D · Madison, ALBuilt 1972 · S/N E-352N1659WTrim Aire Aviation Inc · Mexia, TXBuilt 1973 · S/N TC-1475N165BHawkins Flying Service LLC · Franktown, COS/N D-4451N165HPKessler William A Jr · Uvalde, TXBuilt 1981 · S/N E-1856N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180N165RWCw Aircraft LLC · Atlanta, GABuilt 1964 · S/N TC-683N165XRock Air LLC · Wilmington, DEBuilt 1956 · S/N BA-189N1669WBahri Kiumars · Birmingham, ALBuilt 1972 · S/N CE-392N166ACAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME263N166PFroggatt Richard H · Sterling, MABuilt 1991 · S/N CE-1560N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382N16727Armstrong Bernard A · Cerrillos, NMBuilt 1969 · S/N MB-444N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167NGohman Charles Scott · Salinas, CAS/N TE-137N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472N1683WAirsouth Aviation Services Inc · Little Rock, ARS/N TC-1526N1684WHaller Philip L · Peoria, AZS/N D-9386N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388N168AFApogee Flight Inc · Bellingham, WABuilt 1953 · S/N G-299N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253N168MNelson Lars C · Anchorage, AKBuilt 1968 · S/N D-8762N168SPMadura Mark · Anchorage, AKBuilt 1980 · S/N P-553N168ULeading Edge LLC · Scottsdale, AZBuilt 1969 · S/N D-8986N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389N1694WKlauber James S Sr · Boonsboro, MDBuilt 1972 · S/N E-363N16956Hollowell Baron J · Boise, IDS/N MC-132N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393N1697WMountcastle Creek LLC · Pratt, KSBuilt 1972 · S/N E-365N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392N1699WDkp Holdings LLC · Melbourne Beach, FLBuilt 1973 · S/N E-399N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N169SPVahedi Vafa S · San Diego, CAS/N TC-353N169TGNordic Sun LLC · Garner, NCBuilt 2005 · S/N E-3627N16BBEuroair Consultants LLC · Vero Beach, FLFirst renewal noticeBuilt 1974 · S/N TC-1749N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456N16CLBig Sky Aviation · Wilmington, DEBuilt 1955 · S/N BA-67N16CTOld Boys Aviation LLC · Knoxville, TNS/N CE-843N16EJAlphaalpha Aviation LLC · Paragould, ARS/N E-3507N16FSGarrett John J IV · Warner Robins, GABuilt 1961 · S/N D-6800N16GDEisele Christopher R · Sheridan, WYBuilt 1944 · S/N 6766N16GKMachugh Adam S · Pasco, WABuilt 1970 · S/N P144N16GMTate Joe D · Eufaula, OKBuilt 1967 · S/N D-8616
Back to AD 99-05-13 R1 WD