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.

N3751AAlpine Aviation LLC · Oasis, IDBuilt 1953 · S/N 22-1994N3751PVilven Jon A · Sweet Springs, MOBuilt 1955 · S/N 22-3471N3752MYassick James M · Eagle River, AKBuilt 1947 · S/N 12-2688N3752ZFowler Brad E · Hood River, ORS/N 18-7512N3753PKarcic Tony M · Prescott, AZBuilt 1955 · S/N 22-3474N3756ACaswell Insurance Services Inc · Yanceyville, NCBuilt 1954 · S/N 22-1998N3756MHardy Russell E · North Pole, AKBuilt 1947 · S/N 12-2691N3756PCreech William A · Selma, ALBuilt 1955 · S/N 22-3477N3757CAnderson Robert S · Fort Wayne, INS/N 5691N3757PCollura Joseph T · Glenwood, NJBuilt 1955 · S/N 22-3478N3758MSwede Aviation LLC · Tucson, AZS/N 12-2552N3759PHoffa John C · South Bend, INS/N 22-3481N375UMAlaskan Outhouse Adventures LLC · Big Lake, AKBuilt 1957 · S/N 18-5447N3760PAltitude Unlimited Inc · Lewes, DES/N 22-3483N3761MHoover Rodney Allen · Wasilla, AKS/N 12-2693N3761ZLazenby Gary M · Grangeville, IDBuilt 1960 · S/N 18-7523N3762MRobinson Fredrick J · Morris, ILBuilt 1947 · S/N 12-2694N3762PMorrison Rodney R · Hot Springs, ARBuilt 1955 · S/N 22-3485N3762ULeipzig Andrew E · Ethridge, TNBuilt 1941 · S/N 5-678N3762ZChapman Stuart M · Vernon, COBuilt 1960 · S/N 18-7525N37641Messerer Jonathan D · Duluth, MNBuilt 1955 · S/N 5-178N3764MDapp Eric M · Corvallis, ORBuilt 1947 · S/N 12-2696N3764PValdes Omar F · Huntington Park, CABuilt 1955 · S/N 22-3488N3764ZDelph Timothy M · Wasilla, AKBuilt 1960 · S/N 18-7527N3765ZKrumm Arno Hermann · Anchorage, AKBuilt 1960 · S/N 18-7528N37666Flying L Aircraft Inc · Fort Denaud, FLFirst renewal noticeS/N 6433N3767MGreat Cloud Design Inc · Dunedin, FLS/N 12-2699N3767PStrutzenberg Keith W Trustee · Chandler, AZBuilt 1955 · S/N 18-4645N3768AShannon Randal S · Drexel, MOBuilt 1954 · S/N 22-2010N376JMMaleitzke John W · Peoria, AZBuilt 1958 · S/N 22-6279N3770AOdom Nicholas S · Lubbock, TXS/N 22-2012N3771PQuicksilver Air Inc · Fairbanks, AKBuilt 1955 · S/N 18-4655N3772ASale Reported · Cedar City, UTSale reportedBuilt 1954 · S/N 22-2014N3772ZHueners Clayton C · Anchorage, AKBuilt 1960 · S/N 18-7451N3773PCan Am Capital · Lafayette, LABuilt 1955 · S/N 18-4659N3774AMasephol James A · Phillips, WIBuilt 1954 · S/N 22-2016N3774ZOwen Matthew L · Kasilof, AKS/N 18-7454N3775PClayton Patrick D · Hazen, ARBuilt 1955 · S/N 18-4663N3776ZWelch Harold Dee · Phillips, WIBuilt 1960 · S/N 18-7457N3777PSkatvold Charles P · Moorhead, MNBuilt 1959 · S/N 18-4665N3777ZAnderson Clarence Trustee · Anchorage, AKS/N 18-7459N3778ZWard Nelson H · Salcha, AKBuilt 1960 · S/N 18-7460N3779AForte Angelo L · Franklinville, NJBuilt 1953 · S/N 22-2021N3779ZNace Kris A · Glendale, ORBuilt 1960 · S/N 18-7461N377CZKramer Dean E · Bernville, PABuilt 1960 · S/N 18-7448N3780MRegistration Pending · Cody, WYRegistration pendingBuilt 1947 · S/N 12-2710N3780ZBenoit Robert W · Hot Springs, ARS/N 18-7462N3781PHoogendorn Homer E · Wasilla, AKFirst renewal noticeBuilt 1955 · S/N 18-4671N3781YPhillips Holly N · Reed Point, MTBuilt 1960 · S/N 18-7463N3782MMills Air Service Inc · Marstons Mills, MAS/N 12-2712
Back to AD 99-01-05 R1