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.

N8762DEpperson James R · Sand Springs, OKBuilt 1958 · S/N 22-5946N8766DRatliff Steven L · Spring Grove, PABuilt 1958 · S/N 22-5952N8767DGriffith Scott G · Newnan, GABuilt 1958 · S/N 22-5953N8768LKnutson Wayne R · Thompson, NDS/N 25-5463N8774CStacy Richard K · Moneta, VAS/N 18-2864N8774DKeeler Michael E · Riverdale, MIS/N 22-5962N8775CMalone Douglas C · Homer, AKBuilt 1953 · S/N 18-2884N8776DThielen Andrew W · Marion, IABuilt 1958 · S/N 22-5964N8778DPockrus Pat B · Mineral Wells, TXS/N 22-5966N8778LRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1972 · S/N 25-5467N877DGDaigle Sean · North Pole, AKS/N 18-7709107N87800May John C · Prosser, WABuilt 1946 · S/N 12-2N87803Davenport David H · Fayetteville, NCBuilt 1946 · S/N 12-4N87804Clarke Adam M · Lompoc, CABuilt 1946 · S/N 12-5N87806Tackett Russell G · Wilder, IDBuilt 1946 · S/N 12-7N8780CMichaud Frank H III · Visalia, CABuilt 1953 · S/N 18-2875N8780DN8780d LLC · Santa Cruz, CAS/N 18-6308N8781DRowe David R · Homer, AKBuilt 1958 · S/N 18-6310N8783CBaum James L Trustee · Anchorage, AKBuilt 1953 · S/N 18-2879N8784LSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1970 · S/N 25-5267N8785CStewart Robert J Jr · Erie, PABuilt 1953 · S/N 18-2881N8785DSalter Phlip G · Beaumont, TXBuilt 1958 · S/N 18-6322N8786DMikkelsen Timothy O · Wasilla, AKBuilt 1958 · S/N 18-6323N87875Rice John D · Maddock, NDBuilt 1954 · S/N 18-3589N8787DRoss Scott · Middletown, NYS/N 18-6324N8787MUndem John D · Grand Rapids, MNS/N 12-3437N8788DMartens Edwin L · Ogallala, NEBuilt 1958 · S/N 18-6325N8789CPainter Joe S · Buffalo, SDFirst renewal noticeBuilt 1953 · S/N 18-2885N8789DStrembicke Derek R · Owens Cross Roads, ALS/N 18-6326N8790CAltitude Unlimited Inc · Lewes, DEBuilt 1953 · S/N 22-1402N8790DOdenbach Eric · Eureka, SDS/N 18-6330N8791LMarkes Tim · Douglas, OKBuilt 1970 · S/N 25-5278N8792DAndresen Elouise H · Anchorage, AKBuilt 1958 · S/N 18-6333N8793LVoerman Joseph R Jr · Cambridge, NYBuilt 1974 · S/N 18-7409125N8795DKowalski Ronald W · Mount Airy, NCBuilt 1958 · S/N 18-6338N8796DNelson Rohn R · Salmon, IDBuilt 1958 · S/N 18-6341N8797DDuflo Spray Chemical Inc · Lowville, NYS/N 18-6342N8798CSchraceo Travis D · Bridgeport, TXBuilt 1953 · S/N 22-1411N8798DAerospace Trust Management LLC Trustee · Wilmington, DES/N 186343N87996Terrell Anthony K · Iowa Park, TXBuilt 1954 · S/N 18-4026N8799CVand Flyve Klub Inc · Thief River Falls, MNBuilt 1953 · S/N 18-2808N8799DStadman Tyrel W · Eagle River, AKBuilt 1958 · S/N 18-6350N879AKirwan Casey · Sebastopol, CABuilt 1951 · S/N 22-204N87AFMetcalf Shane L · Wasilla, AKBuilt 1950 · S/N 18-66N87DCVintage Skycrafters LLC · Kelso, WAS/N 18-3043N87MSellers Mark · Philadelphia, PABuilt 1955 · S/N 22-2951N87NMChildress Gregory F · Dallas, TXBuilt 1957 · S/N 22-5082N87VKBurgstaller Martine S · DeurneBuilt 1960 · S/N 22-8879N8801CBlue Chip Aviation LLC · Falling Waters, WVS/N 22-1414N8803DWhite Jacob · Soldotna, AKBuilt 1958 · S/N 22-5971
Back to AD 99-01-05 R1