AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N943TADe Peyster Francis V · Canby, ORBuilt 1970 · S/N 11-01N943TEZbikowski Scott · Lino Lakes, MNBuilt 2003 · S/N 10222N943THSpirit Aviation Management Services Inc · Thomson, GABuilt 2024 · S/N 172S13143N943TTCkz Ventures LLC · Anchorage, AKBuilt 2005 · S/N 10748N94400Macinnis James Michael · Copley, OHBuilt 1982 · S/N 15285663N94401Maui Aviators LLC · Pukalani, HIBuilt 1982 · S/N 15285664N94405Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608345N9440FPatton Phillip F · Gold Hill, NCBuilt 1965 · S/N 55-0195N9440JDeascentis Dean · Lincoln, CAS/N 28-3552N9440LLuedemann Douglas S · Brenham, TXBuilt 1971 · S/N AA1A-0240N9440NEshowe Aviation Inc · East Peoria, ILBuilt 1969 · S/N 28R-35154N9440VVanhorn Jonathan F · Laguna Hills, CABuilt 1970 · S/N 700030N9440WLicausi Dan · Cathedral City, CABuilt 1968 · S/N 28-11155N9441VKarge Robert F · Peachtree City, GAS/N 700034N9441WBaker Carl · Angleton, TXBuilt 1968 · S/N 28-11157N9441ZTjb Capital LLC · Nashville, TNBuilt 1998 · S/N 18280214N9442Winger Aviation LLC · Palatine, ILBuilt 1973 · S/N 177RG0324N94429Wisconsin Aviation Inc · Watertown, WIBuilt 1982 · S/N 15285669N9442FRhodes Terry G · Snohomish, WABuilt 1966 · S/N 115-0213N9442NClear2aviate LLC · Ionia, MIBuilt 1969 · S/N 28R-35156N9442P42papa LLC · Soldotna, AKBuilt 1974 · S/N 18-7409129N9442RPauly Jeff D · Watkins, MNBuilt 1978 · S/N R18200706N9442VFlight Operations Academy LLC · Prescott, AZS/N 700049N94435Gibler Robert R · Peachtree City, GABuilt 1972 · S/N 287225072N9443HAllport Bruce E · North Hollywood, CABuilt 1975 · S/N 17266156N9443NSchulz John B Jr · Marquette, MIBuilt 1969 · S/N 28R-35157N9443WC H Draw Co Inc · Park City, KSBuilt 1968 · S/N 28-11161N94447Flightime LLC · Stuyvesant, NYBuilt 1982 · S/N 15285673N9444DHurlbert Michael · Wasilla, AKBuilt 1958 · S/N 18-6687N9444HPrestige Worldwide Aerospace LLC · Panama City, FLBuilt 1975 · S/N 17266157N9444LDiller Aaron J · La Salle, COBuilt 1971 · S/N AA1A-0244N9444WMacedo Carlos C · Dayton, OHBuilt 1969 · S/N 28-11163N9445DTriple Fes LLC · San Antonio, TXBuilt 1984 · S/N 172RG1165N9445HBrown Max K · Cushing, OKBuilt 1975 · S/N 17266158N9445JRamey Austin B · Salida, CABuilt 1966 · S/N 28-3557N9445KAishvaryam LLC DBA · Lancaster, TXBuilt 1976 · S/N 28-7615203N9445WEnglund Gary · Goldendale, WABuilt 1969 · S/N 28-11164N94461Daytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 2012 · S/N 172S11205N9446JFitch Stephen C · Moreno Valley, CABuilt 1966 · S/N 28-3558N9446LDiegoli John E · Ashland, ALBuilt 1971 · S/N AA1A-0246N9447HLang Julia A · Greensburg, PABuilt 1975 · S/N 17266159N9447LAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1986 · S/N 17276559N9447NEvans Jeff W · Hannibal, MOBuilt 1969 · S/N 28R-35162N9447WZiemann Mark · Camp Verde, AZBuilt 1969 · S/N 28-11166N9448AOlson Ben A · Gig Harbor, WABuilt 1949 · S/N 15269N9448DLinear Farming Inc · Pleasant Grove, CABuilt 1958 · S/N 18-6691N9448JRichmond Heights LLC · Pocahontas, ARBuilt 1966 · S/N 28-3560N9448LCole Douglas W · Kennewick, WABuilt 1971 · S/N AA1A-0248N9448NMason Harold R · Quincy, WABuilt 1969 · S/N 28R-35163N9448PMgh Inc · Aurora, NEBuilt 1974 · S/N 18-7409130
Back to AD 81-18-04 R2