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.

N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737N333SLT C Air LLC · West Linn, ORBuilt 2021 · S/N 525-1083N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779N333TLBrad And Jill Janecke LLC · Pierre, SDBuilt 1982 · S/N LJ-999N333UPEverel Airborne LLC · Sandia Park, NMS/N 96015N333VPDennee Enterprises Group LLC · New Bern, NCBuilt 1984 · S/N E-2161N333WAPowell Jay · Columbia, MSBuilt 1969 · S/N E-176N333WTWright Aero Inc · Saint Cloud, MNBuilt 1980 · S/N LA-91N333XAJetnexa One LLC · Gilbert, AZBuilt 2015 · S/N 525-0889N333XPRichard L Richards Pa Trustee · Coral Gables, FLBuilt 2000 · S/N LJ-1609N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739N3342VRichards James D · Nucla, COBuilt 1947 · S/N D-805N3345BR Farms LLC · Wilmington, DEBuilt 1994 · S/N E-2865N3346VBarnd Dennis Allen · Manchester, OHBuilt 1947 · S/N D-810N334CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N FL-351N334CPRws Aviation LLC · Indianapolis, INBuilt 1977 · S/N E-1003N334NCarter-Muthana Aero LLC · Bakersfield, CABuilt 1978 · S/N 421C0458N3355VRyan Kevin · Bethel, OHBuilt 1947 · S/N D-819N3356YAdvanced Aviation Services LLC · Sheridan, WYBuilt 1992 · S/N FM-4N335PElvin Robert Brian · Grove, OKBuilt 1996 · S/N E-3005N335PHAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31265N335RAirdocs LLC · Atlanta, GABuilt 2000 · S/N E-3335N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514N33610Gibson Aviation LLC · Palacios, TXBuilt 1985 · S/N S550-0026N3361VMatta Figueroa Eduardo · Chapman, KSBuilt 1947 · S/N D-827N3365VReffett John S · Eagle River, AKBuilt 1947 · S/N D-831N336CBBeechair LLC · Helena, MTBuilt 2002 · S/N E-3431N336JPKalinin Partners LLC · Juneau, AKBuilt 2013 · S/N 208B5036N336LMKlm Unlimited Inc · Staples, MNS/N E-1587N336MLobo Air LLC · Carefree, AZS/N E-3528N336MMUS Special Operations Command · Macdill Afb Tampa, FLBuilt 2008 · S/N FL-607N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265N336NANickravesh Niknam J · Saratoga, CABuilt 1980 · S/N E-480N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008N336RKBridger Aerospace Group Holdings LLC · Belgrade, MTBuilt 1992 · S/N FL-71N336TTophatter85 LLC · Kirksville, MOBuilt 1978 · S/N E-1219N33714United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28785N337FLSunshine Land Survey LLC · Tallahassee, FLBuilt 2003 · S/N FL-373N337GTFl-337 LLC · Redondo Beach, CABuilt 2001 · S/N FL-337N337JXJetonex LLC · Sunny Isles Beach, FLS/N 33734N337LRJetsteam Aviation Inc · Cheyenne, WYBuilt 1981 · S/N 337N337MBDesert Sand Aircraft Leasing Co Inc · Rosharon, TXS/N 37N337PJWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33345N3380VCarney Francis P · Eloy, AZS/N D-848N3387VPermian Basin Blue Sky Inc · Odessa, TXBuilt 1947 · S/N D-861N338D38 Delta Corp · Killington, VTBuilt 1987 · S/N E-2392N338PKWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31268N338RSr Air LLC · Schamburg, ILBuilt 1995 · S/N 560-0338N338SWN338sw LLC · Midland, TXBuilt 1992 · S/N 258229N338TKGranite Boarding LLC · Loomis, CAS/N TH-1991
Back to AD 2006-16-18 R1