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.

N152JPatterson Casey Paul · Kinston, ALBuilt 1979 · S/N 15283162N152JLCivil Air Support LLC · Phoenix, AZBuilt 1978 · S/N 15281834N152LBurdick Rich · Montrose, COBuilt 1979 · S/N 15283964N152LEBirjandi Akbar · Westlake Village, CABuilt 1978 · S/N 15282306N152LTMorcom Aviation Services Inc DBA · Everett, WABuilt 1981 · S/N 15285262N152MCOkechukwu Christopher · Paramus, NJBuilt 1977 · S/N 15279798N152MFMja Flight LLC · Justin, TXBuilt 1981 · S/N 15284867N152MLBright Trevis Lee · Marion, INBuilt 1969 · S/N 15070431N152MMWiegler Michael · Austin, TXS/N 15280836N152NSNovember Sierra Aviation LLC · Oneill, NES/N 15279673N152PHahn Tacy W · Nevada City, CAFirst renewal noticeBuilt 1963 · S/N 18255080N152PFTfa Holding Corp · Daytona Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 15285380N152PKDuby James C · Wellington, NVBuilt 1963 · S/N 15060090N152PRSantaella Guillermo R · Huntley, ILBuilt 1979 · S/N 15283504N152PTWiger Theodore L · Falcon Heights, MNBuilt 1977 · S/N 15280065N152RAIndiana State University · Terre Haute, INS/N 15279562N152REWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284555N152SJBonus Kurt W · Wind Lake, WIBuilt 1978 · S/N 15282476N152SKCade Matt C · Canton, TXS/N 15281404N152SLAvtech Group LLC · Saint Augustine, FLBuilt 1978 · S/N 15282742N152SPFogelberg Scot · Stillwater, MNBuilt 1978 · S/N 15282536N152SQSpartan Education LLC · Tulsa, OKBuilt 1980 · S/N 15284185N152STMckenney Vernon L · Rodeo, CAFirst renewal noticeS/N 1558N152TATuck Aerial Surveys Inc · Big Stone Gap, VAS/N 20800664N152TRWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281247N152UCSkylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15281879N152UFWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15284001N152WBing Kenneth · Millersport, OHS/N 15282154N152WAAces High Aviatio LLC · Long Beach, CABuilt 1979 · S/N 15283845N152WHBecker Steven Hollyfield · New Meadows, IDBuilt 1977 · S/N 15279700N152XTDiaz Alcides L · Archbald, PABuilt 1979 · S/N A1520907N1530CParker Scott E · Herald, CABuilt 1953 · S/N 30230N1530MSinclair Justin Michael · Annandale, VABuilt 1975 · S/N 18264365N1530VThompson David Ray · Greenwood, SCBuilt 1976 · S/N R1722200N1530YCall Richard T · Wasilla, AKBuilt 1962 · S/N 17249230N1531FWrangell Mountain Air Inc · Palmer, AKS/N 185-0874N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038N1534FDieckman Raymond DBA · Hamilton, MTBuilt 1965 · S/N 185-0877N1534GRugger Investment Group LLC · Tustin, CAS/N 421B0630N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709N1534YLipsmeyer Jason K · Springdale, ARS/N 17249234N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710N1535YTheriault John · Harvard, ILBuilt 1962 · S/N 17249235N1536YCk Aviation LLC · Williamstown, NJBuilt 1962 · S/N 17249236N1537CWbs Coatings Inc · Grand Junction, COBuilt 1953 · S/N 30237N1537YAloha Skies Aviation LLC · Pahoa, HIBuilt 1962 · S/N 17249237N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651N1538YPrice Andre D · Granger, INBuilt 1962 · S/N 17249238N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040
Back to AD 97-01-13