AD 96-03-13

Registered aircraft · 1,042

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:96-03-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:96-03-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.

N351KBKabco Aviation LLC · Boaz, ALBuilt 2002 · S/N BB-1904N351SAGuardian Flight LLC · Lewisville, TXBuilt 1992 · S/N BB1423N3532North Delta Ag Aviation LLC · Sledge, MSBuilt 1977 · S/N BE-31N3536Vantage Aviation USA LLC · Tampa, FLBuilt 1979 · S/N BE72N3538New Mountain Aviation LLC · Englewood, COBuilt 1978 · S/N BE-57N3539Thacker Aircraft Holding LLC · Lubbock, TXBuilt 1982 · S/N BE-124N357CCWhitestone Aviation LLC · Orlando, FLBuilt 1982 · S/N LA-180N3606TSunshine Aero Industries Inc · Crestview, FLBuilt 1970 · S/N B30N360BLBachman Aviation LLC · Independence, IAS/N BE17N360EASai Flight Services Inc · Greer, SCS/N BB-1231N360XNavecord Institute · Wilmington, DES/N BB-1783N361EAAlcyone Trust Corp Trustee · Wichita, KSS/N BB-1103N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741N361TDSequoia Beverage Co Lp DBA · Visalia, CABuilt 1986 · S/N BL-128N3620MSanford Medical Center · Sioux Falls, SDBuilt 1991 · S/N BB-1396N363DFreeman Holdings Of West Texas LLC · Medford, ORBuilt 1995 · S/N BB-1503N363JHBering Air Inc · Nome, AKBuilt 2002 · S/N BB-1799N36987Westflight LLC · Yuma, AZBuilt 2004 · S/N BB-1887N370CSReach Air Medical Services LLC · Santa Rosa, CABuilt 1996 · S/N BB-1550N370PRPuerto Rico International Airlines Inc · San Juan, PRBuilt 1969 · S/N B-6N372JBUltra Property Acquisitions LLC · Edinburg, TXBuilt 1980 · S/N BB-719N375JPAir T-Jam LLC · Uniontown, PABuilt 2003 · S/N BB1833N377JEAcr Advertising LLC · Jasper, INS/N BB-1843N378ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-14N378SFTrigg David D · Houston, TXBuilt 1978 · S/N BB-378N379ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-15N379EKAvtrust LLC Trustee · Wilmington, DEBuilt 2001 · S/N BB-1769N3809CRepublic Refrigeration Inc · Monroe, NCBuilt 1981 · S/N LA-112N380ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-26N380JPPaalmc Llv · Shreveport, LAS/N BB-1889N381ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-35N381HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1952N381RUc Aviation Holdings LLC · Union City, TNBuilt 1978 · S/N BB-385N382ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-36N383ATAirtrex Aircraft Juliet Inc · Wichita, KSS/N FE-10N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615N384ATAirtrex Aircraft Kilo Inc · Wichita, KSS/N FE-23N385ATAirtrex Aircraft Lima Inc · Wichita, KSBuilt 1989 · S/N FE-22N389RAAirtrex Aircraft Xray Inc · Wichita, KSBuilt 1986 · S/N BL-56N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313N390RHAlpine Aviation Inc · Provo, UTS/N U-39N390SPState Of Arkansas · Little Rock, ARS/N BB-1970N393JWGeneration Jets LLC · Denison, TXBuilt 1977 · S/N BB-292N395AMHollan Air LLC · Amarillo, TXS/N BB-1101N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421N399ALBallard Aviation Inc · Newton, KSS/N BB-1623N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91N399TWArx Air LLC · Windermere, FLBuilt 1983 · S/N LA-203N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2
Back to AD 96-03-13