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.

N44KAHunter Aviation Of Tampa LLC · Saint Petersburg, FLBuilt 2000 · S/N BB-1711N450NANational Aerotech Aviation Delaware · Wilmington, DES/N U-92N453LCIron Aviation LLC · Bozeman, MTBuilt 1986 · S/N UB53N454DCEllis Dd King Air LLC · Midlothian, TXS/N BB-995N454TMKardecas Corp · Houston, TXBuilt 1995 · S/N BB-1507N456ESTripp Aviation LLC · Pearland, TXBuilt 1983 · S/N BB-1107N466MW1977 Holdings LLC · Visalia, CABuilt 1987 · S/N BB-1273N468SPPacific Mission Aviation · Hagatna, GUBuilt 1998 · S/N BB1639N469SLAngely Air LLC · Lewes, DEBuilt 1982 · S/N BB-1036N46CECentury Equipment Company Inc · Salt Lake City, UTBuilt 1994 · S/N BB1492N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394N474LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-74N479BRGunner Aviation LLC · Fayetteville, ARS/N BB-1179N479VATactical Aviation Inc · Wilmington, DEBuilt 1998 · S/N BB1601N480BRFive Diamond Aviation Holdings LLC · Draper, UTS/N BB1355N481HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1908N486ATMeo Holdings LLC · Newark, DES/N BB-1866N487NNDakota Equipment LLC · Bismarck, NDBuilt 1995 · S/N BB-1513N487VCOaklr LLC · New York, NYBuilt 2001 · S/N BB-1757N48CSMattias Transport LLC · Tucson, AZBuilt 1986 · S/N BB-1247N48PACbc Aviation LLC · Hayden, IDBuilt 1981 · S/N BB-996N48QDynamic Avlease Inc · Bridgewater, VABuilt 1981 · S/N BL48N4925TAir Services LLC · Spokane, WAS/N BB-1870N492GPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N BB-1326N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81N49UCUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC49N4QLFremont Motor Company Inc · Lander, WYBuilt 1981 · S/N BB-942N500FEBeech Transportation Inc · Eden Prairie, MNBuilt 1986 · S/N BB-1212N500HGEm Aviation Ka B200 LLC · Atlanta, GAS/N BB-1954N500LPMeri Acquisitions LLC · Kilgore, TXS/N BB-1141N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514N504GFOxford Advisory Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1156N505AWCsi 135 Division LLC · Albuquerque, NMBuilt 2001 · S/N BB-1755N505SPN505sp LLC · Ontario, CABuilt 1996 · S/N BB-1538N507GFBallard Aviation Inc · Newton, KSBuilt 2001 · S/N BB-1778N5092SGreat Plains Communications LLC · Blair, NEBuilt 2002 · S/N BB-1802N509FPPerdue Farms Inc · Salisbury, MDS/N BB-1886N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728N50KGTurbo Air Charter LLC · Boise, IDBuilt 1982 · S/N BB-1066N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504N50PACenterline Aviation Inc · Middletown, DEBuilt 1988 · S/N BB-1308N50XDynamic Avlease Inc · Bridgewater, VABuilt 1985 · S/N BB-1239N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746N511GAGeaux Aire LLC · Savannah, GABuilt 1993 · S/N BB1462N511TAAir Med Services LLC · Lafayette, LABuilt 1999 · S/N BB-1660N514TBFast Marketing Strategies LLC · Royal Oak, MDBuilt 1990 · S/N BB-1351N51RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-212N520DGDanzer Veneer Americas Inc · Darlington, PABuilt 2001 · S/N BB-1753N522TGSe Express LLC · South Lyon, MIBuilt 1985 · S/N BB-1209N524GMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BL-142
Back to AD 96-09-13