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.

N9295YSln Aviation LLC · Salina, KSBuilt 1986 · S/N 46-8608032N9299PFusion Flight Management LLC · Lake Havasu City, AZBuilt 1997 · S/N 4636123N929RRPanafax LLC · Wilmington, DEBuilt 1997 · S/N 4636115N92APRaven Aircraft LLC · Prescott, AZBuilt 2016 · S/N 4636686N92FZStrawman Aviation LLC · Auburn, INBuilt 2014 · S/N 4636645N930ZMirage 930 Corp Trustee · Wilmington, DEBuilt 1995 · S/N 4622188N931TTCompass Pro LLC · Baldwin, WIBuilt 2008 · S/N 4636441N937WHLakemere Farms LLC · Spirit Lake, IAS/N 46-8508036N93GKFirenze Investment Group Two LLC · Saint George, UTBuilt 2015 · S/N 4636667N93RJStamm David · Lake Almanor, CAS/N 4622130N93WNWave Transportation LLC · North-West Washing, DCS/N 4636151N942BMegkat Equipment LLC · Lewes, DEBuilt 2012 · S/N 4636538N943RBRb Ffhm LLC · Fresno, CABuilt 2007 · S/N 4636427N944SJ & J Aviation LLC · Kokomo, INBuilt 2000 · S/N 4636306N946DPDp Mirage LLC · Brentwood, TNBuilt 1999 · S/N 46-36240N94MACox Dennis J · Beach City, TXBuilt 1986 · S/N 46-8608056N94WMGrowth Caddie LLC · Vero Beach, FLBuilt 1988 · S/N 4608114N951SYYucht Steven · Gainesville, FLBuilt 2024 · S/N 4636838N955DGSuperior Aero & Marine LLC · Bolivar, MOBuilt 1996 · S/N 4636039N955SHInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 4636339N956ADJoel W Nikle · Fargo, NDBuilt 2006 · S/N 4636385N95AGSale Reported · Montgomery, ALSale reportedBuilt 1990 · S/N 4622110N961DCMesimer Reginald V · Saint Petersburg, FLBuilt 1987 · S/N 46-08066N961MAFlying Clubs Of America LLC · Englewood, COBuilt 2015 · S/N 4636669N962MAYalinie Medics LLC · Lexington, KYBuilt 2018 · S/N 4636735N962WFDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 4636203N963MADodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 4636453N963SBHoosier Oms LLC · Kalispell, MTBuilt 1999 · S/N 4636198N965TTFullbright Thomas D · Cold Spring, KYBuilt 2012 · S/N 4636560N96PPSwam Air LLC · Edinburg, VABuilt 1997 · S/N 4636120N972DDLakala Aviation Inc · Vicksburg, MIBuilt 2014 · S/N 4636637N975MASouthworth Aircraft Inc · Tupelo, MSBuilt 2010 · S/N 4636475N977TJValiair Lc Trustee · Casper, WYBuilt 2011 · S/N 4636515N97AABentham Gordon M · Katy, TXBuilt 1999 · S/N 4636235N97CXGold Aero Aviation LLC · Tampa, FLBuilt 1997 · S/N 4636128N97MVNorth American Safety Education Group LLC · Flowery Branch, GABuilt 1996 · S/N 4636023N985MARegistration Pending · Fort Loramie, OHRegistration pendingBuilt 2025 · S/N 4636862N989AVFlying Rj LLC · North Caldwell, NJBuilt 2021 · S/N 4636790N98ZZF4 Holdings LLC · Oro Valley, AZBuilt 2024 · S/N 4636853N995KTHorizon 1p1 Capital Holdings LLC · Oneill, NEBuilt 2014 · S/N 4636640N996CKb Family LLC · Santa Clara, UTBuilt 2021 · S/N 4636794N996EPLehecka Richard T · Spring Grove, ILBuilt 2015 · S/N 4636658N997MADodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 4636126N997MJNeal Daniel R · Tijeras, NMBuilt 1999 · S/N 4636228N99NBSnag Ventures LLC · Pilot Point, TXBuilt 2023 · S/N 4636829N9GFApruda Andri Trustee · Nashville, TNBuilt 1988 · S/N 4608127
Back to AD 99-15-04 R1