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.

N9704DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6615N9705DHensley Roger A · Rosamond, CABuilt 1959 · S/N 22-6616N9707DPapke Brian D · Beulah, MIS/N 22-6619N9707PN B Tweet & Sons · Nome, AKBuilt 1975 · S/N 18-7509135N9709DPearce Ricky · Parsons, KSBuilt 1959 · S/N 22-6621N970AWilson Douglas W · Stockton, CABuilt 1951 · S/N 22-281N9711PTop A Farms Inc · Benkelman, NEBuilt 1975 · S/N 18-7509116N9713DBallard Gary B · Leslie, ARBuilt 1959 · S/N 22-6625N9713PMeggers Roger D · Baker, MTBuilt 1975 · S/N 18-7509139N9714DVermeire Calvin L · Soldotna, AKBuilt 1959 · S/N 22-6626N9714PGilman Robert L · Wasilla, AKBuilt 1976 · S/N 18-7709003N9715DRegistration Pending · Carlton, WARegistration pendingBuilt 1959 · S/N 22-6627N9716DKappele Arthur J · Crystal River, FLBuilt 1959 · S/N 22-6628N9716PGreater Boston Soaring Club · Sterling, MABuilt 1975 · S/N 25-7556032N9717PDakota Aircraft Inc · Pierre, SDBuilt 1975 · S/N 18-7609001N9720DNauman Scott A · Littleton, COS/N 22-6632N9720PTalon Air Service Inc · Soldotna, AKBuilt 1975 · S/N 18-7509137N9722DLincoln Land Community College · Springfield, ILBuilt 1959 · S/N 22-6634N9722NBaker Robert A · Salcha, AKBuilt 1952 · S/N 18-1685N9724PWestcott Brett M · Wasilla, AKBuilt 1975 · S/N 18-7609003N9725DSantine Michael F · Shelby Township, MIBuilt 1959 · S/N 22-6637N9725POldham Kris Dean · Anchorage, AKBuilt 1975 · S/N 18-7609004N9726PInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18-7609005N9727PCoggins Craig C · Nome, AKS/N 18-7609006N9728DGrizzly Skins Of Alaska Inc · Wasilla, AKBuilt 1959 · S/N 22-6640N9729DBurr Industries Inc · Keystone Heights, FLBuilt 1959 · S/N 22-6641N9730DFlood Ashley · Gibbstown, NJBuilt 1959 · S/N 22-6642N9730PDreger Dean R · Wilbur, WABuilt 1975 · S/N 18-7609007N9732DTouzeau Raymond V · Newberg, ORS/N 22-6644N9733DMcfalls Caleb Parker · York, SCBuilt 1959 · S/N 22-6645N9734PHornyak Ryan J · Girard, PABuilt 1975 · S/N 18-7609008N9735DSkinner Timothy G · Archer, FLS/N 22-6647N9735PSprenger Mark R · Eagle River, AKBuilt 1975 · S/N 18-7609009N9736DCamp Doug A · Starkville, MSBuilt 1959 · S/N 22-6648N9736PKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 257556046N9737DFolkvord Darrel L · Toston, MTS/N 22-6649N9740DSchilling Michael · Nikiski, AKFirst renewal noticeBuilt 1959 · S/N 22-6653N9742DJones Adam J · Lucerne Valley, CABuilt 1959 · S/N 22-6655N9746DLong Verl L · Lewiston, IDBuilt 1959 · S/N 22-6659N9747DBender Roger J · Overgaard, AZBuilt 1959 · S/N 22-6660N9749DCaldwell Joel A · Kenai, AKS/N 22-6662N974APowder River Aviation LLC · Gillette, WYBuilt 1951 · S/N 22-288N9754DLaney Charles A · Maiden, NCS/N 22-6668N9757ZWestern North Carolina Air Museum · Hendersonville, NCS/N 226182N9758DEvans Michael K · Nome, AKS/N 22-6672N9760DDavis Michael P · Midway, UTBuilt 1959 · S/N 22-6675N9761PBig Q Aviation Corporation · Helena, MTBuilt 1975 · S/N 18-7609025N9762DMarshall Marcus D · Georgetown, TXBuilt 1959 · S/N 22-6677N9762PKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1974 · S/N 25-7556072N9765DPatey Daniel J · Lakewood, CABuilt 1959 · S/N 22-6680
Back to AD 99-01-05 R1