AD 97-06-06

Registered aircraft · 2,038

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:97-06-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06')
  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.

N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554N155CJUe-55 LLC · Helena, MTS/N UE-55N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286N1560Davis Aviation Inc · Brandon, MSS/N BC-09N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156N157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N UE157N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157N159SFSuburban Air Freight Inc · Omaha, NEBuilt 1991 · S/N UC-159N15GABering Air Inc · Nome, AKS/N UE37N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32N162GCUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N BB-1238N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60N164WSBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1736N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054N1685SBella Vista Transportation & Rentals LLC · Dunnellon, FLS/N LJ-1685N169DRLegacy Aviation LLC · Tea, SDBuilt 1989 · S/N LJ-1205N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169N169RWJorgensen Air Service LLC · Puyallup, WABuilt 1982 · S/N BB-1030N16CMBartholow Rental Co Inc · Wylie, TXBuilt 1997 · S/N BB-1580N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647N16KWWild Blue Aviation LLC · Wilmington, DEBuilt 1996 · S/N LJ-1435N16TMTriad Physician Resources Inc · Longview, TXBuilt 1998 · S/N LJ-1507N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28N170SEGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N LJ-1708N171CJBering Air Inc · Nome, AKBuilt 1993 · S/N UE-71N171MSStick Ball Rudder LLC · Bonita Springs, FLBuilt 2002 · S/N LJ-1668N172EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-172N172GAAlpine Aviation Inc · Provo, UTS/N UB-11N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028N174AVUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-174N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006N175EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-175N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3
Back to AD 97-06-06