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.

N551JACalderon Gustave P · Carlsbad, CABuilt 1978 · S/N E 1424N551JKJk Aircraft Options LLC · Aripeka, FLS/N 551-0031N551JLN551jl LLC · Greenville, SCBuilt 1980 · S/N BB-788N551LJA-Pro LLC · Hernando, MSBuilt 1999 · S/N LJ-1551N551LSMixed Wing LLC · Wilmington, DEBuilt 1981 · S/N 551-0369N551MFDodson International Parts Inc · Rantoul, KSS/N 15N551MSSimpson Michael A · Bridgeport, TXBuilt 1980 · S/N 501-0147N551MWHotzler Terry A · Windom, MNBuilt 1979 · S/N 5510132N551NCNion LLC · New Century, KSBuilt 1950 · S/N 5510171N551RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 076N551SJFav Tailwind LLC · Arroyo Grande, CABuilt 1980 · S/N 5510205N551TGLake Vista Aeronautics LLC · Lewes, DEBuilt 1988 · S/N 551-0591N5524VRamsey Jarrod Ross · Chicago, ILBuilt 1989 · S/N E-2505N552AJGlad IV LLC · Tucson, AZBuilt 1978 · S/N 501-0074N552ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34595N552BSBroken Arrow Crop Insurance Inc · Perryton, TXBuilt 1979 · S/N LJ-836N552CJWolf Pack 7 LLC · Wilmington, DEBuilt 1988 · S/N S550-0150N552CKDeep South Management LLC · Douglas, GAS/N TH-2083N552CLWattles Gurdon S · Stuart, FLBuilt 1986 · S/N E2336N552CMCm552 LLC · Katy, TXBuilt 2000 · S/N E-3337N552CNRer Plane LLC · San Antonio, TXBuilt 2004 · S/N 560-0674N552MEN552me LLC · Las Vegas, NVBuilt 2000 · S/N 258459N5530XFaulhaber Orlin W · North Platte, NEBuilt 1989 · S/N E-2504N5531DBas Part Sales LLC · Greeley, COS/N E840N5534RHanson David J · Charlotte, NCBuilt 1990 · S/N E-2576N5535WGpd LLC · Saint Louis, MOBuilt 1990 · S/N E2540N55367Mammoth Toys Inc · Santa Ana, CABuilt 1990 · S/N E2537N5537XKelly Douglas E · Lake Ozark, MOBuilt 1990 · S/N E-2531N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594N553BWHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258570N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228N554TMLamar Aviation LLC · Paris, TXBuilt 1992 · S/N E-2688N554TSS & S Seeds Inc · Carpinteria, CABuilt 1996 · S/N 560-0376N554TTInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 501-0133N554VPJl Diversified LLC · Scottsdale, AZBuilt 2001 · S/N 560-0554N554WFs II Inc · Minden, NVS/N E3554N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554N5551VRegistered aircraftBuilt 1991 · S/N E-2637N5552XJjs Aero LLC · Middletown, DES/N E-2521N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249N555ALMcgraw Aviation LLC · Lees Summit, MOS/N FL-360N555BGN & E Aviation LLC · Olathe, COS/N 525-0113N555DGBonnie Aero LLC · Dryden, MIBuilt 2013 · S/N 20800547N555DWInstitue Of Aeronautical And Aerospace Institute · Aguadilla, PRBuilt 1985 · S/N 459N555EHHolen Endre · Las Vegas, NVBuilt 1992 · S/N 560-0162N555FWCommerce Flight LLC · Commerce, TXBuilt 1982 · S/N BB-1055N555HCWikle Leon · Rapid City, SDBuilt 1979 · S/N E-1586N555HJFlycarolina King Air Partners LLC · Charlotte, NCBuilt 1994 · S/N LJ-1378N555JCDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2025 · S/N 208B5869N555KKGe Flyer 1 LLC · Sheridan, WYS/N 421C1022
Back to AD 2006-16-18 R1