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.

N4627ZPope County Aviation LLC · Russellville, ARBuilt 1961 · S/N 22-8142N4628ZBratager Jeffrey B · Erskine, MNBuilt 1961 · S/N 22-8144N4629YBarts Flying Service Inc · Storm Lake, IABuilt 1967 · S/N 25-4346N4629ZCollins Cody W · Palestine, TXBuilt 1961 · S/N 22-8145N462TTAir Enterprises LLC · Dover, DEBuilt 1968 · S/N 27-4042N4630PGoodfellow Ian A · Palm Beach Gardens, FLBuilt 1960 · S/N 27-148N4630ZAffolter Easy · Columbus, OHBuilt 1961 · S/N 22-8146N4631PO'Neill Daniel C · Tumwater, WAS/N 27-149N4636PV1 Iowa Aviation LLC · Des Moines, IAS/N 27-155N4636ZJenkins Thomas L III · Perry Park, KYBuilt 1961 · S/N 22-8153N4640ZGent Richard · Lancaster, TXS/N 22-8158N4641ZZenisek Michael W · Fairfax, IABuilt 1961 · S/N 22-8160N4642PColumbus Sign Co · Columbus, GAS/N 27-163N4642YFriends Aviation Inc · Wilmington, DEBuilt 1967 · S/N 25-4361N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165N4650PCornejo Bernard J · Elko, NVS/N 27-173N4652YDakota Acre Farms Inc · Denhoff, NDBuilt 1967 · S/N 25-4372N4652ZCardinali Andrew J · Kirkland, ILBuilt 1961 · S/N 22-8174N4654ZHanson Donald K · Tampa, FLBuilt 1961 · S/N 22-8177N4657ZShort Michael J · Independence, ORBuilt 1961 · S/N 22-8180N4662PCorn Michael L · Wilmington, NCBuilt 1960 · S/N 27-185N4662ZRegistration Pending · Georgetown, TXRegistration pendingS/N 22-8189N4664ZAsh Leslie A · Lebanon, TNBuilt 1961 · S/N 22-8193N4669YHollister Soaring Center LLC · Hollister, CABuilt 1967 · S/N 25-4392N466RBGreat Planes Aviation Inc · Bochester, MNBuilt 1981 · S/N 44-8207001N466SHWings Over Texas Holdings LLC · Denton, TXBuilt 2004 · S/N 4496181N466UVN466uv LLC · Provo, UTBuilt 2018 · S/N 4496449N4673ZNeuenburg James A · Clark Fork, IDFirst renewal noticeS/N 22-8206N4674ZHoadley Todd F · Springfield, OHBuilt 1961 · S/N 22-8207N4676PHuslig Brandon M · Carefree, AZBuilt 1960 · S/N 27-205N4676ZNielsen Nancy A · Eugene, ORBuilt 1961 · S/N 22-8209N4678PRudloff Uwe K Trustee · Lake Village, INS/N 27-207N4678ZQrh LLC · Bartlesville, OKBuilt 1961 · S/N 22-8213N467JKSale Reported · St MaartenSale reportedS/N 274209N4680ZPropelling The Gospel Missions Inc · Standish, MEBuilt 1961 · S/N 22-8215N4684ZGordon Stephen M · Velpen, INBuilt 1961 · S/N 22-8219N4686ZMacmoyle Scott · Blairstown, NJBuilt 1961 · S/N 22-8222N4688ZBurlew Richard · Richlands, NCBuilt 1961 · S/N 22-8225N4689ZDavis James J · Leonardtown, MDBuilt 1961 · S/N 22-8227N4690ZFialcowitz Thomas L · Hotchkiss, COBuilt 1961 · S/N 22-8228N4691PWilliamsburg Air Service · Kingstree, SCBuilt 1960 · S/N 27-220N4691THirsch Michael V · Cambridge, MABuilt 1959 · S/N 22-6713N4691YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1967 · S/N 25-4422N4693YKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 25-4424N4696PPolhemus Christopher · Carmichaels, PABuilt 1960 · S/N 27-225N4697ZAntesberger Edward A · Fairfax, VABuilt 1961 · S/N 22-8237N4699PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-227N4699YSandhill Soaring Club Inc · Brighton, MIBuilt 1967 · S/N 25-4417N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79N46ERAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 27-3649
Back to AD 85-02-05 R1