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.

N40895Kraus Russell E · Albemarle, NCS/N 5-1190N40896Red Oak Flying Club · Cabot, ARBuilt 1941 · S/N 5-1197N4089MViens Ernest W · Eagle River, AKBuilt 1947 · S/N 12-2978N40900Luginbuel Stacy W · Prairie Grove, ARBuilt 1941 · S/N 7576N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109N4092MSmith Dennis L · Carthage, NCFirst renewal noticeBuilt 1947 · S/N 12-2983N40947Simonson Larry A · Dalton, MNBuilt 1941 · S/N 7616N4094MVaughn Charles M · Titusville, FLBuilt 1946 · S/N 12-3028N40950Riggin Flight Service Inc · Madison, SDBuilt 1941 · S/N 7620N40957Roberts Linda L · Bell Buckle, TNBuilt 1941 · S/N 7627N4095ZBreidenbach Bros Inc · Iliff, COBuilt 1964 · S/N 18-8108N4096ESwiss John T · Anchorage, AKBuilt 1978 · S/N 18-7809064N4096ZTurner Hal Eugene Jr · Tiburon, CAS/N 18-8110N40975Hooker Stephan F · Knoxville, TNBuilt 1941 · S/N 7641N4097ZSullivan Daniel J · Long Lake, MNBuilt 1964 · S/N 18-8111N40981Armstrong Bobby · Belhaven, NCBuilt 1941 · S/N 7632N40986Air America Inc · Stow, MAFirst renewal noticeBuilt 1941 · S/N 5-1220N40988Barrientos Jeri D · Collinsville, OKBuilt 1941 · S/N 4-1610N4098ZChant J Archie · Riverton, WYBuilt 1964 · S/N 18-8112N4099EReel Chad · Wasilla, AKS/N 18-7809066N4099ZMayes Brett R · Williams, CABuilt 1964 · S/N 18-8113N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675N40TUParrot Cay LLC · Missoula, MTBuilt 1978 · S/N 18-7809143N41001Ideal Ride LLC · East Dundee, ILBuilt 1941 · S/N 7658N41008Spain Air LLC · Pensacola, FLBuilt 1941 · S/N 7642N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114N4103MMills Air Service Inc · Marstons Mills, MABuilt 1947 · S/N 12-3000N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124N41051Haynes Thomas E · Avon Park, FLS/N 5-1242N41052Tippett Charles S Jr · Warrenton, VABuilt 1941 · S/N 5-1243N41058Waukecub Inc · Waukesha, WIBuilt 1941 · S/N 4-1621N4105MMameli Laurie K · Thomaston, GABuilt 1947 · S/N 12-2999N4105ZMccaughey Steven A · Winter Haven, FLBuilt 1964 · S/N 18-8126N41065Kjeldgaard James K · Fremont, NEBuilt 1941 · S/N 4-1615N4106ZJohnson Royce D · Clinton, ARBuilt 1964 · S/N 188127N4107MBeckham John T · Steelville, MOFirst renewal noticeBuilt 1947 · S/N 12-3005N4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1964 · S/N 18-8128N41086Zabinski Ted W · Voorheesville, NYBuilt 1941 · S/N 7738N4108ASwinehart Frank E · Lock Haven, PABuilt 1951 · S/N 18-867N4108ZRamstad Trygg J · Anchorage, AKBuilt 1964 · S/N 18-8130N41095Yandik Stephen E · Hudson, NYBuilt 1941 · S/N 7704N4109HSchamber Thomas D · Oklahoma City, OKS/N 12-3545N4109MPoklan Janeen A · Mount Orab, OHS/N 123007N4109ZAlf Robert R · Elkhorn, NEBuilt 1964 · S/N 18-8129N410LNormandeau Daniel R · Thompson Falls, MTS/N 18-6614N410RDVan Den Langenbergh Raymond · New Port Richey, FLS/N 18-4920N41103Baldwin Frank D · Troy, MOBuilt 1941 · S/N 7652N41105Richbourg Keith D · Waco, TXBuilt 1941 · S/N 7750N4110ZJohnson Airspray Inc · Argyle, MNBuilt 1965 · S/N 18-8131
Back to AD 99-01-05 R1