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.

N4440ZThompson Logan T · Alliance, NEBuilt 1969 · S/N 18-8784N4441HGoldfarb Martin R · Scottsdale, AZBuilt 1948 · S/N 15-230N4441MJohnson Arnold R · Mina, SDBuilt 1947 · S/N 12-3394N4441PMartinson Dominick T · Valdez, AKS/N 5-603N4441ZThoft Matthew M · Wasilla, AKS/N 18-8785N4442AVella La Cava Air LLC · Albuquerque, NMBuilt 1956 · S/N 22-3772N4442HWeber Robert J · Manhattan, KSBuilt 1948 · S/N 15-231N4442ZKrutzfeldt John · Powderville, MTFirst renewal noticeBuilt 1969 · S/N 18-8786N4443AVollman Merlin · Pearland, TXBuilt 1956 · S/N 22-3773N4443ZMeekin Michael J · Palmer, AKBuilt 1969 · S/N 18-8788N4444AWesolowski Chris E · Anchorage, AKBuilt 1956 · S/N 22-3774N4444HSatina David J · Norton, OHBuilt 1948 · S/N 15-233N4445MClark Stanley E Trustee · Redmond, ORBuilt 1947 · S/N 12-3399N4446ZGrant Kimberly A · Priest River, IDBuilt 1969 · S/N 18-8792N4447HBates Charles A Sr · Vernon, NYS/N 15-236N4447MIndiana Aviation Inc · Nicktown, PAS/N 12-3403N4448ZGrow Michael J · Palmer, AKBuilt 1969 · S/N 18-8795N4449CBell Investments LLC · Wasilla, AKS/N 183664N4449MMoore David P · Chugiak, AKBuilt 1947 · S/N 12-3401N4449ZStenga James E · Soldotna, AKBuilt 1969 · S/N 18-8796N4450ABraxling Todd A · Soldotna, AKBuilt 1956 · S/N 22-3782N4450HFreed Richard H · Watervliet, MIBuilt 1948 · S/N 15-239N4450POverly Terrence L · Tok, AKS/N 18-5159N4451ALee Donald R · Talkeetna, AKBuilt 1956 · S/N 22-3783N4451MMartin Kenneth Lloyd · Palmer, AKBuilt 1947 · S/N 12-3406N4451ZSwannack Peter J · Lamont, WABuilt 1969 · S/N 18-8798N4452ZMutch Max Samuel · Anchorage, AKS/N 18-8799N44536Dickamore Chris E · Lewiston, IDS/N 186611N4453ANau Evan D · Manchester, MIS/N 22-3786N4453ZBoyer Skip P · Oak Harbor, WABuilt 1969 · S/N 18-8800N4454AMcclanahan Luke D · Decherd, TNFirst renewal noticeBuilt 1956 · S/N 22-3787N4454HRobinson Terry J · West Chester, PABuilt 1948 · S/N 15-243N4454MTwitchell Matt D · Venice, UTBuilt 1947 · S/N 12-3405N4454ZWilliams Kenneth J · Wasilla, AKS/N 18-8801N4455HFrance Gary L · West Salem, OHBuilt 1948 · S/N 15-244N4455ZWindsor Greg A · Anchorage, AKBuilt 1965 · S/N 18-8334N4456HStewart Dan R · Cashmere, WABuilt 1948 · S/N 15-245N4456ZHayton James B · Sedro Woolley, WAS/N 18-8803N4457HJenkins James L · Lake Stevens, WABuilt 1948 · S/N 15-246N4457MLunceford Jerry W · Corpus Christi, TXBuilt 1947 · S/N 12-3410N4457ZK Ranches Aviation · Bozeman, MTBuilt 1969 · S/N 18-8804N4458MRickard William A · Virginia Beach, VABuilt 1947 · S/N 12-3413N4458ZAerial Crop Care Co · Hebron, NDBuilt 1969 · S/N 18-8805N4460AHvizdak George D · Colliers, WVS/N 22-3793N4460MScheibe Mark E · Lakeville, OHBuilt 1947 · S/N 12-3412N4460YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4109N4461AOrtwein Mathew M · Reedsport, ORBuilt 1956 · S/N 22-3794N4461MHamm Gregory S · Cordova, AKBuilt 1947 · S/N 12-3414N4461YRubbert Jan D · Upham, NDBuilt 1966 · S/N 25-4111N4461ZRed Leasing LLC · Juneau, AKBuilt 1969 · S/N 18-8808
Back to AD 99-01-05 R1