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.

N7525PStack Robert J · Aurora, COS/N 24-2727N7526DShevock Frank C Jr · Sidman, PABuilt 1957 · S/N 22-5256N7527PWhite Andrew D · Covelo, CABuilt 1961 · S/N 24-2730N7528YSkyward Solutions Inc · Lewes, DEBuilt 1964 · S/N 30-593N752CFAnytime Flights LLC · Scottsdale, AZBuilt 1964 · S/N 30-592N7532PKing Larry Joe · Quanah, TXBuilt 1961 · S/N 24-2736N7532ZHill Curtis E · Bancroft, IDBuilt 1965 · S/N 25-3576N7533PFoster Andrew · Laguna Beach, CABuilt 1961 · S/N 24-2737N7533YFlying Pirates Unlimited LLC · New Bern, NCBuilt 1964 · S/N 30-596N7534PCrow Brenton · Findlay, OHBuilt 1961 · S/N 24-2738N7535YN7535y LLC · Sylvania, OHBuilt 1964 · S/N 30-598N7537YCecerr Paul E · Olive Branch, MSS/N 30-601N7538DOeser Laura Ann · La Grange, TXBuilt 1957 · S/N 22-5268N7538YEdwards John G · Stoneville, NCBuilt 1964 · S/N 30-602N7539DEaa Chapter 99 Inc · Vero Beach, FLS/N 22-5269N7539YChristianini Cassio Pereira · Plantation, FLBuilt 1964 · S/N 30-603N753SPKor Wesley D · White, SDBuilt 1961 · S/N 24-2740N7540DVanhouten Eric · Tunkhannock, PAS/N 22-5270N7542YLyle Eugene W · Honesdale, PABuilt 1965 · S/N 30-606N7543DBerg Butch A · Duluth, MNBuilt 1957 · S/N 22-5274N7545PFriebert Stephen E · Elk Grove, CABuilt 1961 · S/N 24-2752N7546YBrilliant Holdings LLC · Winfield, MOBuilt 1965 · S/N 30-609N7547DHawkins Laurie M · Birch Run, MIBuilt 1957 · S/N 22-5278N7548PSecolad N7548p LLC · Madison, INS/N 24-2756N7549PAlbano Alan T · Elbert, COBuilt 1961 · S/N 24-2757N7550DBickers Kenneth N · Longmont, COBuilt 1957 · S/N 22-5281N7551DThibodeau Philip R · Newfields, NHS/N 22-5282N7551PKassik Ryan W · Commerce City, COS/N 24-2759N7551YWills Terry W · Cedar Park, TXBuilt 1964 · S/N 30-614N7552PSaunders Frank H · Salinas, CABuilt 1961 · S/N 24-2760N7555DHardwick James David · Midland, TXBuilt 1957 · S/N 22-5286N7555YHirvonen Jukka Matti · Oak Ridge, NCBuilt 1964 · S/N 30-618N7556ZUltra Ag Cropdusters LLC · Le Mars, IABuilt 1965 · S/N 25-3608N7557DRandolph David L · Adrian, MIBuilt 1957 · S/N 22-5288N7558DMaschuck Eric A · Elysburg, PABuilt 1957 · S/N 22-5289N7558PAngst Matthew J · Wilmington, OHBuilt 1961 · S/N 24-2767N7559DDelta Pacer LLC · New Iberia, LABuilt 1957 · S/N 22-5290N7560PFlying Warriors LLC · Kearney, NEBuilt 1961 · S/N 24-2769N7560YRa Procurement LLC · Maypearl, TXBuilt 1964 · S/N 30-623N7561PHand Nicholas P · Tahlequah, OKBuilt 1961 · S/N 24-2770N7561YStinson Aviation LLC · Middletown, DEBuilt 1964 · S/N 30-624N7562PMinden Aircraft Repair Inc · Minden, NVBuilt 1961 · S/N 24-2771N7562YOtten John P · Lingle, WYBuilt 1964 · S/N 30-625N7565PWagner Chelsea Mele · Santa Cruz, CAS/N 24-2774N7565YVictor Robert W Jr · Topeka, KSBuilt 1964 · S/N 30-629N7566YS & D Adventure LLC · Middletown, DEBuilt 1964 · S/N 30-630N7568PBroussard James · Colmesneil, TXBuilt 1961 · S/N 24-2779N756AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496244N7570PKraule Ernest O · Saratoga, CABuilt 1961 · S/N 24-2781N7570ZKingsley Kiman J · Miller, MOBuilt 1965 · S/N 25-3631
Back to AD 85-02-05 R1