AD 83-07-14

Registered aircraft · 878

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

N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206N132NFlying Cowboys LLC · Merced, CAS/N BB-1053N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177N140RLN140rl 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-585N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50N150YDSfh 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-260N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554N15KALighthouse 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-1238N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655N169RWJorgensen 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-1647N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167
Back to AD 83-07-14