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.

N578RLValiair Limited Co Trustee · Casper, WYBuilt 1999 · S/N 258397N579ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35187N579BJCurly LLC · Santa Maria, CABuilt 1996 · S/N 560-0383N579DLee David · Palm Springs, CAS/N D-369N579DMDiggins David A · Corpus Christi, TXS/N E-1769N579TXLaw Offices Of Douglas D Ketterman Pllc · San Antonio, TXBuilt 1994 · S/N 525-0061N57BJPlukair Delaware LLC · Wilmington, DES/N S550-0052N57ECSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 2001 · S/N 525-0460N57FWilliams John E · Oak Ridge, TNBuilt 1948 · S/N D-1273N57FCFun Flyers LLC · Portland, ORBuilt 1981 · S/N 501-0229N57FSFobl Inc · Juana Diaz, PRBuilt 1991 · S/N 6500204N57FTS & H Holdings LLC · Wichita, KSS/N BB-136N57GAKa73 LLC · Little Rock, ARBuilt 1979 · S/N BB-477N57GGGerhart Gary Elmer · Houston, TXBuilt 1978 · S/N E-1385N57GTCci Air LLC · Gary, INBuilt 2013 · S/N FL-854N57PGulf Sierra Aviation LLC · Owasso, OKBuilt 1979 · S/N TH-1059N57PASpieker Warren E Jr · Menlo Park, CABuilt 1992 · S/N BB-1444N57RBDavis Timothy M · Yelm, WABuilt 1979 · S/N E-1572N57RFUnited States Department Of Commerce · Lakeland, FLBuilt 1981 · S/N 688N57SBRadkey Edward B · Humble, TXBuilt 1979 · S/N E-1467N57VABigups Aviation 012 LLC · Van Nuys, CABuilt 1996 · S/N FL-154N57VYEuroaviation Inc Trustee · KematenS/N 525-0371N57WAE2 Hangar LLC · Folsom, CAS/N 421C0451N580AHMadeline Inc · Clarkston, MIS/N TH-2027N580BAN Flight LLC · Kenedy, TXBuilt 2007 · S/N BB1975N580BDAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1997 · S/N 525-0209N580BKJohn Newcomb Enterprises Inc · Blacksburg, VABuilt 1982 · S/N BB-1000N580BXPreferred Management Corp · Shawnee, OKS/N TH-2124N580CLBravo Ventures LLC · Reedsburg, WIBuilt 2008 · S/N 560-0780N580EN580e LLC · Hickory, NCBuilt 1995 · S/N TH-1758N580EXCessna Caravan Adventures LLC · Miami, FLBuilt 2020 · S/N 208B5580N580JKMarshall John · Cold Spring, MNBuilt 1977 · S/N TH-792N580RAGibson & Harrup Leasing LLC · North Dinwiddie, VABuilt 1973 · S/N LJ-580N580SBott Radio Network Inc · Gravois Mills, MOBuilt 1979 · S/N BE-77N580UPC C & E I LLC · Louisville, KYS/N 25632N580WFry Michael David · Madeira Beach, FLBuilt 1976 · S/N TH-774N580ZTaft Enterprises LLC · Wilmington, DEBuilt 2008 · S/N 525-0672N581AFAirtrust LLC 11 Series 11 Trustee · Sheridan, WYBuilt 2003 · S/N TH-2063N581ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35188N581CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1183N581ECoobac Dean P · Alpine, WYBuilt 1973 · S/N TH-423N581GHarper Abe L Jr · Daphne, ALBuilt 1976 · S/N TH-716N581KBFenn Farms Inc · Durham, CABuilt 1975 · S/N E-786N581LCCougar Inc · Ridgeland, MSS/N TH-2049N581MBSan Bernardino County California · San Bernardino, CABuilt 2022 · S/N FL-1303N581PFFox Arrow 542 LLC · Jonesboro, ARBuilt 1993 · S/N TH-1707N581PSBonanza Aviation LLC · Wilmington, DEBuilt 1999 · S/N TH-1903N581RFFrederick Ronald M · Dallas, TXS/N TH-2057N581SACalifornia Industrial Rubber Co Inc · Fresno, CABuilt 2000 · S/N TH-1942N581SHShowtime Aviation LLC · Frostproof, FLBuilt 2001 · S/N TH-2011
Back to AD 2006-16-18 R1