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.

N46LULetourneau University · Longview, TXBuilt 2017 · S/N 4496415N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470N46SDPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8054040N4703ZStarling Ronald A · Prescott, AZBuilt 1961 · S/N 22-8245N4704PCarlson Brent · Medford, ORBuilt 1960 · S/N 27-232N4704ZRegistration Pending · Canyon Country, CARegistration pendingBuilt 1961 · S/N 22-8246N4705PHam Edward E · Boring, ORBuilt 1960 · S/N 27-233N4706ZAirsmith Aviation LLC · Oshkosh, WIS/N 22-8248N4707CSmith James A · Lyle, WABuilt 1955 · S/N 22-3291N4707YWengair LLC · Powell, WYBuilt 1967 · S/N 25-4439N4707ZBradsher Larry Flint · Rougemont, NCBuilt 1961 · S/N 22-8250N4711ZHanna David A · Keene, TXS/N 22-8261N4713ZFailing Amanda R · Wasilla, AKBuilt 1961 · S/N 22-8257N4714PKropf Jacob · Halsey, ORBuilt 1960 · S/N 27-243N4715ZMuehlberg Stephen E · Newcastle, OKBuilt 1961 · S/N 22-8259N4719ZBergen Henry E · Fond Du Lac, WIS/N 228264N4721YHendrickson Flying Service Inc · Rochelle, ILBuilt 1967 · S/N 25-4463N4722YX-C Soaring Association Inc · Pensacola, FLBuilt 1967 · S/N 25-4465N4723ZMartin William S · S Coffeyville, OKBuilt 1961 · S/N 22-8268N4724PTnt Farms · Marana, AZS/N 27-252N4726ZAyers Jeffrey L · Harveys Lake, PAS/N 22-8272N4727ZHartson William R · Petoskey, MIS/N 22-8273N4728PSheppard Harold DBA · Riverton, WYBuilt 1960 · S/N 27-257N4729ZSublogic Corp · Urbana, ILBuilt 1961 · S/N 22-8275N4731PBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 27-261N4731ZLamb Steve E · Big Bear City, CAS/N 22-8278N4732YChilhowee Soaring Association Inc · Benton, TNS/N 25-4480N4734VShaw Logan · Redding, CABuilt 1950 · S/N 20-297N4735ZDebold David A · Spring, TXBuilt 1960 · S/N 22-8283N4736YHollatz Walter M · Concord, GABuilt 1967 · S/N 25-4488N4737ZLiljegren Frederick A · Parkers Prairie, MNBuilt 1961 · S/N 22-8288N4738ZSawl Security LLC · Rock Island, TNS/N 22-8289N4739ZMingus Paul H · Mesa, AZBuilt 1961 · S/N 22-8292N4742ZHudson James W · Granite City, ILS/N 22-8298N4743MMcbride Paul · Dallas, TXBuilt 1969 · S/N 301848N4744ZGalloway Gordon · Knights Landing, CABuilt 1961 · S/N 22-8300N4747ADouthitt Mike L · Butte, MTBuilt 1956 · S/N 22-3891N4748AWalker Nicole Ann · Angoon, AKBuilt 1956 · S/N 22-3892N4748YMemphis Soaring Society · Memphis, TNBuilt 1968 · S/N 25-4504N474VMViking Aviation LLC · Rockport, MEBuilt 1956 · S/N 22-4173N4750A22av Group LLC · Austin, TXS/N 22-3895N4750PKenefick Christopher Keith · Rosamond, CABuilt 1960 · S/N 27-288N4750ZBracy Rodney E · Middleville, MIBuilt 1961 · S/N 22-8306N4751AZielinski Joseph Jr · Johannesburg, MIBuilt 1956 · S/N 22-3896N4755ZHerold Dana R · Mcminnville, ORS/N 22-8311N4757PRenck Michael R · Red Rock, TXBuilt 1960 · S/N 27-297N4758PCole Gary L · Richmond, TXBuilt 1960 · S/N 27-274N4758ZMcgirr Kenneth L · Huron, SDS/N 22-8316N4759ZKeib Frederick N · Lowville, NYBuilt 1961 · S/N 22-8317
Back to AD 85-02-05 R1