OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,794

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.

N121DKAutomotive Air II LLC · Belcamp, MDBuilt 2007 · S/N BB-1995N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069N121JGGo Consultants LLC · Wilmington, DES/N LJ-996N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475N121UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0806N121VMAlan Aviation LLC · Altadena, CAS/N 525-0314N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359N12216United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28776N12218United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28778N1221FTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2020 · S/N FL-1221N12221United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28930N12225United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28934N12238United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28804N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475N122GTSperr Adam C · Donnelly, MNBuilt 1980 · S/N E-1673N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239N122RGRiversville Aircraft Corp · Belgrade Lakes, MES/N FL-448N122RMHolland Mark Drew · San Antonio, TXBuilt 1984 · S/N TH-1416N122UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29168N122UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0807N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875N1232YPa1 208b-0566 LLC · Fort Lauderdale, FLBuilt 1996 · S/N 208B0566N1234QDembowski Rodrick · Seattle, WABuilt 1969 · S/N E-165N123AVGc 43 LLC · Annandale, VAS/N E-319N123CHMdi Air LLC · Dothan, ALBuilt 1980 · S/N LA-32N123EDFrench Fly LLC · San Jose, CAS/N 258366N123FFN123ff LLC · North Palm Beach, FLS/N S550-0005N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200N123GSLou Ann Inc · Los Altos, CABuilt 1979 · S/N E-1464N123HGHorowitz Transportation LLC · Newport Beach, CABuilt 2015 · S/N FL-978N123HKTavaero Jet Charter Corp · Houston, TXBuilt 1992 · S/N 258208N123KDAircraft Resource Center Inc · Lakeville, MNBuilt 1981 · S/N 501-0195N123MHBryan-Kennedy LLC · Tulsa, OKBuilt 1974 · S/N LW-104N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587N123MMMuller Miles O · Staples, TXBuilt 1986 · S/N E-2332N123NPTralo Aviation LLC · Owatonna, MNBuilt 1977 · S/N 421C0402N123PL4-S Aviation LLC · Clovis, NMBuilt 1982 · S/N 501-0234N123RFLucky Air LLC · Hobbs, NMBuilt 2008 · S/N FL-589N123TLN919cs LLC · Colts Neck, NJBuilt 1987 · S/N S550-0124
Back to AD 2006-16-18 R1