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.

N4856ZWason Luther M III · Raymond, NHBuilt 1961 · S/N 22-8431N4857ARegistered aircraftN-number assigned, not yet registeredS/N 22-4013N4857ZFrancis Harvey B · Key West, FLS/N 22-8433N4859ADory Lakota L · Caldwell, IDS/N 22-4015N4859ZPinter John M · Grand Ledge, MIFirst renewal noticeBuilt 1961 · S/N 22-8435N485BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2023 · S/N 4496552N485EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 27-3864N4860AWolff Paul J · Baraboo, WIBuilt 1956 · S/N 22-4019N4860YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4662N4860ZSewell Dennis L · Clay Center, KSBuilt 1961 · S/N 22-8436N4861ARubbert Randy C · Reynolds, NDBuilt 1956 · S/N 22-4020N4862ASmith James A · Lyle, WABuilt 1951 · S/N 22-279N4862YKohler Richard L · Moriarty, NMBuilt 1968 · S/N 25-4665N4863ARud Alexandra E · Clara City, MNBuilt 1956 · S/N 22-4022N4863ZIvy James H III · Seligman, AZBuilt 1961 · S/N 22-8439N4865ZSchroer Steven K · Columbus, INBuilt 1961 · S/N 22-8442N4869ANevill Bernard L · Clare, MIBuilt 1956 · S/N 22-4029N486CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 4496417N4873YCherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 25-4675N4875ZRice Gary W · San Antonio, TXBuilt 1961 · S/N 22-8454N4879ZRobert P Brown Inc · Beatty, ORS/N 22-8460N487SCRegistered aircraftBuilt 1959 · S/N 24-1346N4883PMardis James T · Mechanicsburg, PABuilt 1961 · S/N 27-464N4885ZReed Michael D · Parsons, KSBuilt 1961 · S/N 22-8467N4888ZFrancom Jeffery S · Malad City, IDS/N 22-8470N488UVUtah Valley University · Orem, UTBuilt 2018 · S/N 4496451N4893PTri-City Helicopter Services Inc · Richland, WABuilt 1961 · S/N 27-477N4895PKlein Barry A · Friday Harbor, WABuilt 1961 · S/N 27-482N4897YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4704N4898YSimmons Mark Adba · Pawcatuck, CTBuilt 1968 · S/N 25-4705N4899PC E S Corporation · Charleston, WVRevoked, canceledBuilt 1961 · S/N 27-487N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48HAFiack Daniel P · Sun Valley, IDBuilt 1953 · S/N 22-975N48YKimble Robert · Marco Island, FLBuilt 1981 · S/N 27-8154022N4900ZPeden Max S · Eagleville, TNBuilt 1961 · S/N 22-8483N4901ZUnger Michael D · Bellingham, WAS/N 22-8486N4904PCivil Air Support LLC · Phoenix, AZBuilt 1961 · S/N 27-495N4907PTabor Conor C · Littleton, COBuilt 1961 · S/N 27-498N4907ZChristie Ian A H · Limon, COS/N 22-8492N4909ZVersatile Aviation LLC · Waterford, MIBuilt 1961 · S/N 22-8494N4911ZSamson Robert L · Phoenix, AZBuilt 1961 · S/N 22-8496N4913ZRegistered aircraftS/N 22-8499N4915ZPamment Melvin M · Arlington, KYBuilt 1961 · S/N 22-8501N4916PPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 27-506N4917AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496254N4917ZGibsons Gas Inc · Holland, NYS/N 22-8506N491NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496236N4920PDetert Bradley · Valparaiso, INBuilt 1962 · S/N 27-510N4921PAndre David E · San Jose, CABuilt 1962 · S/N 27-511N4923YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4620
Back to AD 85-02-05 R1