OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,921

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.

N3110ZLombardo Robert C · Clarks Summit, PABuilt 1959 · S/N 22-7049N3111KChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496240N3112ZSchifano Benedict S · Scottsville, NYS/N 22-7051N3114FByrd Ronald R · Polk City, FLS/N 22-8615N3117AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496259N3117LAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 4496202N3117ZYoung Donald L · Anniston, ALS/N 22-7062N3118ZTridogs LLC · Cleveland, GABuilt 1959 · S/N 22-7063N3119PKovacs Thomas A · Nashua, NHBuilt 1957 · S/N 23-1041N3119ZStoner Paul V · Austin, TXBuilt 1959 · S/N 22-7064N311BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3313N311EFLibra Air Inc · Las Vegas, NVBuilt 1979 · S/N 44-7995226N311JEJps Aviation LLC · West Chicago, ILS/N 27-7754053N311SRed Rock Construction Inc · Hydro, OKBuilt 1964 · S/N 30-328N3120ZGifford Thomas Lloyd · Canadian, TXS/N 22-7065N3123ZTripp Robert L · Walsenburg, COBuilt 1959 · S/N 22-7068N3125GEastern Kentucky University · Richmond, KYS/N 4496214N3125ZFabris Thomas H · Reva, SDBuilt 1959 · S/N 22-7070N3126PJmc Duryea Investments LLC · Ocala, FLBuilt 1957 · S/N 23-1049N3127PThorn Blake A · Coupeville, WAS/N 23-1050N3127ZLott William F Jr Trustee · Oklahoma City, OKS/N 22-7072N3128TWingsleasing LLC · Wichita, KSS/N 4496219N3128ZGrady Robert DBA · Lansing, ILS/N 22-7073N3129PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1052N3129ZCaldwell Caleb Z · Anchorage, AKBuilt 1959 · S/N 22-7074N312MMBadgley Robert W · Stanley, NDBuilt 1976 · S/N 25-7656085N3131ZPralle Jeffory K · Wasilla, AKBuilt 1959 · S/N 22-7076N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056N3133PLumley John J · Delray Beach, FLFirst renewal noticeBuilt 1957 · S/N 23-1057N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059N3136ZSchafer Patrick A · Marietta, OHBuilt 1959 · S/N 22-7080N313MWClover George S · Catheys Valley, CABuilt 1959 · S/N 24-1637N3140ZHoyt Kenneth B · Marion, KSBuilt 1959 · S/N 22-7084N3141ZKumbier Jenene R · Maxwell, IABuilt 1959 · S/N 22-7086N3143ZChristian Edward A · Evans, GABuilt 1959 · S/N 22-7088N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391N3151ZOld Crow Flyers LLC · Mooresville, NCBuilt 1959 · S/N 22-7098N3152ZMoultrie Zachariah D M · Grass Valley, CABuilt 1959 · S/N 22-7096N3155ZKrejci Dwight D · Wheatland, WYBuilt 1959 · S/N 22-7102N3156ZSale Reported · Wellsville, UTSale reported, canceledBuilt 1959 · S/N 22-7103N3157ZIvy James E · Alba, TXS/N 22-7104N3159ZPepin Daniel J · King Salmon, AKBuilt 1959 · S/N 22-7106N315NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754031N3161PEga Aero Specialty Services LLC · Beaufort, SCBuilt 1957 · S/N 23-1093N3161ZTyner James A · Bend, ORBuilt 1959 · S/N 22-7109N3165PNordstrand Steven D · Oak Harbor, WABuilt 1957 · S/N 23-1097N3165ZSmith Kenneth W · Bedford, INBuilt 1959 · S/N 22-7116
Back to AD 85-02-05 R1