OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,519

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.

N118TBColtman Peter O · Colleyville, TXBuilt 1981 · S/N E-1891N118VSmith Gregg W · Lake Jackson, TXBuilt 1966 · S/N D-8096N1191AMoore John C DBA · San Miguel, CABuilt 1970 · S/N TG-84N1192VSchmidt Victor M · Corbett, ORBuilt 1945 · S/N 6884N1195TRoberts Robin W · Birmingham, ALBuilt 1974 · S/N E-629N1195VRegistration Pending · Biggs, CARegistration pendingBuilt 1947 · S/N 6749N1196VWebstrong Aviation LLC · Conway, ARBuilt 1944 · S/N 6703N119ABSafford Aviation Service Inc · Coolidge, AZBuilt 1966 · S/N TE-145N119DDColeman Russell L · St Charles, ILBuilt 1952 · S/N D-3380N119EWBte Aviation LLC · Wilmington, DEBuilt 1981 · S/N E-1863N119JBWagner Mathew J · Gary, SDBuilt 1958 · S/N D-5683N119JSFennen David A · Katy, TXBuilt 1961 · S/N D-6861N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369N119WRatliff Hayden N · Clarkesville, GABuilt 1953 · S/N D-3518N11ACN11ac LLC · Lighthouse Point, FLS/N TC-215N11AXLoukopoulos George Matthew · Tucson, AZBuilt 1949 · S/N D-1992N11BCBledsoe Lucile M · Wray, COBuilt 1991 · S/N EA-515N11BXMatthew K Cole · Gillespie, ILBuilt 1972 · S/N CE-388N11CFKrens Janet E · Purcellville, VABuilt 1954 · S/N CH-107N11EMEstus Chad · North Las Vegas, NVBuilt 1957 · S/N D-5159N11FCCooper Matthew A · Seattle, WABuilt 1947 · S/N D-25R1N11FFJet Speed Aviation Inc · Las Vegas, NVS/N TE-736N11FPShannon Rcs LLC · Kalispell, MTBuilt 1952 · S/N D-3104N11GGGallagher Aviation LLC · Cincinnati, OHBuilt 1959 · S/N D-6184N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298N11HTJet X Leasing Inc · Johnson, KSBuilt 1967 · S/N D-8534N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234N11JQLosey Charles N Jr · Oneida, TNBuilt 1965 · S/N D-7786N11KFRebel Dawg Aviation LLC · Vestavia Hills, ALBuilt 1967 · S/N TE-325N11KSFaulkner Dale R · Burnet, TXBuilt 1969 · S/N D-9017N11RLBeech Life LLC · Houston, TXBuilt 1980 · S/N EA120N11RMHaig Amy · Redlands, CABuilt 1993 · S/N EA-553N11RTBraly And Braly Pc · Ada, OKBuilt 1967 · S/N D-8420N11SYRautiola Erik · Cresson, TXS/N TC-1468N11UYInternational Air Services Inc Trustee · Carson City, NVS/N EA-218N11VBRobertson Matthew · Nashville, TNBuilt 1969 · S/N D-9031N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891N11VKHoskins Terry Wayne II · Knoxville, TNBuilt 1961 · S/N TC-200N11VNHilton Head Flyers LLC · Liberty, SCBuilt 1981 · S/N ME-416N11VZLowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N E-397N11WPPlacer Aviation LLC · Loomis, CABuilt 1990 · S/N E-2546N11XMWesley F Walker · Rock Hill, SCBuilt 1999 · S/N E-3225N1202BDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N TC1825N1204ZAquila Aero LLC · Denison, TXBuilt 1961 · S/N D-6667N1206ZGlg Properties LLC Series 13 · Bridgeport, TXS/N D-6678N1208ZMaurice L Prince Jr Pc · Lafayette, LABuilt 1961 · S/N TC-60N120BSkysuite Aviation LLC · Tujunga, CABuilt 1962 · S/N TC-230N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248
Back to AD 99-05-13 R1 WD