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.

N4784YBig Sky Jet Inc · Bozeman, MTBuilt 1968 · S/N 25-4553N4785FSoaring Society Of Boulder Inc · Boulder, COBuilt 1962 · S/N 18-7906N4785YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1968 · S/N 25-4556N4785ZMeigs David C · Phoenix, AZS/N 22-8349N4787AStock Matthew D · Clarence, NYBuilt 1956 · S/N 22-3938N4787MBrauer Mike · Ozark, ALBuilt 1947 · S/N 11-302N4787ZIdaho Airplanes LLC · Boise, IDS/N 22-8351N4789MCrawford Alan R · Buchanan Dam, TXBuilt 1947 · S/N 11-303N478ECSale Reported · Ketchikan, AKSale reported, pending cancellationBuilt 1968 · S/N 18-8666N4790ADaugherty Tighe L · Juneau, AKBuilt 1956 · S/N 22-3941N4790MChancellor Julian Wood Jr · Brooksville, MSBuilt 1948 · S/N 11-439N4791MPatrick Hallett · Anchorage, AKBuilt 1947 · S/N 11-305N4792YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4568N4794HHeyano Robert G · Dillingham, AKBuilt 1946 · S/N 11-761N4794YAir Kraft Spraying Inc · Timber Lake, SDBuilt 1968 · S/N 25-4572N4795HGallion David B · Michigan City, INBuilt 1948 · S/N 11-766N4795MMountain Air Inc · Quincy, CAFirst renewal noticeBuilt 1997 · S/N 11308N4795YPiper 4795y Aviation Services LLC · Colorado Springs, COBuilt 1968 · S/N 25-4573N4796AThompson Muriel K · Eagle Pass, TXBuilt 1956 · S/N 22-3947N4796H170 Bowen Brothers LLC · Post Falls, IDBuilt 1946 · S/N 11-765N4798HWells Kris G · Barron, WIBuilt 1948 · S/N 11-768N4798ZAnderson David J · Fridley, MNBuilt 1961 · S/N 22-8365N4799ZRegistration Pending · Carefree, AZRegistration pendingBuilt 1961 · S/N 22-8366N47CBBias Alexandru S · Soldotna, AKS/N 12-2781N47CGStout Bryan A · Telford, PAS/N 18-3587N47FSDahl Duane A · Glasgow, MTS/N 11-102N47JRegistration Pending · Erwinna, PARegistration pendingBuilt 1939 · S/N 4-765N47MLWitt Jerry D III · Houston, TXBuilt 1956 · S/N 22-3865N47TSStewart Terry · Anchorage, AKBuilt 1977 · S/N 18-7709120N47YDunham Roger S · Athol, IDBuilt 1948 · S/N 17-149N4800PFun Country Soaring · Avon Lake, OHBuilt 1968 · S/N 25-4580N4800ZGorzynski Dustin B · Great Falls, MTBuilt 1961 · S/N 22-8367N4801HMcchesney Corey · New Berlin, WIBuilt 1948 · S/N 17-99N4801ZButler Delbert C · Caldwell, IDS/N 22-8368N4802HDawson Steven L · East Troy, WIBuilt 1948 · S/N 17-100N4802MAirport Farms Aviation LLC · Tarkio, MOBuilt 1947 · S/N 11-315N4802ZHoffman James R · Bethel, AKBuilt 1962 · S/N 18-7800N4803ZBuffalo Flyers LLC · Buffalo, MOBuilt 1961 · S/N 22-8370N4804AMakely Abraham M · Culpeper, VABuilt 1956 · S/N 22-3956N4805ZWittman Kristofer L · Anchorage, AKS/N 22-8372N4806AButler David B · Ipswich, MABuilt 1956 · S/N 22-3958N4807YMayes Noelle C · Williams, CAS/N 25-4555N4808HJohnson Steven D · Pardeeville, WIBuilt 1948 · S/N 17-104N4809HBarts Flying Service Inc · Storm Lake, IAS/N 17-103N4810ADecker Richard A · Onalaska, WABuilt 1956 · S/N 22-3962N4810HKasuske Gerald A · Watertown, SDS/N 17-108N4810ZMussell Logan Michael · Leslie, MIBuilt 1961 · S/N 22-8379N4811AJacobs Eric R · Bozeman, MTBuilt 1956 · S/N 22-3963N4811HScheerer Paul R Jr · East Hampton, NYBuilt 1948 · S/N 17-109N4811MSchumacher Marvin L · Pierre, SDBuilt 1947 · S/N 11-322
Back to AD 99-01-05 R1