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.

N130SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-130N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225N131SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-131N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132N132NFlying Cowboys LLC · Merced, CAS/N BB-1053N133BAAlpine Aviation Inc · Provo, UTBuilt 1986 · S/N UB54N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214N14VDouble D International LLC · Miami, FLS/N LJ-411N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531N150KJAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-150N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260N152WWNardi Greg · Missoula, MTS/N LJ-654N153GAAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N UB-34N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366
Back to AD 97-06-06