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.

N9631LNonemaker Joseph R · Quakertown, PABuilt 1973 · S/N AA1B-0131N9631MOrvin Sanden Inc · Wyndmere, NDBuilt 1966 · S/N 670208N9631PKansas Air LLC · Linn, KSS/N 25-7656013N9631QHuntsman Ferral Don · Juneau, AKBuilt 1975 · S/N 17265715N9631RBw Flying Association · Seattle, WABuilt 1959 · S/N TD-314N9631SFreedom Aviation Of America LLC · Newcastle, TXBuilt 1966 · S/N 39N9631UCross Scott · Scott Township, PABuilt 1975 · S/N AA5-0831N9631VHarrold Bruce E · Greybull, WYBuilt 1974 · S/N 17264411N9632HSweitz-Air Inc · Stewartstown, PAS/N 17266279N9632JAirbrain Aviation Inc · Snellville, GABuilt 1966 · S/N 28-3789N9632MAvimar · Marina Del Rey, CABuilt 1966 · S/N 670209N9632UArmstrong Michael · Indianapolis, INBuilt 1977 · S/N AA1C0077N9633HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266280N9633LKessler Garry A · Lansing, WVBuilt 1973 · S/N AA1B-0133N9633MGould Zachary · Pleasant Hill, MOBuilt 1966 · S/N 670210N9633UMoseley Warren C · Haslet, TXBuilt 1977 · S/N AA1C0078N9633WFladager Enterprises Inc · Peerless, MTBuilt 1967 · S/N 28-23090N9634DBacklund Scott W · Greybull, WYBuilt 1959 · S/N 22-6546N9634K137 Lynwood LLC · Elmira Heights, NYS/N 28R-7635251N9634LBeach Donald R · Atlanta, GABuilt 1973 · S/N AA1B-0134N9634MBig Sky Flying Inc · Napa, CAS/N 670211N9634QDubois County Flight Services Inc · Huntingburg, INBuilt 1975 · S/N 17265718N9634WShinar Philip C · California City, CABuilt 1967 · S/N 28-23091N9635BFisher Frank L · San Diego, CABuilt 1981 · S/N 172RG0933N9635HArizona Aircraft Leasing LLC · Mesa, AZBuilt 1975 · S/N 17266282N9635KN9635k LLC · San Luis Obispo, CAS/N 28-7610105N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592N9635MN9635m LLC · Cumming, GABuilt 1966 · S/N 670212N9635QRozynski Jason K · Malabar, FLBuilt 1975 · S/N 17265719N9635SPake Bradley P · Felton, MNBuilt 1966 · S/N 374N9635UCarmichael Donald L · Carlisle, INBuilt 1975 · S/N AA5A-0001N9635V35 Victor LLC · Decatur, GABuilt 1974 · S/N 17264415N9635WGordon David · Long Branch, NJBuilt 1967 · S/N 28-23092N9636HMontanez Orlando · Guaynabo, PRBuilt 1975 · S/N 17266283N9636JPorter Julia N · Pflugerville, TXBuilt 1966 · S/N 28-3833N9636LWest Main Auto Sales Inc · Tupelo, MSBuilt 1974 · S/N AA5-0636N9636MBistline Leland K · Fredonia, AZBuilt 1966 · S/N 670213N9636RTrans West Specialties · Visalia, CAS/N TD-317N9636USchroeder Wolf Udo · Rochester, NYBuilt 1975 · S/N AA5A-0002N9636VNaperville Flying Club · Woodridge, ILBuilt 1974 · S/N 17264416N9637DSpivey Harold E · Thomaston, GABuilt 1959 · S/N 22-6549N9637QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265721N9638CJones Francis P Jr · Newport, ARBuilt 1978 · S/N 28-7816507N9638HHatbright Farm LLC · Wilmington, DEBuilt 1975 · S/N 17266285N9638JPrince Jennifer R · Farr West, UTBuilt 1967 · S/N 28-3867N9638MPinheiro Rodrigo P · Albuquerque, NMBuilt 1967 · S/N 670109N9638QPeterson John E · Benton, KSBuilt 1975 · S/N 17265722N9638VCrazy Aces LLC · St George, UTBuilt 1974 · S/N 17264418N9639CNichols Brian J · Mount Hope, WIBuilt 1978 · S/N 28-7816508N9639DVestal James L · Kernersville, NCBuilt 1959 · S/N 22-6552
Back to AD 81-18-04 R2