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.

N890VPDodson International Parts Inc · Rantoul, KSS/N BB-1116N896CMXrp Investments LLC · Clyde, MIBuilt 1980 · S/N BB-668N898BRElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1986 · S/N BB-1255N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104N899CZN899cz LLC · Milwaukee, WIS/N U-96N899SDRed Rock Aviation LLC · Dover, DEBuilt 1981 · S/N BB-776N89JLDag Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N LA19N89MVLegacy Aviation Trust Holdings Corp Trustee · Doral, FLS/N BB-766N89UABoard Of Trustees · Fayetteville, ARBuilt 1989 · S/N BB-1336N8AMMraf LLC · Wilmington, DEBuilt 1977 · S/N BB-274N8EFMcco Inc · Tuscumbia, ALBuilt 1980 · S/N BB-721N8KBBiddulph Oldsmobile Inc · Phoenix, AZBuilt 1978 · S/N BB-446N8NAN8na LLC · Atlantic Beach, FLBuilt 1981 · S/N BB-950N8NXExecutive Aviation Group Inc · Saint Petersburg, FLBuilt 1980 · S/N BB-774N901BABismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N BB-674N901FFFlightline Holdings II LLC · New Orleans, LABuilt 1980 · S/N BB-637N901LMLifeflight Of Maine LLC · Bangor, MEBuilt 1999 · S/N BB-1693N901PSDavis Aviation Inc DBA · Brandon, MSBuilt 1979 · S/N LA-5N901SFSingleton Investments LLC · Menlo Park, CABuilt 2004 · S/N BB-1859N902VDDavis Aviation Inc · Brandon, MSS/N B-201N903TWTwi Air LLC · Picayune, MSS/N BB-1822N904DGCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1983 · S/N BB-1176N904SHSanford Medical Center · Sioux Falls, SDBuilt 1998 · S/N BB-1614N905NDDodson International Parts Inc · Rantoul, KSS/N BB-468N905SHSanford Medical Center · Sioux Falls, SDS/N BB-1582N906DCHarrington Douglas R Jr · League City, TXFirst renewal noticeBuilt 1982 · S/N BB-1094N907GSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N BB-905N908MHMeadows Homes Inc · Cookeville, TNBuilt 2001 · S/N BB-1781N90AMTexas A And M University · College Station, TXBuilt 1989 · S/N BB-1328N90FAirborne Flight Ops Inc · Reno, NVS/N LA-235N90HKSantana Trading LLC · Edinburg, TXBuilt 1982 · S/N LA-176N90RTFlavin Development LLC · Lake Charles, LABuilt 1981 · S/N LA-146N90SBDavidson Logistics Inc · Bridgeton, MOBuilt 1981 · S/N LA-154N90TDMike Russell Construction Inc · Marysville, CABuilt 1982 · S/N LA-183N90TPFairview Air LLC · Fresno, CABuilt 1980 · S/N LA-66N90UAUniversal Avionics Systems Corp · Tucson, AZBuilt 1980 · S/N LA-21N910AJL'Eagle Air II Inc · Newark, DEBuilt 1981 · S/N BB-910N910KGLg Air LLC · Baton Rouge, LABuilt 1983 · S/N BB1051N911CFCustom Flight Rnh LLC · New Richmond, WIBuilt 1979 · S/N LA-13N911CMPhi Health LLC · Tempe, AZBuilt 1996 · S/N BB-1551N911RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1992 · S/N BB-1425N911SFReiner Russell · Redding, CABuilt 1999 · S/N BB-1659N912MNAvera Mckennan · Sioux Falls, SDBuilt 1993 · S/N BB1468N912SVSaint Vincents Healthcare · Billings, MTBuilt 1988 · S/N BB-1299N913RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1993 · S/N BB-1471N914SHSanford Medical Center · Sioux Falls, SDBuilt 1999 · S/N BB-1688N918BBAlco Aviation Services Consulting LLC · Taft, TNBuilt 1980 · S/N LA113N918CACalifornia Highway Patrol · Sacramento, CABuilt 1978 · S/N BC-57N918DDDiamond D Aviation LLC · Sulphur, LABuilt 1999 · S/N BB-1677N918MMVegetable Flight Resources LLC · Portland, ORBuilt 1980 · S/N LA-52
Back to AD 96-03-13