AD 96-09-13

Registered aircraft · 772

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

N31702Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-3N31703Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-10N31704Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-12N31705Uas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N UB-60N318CBBrown Flight Properties LLC · Midland, TXBuilt 2000 · S/N BB-1730N31FMKing Air Adventure LLC · Wilmington, DEBuilt 1981 · S/N BB-869N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49N323PXFehrs Aviation LLC · Seminole, TXBuilt 2002 · S/N BB-1803N324SAAtlantic Air Services 71991 Inc · Largo, MDBuilt 1989 · S/N UC-94N3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeBuilt 1995 · S/N BB-1523N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360N327LCNeptune Agricultural Group Inc · Vero Beach, FLS/N BB1427N32LJCrocker LLC · Missoula, MTBuilt 1981 · S/N BB-993N330AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-38N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230N331AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-44N332JSSouth Coast Lumber LLC · Brookings, ORBuilt 2006 · S/N BB-1938N332LCUc132 LLC · Dallas, TXFirst renewal noticeS/N UC132N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702N338AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC57N341WBAndrews Worldwide LLC · Amarillo, TXBuilt 2005 · S/N BB-1885N346AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC71N346BALwcr Transportation Inc · Minot, NDBuilt 1999 · S/N BB-1653N347AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC66N349ARAcademy Resources LLC · Taos, NMBuilt 2002 · S/N BL-144N34AKUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-105N34LTPaper Boys LLC · Dover, DEBuilt 1992 · S/N BB-1437N34RZUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-151N351KBKabco Aviation LLC · Boaz, ALBuilt 2002 · S/N BB-1904N351SAGuardian Flight LLC · Lewisville, TXBuilt 1992 · S/N BB1423N360EASai Flight Services Inc · Greer, SCS/N BB-1231N360XNavecord Institute · Wilmington, DES/N BB-1783N361EAAlcyone Trust Corp Trustee · Wichita, KSS/N BB-1103N361TDSequoia 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-1799N367SFSuburban Air Freight Inc · Omaha, NEBuilt 1989 · S/N UC-67N36987Westflight LLC · Yuma, AZBuilt 2004 · S/N BB-1887N370CSReach Air Medical Services LLC · Santa Rosa, CABuilt 1996 · S/N BB-1550N375JPAir T-Jam LLC · Uniontown, PABuilt 2003 · S/N BB1833N377JEAcr Advertising LLC · Jasper, INS/N BB-1843N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378N379EKAvtrust LLC Trustee · Wilmington, DEBuilt 2001 · S/N BB-1769N380JPPaalmc Llv · Shreveport, LAS/N BB-1889N381HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1952N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158N388AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-188
Back to AD 96-09-13