OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-R1')
    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-01-05-R1')
  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.

N4811PPolsfut Todd L · Bakersfield, CABuilt 1947 · S/N 11866N4811YSale Reported · Dover, DESale reportedBuilt 1968 · S/N 25-4592N4811ZClark Ronald L · Marysville, WABuilt 1961 · S/N 22-8380N4812MBristow Michael K · Smyrna, GABuilt 1947 · S/N 11-323N4812YRc Ag Air LLC · Cairo, MOS/N 25-4594N4813AVon Etten Robert P · Ravena, NYBuilt 1956 · S/N 22-3965N4813ZStanley Daniel P · Kiowa, KSS/N 22-8383N4814HPfc Aviation Repair Inc · Wallingford, CTBuilt 1948 · S/N 17-112N4814YKnerr Joshua D DBA · Tehachapi, CAS/N 25-4597N4815YAdrian Soaring Club Inc · Ypsilanti, MIBuilt 1968 · S/N 25-4567N4815ZRoberson James · Stephenville, TXS/N 22-8385N4816ASullivan Phillip M · Louisville, KYS/N 22-3969N4816HBressler John P · Duncannon, PABuilt 1948 · S/N 17-114N4817HHartley Jeffrey S · Greenwich, NYS/N 17-115N4817YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4601N4818ACampbell Allen G · Sault Sainte Marie, MIBuilt 1956 · S/N 22-3971N4818HEiden Ryan J · Central, AKS/N 17-116N4818MWolery Chet · Chester, MTBuilt 1947 · S/N 11-329N4818ZCornell Robert C · Lock Haven, PABuilt 1961 · S/N 22-8389N4819HWade Dude B · Newark, ARS/N 17-117N4819MOestreich Terrance W · Ringle, WIBuilt 1947 · S/N 11330N4819ZWest Coast Air Design LLC · Granada Hills, CAS/N 22-8390N4820HLr Air Inc · Wilmington, DEBuilt 1948 · S/N 17-118N4820ZPumford Thomas E Jr · Bannister, MIBuilt 1961 · S/N 22-8391N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974N4821HLovett Brett E · Liberty, MOBuilt 1948 · S/N 17-119N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975N4823HPressley Jeffrey W · Rockingham, NCS/N 17-121N4823MPiper 11-335 LLC · Strafford, NHBuilt 1947 · S/N 11-335N4824HHuntley Lawrence H · Hernando, FLBuilt 1948 · S/N 17-126N4824MShawver Kyle D · Knoxville, IABuilt 1947 · S/N 11-358N4825ATodd Gary W · Rogers, OHBuilt 1956 · S/N 22-3978N4825HVangsness Elaine K · Fargo, NDBuilt 1948 · S/N 17-122N4825YHall William B · Vincentown, NJBuilt 1968 · S/N 25-4614N4827MSmith Dylan L · Oklahoma City, OKBuilt 1947 · S/N 11-338N4827YThief River Aviation Inc · Thief River Falls, MNBuilt 1968 · S/N 25-4618N4827ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8399N4828ZWidman Ralph W Jr · Lynchburg, OHBuilt 1961 · S/N 22-8400N482EJDavis Douglas L · Everson, WABuilt 1953 · S/N 20-1052N4830ARenick Tyler Cain · Wichita Falls, TXS/N 22-3983N4830HRice Danny R · Cedar Park, TXBuilt 1948 · S/N 17-128N4830ZClements Steven D · Boise, IDBuilt 1961 · S/N 22-8404N4831HSale Reported · Iliamna, AKSale reportedBuilt 1948 · S/N 17-129N4832YStohr Beuford G · Woden, IABuilt 1968 · S/N 25-4626N4833HHartley Jeffrey · Greenwich, NYBuilt 1948 · S/N 17-131N4833MHebert Ronald Edmond · Gig Harbor, WAS/N 11-344N4834ARegistration Pending · Eagle River, WIRegistration pendingBuilt 1956 · S/N 22-3987N4834MGustafson Alexander D · Thornton, COBuilt 1947 · S/N 11-345N4834ZRoesner David A · Salina, KSBuilt 1961 · S/N 22-8408N4835HBuck Travis W · Bozeman, MTBuilt 1948 · S/N 17-133
Back to AD 99-01-05 R1