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.

N6008LGawlik Leslie W · Reisterstown, MDBuilt 1978 · S/N M-2087N6008SAustin Aerial Media LLC · Pflugerville, TXBuilt 1975 · S/N P-338N6008URasmussen John E · Seffner, FLBuilt 1978 · S/N MC-616N60097Ratliff Frank O · Palestine, TXBuilt 1978 · S/N MC-619N600AFClark Development LLC · Dekalb, ILBuilt 1980 · S/N E-1803N600CPColumbus Paper Company Inc · Columbus, GABuilt 1982 · S/N P-590N600CTRutner Stephen M · Palm City, FLS/N E-2979N600GDAlpha Mike LLC · Stoughton, MAS/N E3561N600MBKleid Kenneth E · Spring Branch, TXBuilt 1968 · S/N TC-1184N600MDDowning Scott L · Fitzgerald, GABuilt 1965 · S/N D-7803N600MSInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N E-995N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250N600PGParis Jet Inc · Great Falls, VABuilt 1979 · S/N P-502N600PMBlackford Ryan · Manchester, TNBuilt 1977 · S/N TC-2082N600PRWest Wind Air LLC · Lake Village, ARBuilt 1981 · S/N TC-2384N600VRAutry Technology Center · Enid, OKS/N D-2159N600ZZGsair Inc · Wilmington, DEBuilt 1973 · S/N E-400N60104Theo-N60104 LLC · Wilmington, DEBuilt 1978 · S/N M-2093N60106Lutzko Timothy R · Ocean View, DEBuilt 1978 · S/N M-2094N6010CBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-905N6010EBruce Mkristo E · Ravensdale, WABuilt 1959 · S/N D-5942N6010SR&R Aviation LLC · Wilmington, DES/N P-350N6011JSymond Clarence B · Eastover, NCBuilt 1978 · S/N MC-625N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100N6011SWelch Troy O · Weatherford, TXBuilt 1974 · S/N P-311N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101N6012FSanders Flight Training Center · Jasper, ALBuilt 1965 · S/N TD-616N6012SWhaley Carl S · Shelby, NCS/N TJ-15N6012YBieszczad Wally · Bloomingdale, ILBuilt 1979 · S/N M-2106N60135Charles Ray Aviation LLC · Fleming Island, FLBuilt 1979 · S/N M-2105N6013FMile Fly Club LLC · Gainesville, TXBuilt 1965 · S/N TC-888N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112N6014LIrsfeld Matthew T · Kingman, AZS/N MC-628N6014ZSimpson Alena A · Blue Eye, MOBuilt 1979 · S/N M-2141N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147N6015EGlaysh-Air Aviation LLC · Cary, ILBuilt 1959 · S/N D-5941N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141N6015UN6015u LLC · Lakeview, NCS/N M-2135N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145N60165Caballero Arturo C · Clute, TXBuilt 1979 · S/N M-2145N6016EHagins Chrisopher Ryan · Yulee, FLBuilt 1959 · S/N D-5918N6016FHanson Enterprises Inc · Hamel, MNBuilt 1965 · S/N D-7823N6016KRamsey Keith W · Morrison, TNS/N MC-646N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156N6016YClute Jack S · Valparaiso, INBuilt 1979 · S/N MC-650N6017SEisma Thomas Eugene · Golden, COBuilt 1975 · S/N TJ-17N6018EBurns Robert D · Billings, MTBuilt 1959 · S/N D-5962N6018SJohnson Thomas G · New Port Richey, FLS/N TJ-19N60199Krystofiak Steven · Scottsdale, AZBuilt 1979 · S/N WA-12N6019ECobb Lee C · Van Alstyne, TXBuilt 1959 · S/N D-5980
Back to AD 99-05-13 R1 WD