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.

N737PM & E Horizons LLC · Slatington, PABuilt 1994 · S/N E-2908N737RJMcml Ventures LLC · Orlando, FLBuilt 1981 · S/N 5010238N7385RCw Aircraft LLC · Atlanta, GABuilt 1976 · S/N TH-734N7388RPeitz Russell W · Sebring, FLBuilt 1974 · S/N E565N738TFester John P · Sullivan, MOS/N TH-706N7392RJohnson Franklin H · Tyler, TXBuilt 1974 · S/N E-579N7396RBaja Aviation LLC · Northbrook, ILBuilt 1974 · S/N E-580N73CAShelor Investments LLC · Christiansburg, VAS/N TH-1889N73HKWilmington Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 21957N73HMTrn Aviation LLC · Lewes, DES/N 421C0234N73LHWillow Shade Ltd · Englewood, COBuilt 2016 · S/N 20800588N73LRFalcon N73lr LLC · Belton, TXBuilt 1974 · S/N 35N73MCCoastal Helicopters LLC · La Verne, CABuilt 1973 · S/N LJ-600N73MVPlantation Air LLC · Spartanburg, SCS/N E-3583N73PGFirst Financial Bankshares Inc · Abilene, TXBuilt 2000 · S/N LJ-1607N73PHBronson Air LLC · Thebes, ILBuilt 1979 · S/N LJ-875N73RFRandigo LLC · Wilmington, DEBuilt 1991 · S/N 208B0289N73SMBrown Michael · Gardnerville, NVS/N E-2961N73WCBrs 73wc LLC · Santa Ana, CABuilt 1996 · S/N FL-135N740ASAlaska Aviation Museum · Anchorage, AKBuilt 1981 · S/N 22578N740FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 559N740FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0484N740JMTailwinds LLC · Houston, TXBuilt 1985 · S/N S550-0027N740PCOglethorpe Power Corp · Tucker, GABuilt 2016 · S/N FL-1069N740RBSummit Capital Partners Aviation Services LLC · Houston, TXBuilt 2007 · S/N 560-0752N740RVPlane7 LLC · Fort Lauderdale, FLBuilt 2023 · S/N 208B5760N740TTValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 258644N741CCBlake Aviation Enterprises LLC · Fort Worth, TXBuilt 1997 · S/N 525-0227N741ESSmith Edward B · Slidell, LABuilt 1981 · S/N E-1915N741FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 611N741FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0486N741LFValley Aviation Inc · Lake Lillian, MNBuilt 1979 · S/N E-1529N741WCLynchburg Shipyard Inc · Highlands, TXBuilt 2011 · S/N FL-741N742CKKalitta Air LLC · Ypsilanti, MIS/N 24424N742FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 613N743CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26350N743FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 630N743LLLandlocked Company LLC · Dover, DES/N 743N743TIsr Aviation LLC · Lewes, DEBuilt 1976 · S/N E-802N7444Tytex LLC · Dallas, TXS/N E1520N744ARTop Air Texas LLC · Glendale, CABuilt 2001 · S/N 316N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014N744CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26353N744FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 664N744FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0492N744PCCorzon Aircraft Sales LLC · Highland Park, ILBuilt 2003 · S/N BB-1815N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043N745CKKalitta Air LLC · Ypsilanti, MIBuilt 1998 · S/N 26361N745EALaurel Road Properties LLC · Morehead City, NCBuilt 2001 · S/N BB-1745N745FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 668
Back to AD 2006-16-18 R1