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.

N3979ZHamilton Stephen L · Eagle River, AKBuilt 1963 · S/N 18-7916N397LJJohnson Jeffrey L · Fargo, NDBuilt 1975 · S/N 18-7609018N397PAStelzle Scott A · Templeton, CABuilt 1940 · S/N 5-397N3981ZSeeton Samuel · Casper, WYBuilt 1963 · S/N 18-7924N3982PBlack Industries LLC · Helena, MTBuilt 1956 · S/N 18-4742N3982ZDubious Adventures LLC · Big Lake, AKBuilt 1963 · S/N 18-7925N3983ZHanson Julie A · Anchorage, AKBuilt 1963 · S/N 18-7928N3984PSnively Russell C · Lodge Gross, MTBuilt 1955 · S/N 18-4744N3984ZRefugio Soaring Circle Inc · Refugio, TXBuilt 1963 · S/N 18-7930N3985MFurnas Jerry W · San Diego, CAS/N 12-2865N3985PPrettyman Walter P · Valdosta, GABuilt 1956 · S/N 18-4745N3985ZRatcliff Stephen B · Anchorage, AKBuilt 1963 · S/N 18-7931N3986PWester Lawrence Cale · Star, IDS/N 18-4746N3987PElliff Tyler · Windsor, CABuilt 1956 · S/N 18-4747N3988MFishback Steve M · Anchorage, AKBuilt 1947 · S/N 12-3004N398AKMach 2 LLC · Fairbanks, AKBuilt 1979 · S/N 18-7909071N398SCBornhoft Jerry · Riverton, WYBuilt 1975 · S/N 18-7509020N3991ZFairbanks Investor LLC · Fairbanks, AKBuilt 1963 · S/N 18-7936N3992MRodgers Justin C · Fairbanks, AKBuilt 1947 · S/N 12-2872N3992PAir Bear Aviation Inc · North Hampton, NHBuilt 1956 · S/N 18-4752N3992ZGrandy Boyd · Smoot, WYBuilt 1963 · S/N 18-7937N3994ZHastings Stephen J · Wasilla, AKBuilt 1963 · S/N 18-7943N3995PMoore Dana C · Chignik Lagoon, AKBuilt 1956 · S/N 18-4756N3995ZRay Richard L · Chugiak, AKBuilt 1963 · S/N 18-7944N3996PWhittock Tyson H · Anchorage, AKBuilt 1956 · S/N 18-4757N3996ZFlint Paul L · Anchorage, AKBuilt 1963 · S/N 18-7945N3997MHoward Charles M · Pittsburg, TXBuilt 1947 · S/N 12-2876N3997ZBrown Brandon T · Dallas, TXBuilt 1963 · S/N 18-7946N3999ZGaston James P · New York, NYS/N 18-7934N39FZLongley Charles A · Nome, AKBuilt 1962 · S/N 18-7745N39LDMau Thomas E · Kenmare, NDS/N 18-5757N3DTBighorn Flying Company LLC · Wood River, NEBuilt 1962 · S/N 18-7774N3HXWreyford James S · Marble Falls, TXBuilt 1947 · S/N 12-2555N3KEBlevins Myrl Dean · Wytheville, VABuilt 1962 · S/N 22-9244N3XXSchulze Jeffrey N · Ransomville, NYBuilt 1946 · S/N 12-811N3YRStone Charles Douglas · Cedarville, OHBuilt 1975 · S/N 18-7509113N4000HSmith Clyde R Jr · Lock Haven, PABuilt 1948 · S/N 16-1N4000ZAmstrup Jeremy T · Fairbanks, AKBuilt 1963 · S/N 18-7951N4001HLapiair LLC · Vergennes, VTBuilt 1940 · S/N 41108N4001ZPayne Ronald J II · Wasilla, AKBuilt 1963 · S/N 18-7952N4002ZTappen Farm Supply Inc · Tappen, NDBuilt 1963 · S/N 18-7953N4003MEly Gregory C · Calistoga, CAS/N 12-2880N4004ZTiffany David J · Lyme, CTBuilt 1963 · S/N 18-7955N4005ERmo Property Management LLC · Elkin, NCBuilt 1977 · S/N 18-7809016N4005ZMills Air Service Inc · Marstons Mills, MABuilt 1963 · S/N 18-7956N4006MRegistration Pending · Wasilla, AKRegistration pendingBuilt 1947 · S/N 12-2883N4006ZGuisto Anthony Jl · Hood River, ORBuilt 1963 · S/N 18-7957N4007ESimonson Gale J · Loring, MTBuilt 1977 · S/N 18-7809017N4007ZMcgeehan William F Jr Trustee · Marshfield, MOBuilt 1963 · S/N 18-7958N4008MMoody Ryan M · Anchorage, AKBuilt 1947 · S/N 12-2885
Back to AD 99-01-05 R1