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.

N3877ZAlsworth John H · Anchorage, AKBuilt 1961 · S/N 18-7668N38787Onawa Flying Service · Sioux City, IABuilt 1941 · S/N 7264N3878ZWorrell Trevor S · Anchorage, AKBuilt 1961 · S/N 18-7672N38797Hopkins Elizabeth Reeves · Sunnyvale, TXBuilt 1941 · S/N 7274N3879PZimmer Chris P · Upham, NDBuilt 1955 · S/N 18-4705N3879ZNelson Chad A · Buffalo, SDBuilt 1961 · S/N 18-7677N38812Van Metre Air LLC · Fairfax, VAS/N 7298N3881MBaratto John Maynard · Cohasset, MNS/N 12-2779N38822Yandik Stephen E · Hudson, NYBuilt 1941 · S/N 7308N3882MBrabson Andrew R · Eagle River, AKBuilt 1947 · S/N 12-2778N3882ZHarwood Thomas K · Fairbanks, AKBuilt 1961 · S/N 18-7696N38830Jessen Dennis H · Pequot Lakes, MNBuilt 1941 · S/N 7317N38833Morris Ray O · Ringgold, VAS/N 7320N38834Shackelford John S Jr · Roanoke, TXBuilt 1941 · S/N 7321N3883PMontana Air Service Corp · Big Timber, MTS/N 18-4713N3883ZBrossia Jerry L · Eagle River, AKBuilt 1961 · S/N 18-7697N3884PKeffalos Chris S · Anchorage, AKBuilt 1955 · S/N 18-4717N3884ZChestler Craig M · Soldotna, AKBuilt 1961 · S/N 18-7699N38857Cheney Arthur M · Live Oak, CABuilt 1941 · S/N 7345N3885MGough William N · Vancouver, WABuilt 1947 · S/N 12-2582N3885ZGlidewell Arthur C · Mc Neal, AZBuilt 1961 · S/N 18-7700N38872Fletcher Flying Service 419 LLC · Labelle, FLBuilt 1941 · S/N 5-1094N38874Bolan Steven A · Phoenix, AZBuilt 1941 · S/N 51097N38880Shrader Sarah L · Rhinelander, WIBuilt 1941 · S/N 4-1595N38888Kirkendall Clinton I · Arlington, WABuilt 1941 · S/N 5-1088N38889Rich Aircraft Services LLC · Brush Prairie, WAS/N 5-1086N3888MBennett Rhonda R · Callaway, NEBuilt 1947 · S/N 12-2792N3889MSeitenreich William F Jr · Wasilla, AKBuilt 1947 · S/N 12-2581N3889PSipes Austin L · North Pole, AKBuilt 1956 · S/N 18-4722N388CCDr Holding LLC · Saint Marys, PABuilt 2002 · S/N 9942CCN3890MMiller Daniel O · Sugarcreek, OHBuilt 1947 · S/N 12-2580N3890ZIngman Joshua P · Dickinson, NDBuilt 1961 · S/N 18-7706N3891MHall David B · Newburg, NDBuilt 1947 · S/N 12-2793N3891ZLaudon Sydney L · Anchorage, AKS/N 18-7707N3892ZWinston Christopher C · Vancouver, WABuilt 1961 · S/N 18-7708N3894MMiller Mark R · Hagerman, IDBuilt 1947 · S/N 12-2794N3896MBehm Jerome William · Burlington, NDBuilt 1947 · S/N 12-2796N3896ZDriggs Daniel H · Anchorage, AKBuilt 1961 · S/N 18-7674N3897PAirplane Inc · White Bear Lake, MNBuilt 1955 · S/N 18-4730N3897ZWard Joseph Delon · Wasilla, AKS/N 18-7788N3898MCosta Air Service LLC · Painted Post, NYS/N 12-2798N3898ZTtyf LLC · Hood River, ORBuilt 1960 · S/N 18-7343N3899PJaffa Bruce E · Moose Pass, AKBuilt 1956 · S/N 18-4732N389CCAerial Timber Applicators Inc · Cooperstown, NDBuilt 2002 · S/N 9943CCN38BSJack Browns Seaplane Base Inc · Winter Haven, FLS/N 18-8505N3900MStewart Stewart D · South Egremont, MABuilt 1947 · S/N 12-2799N3900ZTverdy Kenneth W · Buhl, IDBuilt 1961 · S/N 18-7685N3901MDevine Christopher C · Eagle River, AKBuilt 1947 · S/N 12-2800N3902MVigdal Carl B · Keller, TXBuilt 1947 · S/N 12-2801N3903MNaugle Anthony · Schellsburg, PABuilt 1947 · S/N 12-2802
Back to AD 99-01-05 R1