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.

N7JESale Reported · Rogersville, MOSale reported, pending cancellationBuilt 1967 · S/N 30-1618N7WLKriner Andrew V · Orlando, FLBuilt 1969 · S/N 30-1914N7YMN7ym LLC · Rockford, MIBuilt 1969 · S/N 301900N8000Burns Christopher G · Hanover, PABuilt 1965 · S/N 30-682N8000DSmith Craig E · Fillmore, NYBuilt 1957 · S/N 22-5525N8000MBachmann Michael J · Boyertown, PABuilt 1956 · S/N 22-4054N8001CYoung Carl J · Lubbock, TXS/N 22-2190N8001DFaught Jeffrey R · Bismarck, NDBuilt 1957 · S/N 22-5526N8001PWainwright Daniel G · Clifton, ILBuilt 1963 · S/N 24-3241N8001YMyers Russell E · Pine, AZS/N 30-1107N8002PKoerner Aviation Inc · Kankakee, ILBuilt 1962 · S/N 24-3242N8003CNotestine Cody L · Pickerington, OHBuilt 1954 · S/N 22-2192N8005DGibson Michael J · Gambier, OHBuilt 1957 · S/N 22-5531N8005PAcklam David C · Yelm, WABuilt 1962 · S/N 24-3245N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009N8006YBreeding Jarrard L · Sharpsburg, GABuilt 1966 · S/N 30-1112N8007CManifee Doris Darlene · Black Canyon City, AZBuilt 1954 · S/N 22-2196N8007PBec Solutions Inc · Dallas, TXBuilt 1962 · S/N 24-3248N8008YWillis Gary B · Willis, TXBuilt 1966 · S/N 30-1114N8009PWilson Paul W Jr · Hobbs, NMBuilt 1962 · S/N 24-3252N800BYVectored Coverage LLC · Stony Brook, NYS/N 24-3161N800HMMakinson Aviation Warbird Restorations Inc · Deland, FLS/N 22-4168N800KKaufman Charles · West Palm Beach, FLBuilt 1966 · S/N 30-1115N800SUOklahoma State University · Stillwater, OKBuilt 2017 · S/N 4496412N8011CIlfeld Richard R · Apollo Beach, FLBuilt 1954 · S/N 22-2200N8011PPrecision Fab Inc · Greenville, OHBuilt 1962 · S/N 24-3254N8012PSchmidt Kyle P · Rapid City, SDBuilt 1962 · S/N 24-3255N8012YMarsh Geoffrey E · Old Lyme, CTBuilt 1966 · S/N 30-1119N8013DMichel John Vernon III · Westminster, MDBuilt 1957 · S/N 22-5538N8016DKeller Gary H · Washington C H, OHBuilt 1957 · S/N 22-5542N8016PSteelera Aviation LLC · Wolfforth, TXBuilt 1962 · S/N 24-3260N8017PMorrison Matthew B · Tucson, AZBuilt 1962 · S/N 24-3261N8017YLoya Armando · Whittier, CABuilt 1966 · S/N 30-1125N8019YOptimus Aicraft Leasing LLC · Naples, FLBuilt 1966 · S/N 30-1128N801AAvery Walter J · Maxwell, CABuilt 1951 · S/N 22-104N801PCGrand Michael · Palacios, TXBuilt 1965 · S/N 24-4256N801SW5b Aviation LLC · Duncan, OKBuilt 1979 · S/N 447995209N8020CThornton Jason G · El Dorado, KSS/N 22-2207N8020DStanley Steven D · Glasgow, MTS/N 22-5545N8020PLovingood Max H · Naples, FLBuilt 1962 · S/N 24-3264N8020YSnead State Community College · Boaz, ALS/N 30-1129N8021CSweet Kim · Rogers, ARBuilt 1954 · S/N 22-2208N8021DArctic Super Pacer LLC · Anchorage, AKBuilt 1957 · S/N 22-5546N8021YSterling Investment Services Inc · Batavia, ILBuilt 1966 · S/N 30-1131N8022CMl Aviation Consulting LLC · Zephyrhills, FLS/N 22-2209N8022DZurovski David · Albion, NEBuilt 1957 · S/N 22-5547N8022YDanis Paul A · Woodinville, WAS/N 30-1097N8023DSanchez Pascual G · Pantego, NCBuilt 1957 · S/N 22-5549N8023PShisier William · Tempe, AZBuilt 1962 · S/N 24-3267N8024PC Five Ranch Inc · Leoti, KSBuilt 1963 · S/N 24-3268
Back to AD 85-02-05 R1