OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,798

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

N17229Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28793N17233United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28943N17244United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28954N17245United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28955N172UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0867N1731WCollins Air LLC · Kennett, MOBuilt 1972 · S/N E-369N173KSCentralav LLC · Lake Worth, FLS/N FA-82N173MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N FL-1151N173PAN173pa LLC · Wilmington, DEBuilt 1982 · S/N 313N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028N173UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0868N174BFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 142N174CFTri Star Services LLC · Nashville, TNBuilt 1979 · S/N 501-0142N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429N174JSJr Simplot Co LLC · Boise, IDBuilt 2001 · S/N 560-0572N174TATracewings LLC · Goodyear, AZS/N E-3499N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73N174UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0869N17509Starke Charles H III · Weirsdale, FLBuilt 1976 · S/N E-972N17520Patterson William · Spring, TXBuilt 1976 · S/N E-974N1752WMichael S Austin Dmd Ms Psc · Utica, KYBuilt 1972 · S/N E-373N1755WAis Construction Equip Corp · Grand Rapids, MIBuilt 1972 · S/N E-374N17571De Oliveira Derek · Meadow Vista, CABuilt 1977 · S/N E-983N175AMStevens Daniel · Oak Creek, COS/N 421C1221N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006N175BGMile High Holdings LLC · Miami, FLBuilt 1983 · S/N 396N175CJFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 175N175JAir King Inc Trustee · Cheyenne, WYS/N 650-0168N175LKern Charter Service Inc · Bakersfield, CABuilt 1977 · S/N E-985N175PLTp Air LLC · Laredo, TXBuilt 2019 · S/N FL-1187N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183N17621Boe Mark · Morgan, UTBuilt 1977 · S/N E-992N17628Elliot Air LLC · Dunwoody, GABuilt 1977 · S/N E-993N17639Peterson Eric S · San Jose, CABuilt 1977 · S/N E-997N1763W63 Whiskey LLC · Seattle, WABuilt 1973 · S/N E-406N17653Coggin Randall · Longview, TXBuilt 1977 · S/N E-998N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005N176ALAllen Lund Co LLC · La Canada, CABuilt 2004 · S/N 560-0666N176DRKelly Daniel · Alpharetta, GAS/N E-3592N176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1974 · S/N LW-115N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884N176TLBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 258176N176TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N LW-76
Back to AD 2006-16-18 R1