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.

N7654DDouglas Michael G · Holt, MOBuilt 1957 · S/N 22-5364N7654HAnderson Ayden M · Twin Bridges, MTBuilt 1946 · S/N 12-532N7655HKemper Joseph · Coxs Mills, WVS/N 12-533N7656DBlackford Robert G · Summit Point, WVBuilt 1957 · S/N 22-5366N7656HStephani Timothy M · White Lake, WIBuilt 1946 · S/N 12-534N7656KFrankle Joseph Wilder · Arlington, WABuilt 1950 · S/N 20-477N7658KJensen Gregory · Johnston, IAS/N 20-479N7659DJones Emmett F III · Minden, LAS/N 22-5369N7659HAndres James E · Delaware, OHS/N 12-538N7660KGbq LLC · New Prague, MNBuilt 1950 · S/N 20-481N7661DAndrews David L · Redvale, COBuilt 1957 · S/N 18-5930N7661HVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 12-541N7661KJenkins James L · Lake Stevens, WABuilt 1950 · S/N 20-482N7661LDoren Patrick E · Wasilla, AKBuilt 1975 · S/N 18-7509084N7663HZweifel Douglas L · Anchorage, AKFirst renewal noticeBuilt 1946 · S/N 12-543N7663ZGieseke Joe · Tuttle, OKBuilt 1965 · S/N 25-3807N7664DCachorro Cattle Co · Granbury, TXBuilt 1957 · S/N 18-5932N7664KHolzaepfel Carl E · Baytown, TXBuilt 1950 · S/N 20-485N7665DMehling Craig · Hardin, MTS/N 18-5933N7665KHicks Robert W · Petersburg, MIS/N 20-486N7667HKrogstad Paul D · Juneau, AKBuilt 1957 · S/N 12535N7668DDorsey Keith W · Isabel, SDBuilt 1957 · S/N 18-5937N7669DSims Charles A · Chugiak, AKBuilt 1957 · S/N 18-5939N766WTrafford John-Tristan G · Brighton, MIBuilt 1960 · S/N 22-7295N766WMOcean Aerial Ads Inc · Ocean City, MDBuilt 1959 · S/N 18-7205N7670HRobinson Eric C · Palmer, AKBuilt 1946 · S/N 12-549N7670KRoss Mark Eric · Polson, MTBuilt 1950 · S/N 20-491N7671DMartin James P · Sioux City, IABuilt 1957 · S/N 18-5889N7671HAir Dakota Flite Inc · Hettinger, NDBuilt 1946 · S/N 12-551N7672KWare Jake · Bovina, TXBuilt 1950 · S/N 20-493N7674HOverly Terrence L · Tok, AKS/N 12-554N7677KDailing Todd A · Fort Atkinson, WIBuilt 1950 · S/N 20-498N7677ZSpurlock Ricky DBA · Jensen, UTFirst renewal noticeBuilt 1966 · S/N 25-3826N7678DEldridge William D · Anchorage, AKBuilt 1957 · S/N 18-5900N7678HGoth Tedd Lloyd · Hereford, AZBuilt 1946 · S/N 12-567N767KLLowrance Kathleen C · Port Orange, FLBuilt 1978 · S/N 18-7809079N767NTognoli Steve F · Union, ORBuilt 1955 · S/N 18-4484N7680DHart Gary L · Fernwood, IDS/N 18-5902N7682DMckay Don · Soldotna, AKS/N 18-5904N7682HHumphrey Ronald D · Pace, FLBuilt 1946 · S/N 12-571N7683DYellow Bird Inc · Doral, FLBuilt 1957 · S/N 18-5905N7683KArne Blair · Carpenter, SDBuilt 1950 · S/N 20-505N7684DRegistration Pending · Destin, FLRegistration pendingBuilt 1957 · S/N 18-5906N7684HWellborn Ralph L · Kenai, AKBuilt 1946 · S/N 12-573N7685DMcdonnell Chris M · Naknek, AKS/N 18-5908N7685ZHigh Flights Soaring Club Inc · Peyton, COBuilt 1966 · S/N 25-3838N7687DAndreas Nicholas · Bemidji, MNBuilt 1957 · S/N 18-5911N7688DMiller Gregory B · Wasilla, AKBuilt 1957 · S/N 18-5912N7688HHersrud John D · Wasilla, AKBuilt 1946 · S/N 12-577N7688LConsag LLC · Ainsworth, NES/N 187409122
Back to AD 99-01-05 R1