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.

N78781Saddler Michael D · Lebanon, TNBuilt 1947 · S/N 11-1559N78787Largent Walter S · Fairbanks, AKS/N 12-3948N7878MWings Aircraft LLC · New Richmond, WIS/N 12-3144N7878QGoebel William R · Rhome, TXS/N 187409107N78798Hughes David C · Bakersfield, CABuilt 1947 · S/N 11-1572N7879HLorence Joshua J · Soldotna, AKBuilt 1946 · S/N 12-782N787MPWherrell Chad · Okeechobee, FLBuilt 1979 · S/N 18-7909141N787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeBuilt 1966 · S/N 18-8425N787SGContainer Stop Inc · Paso Robles, CABuilt 1953 · S/N 18-2916N78802Ellis David W · Porter, TXBuilt 1947 · S/N 11-1577N7880KMattingley Kenneth R · Willow, AKBuilt 1953 · S/N 22-937N78814Kiernana David J · Copake, NYBuilt 1947 · S/N 11-1587N78815Redline Properties LLC · Sioux City, IABuilt 1947 · S/N 11-1589N78816Brandt Kendall S · Towner, NDBuilt 1948 · S/N 11-1590N78819Houdek Dennis E · Roseburg, ORBuilt 1947 · S/N 111593N7881DParlu Ventures LLC · Greenwich, CTBuilt 1957 · S/N 18-6041N78822White Drew C · Granbury, TXBuilt 1947 · S/N 11-1596N78823Allen John L · Big Sandy, TNBuilt 1947 · S/N 11-1597N78824Weinberger Joseph A Jr · Anchorage, AKBuilt 1947 · S/N 11-1598N78825Houdek Dennis E · Roseburg, ORBuilt 1947 · S/N 111599N78827Latshaw Elizabeth H · Catawba, NCBuilt 1947 · S/N 11-1601N78828Dotter Henry C · North Pole, AKS/N 11-1602N78829Johnson Gerald R · Canyon, MNBuilt 1948 · S/N 11-1603N78831Johnson Terry M · Wolfforth, TXBuilt 1947 · S/N 11-1605N78835Wells Kris G · Barron, WIS/N 11-1618N78837Johnson Zachary M · Anchorage, AKBuilt 1947 · S/N 11-1620N7883DMeierotto Marty · Two Rivers, AKBuilt 1957 · S/N 18-6043N78844Bdl Cub Club LLC · Denton, TXBuilt 1948 · S/N 11-1651N78845Galloway Douglas A · Sandusky, OHBuilt 1948 · S/N 11-1652N7884DMartin John D · Billings, MTBuilt 1954 · S/N 18-6044N7885DLindstrom Daniel G · Somerset, WIBuilt 1957 · S/N 18-6045N7885HFisher Joel F IV · Rockville, MDS/N 12-788N788TDBurdick Kelly E · Wasilla, AKBuilt 1972 · S/N 18-9001N7890HTwo Feathers Industries LLC · Baker City, ORFirst renewal noticeBuilt 1946 · S/N 12-794N7891AAce Aeromotive Inc · Miami, FLS/N 11-1466N7893DMoes John E · Manchester, IABuilt 1957 · S/N 22-5516N7894PBayorek Barry E · West Wendover, NVBuilt 1962 · S/N 18-7876N7895HRoman Brooke · Talkeetna, AKBuilt 1946 · S/N 12-799N7896DJohnson Rickie G · Callahan, FLBuilt 1957 · S/N 22-5522N7896HKiser Gerald S · Christiana, TNBuilt 1946 · S/N 12-798N7898HOdean Steve6663 · Palmer, AKS/N 12-802N7899DBlake Richard E Jr · Marion, LABuilt 1958 · S/N 22-5819N789BNelson Brett R · Shoreview, MNBuilt 1977 · S/N 18-7709171N789FGSolf William · Winnett, MTBuilt 1970 · S/N 18-8883N78AJHamlin Curits · North Pole, AKBuilt 1978 · S/N 18-7809111N78CWPotter Justin D · Eagle River, AKS/N 12-1907N78NRKozak Daniel Patrick · Eagle River, AKS/N 18-3513N78QPHilyer Bruce W Trustee · Seattle, WABuilt 1966 · S/N 18-8469N78RFFairchild Maxwell D · Morristown, TNBuilt 1958 · S/N 22-6243N7900HMartin Robert C · Farmington, MEBuilt 1946 · S/N 12-804
Back to AD 99-01-05 R1