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.

N1760PBartholomew John E · Storm Lake, IABuilt 1954 · S/N 18-4082N1761AVecchio Alfred J · Emerado, NDBuilt 1952 · S/N 22-490N1763PHughes Jennetta M · Big Lake, AKBuilt 1954 · S/N 18-4087N1764ALegge Carl D · Wichita, KSBuilt 1952 · S/N 22-495N1765AMurray James A · Wasilla, AKBuilt 1952 · S/N 22-499N1765PHendry Robert L · Lysite, WYBuilt 1954 · S/N 18-4090N1769PVollendorf William M · Anchorage, AKBuilt 1954 · S/N 18-4107N1771AAllen Timothy · Jackson, GAS/N 22-498N1771PHansen Larry G · Alliance, NEBuilt 1954 · S/N 22-2543N1772AAllen Jack · Deridder, LABuilt 1956 · S/N 22-502N1773PWidman Ralph W · Lynchburg, OHBuilt 1954 · S/N 22-2545N1774PBrandenburg Timothy C · Anchorage, AKBuilt 1954 · S/N 22-2547N1775AChapman Harold J · Nenana, AKBuilt 1952 · S/N 20-865N1779PWilliamson Gary T · Ashmore, ILBuilt 1954 · S/N 22-2552N1783ASatra Jerry · Savage, MTBuilt 1952 · S/N 18-1328N1788ADavis Nigel L · Helena, MTBuilt 1952 · S/N 18-1658N1788PBenson Thomas E · Keller, TXBuilt 1954 · S/N 22-2561N1791PWhitley Brian M · Sandpoint, IDBuilt 1954 · S/N 22-2564N1793AHickle Lucas · Wasilla, AKS/N 18-1664N1795ASvendsen Gregory Roy · Anchorage, AKBuilt 1952 · S/N 18-1665N1796PMcmahan C Merrill · Wausau, WIBuilt 1954 · S/N 22-2569N1797PSherman John · Northport, NYBuilt 1954 · S/N 22-2570N1798ASlow Goose LLC · Chevy Chase, MDBuilt 1952 · S/N 18-1667N1799PGranger Joshua M · Rosebud, MTBuilt 1955 · S/N 22-2572N17NEWilson James M · Scottsdale, AZS/N 18-7709083N17NVLeseberg Mark E · Boulder City, NVBuilt 1946 · S/N 12-863N17PCCarolina Seaplanes LLC · Tega Cay, SCFirst renewal noticeBuilt 1958 · S/N 22-5931N17VGPerman Thomas E · Jupiter, FLBuilt 1948 · S/N 17-97N1801ABenner Robert A · Meridian, IDFirst renewal noticeS/N 22-513N1801PPayne David J · Eagle River, AKBuilt 1955 · S/N 22-2579N1804PVaughn James F · La Porte, INBuilt 1955 · S/N 22-2583N1805PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-2584N1807PTempleton James N · Petersburg, ILBuilt 1955 · S/N 22-2586N1808PBistline Nephi K · Colorado City, AZS/N 22-2587N180ATClark John W · Anchorage, AKBuilt 1978 · S/N 18-7809096N180DWWilliams J Darrell · Colbert, OKBuilt 1959 · S/N 22-7132N180ENNealey Eric D · Barrington, ILBuilt 2003 · S/N 9966CCN180JNNealey James L · Buffalo, WYBuilt 2002 · S/N 9954CCN180PZBertholl Dwayne R · Eagle River, AKBuilt 1963 · S/N 18-8075N180TWatanabe Masayuki · Harbor Oaks, FLBuilt 1953 · S/N 18-2294N1810PTurner Christian Millard · Eastsound, WABuilt 1955 · S/N 22-2589N1812PCarothers Edward L · Jersey Shore, PABuilt 1955 · S/N 22-2591N1813ALawrence Mark J · Rouses Point, NYS/N 22-516N18141Schulte James P · Hurst, TXBuilt 1951 · S/N 181332N1814DAndover Flight School Inc · Andover, NJBuilt 1958 · S/N 18-6406N1815ALa Viano Kenneth J · Westwood, NJBuilt 1952 · S/N 22-521N1819Peters Sean T · Oak Harbor, OHBuilt 1959 · S/N 22-6705N181AWKustatan Leasing LLC · Nikiski, AKS/N 18-1743N181FBaker Myron C · Morrow, OHRegistration revokedBuilt 1959 · S/N 226705N181TWatkins Steven B · Roxboro, NCBuilt 1953 · S/N 18-2295
Back to AD 99-01-05 R1