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.

N806RTIkhana Aircraft Holdings LLC · Murrieta, CAS/N 009N806SQBeco Aviation LLC · Nevada, TXBuilt 1996 · S/N 650-7060N806TPickering Jeff C · Paris, TXBuilt 1973 · S/N E-423N806TCAviation Resource Group Inc · Fort Lauderdale, FLS/N 258364N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081N806WBCircle I Air LLC · Lubbock, TXBuilt 1982 · S/N BB-1047N806XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61786N8072DLong Jill A · Apo, AES/N E-2728N8073WKilo Mike LLC · Nancy, KYBuilt 1992 · S/N E-2730N8077MKriessler Scott C · Port Clinton, OHBuilt 1990 · S/N E-2565N8077XTudor George J · Mecca, CABuilt 1990 · S/N E-2534N807AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258597N807BFSale Reported · Bishop, CASale reportedBuilt 1976 · S/N 194N807BWTejama LLC · Amarillo, TXBuilt 2003 · S/N 560-0640N807DJGreat West Produce Co Inc · Commerce, CABuilt 2001 · S/N E-3371N807DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31921N807EVRegistered aircraftS/N 208B0807N807FERegistration Pending · Mountain View, CARegistration pendingBuilt 1987 · S/N 208B0041N807JAAv Serv LLC · Dover, DEBuilt 1985 · S/N 20800075N807JCGwu LLC · Saint James, MOBuilt 2002 · S/N 560-0602N807NHJohnson Gregory D · Elkhart, IAS/N E-2704N807NNAmerican Airlines Inc · Fort Worth, TXS/N 31077N807SMAurora Air Partners LLC · Portland, ORBuilt 2007 · S/N BB-1989N807THSan Mateo Real Estate Inc · San Mateo, CABuilt 1977 · S/N TH-807N807UPWheels Up Partners LLC · New York, NYBuilt 2013 · S/N FL-892N807USRegistration Pending · Miami, FLRegistration pendingS/N 807N807XAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 63406N80809Davis Aviation Inc DBA · Brandon, MSBuilt 2010 · S/N FL-729N8080PPiper Llp · Decatur, ALBuilt 1992 · S/N E-2736N8082RJ M Rowland Aviation LLC · Eastman, GABuilt 1969 · S/N E-152N8083FTindall Haul And Erect Corp · Spartanburg, SCBuilt 1993 · S/N E-2771N8085NRandall Daniel Ronald · Minneapolis, MNS/N E-2740N8087RCavanaugh Robert K · Valparaiso, INBuilt 1992 · S/N E-2738N8088JPhillips Robert Carroll III · Waxhaw, NCBuilt 1990 · S/N E-2502N808ACInterwings Aircharter Corp · Lewes, DEBuilt 1995 · S/N 560-0323N808BESkyfall Aviation LLC · Blacksburg, VABuilt 1988 · S/N BB-1312N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004N808CEOpen Air LLC · Glendale, AZBuilt 2009 · S/N 560-0808N808DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31920N808MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2427N808MCLrt Aero Partners LLC · Sheridan, WYBuilt 2003 · S/N 258614N808NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1984 · S/N 424N808NHAkers Gary L · Eden, NCS/N E-2817N808NNWilmington Trust Co Trustee · Wilmington, DES/N 33206N808PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 77N808RTIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1976 · S/N 499N808SWFmgi Inc · Woodstock, GABuilt 1978 · S/N LJ801N808WRAlta Aviation LLC · Baileys Harbor, WIBuilt 2004 · S/N E-3570N8092RBoogers In Flight LLC · Ada, OKS/N E-161N8095FBrown Dr Jay · Ames, IABuilt 1992 · S/N E-2695
Back to AD 2006-16-18 R1