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.

N5335ZGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 22-9045N5337HOder Kenneth L · Taylorsville, KYBuilt 1949 · S/N 16-143N5337ZBrown Estates Aviation LLC · Fresno, CABuilt 1961 · S/N 22-9047N5340HHarmon Michael N · Ankeny, IABuilt 1949 · S/N 16-144N5343HDawson Guy · Lake Clear, NYBuilt 1949 · S/N 16-149N5343ZGolden Age Aeroworks LLC · Lone Rock, WIBuilt 1962 · S/N 22-9059N5348TDavis Samuel T · Malad City, IDS/N 18-8009009N5348ZDavis Robert D · Shongaloo, LABuilt 1961 · S/N 22-9068N5350ZAgalotis Paul E · San Martin, CABuilt 1961 · S/N 22-9071N5351ZGostola Thomas · Fairmount, INBuilt 1961 · S/N 22-9072N5352ZMcdougall Michael D · Caldwell, IDBuilt 1961 · S/N 22-9075N5354ZManson Timothy C · New Gloucester, MEBuilt 1961 · S/N 22-9077N5355ZWatts Carrie L · Hazen, NVBuilt 1961 · S/N 22-9078N5356HMurphey Stephen B · Lynchburg, SCBuilt 1949 · S/N 16-162N5357XFirn Line Aviation Inc · Wasilla, AKS/N 18-7391N5358HDaniels Scott M · Litchfield, MEBuilt 1949 · S/N 16-165N5359ZSale Reported · Crozet, VASale reportedS/N 22-9085N535TCNichols Craig J · Andover, MNBuilt 1947 · S/N 12-3976N5360HEastern Stearman Inc Trustee · Leesburg, VABuilt 1949 · S/N 16-167N5361HNall Melvin J · Luthersville, GABuilt 1949 · S/N 16-168N5362XSky West Aviation Inc Trustee · Albuquerque, NMS/N 18-6685N5363HBauer Dereck R · Springfield, ORBuilt 1949 · S/N 16-172N5364ZHughes Tony W · Irmo, SCBuilt 1961 · S/N 22-9094N5365HVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1949 · S/N 16-171N5366HShannon Harry D · Bartow, FLBuilt 1949 · S/N 16-173N5367ZAdvance Aviation Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1961 · S/N 22-9099N5368ZTevik Michael A · Provo, UTBuilt 1961 · S/N 22-9100N5370HGodec David E · Waunakee, WIBuilt 1949 · S/N 16-177N5371HMacdonald Randall N · Weidman, MIBuilt 1949 · S/N 16-178N5373HMoore Jeffrey D · Blossvale, NYBuilt 1949 · S/N 16-184N5373YBush Dan S · Wasilla, AKS/N 18-8140N5374ZMyers Kenneth Jerome · Haines, ORBuilt 1961 · S/N 22-9140N5377HSchmid Gerhard G · New Smyrna Beach, FLBuilt 1949 · S/N 16-183N5377ZTurner Edward J III · Mokena, ILBuilt 1961 · S/N 22-9139N5378HFellman Peter A · North Chatham, MABuilt 1949 · S/N 16-185N5378YRagwing Flyers LLC · Richmond, TXBuilt 1964 · S/N 18-8141N5379YHandly William A · Arcola, MSBuilt 1964 · S/N 18-8142N5379ZMcelwee Glenda A · Lake City, FLS/N 22-9146N5380HBaughman Neil F · Harrisburg, PABuilt 1949 · S/N 16-187N5380ZHerrema James M · Fountain, MIBuilt 1961 · S/N 22-9147N5381ZRasmussen Mark · Hogeland, MTBuilt 1961 · S/N 22-9149N5382HZefting Brett M · Bellingham, WAS/N 16-189N5384HDeleon Joseph M · Saint Petersburg, FLBuilt 1949 · S/N 16-191N5385YKeogh Timothy R · Ely, NVBuilt 1964 · S/N 18-8143N5386HMcwhorter Ag LLC · Searcy, ARS/N 16-193N5386ZKetcham Blake L · Turtle Creek, PABuilt 1961 · S/N 229154N5387ZHester Nathan A · El Centro, CABuilt 1961 · S/N 22-9156N5388HRamsey Brian D · Van Nuys, CABuilt 1949 · S/N 16-195N5388ZHarcourt Tim J · Libby, MTBuilt 1961 · S/N 22-9157N5389HBlessum Jay A · Minot, NDBuilt 1949 · S/N 16-196
Back to AD 99-01-05 R1