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.

N12KSWalton Cheryl H · Indianapolis, INBuilt 1974 · S/N TE-1005N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119N12PMFlying Bald Eagles Inc · New Lenox, ILBuilt 1964 · S/N D-7514N12PPAero Verde LLC · Wheat Ridge, COBuilt 1975 · S/N P-334N12RCSkipper Thomas · Coburg, ORS/N D-9308N12SRNorthshore Group LLC · Wilmington, DEBuilt 1974 · S/N P-316N12TPTravels With Trip LLC · Lewes, DEBuilt 1961 · S/N D-6710N12WLLauterbach Christian · Carmel, CABuilt 1975 · S/N TC-1870N1300ZRosewood Aviation LLC · San Diego, CAS/N D-6808N1302ZPlaisier Matthew · Lafayette, TNBuilt 1961 · S/N TC-173N1303ZCentral Virginia Aviation Inc · North Dinwiddie, VAS/N D-6740N1305ZReynolds James Patrick · Lebanon, TNBuilt 1961 · S/N TC-119N1307Brian Michael L · Greensboro, NCBuilt 1969 · S/N TC-1307N1307ZFerris Dale E · Willsboro, NYS/N D-6742N1308ZDelaney Troy · Lake Ozark, MOBuilt 1961 · S/N D-6743N1309ZReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N TD-463N1311ZJprg Aviation Inc · Orlando, FLBuilt 1961 · S/N TC-120N1313WSecond Kitchen LLC · Chicago, ILBuilt 1979 · S/N E-1440N1314ZGensler Jordan T · Three Lakes, WIBuilt 1961 · S/N D-6746N1315ZRiesbeck Randall C · Waynesville, OHBuilt 1961 · S/N TC-123N1316ZN1316zulu LLC · Defiance, OHBuilt 1961 · S/N D-6749N1319ZGood Steven D · Douglas, WYBuilt 1961 · S/N D-6757N131BMillspaugh John · Weatherford, OKBuilt 1955 · S/N D-4436N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538N131MDWoodley Aerial Leasing LLC · Walnut, ILBuilt 1959 · S/N D-5978N131MEDuncan John H Jr · Bend, ORBuilt 1984 · S/N TJ-451N131TWBaron N131tw LLC · Wilmette, ILBuilt 1974 · S/N TE-963N1324ZMonson Ryan D · The Woodlands, TXBuilt 1961 · S/N D-6759N1326ZJoseph Casey · Lufkin, TXBuilt 1961 · S/N D-6760N1328ZStewart Ian D · Beaverton, ORBuilt 1961 · S/N D-6761N132BMds Flying LLC · Deephaven, MNBuilt 1981 · S/N TE-1189N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331N132FBRock Rivers Bancorp · Rock Rapids, IABuilt 1975 · S/N E-700N132PA2 Supersonic LLC · Ann Arbor, MIS/N M-2194N132TWRc Flyers LLC · Wilmington, DEBuilt 1974 · S/N TC-1654N132YCarr Scott A · Allen, NEBuilt 1954 · S/N D-3861N1332ZUp And Up Aviation LLC · Spring, TXBuilt 1961 · S/N TC-141N1333Beech Nut Flyers LLC · San Diego, CABuilt 1968 · S/N TC-1100N1339ZSmith Derek D · Brooks, GABuilt 1961 · S/N TC-139N133AGRaritan Valley Flying School · Princeton, NJS/N CE-1470N133BSMusser Merton · Billings, MTBuilt 1988 · S/N CE-1234N133CGRoq Farm LLC · Diboll, TXBuilt 1989 · S/N CE1416N133ECMf33a Enterprises LLC · Amarillo, TXBuilt 1992 · S/N CE-1679N133EMWheels Up LLC · Lincoln, NES/N E-517N133GMBem Holdings LLC · Nashville, TNBuilt 1987 · S/N CE-1170N133LBlair Byron · Ajo, AZBuilt 1952 · S/N D-3300N133MDWells Rich · Aspen, COBuilt 1987 · S/N CE-1163N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173
Back to AD 99-05-13 R1 WD