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.

N2479HGleim Garrett William · Gainesville, FLS/N 18-7909193N247TGriffin Kenneth D · Anchorage, AKS/N 18-2361N24806King Barry J · Bentonville, ARBuilt 1939 · S/N 3459N24812Balcom George H · Bemus Point, NYS/N 4-731N24829Mazza Ral James · Plano, TXBuilt 1939 · S/N 4-742N2483MLanners Thomas P · Chickaloon, AKBuilt 1947 · S/N 12-1684N24844Linex Martin E · Greenville, TXFirst renewal noticeBuilt 1939 · S/N 4-740N2484MRegistered aircraftAssigned, pending cancellationS/N 12-1686N24852Vittorio Frank M · Saginaw, MNBuilt 1939 · S/N 4-743N24853Rennie John Mason · New Smyrna Beach, FLS/N 3491N2485ALees Jerry D · Fairbanks, AKBuilt 1952 · S/N 18-1954N2485MMason Michael S · Sequim, WABuilt 1947 · S/N 12-1559N24869Dejong Arie H · Maricopa, AZFirst renewal noticeBuilt 1931 · S/N 3510N2486AHoudek Dennis E · Roseburg, ORS/N 11-880N2486MBartel Christopher H DBA · Williamsburg, PABuilt 1948 · S/N 12-1685N2486PWoods Jerry Lee II · Murchison, TXBuilt 1955 · S/N 22-2860N2487AHoffman Gary D · Spencer, NEBuilt 1952 · S/N 18-1956N2487HEllis Wendell K · Chugiak, AKBuilt 1979 · S/N 18-7909195N2488APetrik Kale O · Sidney, MTBuilt 1952 · S/N 18-1969N2489ALong Patrick B · Buffalo, WYS/N 18-1957N2489MBarker Gerald E · Weymouth, MAS/N 12-1695N248TGiannonatti Lance A · Ludlow, SDBuilt 1953 · S/N 18-2362N24901Eaa Chapter 1580 Inc · Houghton Lake, MIS/N 4-699N2491ACampbell Aviation Inc · Dutton, MTBuilt 1952 · S/N 18-1962N2491MPope Geoffrey M · Bishop, CABuilt 1947 · S/N 12-1698N24921High Planes Aviation LLC · Goodland, KSBuilt 1939 · S/N 4-705N24925Bensinger Group Inc · Meridian, IDBuilt 1939 · S/N 4-762N24926Quinby Bruce · Kingston, TNBuilt 1939 · S/N 4761N24929N24929 LLC · Ada, MIBuilt 1939 · S/N 4-763N2492MSchaaf Terry L · Bowman, NDBuilt 1947 · S/N 12-1699N2493MDriver Kegan Thomas · Billings, MTS/N 12-1561N2494AOtto Justin · Lakeland, TNBuilt 1952 · S/N 18-1961N24952Case Jeffery R · Camas, WABuilt 1939 · S/N 4-770N2496ASibille Keith C · Griffin, GABuilt 1952 · S/N 18-1963N2496PTri M LLC · Nikiski, AKS/N 18-4305N24978Trees Thomas A · Lacey, WABuilt 1979 · S/N 18-7909196N2497ARobertson Roy A · Anchorage, AKBuilt 1952 · S/N 18-1967N2497BHoward Eldon J · Lewiston, IDBuilt 1980 · S/N 18-8109009N2497PWright William B Jr · Deeth, NVBuilt 1955 · S/N 18-4306N2498PBarnes Stephen Ray · Cordova, AKBuilt 1955 · S/N 18-4307N24992Depoy Lowell · Salem, INBuilt 1939 · S/N 3590N2499MC & C Sierra LLC · Jackson, WYBuilt 1947 · S/N 12-1566N249TBigger Tires More Fun LLC · Anchorage, AKBuilt 1953 · S/N 18-2363N24MFBrito Manuel · Dillingham, AKBuilt 1955 · S/N 22-3554N24PPeters Duane A · Anchorage, AKBuilt 1981 · S/N 18-8109073N24QBFedorko Daniel J · Saylorsburg, PABuilt 1957 · S/N 18-5732N2500PLasche James R Jr · Weatherford, TXBuilt 1955 · S/N 22-2861N2502AAmoah-Kusi Christian · Scappoose, ORFirst renewal noticeBuilt 1952 · S/N 22-815N25032Nelson Bruce · Lutz, FLBuilt 1939 · S/N 3611N25049Glasser W Dean · Boswell, PABuilt 1939 · S/N 4818
Back to AD 99-01-05 R1