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.

N1061DCcr Aviation LLC · Summit, NJBuilt 1997 · S/N E-3094N1061FFoxtrot Flight LLC · Clarksdale, MSS/N TH-1761N1062WSale Reported · Douglas, GASale reportedBuilt 1973 · S/N E-411N1063WDakota Land LLC · Simms, MTBuilt 1973 · S/N E-410N1064CBayside Development LLC · Bellingham, WAS/N TH-1764N1065BRegistered aircraftS/N TH-1765N1066HBaronhfl LLC · Jacksonville, FLS/N TH-1766N1066PG&K Management Co LLC · Ocala, FLBuilt 1995 · S/N E-3006N1068KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1448N1069WElk Lake Group Inc · Plymouth, MNBuilt 1973 · S/N E-416N106ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0917N106CJCitation 525 Inc · Eugene, ORBuilt 1993 · S/N 525-0006N106DDHlp Aviation LLC · Shreveport, LABuilt 2005 · S/N LJ-1738N106GATactical Safety Training LLC · Dublin, GAS/N TH-437N106GBHardhead Aviation LLC · Midland, TXBuilt 1986 · S/N BB-1249N106KV3 Aviation LLC · Lexington, OKBuilt 1975 · S/N E-716N106MBBaron Phoenix Aviation LLC · Newport, RIBuilt 2000 · S/N TH-1935N106MJAngstrom Aviation LLC · Southfield, MIBuilt 2015 · S/N 525-0897N106PGGreco Equipment Leasing LLC · Bartlett, ILBuilt 1993 · S/N 650-7012N106RFRandigo LLC · Wilmington, DEBuilt 1995 · S/N 208B0481N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428N106SASkyline Aviation Services LLC · Miramar, FLBuilt 1990 · S/N FA206N106VERedding Aero Enterprises Inc · Redding, CABuilt 1999 · S/N 208B0769N106VPTeam Aero LLC · Shawnee, KSBuilt 2002 · S/N 560-0628N1071WPcs Air LLC · Middletown, PABuilt 1973 · S/N E-417N1072FGeorgia Air LLC · St Simons Island, GABuilt 1996 · S/N E-3002N1073SAlabama Department Of Transportation · Montgomery, ALBuilt 1996 · S/N TH-1773N1074GEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1534N1075XFisher Creek Corp · Grove Hill, ALBuilt 1996 · S/N TH-1775N1076KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1461N1077WPrewitt Russell · Statham, GABuilt 1973 · S/N E-420N1078SRegistered aircraftBuilt 1996 · S/N TH-1778N1079DGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1462N107JGGrundy Aviation LLC · Horsham, PABuilt 2019 · S/N 525-1020N107JHJb Sky LLC · Baton Rouge, LABuilt 2014 · S/N FL-920N107KAN107ka Inc · Addison, TXBuilt 2005 · S/N 208B1107N107LULynn University Inc · Boca Raton, FLBuilt 1981 · S/N E-1847N107MMBonanza Aviation LLC · Tulsa, OKBuilt 1983 · S/N E-2089N1080STacoma Management Inc · Martinsville, VABuilt 1997 · S/N TH-1818N1081YWc LLC · Austin, TXBuilt 1996 · S/N E-3039N1083SGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1443N1083WAeolus Aircraft LLC · Seminole, OKS/N TH-323N1086FAvion Capital Corp · Anchorage, AKBuilt 1995 · S/N 208B0436N1088LLima Whiskey Ic LLC · Mertzon, TXBuilt 1995 · S/N E-2988N1089CRegistered aircraftBuilt 1995 · S/N E-2989N1089EAml Aviation LLC · Lexington, KYBuilt 1996 · S/N E-3030N1089WKucera Christopher T · King George, VABuilt 1973 · S/N E-422N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730N108ANFlorida Air Cargo Inc · Davie, FLS/N 208B0975N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305
Back to AD 2006-16-18 R1