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.

N3017JColeman John C · Mc Alpin, FLBuilt 1965 · S/N 15061117N3017URivera Michael R · Magnolia, TXBuilt 1963 · S/N 17250617N3017XMunson Timothy G · Mendota, ILBuilt 1966 · S/N 15064417N30182Johnson Arnold R · Mina, SDBuilt 1968 · S/N 17701105N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125N30189Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1968 · S/N 17701108N3018FDietzler James J · Weyauwega, WIBuilt 1966 · S/N 18257118N3018JHargraves Richard N · Clarksville, ARS/N 15061118N3018QAndre Eric J · Somerset, WIBuilt 1967 · S/N 18258018N3018XWard David J · Garden Valley, IDBuilt 1966 · S/N 15064418N3018YGranger Airplane LLC · Granger, INBuilt 1962 · S/N 18254018N30195Palmer Peter L · Mission, TXBuilt 1968 · S/N 17701113N30198Thomas Mark J · Vacaville, CABuilt 1968 · S/N 17701115N3019FMadison Richard Christopher · Little Rock, ARBuilt 1966 · S/N 18257119N3019JRhinelander Flying Service Inc · Rhinelander, WIBuilt 1965 · S/N 15061119N3019QHatfield Brothers LLC · Gooding, IDBuilt 1967 · S/N 18258019N3019XSkyy King LLC · Helena, MTBuilt 1966 · S/N 15064419N301ALForhan Michael A · Urbana, OHBuilt 1967 · S/N 3370636N301CPWhy Not Fly Aviation LLC · Gainesville, VAS/N 414A0105N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891N301DDRockalong Holdings LLC · Stanton, TXBuilt 1979 · S/N 18503985N301DPEvans Jack · Albuquerque, NMS/N 17268863N301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18052490N301GWCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1969 · S/N 15071678N301JCGardner Jeffrey · Reno, NVBuilt 1980 · S/N 18267770N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555N301MCCharles Michael Maya · Erie, COBuilt 1978 · S/N 18503705N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763N301PFLahm David K · Cozad, NEBuilt 1975 · S/N 15076830N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334N301RS2f Trade LLC · Collinsville, TXS/N 21062473N3020UKelly Ho-Montoya Insurance Group LLC · Wichita Falls, TXBuilt 1963 · S/N 17250620N3020XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1966 · S/N 15064420N3020YJ & T Sullivan Farms Gp · Macon, TNBuilt 1962 · S/N 18254020N30218Mckillip Kirby G · Kemah, TXBuilt 1968 · S/N 17701127N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405N3021FRegistered aircraftBuilt 1966 · S/N 18257121N3021JDuffy William B · Denton, TXBuilt 1965 · S/N 15061121N3021QPicco Anthony · Sykesville, MDBuilt 1967 · S/N 18258021N3021SCollett Danny W · Stewart, TNBuilt 1967 · S/N 15066921N3021XMay'S Welding Service Inc · Cotulla, TXS/N 15064421N3021YBrancao Bryan A · Norco, CABuilt 1962 · S/N 18254021N30225Hall Curtis B · Shepherdsville, KYBuilt 1968 · S/N 17701131N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922N3022VRetroair Restoration LLC · Big Lake, AKBuilt 1974 · S/N 15076354N3022XCintim LLC · Carrabelle, FLS/N 15064422N30231Pankratz Paul J · Lakeville, MNBuilt 1968 · S/N 17701136N30235Booher Harold D · Manchester, MOBuilt 1968 · S/N 17701139N30238Nunley Dwight · Hawkins, TXBuilt 1968 · S/N 17701142
Back to AD 97-01-13