OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

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.

N1009AWilliams Wendell · Anchorage, AKBuilt 1950 · S/N 18581N100SXKing Samuel E · Battle Mountain, NVBuilt 1951 · S/N 18-709N1011AMachamer John K · Gettysburg, PABuilt 1950 · S/N 18-582N1012ASimmons Michael T · Carolina Beach, NCBuilt 1950 · S/N 18-588N1017AEllis Wendell K · Gakona, AKBuilt 1950 · S/N 18-587N1017SKrl LLC · Longview, TXS/N 18-7038N101EBKinneen Simon N · Nome, AKS/N 18-7809028N101KCH O Aircraft Inc · Maple Grove, MNS/N 18-649N101KRVlach Ronald G · Fremont, NEBuilt 1946 · S/N 12-53N101SCAnderson Benjamin T · Havre De Grace, MDBuilt 1964 · S/N 18-6200N101ZYBartel Gordon L · Willow, AKS/N 12 1935N1022BKustatan Leasing LLC · Nikiski, AKBuilt 1955 · S/N 18-4646N1023AWhite Leland T · Deer Park, WABuilt 1951 · S/N 18-595N1023KBushak Aviation LLC · Frederick, MDBuilt 1954 · S/N 18-3942N1023NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 18-1889N1029ALange Cole Kenneth · Oglala, SDBuilt 1954 · S/N 18-600N102LWWulff Allan · Reston, VABuilt 1955 · S/N 18-4383N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216N102TCMason Brian L · Eagle River, AKS/N 18-7909038N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806N102WRSt Onge Adam R · Sterling, AKBuilt 1952 · S/N 20-919N1034AHawk Don · Shady Cove, ORS/N 18-606N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N103VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5817N103WEEngel Douglas A · Plainfield, ILS/N 2537N10404Powers Phillp K · Tallulah, LAS/N 18-3561N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619N1042APetrie Michael · Chugiak, AKBuilt 1951 · S/N 18-616N1043KShadowens Jackie R · Sapulpa, OKBuilt 1954 · S/N 18-3919N1044TSnyder Otho J · Underwood, NDS/N 5-628N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622N1047VPoulter Thomas R · Chelsea, MIBuilt 1954 · S/N 18-3911N1048AUnderdahl Kirby L · Hamilton, MTBuilt 1951 · S/N 18-626N1049CGerbi Charles R Trustee · Auke Bay, AKS/N 11-1027N1049PLamal Thomas K · Fairbanks, AKBuilt 1957 · S/N 18-7816N104CCN104cc LLC · Fredericksburg, TXBuilt 2002 · S/N 9947CCN104JDJnk Equipment LLC · Deer Harbor, WABuilt 1979 · S/N 18-7909077N104TCarey Daniel F · Rockville Centre, NYS/N 18-2218N1050AMcmahan Charles B · Gakona, AKBuilt 1951 · S/N 18-628N1051ARegistered aircraftBuilt 1951 · S/N 18-641N10572Jefferson Jake O · Wasilla, AKS/N 18-933N1059AButler Billy D · Hilger, MTBuilt 1951 · S/N 18-630N105CCWyoming Wool Growers Association · Casper, WYBuilt 2002 · S/N 9948CCN105FVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1940 · S/N 5-477N105JCHeckathorn Chad W Trustee · Elk Point, SDBuilt 1950 · S/N 18-308N105JHBaxter Brandon C · Wasilla, AKBuilt 1947 · S/N 12-3240N105JRRobinson Matthew W · Duncan, OKBuilt 1981 · S/N 18-8109070N105TPeterson Nathan C · Cordova, TNBuilt 1952 · S/N 18-2219N1065ANordhaus Robert · Lake Geneva, WIBuilt 1951 · S/N 18-648N1066AYounggren James H · Hallock, MNBuilt 1951 · S/N 18-646
Back to AD 99-01-05 R1