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.

N30849Christensen Craig H · Webster, MNBuilt 1940 · S/N 5-268N3085MCooley Pamela C · New Durham, NHBuilt 1947 · S/N 12-1773N3085YMarsh Aviation Of Marana Inc · Marana, AZFirst renewal noticeS/N 25-4265N3086MBouschor William V · Curtis, WABuilt 1947 · S/N 12-1774N3086ZJohnston Kirk C · Chugiak, AKBuilt 1960 · S/N 18-7437N30875Emmerson James E · Fort Scott, KSBuilt 1940 · S/N 5168N30879Nelson Edward T · Silver Springs, FLS/N 5-274N3088MFreeland Chris G · Brownwood, TXS/N 12-1777N3088ZRavens Rebuilders Inc · Ellenboro, WVBuilt 1959 · S/N 18-7142N30897Jones Ralph E · Oldwick, NJBuilt 1940 · S/N 5-279N30899Registration Pending · Yorktown Heights, NYRegistration pendingBuilt 1940 · S/N 5182N3089MErickson Mark D · Valley Springs, SDBuilt 1947 · S/N 12-1778N308TSchanilec Matthew J · Park River, NDBuilt 1953 · S/N 18-2422N30906Vesely Edward A · Houston, TXBuilt 1940 · S/N 5191N30916Sowders Darwin G · Robinson, TXBuilt 1940 · S/N 5-283N3091ZCheshier Elmer J · Cordova, AKBuilt 1959 · S/N 18-7145N30924Bliss Jacob W · Spokane, WABuilt 1940 · S/N 5-285N30926French Robert P · Dexter, MEBuilt 1940 · S/N 5205N3092MGeeslin James Welch III · Sterling, AKS/N 12-1781N3092ZE & K Feeders Inc · Emmet, NES/N 18-7146N30933Jenkins Joe A · Wyoming, DES/N 5222N3093ZHall Wendell D · Upham, NDBuilt 1959 · S/N 18-7148N30944Air Speed Development LLC · Helena, MTBuilt 1940 · S/N 5223N30948Aslesen Leasin LLC · Halstad, MNBuilt 1940 · S/N 5289N3094ZEspil John R · Lovelock, NVBuilt 1959 · S/N 18-7150N30952Tedrow Scott S · Goodrich, MIBuilt 1940 · S/N 5226N3095ZRichardson Wade S · Stevensville, MTBuilt 1959 · S/N 18-7151N30960Stuart John R · Taylorsville, KYBuilt 1940 · S/N 5231N30971Hill Kevin J · Aurora, MNBuilt 1940 · S/N 4-1249N30975Turner Larry · Fallon, NVBuilt 1940 · S/N 4-1248N3097ZWinters Jack F · Fairbanks, AKS/N 18-7153N30985Rose Carl Warrent · Westmoreland, TNBuilt 1940 · S/N 4-1266N30986Lundy William C · Shaker Heights, OHS/N 4-1264N3098MMorrison Robert H · Fort Denaud, FLBuilt 1947 · S/N 12-1784N3098ZShibe Brent G · Anchorage, AKBuilt 1959 · S/N 18-7169N30992Goheen Gordon C · Battle Ground, WAS/N 4-1270N30995Kirk Kevin J · Pulaski, PABuilt 1940 · S/N 4-1269N30996Everts Robert A · Sarasota, FLBuilt 1940 · S/N 41267N309TWest Coast Aircraft LLC · Carson City, NVBuilt 1953 · S/N 18-2423N30BTKarastamatis Thanassi · Collierville, TNS/N 22-1415N30CSAdams Brad A · Soldotna, AKBuilt 1957 · S/N 18-5409N30GWAnderson Brett J · Groton, SDBuilt 1954 · S/N 18-3939N30VBukolsky Ivan · Silt, COBuilt 1955 · S/N 12-333N31000Fahy Thomas E · Carabaset Vly, MEBuilt 1940 · S/N 5-294N31005France Miles D · Wasilla, AKBuilt 1940 · S/N 5249N3100MHennessy John P · Bigfork, MTBuilt 1947 · S/N 12-1786N31012Van Gorden Jeffrey L · Vestal, NYS/N 5255N31017Hicks Paul G · Lizton, INBuilt 1962 · S/N 5257N3101MThompson Curtis Lee · Chugiak, AKBuilt 1947 · S/N 12-1788N31020Harvey Christopher Johnryan · Port Leyden, NYBuilt 1940 · S/N 5-300
Back to AD 99-01-05 R1