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.

N2351LVlazny Stephen F · Divide, COBuilt 1963 · S/N M-188N2351WWebb Brian C · Owasso, OKBuilt 1966 · S/N M-949N23523Fox & Bear Air Charters LLC · South Padre Island, TXBuilt 1977 · S/N E-1175N23524San Francisco Peaks Trucking Inc · Flagstaff, AZBuilt 1978 · S/N E-1174N2352LHaag Harvey E · Clearfield, PABuilt 1963 · S/N M-189N2352WAlligator Air Transport LLC · Fort Lauderdale, FLS/N M-950N23534Schwabenton William J · Greensboro, NCBuilt 1977 · S/N CE-751N2353JWings Of History Air Museum · San Martin, CABuilt 1963 · S/N M-311N23540State Of Iowa · Iowa City, IABuilt 1977 · S/N E-1180N23541Registration Pending · Middleburg, FLRegistration pendingBuilt 1977 · S/N E-1182N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085N2354BHigh Sky LLC · Rogers, ARBuilt 1968 · S/N D-8831N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154N2354QWallace Willie B III · Donalsonville, GABuilt 1963 · S/N M-422N23551S&M Aviation (A Co Limited Liability Co) · Colorado Springs, COBuilt 1977 · S/N E-1183N23553Uandmycar.Com Inc · Plattsburgh, NYBuilt 1977 · S/N P-453N2355QKreek Karl · Glasgow, KYBuilt 1963 · S/N M-423N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195N2356JN2356j LLC · Winchester, VABuilt 1963 · S/N M-314N2356ZOlson David C · Emmetsburg, IAS/N M-69N23571Dlat Holdings LLC · Allen, TXBuilt 1977 · S/N TE-1120N23573Rolrice Family Limited Partnership · Tulsa, OKBuilt 1977 · S/N TC-2107N23578Green Law Aviation Inc · Culpeper, VABuilt 1977 · S/N E-1185N2357LLords Assets LLC · Columbus, OHBuilt 1963 · S/N M-195N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157N23583Ingersoll David K · Trinity, ALBuilt 1978 · S/N D-10087N23588Bunn Enterprises Inc · Fleming, OHBuilt 1978 · S/N P-454N2358LSimpson Timothy A · Niles, MIBuilt 1963 · S/N M-196N2358QBertrand Jason A · Seattle, WAS/N M-427N2358WBeyer Kaleb A · Danville, ARBuilt 1966 · S/N M-955N2358ZBrinegar Matthew D · North Tustin, CABuilt 1962 · S/N M-70N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159N2359QBean Glen A · Damascus, ORS/N M-428N235AADifferent Auto LLC · Twin Falls, IDBuilt 1959 · S/N D-5967N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134N235DCCalley Darryl E · Snyder, TXS/N CE-750N235EMcfarland Joel Cable · East Earl, PABuilt 1963 · S/N D-7162N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443N235RRegistered aircraftBuilt 1966 · S/N D-8360N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326N235SEPlane Flt LLC · Broken Arrow, OKBuilt 1981 · S/N E-1953N235SGZonaair LLC · Roll, AZS/N E-3544N236Cooper Stephen · Fairbanks, AKBuilt 1942 · S/N 3179N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088N23608Beech36 LLC · Clarkston, MIBuilt 1978 · S/N E-1188N23609Wiebelhaus John J · Strasburg, COBuilt 1978 · S/N D-10089N23612Lcms Limited · Durham, NCBuilt 1977 · S/N CE-756N23614Great American Jet Inc · Cincinnati, OHBuilt 1978 · S/N TC-2153N23615Yoder Metal & Post Frame & Building Supplies · Haven, KSBuilt 1977 · S/N E-1191
Back to AD 99-05-13 R1 WD