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.

N300TAMarshmont Aviation LLC · Greenville, SCS/N LA-9N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319N301PTDenaina Leasing Agency LLC · Anchorage, AKBuilt 1983 · S/N BP-028 82-23780N301TSNeptune Aviation Services Inc · Missoula, MTBuilt 1979 · S/N BE-76N301WYOrion Air Holdings LLC · Cheyenne, WYS/N BB-476N302CGKiowa Turbine LLC · Galesburg, ILS/N BB-1112N303CJLand Of Indiana Inc · Bedford, INBuilt 1979 · S/N BB-596N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495N305ELRoper Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB947N305LGEaglemed LLC · Wichita, KSBuilt 2001 · S/N BB-1789N307DMBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N BB-332N30GTCal Asset Holding LLC · Fresno, CABuilt 1980 · S/N LA-37N30SETradewinds 12/21 Inc · Denison, TXBuilt 1977 · S/N BB313N311GCRte Enterprises Inc · Canoga Park, CABuilt 1980 · S/N LA-55N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461N316GCMarc Aircraft Holding LLC · Soldotna, AKBuilt 1978 · S/N BB-430N318CBBrown 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 U49N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465N321FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1979 · S/N BC-70N321PDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1980 · S/N GR-10N321TRVertivue LLC · Allentown, PAS/N LA-48N323PXFehrs Aviation LLC · Seminole, TXBuilt 2002 · S/N BB-1803N3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeBuilt 1995 · S/N BB-1523N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553N327BADamandan Air Enterprises LLC · Gallatin, TNBuilt 1980 · S/N BE99N327LCNeptune Agricultural Group Inc · Vero Beach, FLS/N BB1427N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548N32LJCrocker LLC · Missoula, MTBuilt 1981 · S/N BB-993N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816N332JSSouth Coast Lumber LLC · Brookings, ORBuilt 2006 · S/N BB-1938N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702N333WTWright Aero Inc · Saint Cloud, MNBuilt 1980 · S/N LA-91N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514N341WBAndrews Worldwide LLC · Amarillo, TXBuilt 2005 · S/N BB-1885N343KKTreeline Transportation Inc · Vance, ALBuilt 1978 · S/N BE-46N346BALwcr Transportation Inc · Minot, NDBuilt 1999 · S/N BB-1653N349ARAcademy 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-1437N34UPCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N BC-006N350TCFobl Inc · Juana Diaz, PRBuilt 1979 · S/N BE-62
Back to AD 96-03-13