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.

N7862RUas Transervices Inc · Boca Raton, FLFirst renewal noticeBuilt 1969 · S/N U-85N786DDTransouth Leasing LLC · Longview, TXS/N BB-1171N789CTKingfisher Associates LLC · Wilmington, DEBuilt 1981 · S/N BB-820N78DARegistered aircraftBuilt 1976 · S/N BE-11N791DCExecutive Air Taxi Corporation · Bismarck, NDBuilt 1991 · S/N BB-1402N791EBSav Aviation LLC · Jacksonville, TXBuilt 1980 · S/N BB791N793DCBillings Clinic · Billings, MTBuilt 1991 · S/N BB-1404N795PAPdx LLC · Indianapolis, INS/N BB-328N797KDDodson International Parts Inc · Rantoul, KSS/N BL68N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68N799DDRenfro Michael W · Bethel, AKBuilt 1971 · S/N B-102N799MCPerry King Air LLC · Perry, GABuilt 1982 · S/N BB-998N79DMKsg Capital LLC · Casper, WYBuilt 1981 · S/N BB-853N79EFPonca International LLC · Ponca, ARS/N BB1350N7NANasa Armstrong Flight Research Center · Edwards, CABuilt 1982 · S/N BB-997N800BSM&F Western Products Inc · Sulphur Springs, TXBuilt 1998 · S/N BB-1620N800PKFarmers Oil Co Inc · Anthony, KSBuilt 1981 · S/N BB-982N800TSPetrie Motor Company Inc · Lake Worth, TXBuilt 1982 · S/N BB-1032N801NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1983 · S/N BB-1164N802BAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-29N803HCH J King Air LLC · Madison, GAS/N LA-99N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724N806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLS/N BC-22N806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1981 · S/N BB990N806LWSac Wild LLC · Loomis, CABuilt 1994 · S/N BB-1494N806WBCircle I Air LLC · Lubbock, TXBuilt 1982 · S/N BB-1047N807SMAurora Air Partners LLC · Portland, ORBuilt 2007 · S/N BB-1989N808BESkyfall Aviation LLC · Blacksburg, VABuilt 1988 · S/N BB-1312N809HCCourson Oil And Gas Inc · Perryton, TXS/N BB-1864N809PSP & P Air LLC · Wilmington, DEBuilt 1978 · S/N BB-339N80CPBf Air LLC · Panama City, FLBuilt 1977 · S/N BB-263N80WMAt Aero LLC · Wilmington, DES/N BB-863N812GBTrinity Logistics Holdings LLC · Saint Johns, FLBuilt 1980 · S/N LA-72N812TTBranched Oak Charter LLC · Rising City, NEBuilt 1985 · S/N BB-1207N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55N816BSN811kc LLC · Sunrise, FLBuilt 1992 · S/N BB-1440N817BAZane Bennett Galleries LLC · Santa Fe, NMBuilt 1981 · S/N BB956N818FWPelican Aircraft Inc · Wilmington, DEBuilt 1991 · S/N BB-1394N81ETRussell Timothy Lee Jr · Saint Petersburg, FLBuilt 1998 · S/N BB1625N81TFA P A C LLC · Berlin, NJBuilt 1980 · S/N BB-750N81TLC S & P Rocky Mountain Inc · Cheyenne, WYS/N BB-959N820DLEs&E Aviation LLC · Greensboro, NCS/N BB-1820N821CBEz Transportation Inc · Rosharon, TXBuilt 1977 · S/N BE-35N825KASav Aviation LLC · Jacksonville, TXS/N BB-825N825STLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1989 · S/N BB-1320N826WGSibi LLC · Indianapolis, INBuilt 2000 · S/N BB-1710N828SSSusanaire LLC · Dallas, TXBuilt 1986 · S/N BB-1252N829MCKidd Johnston Aviation LLC · Odessa, TXBuilt 2000 · S/N BB-1708N831MWKdm Ltd · Santa Teresa, NMS/N BB-1850N831WPVagus Group Inc · Wilmington, DEBuilt 1979 · S/N BB-569
Back to AD 96-03-13