OpenAirDocs.org
AD 99-15-04 R1

Registered aircraft · 896

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-15-04-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:99-15-04-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.

N67NGNwa Financial And Aviation Services LLC · Springdale, ARBuilt 2018 · S/N 4636727N67TGMccall Andrew Keith · Abilene, TXBuilt 1989 · S/N 4622032N682AKAk Aircraft LLC · Peoria, AZBuilt 2023 · S/N 4636824N687KMDiamond Services Co · Woodward, OKBuilt 2011 · S/N 4636517N687WE-Tan Transportation LLC · Malone, WIBuilt 1992 · S/N 4622124N6891SAltimeter Aviation Holdings LLC · Pleasanton, CABuilt 2022 · S/N 4636807N689KCMy Terms LLC · Katy, TXBuilt 2016 · S/N 4636689N68CPGroesch Charles William · Springfield, ILS/N 4636238N6908PSix Six Hotel Corporation · Bangor, PABuilt 1985 · S/N 46-8508062N6908XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508064N6913TSanders Wes E · Palos Park, ILBuilt 1985 · S/N 46-8508072N6914YAirgo US Inc · Columbia, MOFirst renewal noticeBuilt 1985 · S/N 46-8508075N692BMTexas Sea Ventures LLC · Laredo, TXBuilt 2012 · S/N 4636551N692STVanwiggeren David · Ottawa, ILBuilt 2015 · S/N 4636685N694STMcmillion Air LLC · Franklin, INBuilt 2016 · S/N 4636694N6962SYeaman John Robert IV · Aroda, VABuilt 2000 · S/N 4636272N699MDJvation LLC · Belgrade, MTBuilt 1994 · S/N 4622159N699PGBrady Richard V · Show Low, AZBuilt 2013 · S/N 4636600N699TBUS Anesthesia Consultants LLC · Chesterfield, MOBuilt 1994 · S/N 4622158N706CGDonegal Excavating Inc · Lemont, ILBuilt 2016 · S/N 4636706N706ZHlm706z Inc · Bismarck, NDBuilt 2000 · S/N 4636256N707GZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 4636577N710WKWayne Mogg Inc · Rossmoor, CABuilt 2023 · S/N 4636820N711CPKoo Aviation LLC · Woodsfield, OHBuilt 2014 · S/N 4636636N711DJett Aviation Partners LLC · Bismarck, NDBuilt 1989 · S/N 4622036N711XLSe Aviation LLC · Great Falls, MTS/N 4608062N712MKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1986 · S/N 4608032N714KLMatera Management LLC · Spanish Fork, UTBuilt 2002 · S/N 4636328N715BBMartin L Jeffrey · Hudson, OHBuilt 1996 · S/N 4636038N715LMIntepros Inc · Jupiter, FLBuilt 1998 · S/N 4636173N716JMAtec Aviation LLC · Jupiter, FLBuilt 2017 · S/N 4636716N717BLWeaver Air LLC · Starkville, MSS/N 46-8508082N717GMAlbatross Aviation LLC · Tazewell, TNBuilt 1997 · S/N 46-36118N717SKLava Rock Properties LLC · Saint George, UTS/N 4636053N718TDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 4636813N71WZArlington Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 4636275N721RWGulf Coast Business Advisors LLC · Pineville, LABuilt 2021 · S/N 4636781N722ETSymonds Stephen M · Colleyville, TXBuilt 1996 · S/N 4636047N723APN816k LLC · Kalispell, MTS/N 4636093N723DGEyefly LLC · Hastings, NEBuilt 2023 · S/N 4636827N725EDMolden Erik · Newtown, PABuilt 2012 · S/N 4636555N725MA100ll First Class LLC · Santa Rosa Beach, FLBuilt 2023 · S/N 4636835N726BWBoberts LLC · Beach Lake, PABuilt 2010 · S/N 4636478N727KWilliam L Schmidt Attorney At Law Pc · Fresno, CABuilt 1994 · S/N 4622178N728DSTebeaux William Jene · College Station, TXBuilt 1986 · S/N 4608047N72DTMalibu Aviation Inc · Wichita, KSBuilt 1985 · S/N 46-8508084N735RCSoto Flavio Cesar · Nogales, AZBuilt 1998 · S/N 4636167N7377GMcafee K Scott · Missoula, MTBuilt 2023 · S/N 4636823N744DDTaffet Jay · New Orleans, LABuilt 1984 · S/N 46-8408075N744RVAustin Aviation LLC · Maumelle, ARBuilt 2003 · S/N 4636342
Back to AD 99-15-04 R1