AD 90-02-13

Registered aircraft · 3,863

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:90-02-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:90-02-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.

N21FC310 Pals LLC · Lake City, FLBuilt 1974 · S/N 310Q1080N21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 310R-1580N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209N21HAEngle Scott · Plymouth, MNS/N 310R1850N21KBLow Carl S III · Aurora, TXBuilt 1973 · S/N 310Q0777N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439N21MTTarrant County College · Fort Worth, TXBuilt 1967 · S/N 320F-0017N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650N2207FAnderson Mike DBA · Muskogee, OKS/N 310L-0007N220BRSimmonds Gary Bert · San Antonio, TXBuilt 1977 · S/N 310R0973N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459N220HDAce Transport Service Inc · Wilmington, DEBuilt 1975 · S/N 310R0593N2211FSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1960 · S/N 39235N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011N2212ASiewart Michael · Columbus, OHS/N 310G-0018N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014N221MBMendenhall Carl T · Sophia, NCBuilt 1966 · S/N 310L-0021N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021N222AWJust Planes Inc · Hobbs, NMFirst renewal noticeBuilt 1969 · S/N 310P-0106N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264N222DJGarone Michael A · Miami, FLBuilt 1967 · S/N 310L-0202N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823N222FWLindsey Daniel Rey · Clovis, NMS/N 310I0002N222LTwo Motor Odor LLC · Paris, TXS/N 320E-0053N222PEPacific Air Charters Inc · Honolulu, HIBuilt 1976 · S/N 310R0632N222PLAnderas Per R · Green Bay, WIS/N 414A0521N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164N2232FPritchard Dale G · St Maries, IDBuilt 1966 · S/N 310L-0032N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036N223HWatson James E Jr · Victor, COBuilt 1956 · S/N 35385N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105N2240FFenco Holdings Inc · Cheyenne, WYS/N 310L0040N2241FHaag Douglas A · Collierville, TNBuilt 1967 · S/N 310L-0041N2244FSky King 44f LLC · Florence, SCBuilt 1966 · S/N 310L-0044N2249MSky Visions Photography LLC · Manitowoc, WIFirst renewal noticeBuilt 1966 · S/N 310L-0049N2252FAdh Enterprises Inc · Sherman, ILBuilt 1966 · S/N 310L-0052N2256FWesellairplanes.Com Inc · Wilmington, DES/N 310L-0056N2259FDemon21 LLC · Granville, OHBuilt 1966 · S/N 310L-0059N225LRice James M · Austin, TXBuilt 1965 · S/N 310J-0025N2265FRegistration Pending · Wilmington, DERegistration pendingBuilt 1967 · S/N 310L-0065N2266FTechnical Education Services Inc · Virginia Beach, VAS/N 310L-0066N2268FKephart Peter J · Washington, MOBuilt 1966 · S/N 310L-0068N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084
Back to AD 90-02-13