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.

N58KSMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1958 · S/N DH-165N58KWBloomer Carl A · Bull Valley, ILBuilt 1958 · S/N D-5690N58LGMorgan Farms LLC · Twin Falls, IDBuilt 1981 · S/N TJ-393N58LPPrichard Lev H · Dallas, TXBuilt 1985 · S/N TJ-481N58MCTubreaux Aviation Services LLC · Shreveport, LABuilt 1978 · S/N CJ-143N58MDLicandro Rudolph · Prospect, KYBuilt 1979 · S/N TJ-248N58MSRegistration Pending · Oklahoma City, OKRegistration pending, canceledBuilt 1994 · S/N E-2889N58NKasper Richard J · Swanzey, NHBuilt 1944 · S/N 6762N58PHangar Seven LLC · Penn Yan, NYBuilt 1980 · S/N TJ-303N58PADwt Air LLC · Lakeland, FLBuilt 1981 · S/N TJ-348N58PCGrooms David C · Gallatin, TNBuilt 1977 · S/N TJ-101N58PDFoley Jeffrey William · Scappoose, ORBuilt 1976 · S/N TJ-86N58PECenice LLC · Eagle, COBuilt 1982 · S/N TJ-435N58PPWeaver Aviation LLC · Mount Pleasant, SCS/N TC-1762.N58PRQuinlan John H · Claxton, GABuilt 1978 · S/N TJ-149N58PTBarsukov Kirill · Jersey City, NJBuilt 1968 · S/N D-8855N58PZMiller Paul David · Dallas, TXBuilt 1981 · S/N TJ-360N58RAGibbs Ron · Parker, AZBuilt 1975 · S/N TJ-14N58SSHill Rick A · San Antonio, FLBuilt 1980 · S/N E-1734N58TBTaylor Scott · Bg Bnd Ntl Pk, TXS/N TJ-113N58TCN58tc LLC · Gibsonton, FLBuilt 1984 · S/N TJ-455N58TDEaston Douglas J · Sandpoint, IDBuilt 1982 · S/N TJ-411N58TEGtk Services LLC · Carbondale, ILBuilt 1980 · S/N TJ-326N58TFFlying Matters LLC · Cedarburg, WIBuilt 1980 · S/N TJ-292N58TKTwa Partners LLC · Billings, MTBuilt 1979 · S/N TK-107N58TMBobcat Air LLC · Maddock, NDBuilt 1973 · S/N TE-911N58VBBeckman Donald A · Rostraver Township, PABuilt 1980 · S/N TJ-260N58VTPhilippou Thomas C · Harvard, MABuilt 1958 · S/N D-5446N58ZZDestination Marketing Group LLC · Sedona, AZBuilt 1983 · S/N TJ-432N5900CKaufmann Landry V · Gamaliel, KYBuilt 1951 · S/N D-2854N5901SSheffield Kraig · Guthrie, OKBuilt 1966 · S/N D-8118N5902SFuhrmann Roy R · Webster, MNBuilt 1966 · S/N D-8110N5903CCollins John P · El Cajon, CAS/N D-3273N5905SLutes Ralph E · Shipshewana, INBuilt 1966 · S/N D-8130N5907CN5907c LLC · Fairhope, ALBuilt 1952 · S/N D-3290N5908CAircorps Aviation LLC · Bemidji, MNBuilt 1952 · S/N D-3267N590BFolds James W · Tifton, GABuilt 1948 · S/N D-1609N590PMMcewen Drew M · Wichita, KSBuilt 1969 · S/N D-8909N5910SCrow River Aviation LLC · Watertown, MNBuilt 1966 · S/N D-8122N5912CLindley Shawn P · Boone, COBuilt 1953 · S/N D-3414N5912STop Hand Field Service LLC · Stillwater, OKBuilt 1968 · S/N D-8830N5915SFord Keith A · Colorado Springs, COBuilt 1966 · S/N D-8120N5916SCross Gerald S · Fresno, CABuilt 1966 · S/N D-8124N5917CVierra David R · Chaska, MNBuilt 1952 · S/N D-3277N591ADSome Amigos LLC · Spring, TXBuilt 1964 · S/N TC-647N5920SLukan Duane G Trustee · Liberty Lake, WAS/N D-8131N5921CRegistered aircraftS/N D-3281N5924CJuneau Greg L · Shreveport, LAS/N D-3283N5925CBrickey William C · Morrilton, ARBuilt 1952 · S/N D-3284N5926CCase Robert M · Poulsbo, WABuilt 1952 · S/N D-3285
Back to AD 99-05-13 R1 WD