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.

N200GPWesley Partners II LLC · Mount Vernon, TXBuilt 1994 · S/N BB1496N200GSNavajo Nation · Window Rock, AZFirst renewal noticeS/N BB--1214N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568N200HDCooper Container Corp · Maynardville, TNBuilt 1981 · S/N BB-987N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40N200JREngelman Acres Ltd · Edinburg, TXBuilt 1983 · S/N BB-1123N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691N200PHPrairie Ventures Aviation LLC · Worthington, MNFirst renewal noticeBuilt 1977 · S/N BB-238N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410N200RELw164 Inc Trustee · Wilmington, DEBuilt 1975 · S/N LW-164N200RMMps Enterprises LLC · North Platte, NEBuilt 1973 · S/N LW-45N200RRTexas Dept Of Criminal Justice · Huntsville, TXBuilt 1987 · S/N BB-1282N200UOhio University · Albany, OHBuilt 1995 · S/N LJ1389N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201N202FFBeech Transportation Inc · Eden Prairie, MNBuilt 2001 · S/N BB-1786N202NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB1611N202UXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-202N203DHGuardian Flight LLC · Lewisville, TXFirst renewal noticeS/N BB-1845N203PCEaton Brothers Transportation LLC · Riverside, MOS/N LW-258N203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 1976 · S/N LW-203N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164N204AFUas Transervices Inc · Boca Raton, FLS/N U-204N204JTBarbaro Enterprises LLC · Argyle, TXBuilt 1997 · S/N BB1563N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115N2050ATia Aeronautics Inc · Harlingen, TXBuilt 1978 · S/N LJ-813N205EJLynch Flying Service Inc DBA · Billings, MTBuilt 1998 · S/N BB-1634N205MSJustice Air Inc · Farmingdale, NYBuilt 1981 · S/N LJ-948N205SPState Of Colorado · Englewood, COS/N BB-1826N205STPate & Pate Air LLC · Andalusia, ALBuilt 1981 · S/N LJ-965N205TMSmitty'S Supply Inc · Roseland, LABuilt 2007 · S/N BB-1991N206AVUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-206N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516N207PDale Aviation · Rapid City, SDBuilt 1995 · S/N LJ-1406N207SBBlackbird Aero LLC · Boca Raton, FLS/N B-69N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851N208SRBardoo Urias L · Massapequa, NYBuilt 1974 · S/N B208N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827N20FDGilmer Aircraft Leasing LLC · Wilmington, DEBuilt 1998 · S/N LJ-1528
Back to AD 97-06-06