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.

N35640Rivera Carlos A · Morriston, FLBuilt 1941 · S/N 6496N35649Vanderwall Richard K · Newark, NYS/N 6507N35657Martinez Anthony III · Great Bend, KSBuilt 1941 · S/N 6516N3565PPavia Joshua A · Alamogordo, NMBuilt 1955 · S/N 18-4557N3565ZLewis William D · Shelbyville, TNBuilt 1960 · S/N 22-7480N3567PWoolington James D · Dillingham, AKBuilt 1955 · S/N 18-4559N35688Colvin Clu Dusting DBA · Big Cabin, OKBuilt 1941 · S/N 5-732N3568MLong Douglas J · Wolf Point, MTBuilt 1947 · S/N 12-2504N3568ZUelner Nathan · Cedar Falls, IABuilt 1960 · S/N 22-7484N35695Horovitz Paul M · Rincon, GABuilt 1941 · S/N 4-1400N35697Haldeman Enterprises LLC · Vancouver, WABuilt 1941 · S/N 5-725N35698Sherlock Pete W · Gwinner, NDS/N 4-1397N3569AAlbright Larry W · Perkins, OKBuilt 1953 · S/N 22-1843N3569ZKleewein Daniel A · Pewaukee, WIS/N 22-7485N35709Ross David R · Wakeman, OHS/N 6550N3571MCasazza Christian G · Anchorage, AKBuilt 1947 · S/N 12-2419N3571ZThompson Lyndon R · West Fargo, NDBuilt 1960 · S/N 18-7349N35721Bakken Al J · Belgrade, MTBuilt 1941 · S/N 5-762N35729Wood Wesley W · Belle Fourche, SDBuilt 1941 · S/N 4-1407N3572PMulkey Joshua D · Anchorage, AKS/N 18-4526N35736Diamond J Farms · Pleasant Grove, CAS/N 6556N3573AAlderman Bill A · Chelsea, OKBuilt 1953 · S/N 22-1847N3573MCheney Klyn W · Gooding, IDBuilt 1947 · S/N 12-2420N3573PStewart James B · Anchorage, AKBuilt 1955 · S/N 18-4527N3573ZBlue Ice Aviation Inc · Wasilla, AKBuilt 1960 · S/N 18-7359N35745Smith Robert D · Roanoke, TXS/N 5-747N3574WOrton Aviation LLC · Walker, MNBuilt 1946 · S/N 18159N3574ZWestwood Dave · Red Lodge, MTBuilt 1960 · S/N 18-7360N35756Englebaugh Thomas H · Wellsville, NYBuilt 1941 · S/N 6571N3575ZRieke Rhett W · Bigfork, MTS/N 18-7364N35762Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 5-753N35764Routh Gary L · Lebanon, TNBuilt 1941 · S/N 5-758N3576ASolosky Robert L · North Barrington, ILBuilt 1953 · S/N 22-1850N3576ZRaymond Jeff R · Fairbanks, AKBuilt 1960 · S/N 18-7365N3577PKeegan Stephen E III · Nome, AKS/N 18-4531N35783Walling Justin M · New Carlisle, OHBuilt 1941 · S/N 6583N35784Jackson James C · Hickory, PAS/N 5-765N35786American Airpower Heritage Flying Mu · Dallas, TXBuilt 1941 · S/N 5-772N3578PTirrell Danielle J · Fairbanks, AKBuilt 1955 · S/N 18-4532N3578ZNance Gary L · Fairbanks, AKBuilt 1960 · S/N 18-7368N35793Mcenery Brian T · Elmendorf, TXBuilt 1941 · S/N 5-770N3579APerry John E · Kenai, AKBuilt 1953 · S/N 22-1854N3579BEssman Kenneth R · Burlington, WIBuilt 1950 · S/N 18-368N3579ZMartin Michael J · Anchorage, AKS/N 18-7369N357FPJenson Michael N · Nevis, MNBuilt 1961 · S/N 22-7334N357PMEumundi Trading Co · Wilmington, DEBuilt 1976 · S/N 187609154N357RJJilek Ray A · Spearfish, SDBuilt 1956 · S/N 18-5071N357SCDingess James D · Carson City, NVBuilt 1966 · S/N 18-8412N357THutchison Warren L · Wasilla, AKS/N 18-2421N35809Merritt Robert L · Afton, WYBuilt 1941 · S/N 6607
Back to AD 99-01-05 R1