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.

N587CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1189N587TWAircraft Security Corp · Laredo, TXBuilt 1979 · S/N BB-587N588ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH-1843N588ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35685N588CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N TH-965N588PAirstar LLC · Lees Summit, MOBuilt 1994 · S/N TH-1725N588PCAustin Aviation LLC · Santa Ana, CABuilt 1999 · S/N E-3271N588PSTaylor 483 LLC · Albuquerque, NMBuilt 1996 · S/N 208B0588N588SAReach Air Medical Services LLC · Santa Rosa, CABuilt 2000 · S/N LJ-1588N588SDIal Corp · Lewes, DES/N LJ-1663N588TBac LLC · Aliceville, ALBuilt 1977 · S/N TH-791N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N589ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35686N589PUniversity Of Central Missouri · Warrensburg, MOBuilt 1989 · S/N TH-1559N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644N589TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N FL-254N589YDennis Aviation LLC · Bartlett, TNBuilt 1977 · S/N TH-852N58ARAnnis Aviation LLC · Gray, GABuilt 1987 · S/N TH-1525N58AYAviapa Flight LLC · Doylestown, PABuilt 1995 · S/N BB-1511N58BESouth Georgia Air LLC · Valdosta, GAS/N TH-2055N58BLHawker 800xp LLC · Fort Lauderdale, FLS/N 258236N58BSJordan Corporation · Jackson, MIS/N TH-1142N58BYFry Shawn Trustee · Baxter, TNBuilt 1970 · S/N TH-25N58CHChase Brandon C · Plains, KSBuilt 1978 · S/N TH-949N58CKMajestic Fleet LLC · Miami, FLBuilt 1974 · S/N TH-567N58DRocketman Rocketeers Lc · Austin, TXBuilt 2005 · S/N 560-0690N58DAUniversity Of Central Missouri · Warrensburg, MOBuilt 1984 · S/N TH1402N58DCDream Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1206N58DHAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2002 · S/N 258599N58DLHam John T · Murfreesboro, TNBuilt 1975 · S/N TH-692N58ELN1107u LLC · Lewisville, NCBuilt 1979 · S/N TH-1003N58ERPersonnel Aviation Services LLC · Bloomfield Hills, MIBuilt 2023 · S/N 525-1157N58EVLittle Tree Aeromotive LLC · Banner Elk, NCBuilt 1976 · S/N TH-704N58GELje Air LLC · Park Ridge, ILBuilt 1985 · S/N TH-1480N58GFCollier Air LLC · Fernandina Beach, FLBuilt 2004 · S/N TH-2095N58GKMvm LLC · Lewes, DEBuilt 1976 · S/N TH-763N58GWAlpha Whiskey LLC · Easton, PAS/N TH-2048N58HCMedina Sky LLC · Medina, OHBuilt 1975 · S/N TH-637N58HLGreen Button Holdings LLC · Overland Park, KSBuilt 1999 · S/N 279N58HWHotel Whiskey LLC · Sylvania, OHS/N TH-2058N58JZAcv Group LLC · Mckinleyville, CABuilt 1976 · S/N TH-710N58KERacego Corp · San Juan, PRBuilt 1978 · S/N TH-921N58KTBarron Equipment Leasing LLC · Port Washington, NYBuilt 2000 · S/N TH-1955N58LDHenderson Leon Jr · Ellisville, MSBuilt 1985 · S/N TH-1472N58LFAckley Ray · Charlotte, NCBuilt 1972 · S/N TH-237N58MFTurk Mike F · Pinehurst, TXBuilt 1972 · S/N TH-279N58MHA Pro LLC · Hernando, MSBuilt 1995 · S/N TH-1752N58MSRegistration Pending · Oklahoma City, OKRegistration pending, canceledBuilt 1994 · S/N E-2889N58NDNorth Dallas Aviation Inc · Addison, TXBuilt 1999 · S/N TH-1906N58PBDirect Flight LLC · Kitty Hawk, NCBuilt 1983 · S/N TH-1379
Back to AD 2006-16-18 R1