AD 95-09-13

Registered aircraft · 1,061

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:95-09-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:95-09-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.

N826CMKuriel Michael · Las Vegas, NVS/N 421C0508N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064N82DAAircraft Holding Solutions LLC Trustee · Newark, DES/N 414A0476N82GLJusticia Holdings LLC · Roanoke, VAS/N 414A0275N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340N834RMInfinity Properties LLC · Summerset, SDS/N 421C-0834N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668N835RCDodson International Parts Inc · Rantoul, KSS/N 4040835N8378GPrecision Guidance LLC · Bloomington, ILBuilt 1977 · S/N 421C0310N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350N8401ACommercial Property Services Group LLC · Wichita, KSBuilt 1977 · S/N 421C0443N842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 421C0312N8430NFitch John A · Cary, ILBuilt 1978 · S/N 421C0490N844CKTurpin Time LLC · Helena, MTBuilt 1979 · S/N 421C0706N84DAVoorhees Investments Inc · Costa Mesa, CABuilt 1980 · S/N 414A0519N84PRSkov Equipment Co · Fabens, TXBuilt 1979 · S/N 414A0213N850RMDueck Arthur P · Lakewood, OHBuilt 1977 · S/N 421C0283N853MTK & T Inc · Salt Lake City, UTS/N 421C0602N855HSanford Larry D · Edmond, OKBuilt 1982 · S/N 414A0855N859DMDavis Mark E · Pearland, TXS/N 421C0859N85KSCnet Aviation LLC · Lindale, TXBuilt 1978 · S/N 421C0525N861HCN861hc LLC · Elk City, OKBuilt 1977 · S/N 421C0438N866KABad Aire LLC · Aledo, TXS/N 421C1255N866PMBluview Management LLC · Avon Park, FLS/N 421C0651N86AWMohave County Sheriff'S Office · Kingman, AZBuilt 1978 · S/N 414A0040N86PDTanric Aviation LLC · Tuscola, TXBuilt 1982 · S/N 414A0837N870VLCaribbean Flyers LLC · San Juan, PRBuilt 1981 · S/N 402C0616N871VLZee Enterprise Inc · Chicago, ILBuilt 1980 · S/N 402C0290N87386Golden Eagle Flyers Inc · Cheyenne, WYS/N 421C0168N87541Chadbourne Daniel I Jr · Anchorage, AKS/N 421C0007N87561Forest Aire LLC · Flagstaff, AZBuilt 1975 · S/N 421C0017N877JBOg Flights LLC · Dover, DEBuilt 1980 · S/N 421C0877N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605N878DMFly North 421 LLC · Helena, MTBuilt 1977 · S/N 421C-0413N87GKAlpha Zulu Aviation LLC · Spring, TXS/N 421C0131N87PPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 421C0206N880JSDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C-0489N8825GRichardson Dean A · St Thomas, VIFirst renewal noticeBuilt 1981 · S/N 404-0628N884LPBecton Aviation LLC · Lubbock, TXS/N 421C0102N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239N88537Gink2 LLC · Elkhorn, NEBuilt 1978 · S/N 421C0514N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240N88584Dallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0642N88604Trade Winds Aviation Holdings LLC · Lewes, DEBuilt 1978 · S/N 421C0604N88606N88606 LLC · Ely, IAS/N 421C0649N88646Eagle Air LLC · Garden Ridge, TXS/N 421C0630N88PEFirst Winds LLC · Norfolk, NES/N 421C0851N890CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1978 · S/N 402C0006N89ADClairmont Holdings Vi LLC · St Thomas, VIS/N 402C0115
Back to AD 95-09-13