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.

N2504MAerial Messages Leasing Co · Longwood, FLBuilt 1946 · S/N 12-1002N25052Hayhurst Shane R · Winfield, PAFirst renewal noticeBuilt 1939 · S/N 3624N2505ASims Kenneth Leon · Desert Hot Springs, CABuilt 1952 · S/N 22-816N2505MSever Jeffrey D · Anchorage, AKBuilt 1946 · S/N 12-1003N2507MEller Ralph E · Wasilla, AKBuilt 1946 · S/N 12-1005N2509PAubort Eric Y · Laguna Hills, CABuilt 1955 · S/N 22-2870N250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1971 · S/N 25-5425N250TWhite William Brian · Apex, NCBuilt 1953 · S/N 18-2364N2510AIlgenfritz Don C Jr · Fairbanks, AKBuilt 1952 · S/N 18-1974N2510HErickson Paul C · Alexandria, MNBuilt 1979 · S/N 18-7909197N2511ABrierley Michael G Trustee · Sparks, NVBuilt 1952 · S/N 18-1971N2511MAustin Air Cruisers LLC · Dripping Springs, TXS/N 12-1009N2512AFell William P · Anchorage, AKS/N 18-1970N2512DNelson Rodney L · Quimby, IABuilt 1979 · S/N 18-8009008N2512PMiller Christopher M · Centreville, VAS/N 22-2874N2513MFinley Joel H · Sandwich, MAS/N 12-911N2513PLeon Bernardo Eucario Moreno · Missouri City, TXBuilt 1955 · S/N 22-2875N2514ABeard Michael Wayne · Eveleth, MNBuilt 1953 · S/N 18-2140N2515AClaus Jay G · Palmer, AKBuilt 1952 · S/N 18-1972N2515PMalone Rex A · Rowlett, TXBuilt 1955 · S/N 22-2877N2516AAscension Aviation LLC · Gaylord, MIBuilt 1953 · S/N 18-2141N2516PNidle Jeffery C · Leasburg, NCBuilt 1955 · S/N 22-2878N2518ARegistration Pending · Wasilla, AKRegistration pendingBuilt 1953 · S/N 18-2148N2518PRife Ramon K Jr · Casper, WYBuilt 1954 · S/N 22-2383N2519PDayton Dean W · Marysville, OHBuilt 1955 · S/N 22-2881N251TGelvin Stanley M · Central, AKBuilt 1946 · S/N 12-254N2521SSieberts Soren K · Anchorage, AKBuilt 1979 · S/N 18-7909152N2522APierce Stephan L · Graham, TXBuilt 1953 · S/N 22-830N2522ERankin Kevin · Maryville, MOS/N 11-843N2523AChadwick Harold T · Ottsville, PABuilt 1952 · S/N 22-829N2523PHarris Jason C A · Unalakleet, AKS/N 22-2885N2524MDd Leasing LLC · Aberdeen, IDBuilt 1946 · S/N 12-910N2526ABamak Corp · Eagle River, AKBuilt 1956 · S/N 22-833N2526MTulin Donald J · Anchorage, AKS/N 12-1017N2527PSprenger Michael D · Juneau, AKBuilt 1955 · S/N 22-2890N2528AEhrhart Philip J · Narvon, PABuilt 1952 · S/N 22-836N2528MJohnson Robert M · Mapleton, MES/N 12-1019N2528SScola Kevin M · Marshfield, MABuilt 1979 · S/N 18-7909153N252TJanssen Jerry D · Barnesville, MNBuilt 1953 · S/N 18-2366N2531MCurtis Kevin R · Flushing, MIBuilt 1946 · S/N 12-1022N2532PRiley Mitchell C · Seattle, WABuilt 1955 · S/N 22-2895N2533MJohnson Cory R · Owatonna, MNBuilt 1946 · S/N 12-925N2534AWilcoxon James · Scobey, MTBuilt 1952 · S/N 18-2152N2534MBooher John R · Eagle River, AKBuilt 1946 · S/N 12-926N2534PPearson Vincent N · Broken Bow, NES/N 22-2897N2536EEarle James K · Argonia, KSBuilt 1959 · S/N 22-6816N2537BCabanski Dirk D · Green Bay, WIS/N 18-8109008N2540ASlaton James E · Minot Afb, NDS/N 22-837N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903N2541SLanning Danny E · Alzada, MTBuilt 1979 · S/N 18-7909156
Back to AD 99-01-05 R1