OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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.

N77RCN77rc LLC · Wilmington, DEBuilt 1972 · S/N 28R-7335092N77SLSanders Wiley C Jr · Troy, ALBuilt 1967 · S/N 30-1654N77SZMermoz Inc Trustee · Wilmington, DEBuilt 1977 · S/N 34-7770198N77TTTurley James H · Plainwell, MIBuilt 1976 · S/N 32R-7680244N77WESteven Paul Joyner · Austin, TXBuilt 1969 · S/N 28R-35114N7803PNoguess James E · Deming, NMS/N 24-3064N7804PFisher B Barton · Bowman, NDBuilt 1962 · S/N 24-3023N7805PN6760s LLC · Brooklyn, NYBuilt 1962 · S/N 24-3073N7805YN7805y LLC · Winchester, VAS/N 30-884N7806PSpires Kenneth G · Seville, OHBuilt 1962 · S/N 24-3025N7806YHhozapnv-LLC · Las Vegas, NVBuilt 1965 · S/N 30-885N7807YMcv2021 LLC · Saint Augustine, FLBuilt 1965 · S/N 30-886N7808YKleiner Daniel S · Aliso Viejo, CABuilt 1965 · S/N 30-887N780ACSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301967N780FMIolaire Aviation Inc · Wilmington, DEBuilt 2002 · S/N 2844086N7810PCompass Aviation LLC · Lagrange, GABuilt 1962 · S/N 24-3030N7811PLitz Mark C · Mission Viejo, CABuilt 1962 · S/N 24-3031N7815YPinhoc Inc · Winter Garden, FLBuilt 1965 · S/N 30-747N7817PGoff Mark A · Grand Blanc, MIBuilt 1962 · S/N 24-3037N7818PJohnson Herbert A · Evart, MIBuilt 1962 · S/N 24-3038N7818YCooney Daniel E · Wrightwood, CABuilt 1965 · S/N 30-895N7819YCobabe Ronald Bruce · Boerne, TXBuilt 1965 · S/N 30-896N781WWMattson William W · Telluride, COBuilt 1977 · S/N 28R-7803090N7820PCowlin Nathan · Hollywood, SCBuilt 1961 · S/N 24-2665N7820YComa Pipe LLC · Wilmington, DEBuilt 1965 · S/N 30-897N7821PTucker Engineering Associates Inc · Locust, NCS/N 24-3040N7822PTrue Airspeed Aviation LLC · Albany, GABuilt 1962 · S/N 24-3041N7824CRegistered aircraftBuilt 1975 · S/N 28R-7635118N7826YInternational Air Services Inc Trustee · Carson City, NVS/N 30-800N7827PRowan Christopher James · Sparks, NVBuilt 1962 · S/N 24-3047N7827YEpton Richard Charles · Senoia, GABuilt 1965 · S/N 30-902N7828PBvv Aviation LLC · Ben Wheeler, TXBuilt 1962 · S/N 24-3048N7828YVan Laak James E · Poquoson, VAS/N 30-903N7829PSpring Mountain Technologies LLC · Schwenksville, PABuilt 1962 · S/N 24-3049N7830YGospel Ministries International Inc · Mc Donald, TNBuilt 1965 · S/N 30-906N7832PInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 24-3052N7833BAnderson Bryan C · Arlington, TNBuilt 1959 · S/N 24-952N7833PPeters Jakob G · Tempe, AZS/N 24-3053N7834PRegistered aircraftBuilt 1962 · S/N 24-3054N7834YBall Half Out LLC · Mesa, AZBuilt 1965 · S/N 30-911N7835YRegistration Pending · Lewes, DERegistration pendingBuilt 1965 · S/N 30-912N7836PKearney Kory · Papillion, NEBuilt 1962 · S/N 24-3056N7837PMobbd LLC · Vero Beach, FLS/N 24-3057N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920N7842FIso Art Ltd · Hamilton, MTS/N 28R-7703004N7842PFall Stuart W · Holland, MIBuilt 1962 · S/N 24-3065N7844PTroy Watson Consulting Inc · Muleshoe, TXBuilt 1962 · S/N 24-3067N7845PRawlins Everett R · Pedro, OHBuilt 1962 · S/N 24-3068N7848PJads Airplane Club LLC · Boyne City, MIBuilt 1962 · S/N 24-3071N784ASDe Paola Humerto J · Pembroke Pines, FLBuilt 1972 · S/N 28R-7235160
Back to AD 97-01-01 R1