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.

N4192ZSwanson Amos W · Palmer, AKBuilt 1966 · S/N 18-8379N4194HWise Joe · Kilgore, TXBuilt 1948 · S/N 15-77N4196HBurnett John A · Wadsworth, ILS/N 15-79N4197ZBurns Barry D · Amarillo, TXS/N 18-8389N4198ZMcfarlane Bradley J · Port Alsworth, AKBuilt 1966 · S/N 18-8391N4199AKiser Richard K · Mount Solon, VABuilt 1951 · S/N 18-924N4199ZSymanowski Kevin · Reeder, NDBuilt 1966 · S/N 18-8392N419AKSpats Aviation LLC · Toledo, OHBuilt 1951 · S/N 18-1067N41AHHarding Kenneth H · Columbus, OHBuilt 1954 · S/N 22-1899N41BFFerretti Bruno · Port Jervis, NYBuilt 1941 · S/N 6437N41EFCadet Air Corps Museum · Tarkio, MOS/N 18-2428N41LSGendron Chistofer P · Prospect Park, PABuilt 1952 · S/N 20-862N41QBBravo Charlie LLC · Johnston, IABuilt 1979 · S/N 18-7909067N4200HFoss David K · Anchorage, AKBuilt 1948 · S/N 14-3N4200MGrald Jonathan A · New Hampton, NYBuilt 1947 · S/N 12-3103N4201HWattenbarger Jay K · Fairbanks, AKS/N 14-4N4201ZBennett Ruth B Trustee · Vancouver, WABuilt 1966 · S/N 18-8420N4202ZPiatt Matthew D · Wasilla, AKBuilt 1966 · S/N 18-8421N4203HIvy Mark A · Anchorage, AKBuilt 1948 · S/N 14-6N4203MLangenberg Stewart M · Santa Barbara, CABuilt 1947 · S/N 12-3097N4203ZLongboat Key Aviation LLC · Wooster, OHBuilt 1966 · S/N 18-8422N4204HAndrews Billy G · Wasilla, AKS/N 14-7N4204ZKansas Air LLC · Linn, KSS/N 18-8423N42052Jaton Brady Glen · Sioux Falls, SDS/N 10334N4205HSwift Leonard M · Goldendale, WABuilt 1948 · S/N 14-8N4206HLeonard James P · Eagle River, AKBuilt 1948 · S/N 14-9N4207HGage Duane · Princeton, IDBuilt 1948 · S/N 14-10N4207MLessley Aviation LLC · Carrollton, MSBuilt 1947 · S/N 12-3100N4208HDahmes Bradley M · Hawick, MNBuilt 1948 · S/N 14-12N4208MBurkhart Galen L W · Portland, ORS/N 12-3112N4209HKirby Ronald S · Delta Junction, AKBuilt 1948 · S/N 14-11N4209MWahl Joseph Lewis · Elizabeth, COBuilt 1947 · S/N 12-3104N4209ZBy Sky Or By Sea LLC · Kalispell, MTBuilt 1966 · S/N 18-8428N4210HGage Ricky Duane · Lewiston, IDBuilt 1948 · S/N 14-13N4210ZMccarthy Gary W · Chugiak, AKBuilt 1966 · S/N 18-8429N4211MMccartan Gary M · Pocahontas, IABuilt 1947 · S/N 12-3106N4212MMiller Taylor Robert Mamouney · North Bend, ORBuilt 1947 · S/N 12-3107N4213HWiese Ryan Mark · Eagle River, AKBuilt 1948 · S/N 14-16N4213MNatale William F · Saratoga Springs, NYBuilt 1947 · S/N 12-3108N4214HGranger Andrew J · Denver, COS/N 14-101N4215HDavis John N · Port Alsworth, AKBuilt 1948 · S/N 14-18N4216ZGleason Egan · Valdez, AKBuilt 1966 · S/N 18-8437N4217HBowser Dwight H · Anchorage, AKFirst renewal noticeBuilt 1948 · S/N 14-20N4217ZSchock Erik D · Wasilla, AKBuilt 1974 · S/N 18-7409043N4218MFordyce Gregory L · Gaston, ORBuilt 1947 · S/N 12-3114N4218YDaniels David R · El Paso, TXBuilt 1955 · S/N 18-2510N4219HHardman Lorin D · Wasilla, AKBuilt 1948 · S/N 14-22N4219ZBubber Inc · Lake Providence, LABuilt 1966 · S/N 18-8442N4220ZLonon Michael E · Yuba City, CABuilt 1966 · S/N 18-8443N4221ZBlue River Aviation LLC · Palmer, AKBuilt 1966 · S/N 18-8445
Back to AD 99-01-05 R1