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.

N4561MHumbler LLC · Northampton, PABuilt 1947 · S/N 11-64N4562HWeber Keith T · Rubicon, WIBuilt 1948 · S/N 15-338N4562YEd Air Inc · Oaktown, INBuilt 1967 · S/N 25-4186N4563ZKnutson Wayne R · Thompson, NDS/N 22-8070N4564ZJones Brad · Oak Hill, FLBuilt 1961 · S/N 22-8071N4565AGriswold Joshua M · Wasilla, AKBuilt 1956 · S/N 22-3876N4565MWilliams Ross Richard · Philip, SDS/N 11-68N4566ZPackett Roger L · Yachats, ORBuilt 1961 · S/N 22-8074N4567ADonovan Timothy P · Wichita Falls, TXBuilt 1956 · S/N 22-3878N4567HFox Leo B · Lancaster, MOBuilt 1948 · S/N 15-337N4568ABartlett Michael W · Barron, WIBuilt 1956 · S/N 22-3879N4568MSolan Richard J · Canaan, CTBuilt 1947 · S/N 11-71N4569MEllis Wendell Kirk · Gakona, AKBuilt 1947 · S/N 1172N4569YDebilt Bruce A · Berthold, NDBuilt 1967 · S/N 25-4232N4571HCosta Felipe R · Winston Salem, NCBuilt 1948 · S/N 15-345N4571YDavis James J · Beaver Dam, WIBuilt 1967 · S/N 25-4235N4573MStauffacher Rick J · Harrisburg, SDBuilt 1947 · S/N 1176N4573ZMatty Elizabeth · Tucson, AZS/N 22-8082N4574HOak Bluff Farm LLC · Dalton, GABuilt 1949 · S/N 15-349N4576ZBauman Solomon A · Lyle, WAS/N 22-8085N4577AThompson Dennis E Jr · Anchorage, AKBuilt 1956 · S/N 18-4883N4577HAllen Mark C · Redding, CABuilt 1948 · S/N 15-351N4577MSlayden Steven M · Rhome, TXS/N 11-80N4578MKennedy Ken · Lubbock, TXBuilt 1947 · S/N 11-81N4579AReid Melissa K H · Anchorage, AKBuilt 1956 · S/N 18-4885N4579HDavis Rick L · Everett, WAS/N 15-353N4579MRopp Douglas L · Albany, ORBuilt 1947 · S/N 11-82N4581HHenderson Drake S · Willits, CABuilt 1948 · S/N 15-355N4582AHart Duane L Trustee · Wasilla, AKS/N 18-4888N4582HAnderson Irvin A · Chandler, AZBuilt 1948 · S/N 17-7N4582ZWriedt Dirk · South Beloit, ILBuilt 1961 · S/N 22-8091N4584HScootair LLC · Alburgh, VTBuilt 1948 · S/N 17-9N4584ZCompton Michael · Crabtree, ORBuilt 1961 · S/N 22-8093N4586ALewton John · Belgrade, MTBuilt 1956 · S/N 18-4895N4586HWinston Eric D · Canby, ORS/N 17-2N4586YRiggin Flight Service Inc · Madison, SDBuilt 1967 · S/N 25-4264N4587AChasing Alaska Corp · Anchorage, AKBuilt 1957 · S/N 18-4896N4587HJohnson Steven Donald · Pardeeville, WIBuilt 1948 · S/N 17-3N4588MKukuchka S Abby · Tunkhannock, PABuilt 1947 · S/N 1191N4588ZEta Of Missouri Inc · Lone Jack, MOBuilt 1961 · S/N 22-8097N4589MMorris Jerry W · Deer Trail, COBuilt 1947 · S/N 11-92N4590AEllis Darry Lynn · Wasilla, AKBuilt 1956 · S/N 18-4899N4590HSchwartz Kenneth G · Lincoln, CABuilt 1948 · S/N 17-4N4590ZSpeck Daniel N · Waverly, NYBuilt 1961 · S/N 22-8099N4591ACollins William A · Tillar, ARBuilt 1962 · S/N 18-4901N4591MPlayer Virginia P · Valdosta, GAS/N 11-94N4591ZColt Flying Club LLC · Lebanon, PAS/N 22-8100N4592HSessoms Aero LLC · Vero Beach, FLS/N 17-6N4593ABvm LLC · Stonington, CTBuilt 1956 · S/N 18-4903N4593HFriebel Mark A · Shelby, OHBuilt 1948 · S/N 15-357
Back to AD 99-01-05 R1