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.

N959ERs Specialties LLC · Anchorage, AKBuilt 1955 · S/N 18-4021N959RDDoering Ray A · Devils Tower, WYBuilt 1979 · S/N 18-7909159N95AHBrown Hunter · Sulphur Rock, ARBuilt 1978 · S/N 18-7809152N9601DRiffle David T · Woodinville, WABuilt 1958 · S/N 22-6510N9603DHeartland Aviation Inc · Alliance, NES/N 22-6512N9605DDirty Side Down LLC · Downers Grove, ILBuilt 1958 · S/N 22-6514N9606DNiemi Danny L · Osage, MNS/N 22-6516N9607DRomo Mark A · Dillingham, AKBuilt 1958 · S/N 22-6517N9609PMerlin Aviation Inc · Moriarty, NMBuilt 1976 · S/N 25-7656007N960VSSauder Philip J · Peninsula, OHBuilt 1959 · S/N 18-6799N9610DHicks Joseph O · Germanton, NCBuilt 1958 · S/N 22-6520N9612DSoto Edward · Wasilla, AKBuilt 1958 · S/N 22-6522N9615DPeterson Thomas M · Park Rapids, MNBuilt 1959 · S/N 22-6525N9617DWinton Christopher M · Valley Center, KSBuilt 1958 · S/N 22-6528N9618DRich Beryl G · Brush Prairie, WABuilt 1958 · S/N 22-6529N9619DSciotti Michael V · Wasilla, AKBuilt 1958 · S/N 22-6530N961LWGrassroots Aviation · Starkville, MSS/N 20-961N9621DLimitless Outdoors · Bonners Ferry, IDBuilt 1958 · S/N 22-6532N9624DBuster Wendy K · Forney, TXBuilt 1959 · S/N 22-6536N9625DCentral Products Inc · Gladwin, MIBuilt 1958 · S/N 22-6537N9627PDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1976 · S/N 18-7709001N9629DAnderson Antoinette · Granbury, TXBuilt 1958 · S/N 22-6541N9631PKansas Air LLC · Linn, KSS/N 25-7656013N9634DBacklund Scott W · Greybull, WYBuilt 1959 · S/N 22-6546N9637DSpivey Harold E · Thomaston, GABuilt 1959 · S/N 22-6549N9639DVestal James L · Kernersville, NCBuilt 1959 · S/N 22-6552N9642DMalsom Isaac B · Box Elder, SDBuilt 1959 · S/N 22-6556N9642PSouthern California Soaring Academy Inc · Valencia, CABuilt 1976 · S/N 25-7656023N9643DBlumhorst Ricky W · Paola, KSBuilt 1959 · S/N 22-6557N9645DDarryn Allyson R · Las Cruces, NMBuilt 1959 · S/N 22-6559N9646DFerrell Alan B · Arlington, OHBuilt 1959 · S/N 22-6560N9647DSutton Neal · Ashby, NEBuilt 1959 · S/N 22-6561N9649DUlrich Kenneth B Jr · Kingwood, TXBuilt 1959 · S/N 22-6563N9649PHarris Hill Soaring Corp · Horseheads, NYBuilt 1975 · S/N 25-7556008N9650DKahanek Doug II · Alvarado, TXBuilt 1959 · S/N 22-6564N9651DKadera David E · Dorchester, IABuilt 1959 · S/N 22-6565N9651PLedda Robert L · Soldotna, AKBuilt 1974 · S/N 18-7409142N9652DWilliams Michael P · Shelburne Falls, MAS/N 22-6566N9653DHurt Thomas J · Kerrville, TXBuilt 1959 · S/N 22-6569N9653PUhls Keith T · Austin, TXBuilt 1974 · S/N 18-7409144N9655PWiita Christopher D · Anchorage, AKS/N 18-7409148N9656DSpearman Clint · Scottsbluff, NEBuilt 1959 · S/N 22-6572N9656PLee Gerald R · Glennallen, AKBuilt 1974 · S/N 18-7409149N9657PJacobsen Nathaniel · Juneau, AKBuilt 1974 · S/N 18-7409150N9658DSwann Sherrie Kim Trustee · Toledo, OHBuilt 1959 · S/N 22-6574N9660PCook Timothy L · Eagle River, AKBuilt 1975 · S/N 18-7509004N9663DRamsey Bobby W · Harrogate, TNBuilt 1959 · S/N 22-6579N9663PDilse Brian R · Grand Forks, NDS/N 18-7509008N9664PYundt Joshua J · Wasilla, AKBuilt 1975 · S/N 18-7509001N9666DWing Robert E · Fairbanks, AKBuilt 1968 · S/N 18-8739
Back to AD 99-01-05 R1