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.

N57BDynamic Avlease Inc · Bridgewater, VABuilt 1983 · S/N BL-67N57FTS & H Holdings LLC · Wichita, KSS/N BB-136N57GAKa73 LLC · Little Rock, ARBuilt 1979 · S/N BB-477N57PASpieker Warren E Jr · Menlo Park, CABuilt 1992 · S/N BB-1444N580BAN Flight LLC · Kenedy, TXBuilt 2007 · S/N BB1975N580BKJohn Newcomb Enterprises Inc · Blacksburg, VABuilt 1982 · S/N BB-1000N580SBott Radio Network Inc · Gravois Mills, MOBuilt 1979 · S/N BE-77N581EAElite Medical Air Transport LLC DBA · El Paso, TXBuilt 2002 · S/N BL-143N585CEAugusta Aviation Inc · Hilton Head Island, SCS/N BB1194N585RBPonderosa Aviation LLC · Safford, AZBuilt 1979 · S/N BB-528N586UCMegel Air LLC · Cleveland, GABuilt 1983 · S/N BB-1118N587TWAircraft Security Corp · Laredo, TXBuilt 1979 · S/N BB-587N58AYAviapa Flight LLC · Doylestown, PABuilt 1995 · S/N BB-1511N58QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeS/N BL8N593GGCircle S Air LLC · Wilmington, DEBuilt 1980 · S/N BB-593N597BAMca-Plane LLC · Grand Blanc, MIBuilt 2004 · S/N BB1851N597MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N BB-720N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89N59ALBilly Ray Casteel LLC · Russellville, ALBuilt 1983 · S/N LA-208N59BWStandridge Color Corp · Social Circle, GABuilt 1982 · S/N LA-170N59EKCrosby Richard · Macon, GAS/N LA-58N59MDynamic Avlease Inc · Bridgewater, VAS/N BB-1419N5AETenax Aerospace LLC · Ridgeland, MSS/N BB-1891N5AHEmpire Air LLC · Indio, CABuilt 1980 · S/N LA-53N5PXRed Poodles LLC · Boston, MABuilt 1979 · S/N BB-554N5STDe Paz Aviation LLC · Coral Gables, FLBuilt 1977 · S/N BB-289N600RKLc Whitford Co Inc · Wellsville, NYBuilt 2002 · S/N BB-1800N600WADothan Security Inc · Dothan, ALBuilt 1980 · S/N LA-71N601CWFree Bird Aviation LLC · Ridgeland, MSBuilt 1981 · S/N BB-842N6045STexoma Building Services LLC · Kingston, OKBuilt 1979 · S/N BE-65N605EAChip Aviation LLC · South Pittsburg, TNBuilt 1981 · S/N LA-129N605JDM2driver LLC · Midland, TXBuilt 1996 · S/N BB-1555N6069AAt Aero LLC · Wilmington, DEBuilt 1978 · S/N BB-357N606CMSeagull Aviation LLC · Larkspur, CABuilt 1981 · S/N LA-163N607FJGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1963N60RADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N BT-7N60TJArk Leasing Inc · Newport Beach, CABuilt 1977 · S/N BE-21N610TANorth Flight Aero Med · Traverse City, MIBuilt 1998 · S/N BB-1609N611SDGreen Diamond One LLC · Knoxville, TNBuilt 1988 · S/N BB-1307N613GAGaf Holdings Inc · Visalia, CABuilt 2005 · S/N BB-1909N613TAWild Blue Aviation LLC · Wilmington, DEBuilt 1997 · S/N BB-1581N618United States Department Of Interior · Boise, IDBuilt 1990 · S/N BB-1378N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484N619DDPark Avenue Group Inc · Stuart, FLBuilt 1980 · S/N BE-92N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458N61APTrewhitt Jamie Mcmahan · Pacific Palisades, CAS/N BB-1192N61AYAonvo Investment LLC · North Miami, FLS/N BB575N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438N61PCN61pc Leasing LLC · Ponca City, OKBuilt 1994 · S/N BB-1483N61PEHc4 LLC · Fair Play, SCBuilt 1983 · S/N BB-1132
Back to AD 96-03-13