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.

N918MTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1983 · S/N LA-211N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824N91MFCkw Aviation LLC · Dalhart, TXBuilt 1980 · S/N BB-657N91RKAir Flight Inc · Fort Lauderdale, FLBuilt 1976 · S/N B-226N921AZArizona Department Of Public Safety · Phoenix, AZBuilt 1988 · S/N BB-1287N921MFPuerto Coral Corp · Wilmington, DEBuilt 1980 · S/N LA62N922ALBallard Aviation Inc · Newton, KSS/N BB1529N923ASDjp Properties LLC · Selma, CABuilt 1979 · S/N BB-541N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483N924JBN924jb LLC · Little Rock, ARBuilt 2004 · S/N BB-1849N926TJBlackhawk Consulting LLC · Raceland, LABuilt 1999 · S/N BB-1662N928KAction Offshore LLC · Port Arthur, TXBuilt 1998 · S/N BB-1608N928KLKa-B200 LLC · San Angelo, TXBuilt 1994 · S/N BB-1482N929BWSkyway K LLC · Middletown, DEBuilt 1998 · S/N BB-1630N92JTHigh Shadow LLC · Roach, MOBuilt 1980 · S/N LA-73N92WCAviation Group LLC · Wilmington, DEBuilt 1989 · S/N BB-1330N933RTZito Aviation LLC · La Salle, COS/N BB-955N935AJDouble C Air LLC · Sacramento, CABuilt 1981 · S/N BB-935N93AMAsm Aviation LLC · Bismarck, NDBuilt 1982 · S/N LA166N93GTDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N B-179N93SFArctic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-13N93VDAbsl Construction · Hayward, CABuilt 1972 · S/N B-118N93WTWes Tex Drilling Company · Abilene, TXBuilt 1979 · S/N BE-80N940HCAll Aviation LLC · Hudson, WIBuilt 1988 · S/N BB-1303N942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNBuilt 2000 · S/N BB-1731N944CWby Enterprises II LLC · Jackson, TNBuilt 2001 · S/N BB-1749N944LSJmb Air LLC · Algona, IABuilt 1979 · S/N BB-604N948CEPro-Serve Aviation LLC · Englewood, COBuilt 2000 · S/N BB-1736N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98N949BWBering Air Inc · Nome, AKS/N BB-1763N949CFTee Pee Wings LLC · San Angelo, TXS/N BB-1828N949MAMajestic Aviation LLC · Billings, MTBuilt 2002 · S/N BB-1795N949REAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1981 · S/N BB-949N94PGM Wall Inc · Chesapeake, VAFirst renewal noticeBuilt 1983 · S/N LA-205N950AAAlpine Aviation Inc · Provo, UTBuilt 1974 · S/N U-159N950MBLos Angeles County Sheriffs Department · Long Beach, CABuilt 1990 · S/N BB-1372N953AJS A Comunale Co Inc · Barberton, OHBuilt 2000 · S/N BB-1723N953RCRmc Aviation LLC · Trumann, ARBuilt 1980 · S/N BE-94N954MSBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N BB-1649N954ZAZulu Air LLC · Opa Locka, FLBuilt 2000 · S/N BB-1712N957CBBd Air LLC · Battle Ground, WABuilt 1998 · S/N BB-1624N95GADrco Aviation LLC · Matthews, MOBuilt 1993 · S/N BB1467N95LMT L Irrigation Co · Hastings, NES/N BB-1956N95TTKelly Air LLC · Cedar Falls, IABuilt 1981 · S/N BB-917N95UTPacificorp · Portland, ORBuilt 2001 · S/N BB-1759N95WAAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U-6N960JPElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1983 · S/N BB-1163N969MAVenable Group LLC · Tupelo, MSBuilt 1981 · S/N BB-894N96AMTexas A&M University System · College Station, TXBuilt 2000 · S/N BB-1713N96CESummit Air Leasing LLC · Portage, MIBuilt 1996 · S/N BB-1536
Back to AD 96-03-13