OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-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:85-02-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.

N8778LRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1972 · S/N 25-5467N8778PTrammell Shaun · Broken Arrow, OKBuilt 1965 · S/N 24-4229N8778YBad Altitude Aviation · Washington, UTBuilt 1969 · S/N 30-1934N877NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496475N877PTaylor Peter L · Red Bluff, CABuilt 1960 · S/N 24-1826N8780PChampion Milton · Reno, NVBuilt 1965 · S/N 24-4232N8780YRegistered aircraftBuilt 1969 · S/N 30-1936N8781PJenkins Aviation Ventures LLC · Woodstock, GABuilt 1965 · S/N 24-4233N8783YOsprey Holding Company LLC · Foley, ALBuilt 1969 · S/N 30-1940N8784LSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1970 · S/N 25-5267N8784PCrane Steven · Phoenix, AZBuilt 1965 · S/N 24-4237N8784YFoster Darryl L · The Woodlands, TXBuilt 1969 · S/N 30-1942N8786PSisk Jerald L · Brighton, COBuilt 1965 · S/N 26-135N87878International Air Services Inc Trustee · Carson City, NVBuilt 1959 · S/N 24-469N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241N8790CAltitude Unlimited Inc · Lewes, DEBuilt 1953 · S/N 22-1402N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243N8791LMarkes Tim · Douglas, OKBuilt 1970 · S/N 25-5278N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792PPrivette Richard E · Oak Hill, FLBuilt 1965 · S/N 24-4245N8793PFlaagan Kevin D · Beulah, NDBuilt 1965 · S/N 24-4246N8794PDelaware Mark P · Phoenix, AZBuilt 1965 · S/N 24-4247N8795PJejgr LLC · Presho, SDBuilt 1965 · S/N 24-4248N8795YJohnson Paul · Wichita Falls, TXS/N 30-1954N8796PAllie Doug B · Glasgow, MTBuilt 1965 · S/N 24-4249N8797PPlant Curtis W · Runge, TXBuilt 1965 · S/N 24-4250N8797YHight Derrick R · North Aurora, ILBuilt 1969 · S/N 30-1812N8798CSchraceo Travis D · Bridgeport, TXBuilt 1953 · S/N 22-1411N8799PMontgomery M Kim · Vega, TXBuilt 1965 · S/N 24-4252N879AKirwan Casey · Sebastopol, CABuilt 1951 · S/N 22-204N87AJdkracl Aircraft LLC · Gretna, NEBuilt 1970 · S/N 27-4594N87CWZou Christian · Chandler, AZBuilt 1967 · S/N 30-1639N87MSellers Mark · Philadelphia, PABuilt 1955 · S/N 22-2951N87NMChildress Gregory F · Dallas, TXBuilt 1957 · S/N 22-5082N87RPWhitehead Glenn K · Friendswood, TXS/N 24-1603N87VKBurgstaller Martine S · DeurneBuilt 1960 · S/N 22-8879N8800PAnp Networks Corp · Las Vegas, NVS/N 24-4253N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8801CBlue Chip Aviation LLC · Falling Waters, WVS/N 22-1414N8802PPennington Mitchell T · Medley, WVBuilt 1965 · S/N 24-4257N8803DWhite Jacob · Soldotna, AKBuilt 1958 · S/N 22-5971N8803PWade Brian K · Apalachin, NYBuilt 1965 · S/N 24-4258N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N8805CSandifer Steve R · Barnwell, SCBuilt 1953 · S/N 22-1419N8806CGribbins Aviation LLC · Campbellsville, KYBuilt 1953 · S/N 22-1420N8806PZiolkowski James E · Amarillo, TXBuilt 1965 · S/N 24-4261N8807DGorski Tim B · Larsen, WIBuilt 1958 · S/N 22-5975N8807PRegistered aircraftBuilt 1965 · S/N 24-4263
Back to AD 85-02-05 R1