OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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:79-10-03-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:79-10-03-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.

N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927N9626CExecutive Flight Training & Services LLC · Sanford, NCBuilt 1978 · S/N 28-7816506N9626HRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 17266274N9626JCharles James Blake · Stinnett, TXBuilt 1966 · S/N 28-3782N9626QChambers Matthew A · Tehachapi, CABuilt 1975 · S/N 17265710N9627HSuperbuyer Inc · San Jose, CABuilt 1975 · S/N 17266275N9627JTucker Aviation LLC · Hollister, MOBuilt 1966 · S/N 28-3783N9627PDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1976 · S/N 18-7709001N9628HT3 Aerosports LLC · Vian, OKBuilt 1975 · S/N 17266276N9628JMarshall Air LLC · Albuquerque, NMS/N 28-3785N9628KTriple Chin LLC · Bloomington, MNBuilt 1976 · S/N 28-7690266N96299Djm Aviation LLC · Rhome, TXS/N 17276054N9629CFly Gateway Aviation Institute · New Castle, DEBuilt 1978 · S/N 28-7890430N9629DAnderson Antoinette · Granbury, TXBuilt 1958 · S/N 22-6541N9629JBrown Korey Fetty · Macungie, PABuilt 1966 · S/N 28-3786N9629KN9629k LLC · Provo, UTBuilt 1976 · S/N 28-7690267N9629RThomas Christopher A · Seaford, DEBuilt 1959 · S/N TD-307N9629WRobbins Clyde · Golden, MSBuilt 1967 · S/N 28-23086N962DCCarruth Don V · Fredericksburg, TXBuilt 2013 · S/N 70706N962RTTatarchuk Johnie Roy Jr · Orange, TXBuilt 1993 · S/N 92006N962SCRegistration Pending · Texas City, TXRegistration pendingBuilt 1960 · S/N TD-359N962TEPayne Mark Howard · Spring, TXBuilt 2004 · S/N 10241N9630QKelley Aircraft LLC · Weyers Cave, VABuilt 1975 · S/N 17265714N9630UWright Brent C · Boulder Creek, CAS/N AA5-0830N9630VN275508 LLC · Margate, FLBuilt 1974 · S/N 17264410N9630WNull Robert D · Lake Charles, LABuilt 1967 · S/N 28-23087N9631BPercy Flyers LLC · Dexter, MIBuilt 1981 · S/N 172RG0930N9631CThompson Joseph D · Alliance, NEBuilt 1978 · S/N 28-7890431N9631QHuntsman Ferral Don · Juneau, AKBuilt 1975 · S/N 17265715N9631RBw Flying Association · Seattle, WABuilt 1959 · S/N TD-314N9631UCross 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-3789N9633HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266280N9633UMoseley 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-6546N9634QDubois 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 17266282N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592N9635QRozynski Jason K · Malabar, FLBuilt 1975 · S/N 17265719N9635UCarmichael 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-0636
Back to AD 79-10-03 R2