AD 97-01-13

Registered aircraft · 54,837

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-13')
    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-13')
  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.

N3069QMarin Alberto · Mc Neal, AZS/N 18258069N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544N306GWCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 17250714N306PMBc 414 LLC · Vineyard Haven, MABuilt 1979 · S/N 414A0419N306TBApex Aviation Holding LLC · Kalispell, MTBuilt 1982 · S/N 340A1537N306TCN306tc LLC · Greenwich, CTBuilt 1976 · S/N 18503061N30708Johnson Raymond W · Buffalo, MNBuilt 1969 · S/N 17701414N30709Wessels Jr Steven A · Milledgeville, GABuilt 1969 · S/N 17701415N3070JCascade Soaring Society · East Wenatchee, WABuilt 1965 · S/N 15061170N3070YPearce Andrew R · Raleigh, NCBuilt 1962 · S/N 18254070N30713Wallace James Ray · Baltimore, MDBuilt 1970 · S/N 17701417N30717Day David G · Glendora, CAS/N 17701420N30718Olson Andrew S · Copper Canyon, TXBuilt 1969 · S/N 17701421N3071FRees Ryan G · Loa, UTS/N 18257171N3071JHaas James D · Frisco, TXBuilt 1965 · S/N 15061171N3071QNichols Waylon · Copeland, KSBuilt 1967 · S/N 18258071N3071URegistration Pending · Sheridan, WYRegistration pendingBuilt 1963 · S/N 17250671N3071XSmith Lawrence A · Alleyton, TXBuilt 1966 · S/N 15064471N30727Blanchard Ken E · Lumberton, MSBuilt 1969 · S/N 17701426N30728Lambert Hubert D · Lincolnton, NCBuilt 1969 · S/N 17701427N30729Thompson William C III · Lawrenceville, ILBuilt 1969 · S/N 17701428N3072EReed Michael A Trustee · Minerva, OHBuilt 1978 · S/N 17271428N3072JNavanugraha Piya · Hemet, CABuilt 1965 · S/N 15061172N3072SRawson Aviation LLC · Pryor, OKBuilt 1967 · S/N 15066972N3072VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 15076377N30730Cassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 1969 · S/N 17701429N30734Paradise Mark F · Indianapolis, INBuilt 1969 · S/N 17701433N3073FLuther Arnold D · Las Vegas, NVBuilt 1966 · S/N 18257173N3073JFilter Keith F Jr · Lake Havasu City, AZBuilt 1965 · S/N 15061173N3073SCresswell Aubrie J · Norwood, PABuilt 1967 · S/N 15066973N3073YWf Aviation LLC · Bozeman, MTBuilt 1962 · S/N 18254073N30741Nagy Mark M · Shingle Springs, CABuilt 1969 · S/N 17701435N30743Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 17701437N30747Silverwings Aviation LLC · Dover, DEBuilt 1969 · S/N 17701440N3074JMehling Robert C · Hardin, MTS/N T18803600TN3074QGriffin John O · Driggs, IDBuilt 1967 · S/N 18258074N3074STail Aero Corp · Wilmington, DEBuilt 1967 · S/N 15066974N3074YIronman Welding Inc · Rifle, COBuilt 1962 · S/N 18254074N30753Episcopal Wings Ministry Inc · Fairbanks, AKBuilt 1969 · S/N 17701443N30754Johnson Jiju · Fox Point, WIBuilt 1969 · S/N 17701444N3075FTurpen Kraig Aaron · Fredericksburg, TXBuilt 1966 · S/N 18257175N3075QDickerson Anthony S · San Tan Valley, AZBuilt 1967 · S/N 18258075N3075YAir Eagle LLC · Rome, GABuilt 1979 · S/N 21063169N30761Feaster Christopher D · Richmond, INS/N 17701448N30763Stith Gregory C · Osprey, FLBuilt 1970 · S/N 17701450N30765Hope Michael J · Exeter, NHBuilt 1970 · S/N 17701452N30767Cardinal N30767 LLC · Germantown, TNBuilt 1970 · S/N 17701453N30769Fridley R Mark · Owasso, OKBuilt 1970 · S/N 17701454N3076EHinkes Kenny · Albuquerque, NMBuilt 1978 · S/N 17271430N3076JMortgage Experts LLC · Homestead, FLBuilt 1965 · S/N 15061176
Back to AD 97-01-13