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.

N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140N303MBBas Part Sales LLC · Greeley, COBuilt 1982 · S/N T30300157N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290N303RJTr Zato Heir Land & Cattle LLC · Spur, TXBuilt 1970 · S/N 18501728N303SDHarris County Sheriff'S Office · Spring, TXBuilt 1973 · S/N 18261849N303WAWacker Logistics LLC · Naples, FLBuilt 1984 · S/N T30300265N303WJQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N T30300087N303WWQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N T30300226N303XStocki Ronald W · Centennial, COBuilt 1960 · S/N 52957N30404Cardinal Flyers LLC · Powell, OHBuilt 1969 · S/N 17701237N30407Cardinal Cronies LLC · Clarinda, IABuilt 1968 · S/N 17701238N30409Schmitt Cameron · Fort Dix, NJBuilt 1968 · S/N 17701239N3040FJump Tn LLC · Greeneville, TNBuilt 1966 · S/N 18257140N3040JCrabtree Steven B · Canyon, TXBuilt 1965 · S/N 15061140N3040SPearson Wayne L · Fayetteville, ARS/N 15066940N3040VFlight Deck Air And Sea LLC · West Palm Beach, FLS/N 15076365N3040YRight Rudder Flyers LLC · Columbia Falls, MTS/N 18254040N30413Eagle Sky Patrol Inc · Deadwood, SDS/N 17701240N30418Young Matthew B · Brighton, ILBuilt 1969 · S/N 17701244N3041FRoffey Edward P Trustee · Grand Junction, COBuilt 1966 · S/N 18257141N3041UMoser Paul J · Danville, PABuilt 1963 · S/N 17250641N3041XSky Partners LLC · Sylacauga, ALBuilt 1966 · S/N 15064441N30422Casey Michael B · Hemingford, NEBuilt 1976 · S/N 18503129N3042FTdc Aviation LLC · Scottsdale, AZBuilt 1966 · S/N 18257142N3042JHutchison Robert T · Big Lake, AKBuilt 1965 · S/N 15061142N3042XMariani Nut Co Inc · Winters, CABuilt 1979 · S/N 18503903N30433Flying Hawks Inc · Palmyra, WIBuilt 1968 · S/N 17701251N30436Carson Charles E · North Vernon, INBuilt 1968 · S/N 17701252N30437Richards David N · Port Matilda, PABuilt 1968 · S/N 17701253N3043QDerango Gregory J · Chitina, AKBuilt 1967 · S/N 18258043N3043XVaughan John T · Safety Harbor, FLBuilt 1966 · S/N 15064443N30441Gillenwater Timothy J · Glasgow, KYBuilt 1968 · S/N 17701256N30443Songer Harvey · Beech Grove, ARBuilt 1968 · S/N 17701257N30444Crapnell Mark · Huntington Beach, CAS/N 210-58861N30446Gumz Terry J · Wailuku, HIS/N 17701260N3044QParrow Ronald J · Hampton, CTBuilt 1967 · S/N 18258044N30450Recker Timothy J · Aurora, IABuilt 1968 · S/N 17701262N30458Spires William B · Minden, NVBuilt 1968 · S/N 17701267N3045FFinley Eric · Ione, CABuilt 1966 · S/N 18257145N3045QLong Randy B · Coleman, TXS/N 18258045N3045UAfterburner Aviation LLC · Lewes, DES/N 17250645N3045VBuck Quincy M · Lakeville, MNBuilt 1974 · S/N 15076367N30463Chambers Frederick J · Lake Forest, CABuilt 1968 · S/N 17701271N30464Cunningham Augustus Bruce · Madison, ALBuilt 1968 · S/N 17701272N3046FPlane Brilliant · Odessa, FLS/N 18257146N3046JDyer David A · White Hills, AZBuilt 1965 · S/N 15061146N3046QN3046q LLC · Colorado Springs, COS/N 18258046N3046SWhite William E · Watkinsville, GABuilt 1967 · S/N 15066946N30474Ross Richard R · Jerseyville, ILBuilt 1968 · S/N 17701277
Back to AD 97-01-13