OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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.

N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108N108HPTextron Aviation Inc · Wichita, KSS/N 525-1422N108JTPierobon Patricia · Port Orange, FLS/N E-1355N108KCV1vr LLC · Wilmington, DEBuilt 1974 · S/N 8N108RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0528N108RJDixon John W · Aurora, ORBuilt 2002 · S/N BB-1801N108RKBarnard Brian D · Tallahassee, FLBuilt 1979 · S/N E-1513N108RLShamrock Aero LLC · Liberty, NCBuilt 2003 · S/N 258619N108VRDraughn Aviation LLC · Salado, TXBuilt 2002 · S/N 560-0601N1091GUnderwood Mold Co Inc · Woodstock, GABuilt 1996 · S/N E-3001N1092YCbg Properties LLC · Madison, MSBuilt 1996 · S/N E-3045N1093GLombard William E · Bellingham, WABuilt 1996 · S/N TH-1793N1094GOgan Michael J · Pierre, SDBuilt 1996 · S/N TH-1794N1095ATychsen Scott E Trustee · Horse Shoe, NCBuilt 1996 · S/N E-2995N1095WEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1456N1097GAos Aviation LLC · Baton Rouge, LAS/N E-3035N1097WFred Wacker Agency Inc · Miles City, MTBuilt 1973 · S/N E-426N1097ZIndian Sky LLC · Bossier City, LABuilt 1997 · S/N E-3083N1098WB & G Aviation LLC · Virginia Beach, VABuilt 1996 · S/N E-3043N1099Carolina View Aviation LLC · Greensboro, NCBuilt 2019 · S/N 525-1028N1099AFritz William · Franklin, PABuilt 1997 · S/N E-3088N1099WTop Hand Inc · Laurel, MTBuilt 1973 · S/N E-424N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310N109CCourtor Leasing LLC · Valencia, PABuilt 1981 · S/N 501-0236N109CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0060N109EADegiarde Robert P · New York, NYBuilt 1994 · S/N E-2897N109HPFlorida Highway Patrol · Tampa, FLBuilt 2015 · S/N 208B5239N109LLLewis & Lewis Equipment LLC · Dodge City, KSBuilt 1991 · S/N E-2626N109MDM B Duncan Inc · Bakersfield, CABuilt 1985 · S/N BB-1213N109MLJerry Luttrell And Associates Inc · Kearney, MOBuilt 1988 · S/N E-2450N109TYFly Wide LLC · Lewes, DES/N E-2235N10AGBaron Associates LLC · Norfolk, VABuilt 1980 · S/N BE-100N10BBFayard Enterprises LLC · Wake Forest, NCBuilt 1989 · S/N 20800152N10CW911 Aviation LLC · Durant, OKBuilt 1985 · S/N BB-1211N10DHVta Capital LLC · Ontario, CABuilt 1981 · S/N LA-111N10DQTextron Aviation Inc · Wichita, KSS/N 525-1426N10EAEagle Air Transport Inc · Ottawa, ILS/N 199N10FKing Leasing Corp · San Diego, CABuilt 1974 · S/N 12N10FFValiair Lc Co Trustee · Casper, WYBuilt 1976 · S/N 421C0082N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015N10FVMark Hicks Transport LLC · Missoula, MTBuilt 2011 · S/N FL-782N10GGMartinelli Alexander Joseph · Waco, TXBuilt 1947 · S/N D-1065N10GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 010N10JAAircraft Structures International Corp · Enid, OKBuilt 2002 · S/N 208B0961N10LFive States Holdings LLC · Helena, MTBuilt 1972 · S/N E-347N10MDMiss Blackwell Aviation LLC · Pawleys Island, SCBuilt 2017 · S/N 525-0967N10NCHayward Enterprises Inc · High Point, NCBuilt 1980 · S/N 172N10NNK&L Air LLC · Lakewood Ranch, FLBuilt 1994 · S/N E-2895N10PWAircraft Partner Holdings Inc Trustee · BerlinBuilt 1995 · S/N E-2950N10QWBlackhawk 04 LLC · Portland, ORS/N BB-1846
Back to AD 2006-16-18 R1