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.

N7044YMcneely Courtney L · Dallas, TXBuilt 1963 · S/N 30-47N7045BAndresen Victor R · Anchorage, AKBuilt 1956 · S/N 22-4299N7046PComanche Aviation LLC · Davie, FLBuilt 1960 · S/N 24-2194N7046ZVrooman Lawrence M · Winterville, NCBuilt 1964 · S/N 25-2812N7047PHirkala Ronald R · New Cumberland, WVBuilt 1960 · S/N 24-2195N7047YJenkins Joe C · Wyoming, DEBuilt 1963 · S/N 30-50N7047ZJersey Ridge Soaring LLC · Blairstown, NJBuilt 1964 · S/N 25-2813N7048DFlowers Bobby J · Parksley, VABuilt 1957 · S/N 22-4945N7048KHurlbert Michael L · Wasilla, AKBuilt 1950 · S/N 20-155N7048PGerard Garrett · North Bend, OHBuilt 1960 · S/N 24-2196N7049BUnderhill Eugene M · Dufur, ORBuilt 1956 · S/N 22-4303N7049KBenedict Kelly · Wasilla, AKS/N 20-157N7049ZOlathe Spray Service Inc · Olathe, COBuilt 1964 · S/N 25-2816N7050KSyzygy Consultation Services LLC · Hurricane, UTBuilt 1950 · S/N 20-158N7050PBork Joseph L · Mosier, ORS/N 24-2199N7050YTonys Aerial Service Inc · Great Bend, KSBuilt 1963 · S/N 30-53N7050ZMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 25-2818N7051DBraun Ronald J · Wasilla, AKBuilt 1957 · S/N 22-4948N7052HScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554130N7052PFlying Great Danes LLC · Chesapeake, VABuilt 1960 · S/N 24-2201N7053BStevens Alan · Meridian, IDBuilt 1956 · S/N 22-4307N7053KMatlad Inc · Wilmington, DEBuilt 1950 · S/N 20-160N7053PManter Earl F · Delaware, OHBuilt 1960 · S/N 24-2202N7054BWinter Jerry L · Cumming, GAS/N 22-4310N7054KPehoski Joseph R · Anchorage, AKBuilt 1950 · S/N 20-161N7054YNordman Clay L · Catheys Valley, CABuilt 1963 · S/N 30-65N7055PKehrle Betty M · Chandler, AZBuilt 1960 · S/N 24-2205N7056PSelf Melvin Lamar Jr · Greenwood, MSBuilt 1960 · S/N 24-2206N7058KGiarusso Richard John · Carlisle, IABuilt 1950 · S/N 20-165N7059DSmith Andrew W · Willow, AKBuilt 1957 · S/N 22-4956N7059PProx Jonathan P · Enterprise, ALBuilt 1960 · S/N 24-2209N7059YPhill-Air Inc · Dover, DEBuilt 1963 · S/N 30-70N705BSAims Community College · Greeley, COS/N 4496500N705CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 4496509N705SFLet Industries LLC · Lewes, DEBuilt 1974 · S/N 27-7405311N7060KMaxson Lee V · Mesa, AZS/N 20-176N7061YHoistad Flying Service Inc · Forman, NDBuilt 1963 · S/N 30-73N7062YFox Norman A · Maryville, TNBuilt 1963 · S/N 30-74N7064ZSevcik Clint L · Medford, MNBuilt 1964 · S/N 25-2844N7065PReno Joshua · Krum, TXBuilt 1960 · S/N 24-2217N7066PEckel Kenneth · Hernando, MSBuilt 1960 · S/N 24-2218N7066ZStuder Alfred C · Shelby, MIBuilt 1964 · S/N 25-2848N7067KOlson Michael B · Anchorage, AKS/N 20-172N7067YCactus Skybolt Aviation LLC · Athens, ALBuilt 1963 · S/N 30-80N7068PLs Engineering Inc · Salt Lake City, UTBuilt 1960 · S/N 24-2220N7068YAdvanced Aircrew Training LLC · Nashua, NHBuilt 1963 · S/N 30-81N7069KPlatinum Commercial Company LLC · Platinum, AKBuilt 1950 · S/N 20-174N7069PD And S Neotech Inc · Ogden, UTBuilt 1961 · S/N 24-2221N706SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 27-7405394N7070PHytry Randal G · De Soto, WIBuilt 1960 · S/N 24-2222
Back to AD 85-02-05 R1