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.

N728KKWeddle Stephen J · Phillips, WIBuilt 1951 · S/N 20-712N7290KAnderson Brent J · Whitewater, MTBuilt 1950 · S/N 18-202N7291DLehman John Thomas · Corbett, ORBuilt 1957 · S/N 18-5711N7291KCassell Robert W · Wasilla, AKBuilt 1950 · S/N 18-203N7296KVne LLC · Sheridan, WYS/N 18-210N7296ZKolb Duane L · Bison, SDBuilt 1965 · S/N 25-3241N7297DMachida Steven · Homer, AKBuilt 1957 · S/N 18-5717N7297KWarren Mark J · Sleetmute, AKS/N 18-211N7298KNeal Christopher C · Staples, MNBuilt 1950 · S/N 18-212N7298ZShenandoah Valley Soaring Inc · Nellysford, VABuilt 1965 · S/N 25-3111N72999Huntington Roger · Galena, AKS/N 22-6507N7299KHofer Todd Paul · Doland, SDBuilt 1950 · S/N 18-213N72ABGlobe Motorcycles Ltd Inc · Pembroke Pines, FLBuilt 1969 · S/N 25-5088N72BWChapman Oliver J · Wingo, KYBuilt 1950 · S/N 18-159N72CVMccullough Wayne L · Greenfield, INBuilt 1958 · S/N 22-6115N72RPVisscher Fred D · Madison, GABuilt 1952 · S/N 18-2214N72WRFratzke Nathan A · Sterling, AKS/N 18-8982N7300DClendaniel Randon · Desert Hot Springs, CAS/N 22-5087N7301DGrant Cary · Cave Creek, AZBuilt 1957 · S/N 22-5088N7303ZSeminole Flying Soaring Inc · Clermont, FLS/N 25-3247N7306DJ S H Farms Inc · Hermiston, ORBuilt 1957 · S/N 22-5093N7306KKutschera Thomas C · Youngsville, NYBuilt 1950 · S/N 20-216N7307DKnight Todd A · Grimes, IAS/N 22-5095N7307XZimmer Chris P · Upham, NDBuilt 1965 · S/N 253251N7307ZKrutson Wayne R · Tioga, NDS/N 25-2755N7308KBradley Gary C · Orchard Park, NYBuilt 1950 · S/N 20-217N7308ZKnutson Wayne R · Tioga, NDBuilt 1965 · S/N 25-3253N7309KStanley Bryan D · Paso Robles, CABuilt 1950 · S/N 20-218N7311DRasmussen Kent L · Jetmore, KSBuilt 1957 · S/N 22-5099N7311ZBermuda High Soaring School · Lancaster, SCBuilt 1965 · S/N 25-3258N7312DJenkins James L · Lake Stevens, WABuilt 1957 · S/N 22-5100N7312KWilson David A · Garrison, IABuilt 1950 · S/N 20-221N7313ZSimmons Mark A DBA · Pawcatuck, CTBuilt 1965 · S/N 25-3245N7315DSkyhaven Airport Inc · Tunkhannock, PABuilt 1957 · S/N 22-5103N7316KSantucci John D · Boonton, NJBuilt 1950 · S/N 20-225N7318DAir & Field Equipment LLC · Moore, IDS/N 22-5106N731UACherry Hill Aviation Inc · Freetown, INS/N 25-7405687N7322DRainey William F III · Mt Pleasant, TNBuilt 1957 · S/N 22-5110N7322KBudd Douglas N · Crawford, NEBuilt 1950 · S/N 20-232N7323DWilkerson Dwight T · Kirkland, WABuilt 1957 · S/N 22-5111N7324DRuach LLC · Wilmington, DES/N 22-5112N7324KBurley Joseph D · Fayetteville, GABuilt 1950 · S/N 20-230N7325KMouton Charles J Jr · Gladewater, TXBuilt 1950 · S/N 20-233N7326DAllen Jason J · Benson, NCBuilt 1957 · S/N 22-5114N7326KSiebert Mark R · Monticello, MNBuilt 1950 · S/N 20-234N7327DFrankfort Flying Club Inc · Beulah, MIBuilt 1957 · S/N 22-5115N7329DCampbell Michael S · Ann Arbor, MIS/N 22-5117N732UASonoran Aero LLC · Phoenix, AZBuilt 1968 · S/N 25-4658N7330KFinke Michael C · Sewickley, PABuilt 1950 · S/N 20-231N7330ZAlbertson James M · Slocomb, ALBuilt 1965 · S/N 25-3230
Back to AD 99-01-05 R1