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.

N4133HJohnson Steven D · Pardeeville, WIBuilt 1948 · S/N 15-16N4134ZHuseby Terry L · Hulett, WYBuilt 1964 · S/N 18-8207N41356Brabham Melvin W · Fairbanks, AKS/N 5-1341N4135HSommer John J · Seattle, WABuilt 1948 · S/N 15-18N4135MHardy Val D · Lewistown, MTBuilt 1947 · S/N 12-3034N41360Cross Thomas Ad · Yacolt, WABuilt 1945 · S/N 5-1395N4136ENelson Gregory A · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809082N4136HMetzler Kevin W · Rosamond, CABuilt 1948 · S/N 15-19N4136MArmstrong Charles · Shelbyville, MIBuilt 1947 · S/N 12-3035N4137ZAtg Enterprises Inc · Aztec, NMBuilt 1964 · S/N 18-8209N41385Boening Bros Dusting & Spraying Inc · Floresville, TXS/N 5-1350N41386Oliver Rodney W · Houston, AKBuilt 1941 · S/N 5-1349N41388Rendel James L · Rock Hill, SCS/N 5-1345N4138ZZweifel Douglas L · Anchorage, AKS/N 18-8210N41396Haynes Thomas E · Avon Park, FLS/N 5-1357N4139MWhiteley Jeffrey L · Jefferson, ORS/N 12-3038N4139ZL Sheffels And Son Inc · Wilbur, WABuilt 1965 · S/N 18-8211N41401Lardner Vincent J · Los Lunas, NMBuilt 1941 · S/N 5-1365N41405Horton Ernest J III · Galveston, TXS/N 5-1368N4140ZMeierotto Jeff T · Two Rivers, AKBuilt 1965 · S/N 18-8213N4141HBizy Eves Enterprises LLC · San Antonio, TXS/N 15-24N4141ZBalmer Jeffrey A · Crosslake, MNBuilt 1964 · S/N 18-8215N4142MMiddleton William A Jr · Crestwood, KYBuilt 1947 · S/N 12-3041N4143HEllison Ben L · Mercer Island, WABuilt 1948 · S/N 15-26N4143ZRavenscroft Brant A · Box Elder, SDBuilt 1965 · S/N 18-8221N4144ETradewind LLC · Wasilla, AKBuilt 1978 · S/N 18-7809084N4144HBates Charles A Sr · Vernon, NYBuilt 1948 · S/N 15-27N4144MSannon Michael R · Fairview, MTBuilt 1947 · S/N 12-3044N4146EHarrison Jeffrey L · Fairbanks, AKBuilt 1978 · S/N 18-7809085N4146MKincaid Adam D · Anchorage, AKBuilt 1947 · S/N 12-3045N4147EEnglerth Mark J · Wasilla, AKBuilt 1978 · S/N 18-7809086N4147HKoerner Stephen F · Kankakee, ILS/N 15-29N4147ZHopper Bruce · Chugiak, AKBuilt 1965 · S/N 18-8225N4148EDoody Michael C · Knoxville, TNBuilt 1978 · S/N 18-7809087N4148ZWillet Gerald E · Townsend, MTBuilt 1965 · S/N 18-8227N4149HDietrich Walter C · Hastings, FLBuilt 1966 · S/N 15-32N414JFoster Walter T · Terre Haute, INBuilt 1940 · S/N 41299N41500Brandt Benjamin C · Nampa, IDBuilt 1989 · S/N 1809011N41508Cobb Ralph B · Nicholasville, KYBuilt 1994 · S/N 8156N4150HThomas Brett · Gettysburg, PABuilt 1989 · S/N 1809001N4150MDozier Roger S · Fairfield, ILBuilt 1947 · S/N 12-3049N4150NMarland Robert T Jr · North Platte, NEBuilt 1988 · S/N 1809004N4150RLewis Aeronautical LLC · San Antonio, TXBuilt 1988 · S/N 1809006N4150ZDalks Leasing Inc · Wilmington, DEBuilt 1965 · S/N 18-8289N4151FSmith Anna J Trustee · Newport, NYBuilt 1989 · S/N 1809047N4151HMoore Darren C Trustee · Torrance, CABuilt 1989 · S/N 1809014N4151MWillard John E · Rockwood, MEBuilt 1947 · S/N 12-3050N4151TState Of Alaska · Anchorage, AKBuilt 1989 · S/N 1809016N4151ZFischer Mackenzie A · Willow, AKBuilt 1965 · S/N 18-8327N41529United States Department Of Agriculture · Cedar City, UTBuilt 1989 · S/N 1809036
Back to AD 99-01-05 R1