OpenAirDocs.org
AD 99-23-22 R2

Registered aircraft · 1,335

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:99-23-22-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2')
  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.

N471MCAtlas Air Inc · White Plains, NYBuilt 1997 · S/N 26557N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785N478VTTipnes Aviation LLC · Tampa, FLBuilt 1981 · S/N 308N480MCAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 28812N481MCAtlas Air Inc · Purchase, NYS/N 32339N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675N482MCAtlas Air Inc · Purchase, NYBuilt 2001 · S/N 32340N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676N484FMV1vr LLC · Wilmington, DES/N 81N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553N48KZN48kz LLC · Long Beach, CABuilt 2001 · S/N 191N492AN492a LLC · Gilbert, AZBuilt 1984 · S/N 425N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323N501JVJetvue Texas LLC · Richardson, TXBuilt 1982 · S/N 373N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304N502SVCryptologistics Of America Inc · Southwest Ranches, FLBuilt 1985 · S/N 502N504PASmee Homes Inc · Porterville, CABuilt 1988 · S/N 43N504STSdt Air Delaware LLC · Wilmington, DEBuilt 1996 · S/N 162N506ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35690N508ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35691N508MMMarklyn Jet Parts LLC · Dallas, TXS/N 66N50BHTravel Link LLC · Vienna, VABuilt 1982 · S/N 359N50BLBnb LLC · Wilmington, DES/N 2N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187N50MWWj Of Delaware Inc · Fort Lauderdale, FLS/N 503N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269N510FROneflight International Inc · Englewood, COBuilt 1984 · S/N 446N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123N512ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39043N513ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35192N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338N514ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35193N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016N516JAKings Aviation Corp · Garden City, NYBuilt 1991 · S/N 089N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197N518ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35693N519ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 36482N520ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 36481N520NANasa Langley Research Center · Hampton, VAS/N 86-0206N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282N522TLDodson International Parts Inc · Rantoul, KSS/N 98
Back to AD 99-23-22 R2