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.

N5XCTouchstone Capital Aviation LLC · Miami, FLBuilt 2012 · S/N 4636547N5YGSethjay LLC · Washington, DCBuilt 1995 · S/N 4636001N600AGBisignano Michael · Palm Coast, FLBuilt 1989 · S/N 4622053N600CRSilver Throne Aviation LLC · Anchorage, AKBuilt 1989 · S/N 4622060N6041SGaluardi Judith L · Berlin, MDBuilt 2007 · S/N 4636434N607CBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4636497N607EDUnimax Aviation LLC · Portland, ORBuilt 2010 · S/N 4636481N6099PCudd Bradley Shane · Guymon, OKBuilt 2010 · S/N 4636468N60PMCeahorse LLC · Greenwich, CTBuilt 2019 · S/N 4636744N610ECPeloton Aviation LLC · Wentzville, MOBuilt 2023 · S/N 4636834N612SLN612sl Skynance LLC · Marshfield, WIBuilt 2024 · S/N 4636842N614STMedi-Tek Inc · Antioch, CABuilt 2014 · S/N 4636614N615WMcnamara Donald James · Sunriver, ORBuilt 2012 · S/N 4636556N6162DFriedman Steve · Atlanta, GABuilt 2011 · S/N 4636523N616JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 4636616N618BDSandhu Sky Ventures LLC · Livermore, CABuilt 1989 · S/N 4622047N61FLCobb Glenn A · Blacksburg, VABuilt 1989 · S/N 4622037N621CASair LLC · Natchitoches, LAS/N 4636008N623PTThomas Philip M · Monroe, LABuilt 2012 · S/N 4636543N626ARHunsicker Calvin E · Fryeburg, MEBuilt 2021 · S/N 4636782N627AXSky Ridge Transport LLC · Anaheim, CABuilt 2002 · S/N 4636341N627DYColtov LLC · San Diego, CABuilt 1999 · S/N 4636247N627PABig Sky Leasing LLC · Johnson, KSBuilt 2014 · S/N 4636627N629DKUnited Steel Erectors Corp · Atlantic, IABuilt 1998 · S/N 4636158N629STHolokai LLC · Boyes Hot Springs, CABuilt 2014 · S/N 4636629N62CASchoenle Paul D · South Bend, INBuilt 1996 · S/N 4636025N62LNDeeds Little Corp · Wilmington, DEBuilt 2012 · S/N 4636533N62VMAerolife Aviation LLC · Knox, INBuilt 1986 · S/N 46-8608008N630ESJez Farms LLC · Mattoon, ILBuilt 2019 · S/N 4636740N630KBKilo Bravo LLC · Saratoga, CABuilt 2014 · S/N 4636625N632PMCentral Valley Air Transportation LLC · Fresno, CABuilt 2014 · S/N 4636632N636SPJcc Transport LLC · Indianapolis, INBuilt 2024 · S/N 4636837N637BEJzl Corp · Fort Collins, COBuilt 1984 · S/N 46-8508018N63PWValiair Lc Trustee · Casper, WYBuilt 1987 · S/N 46-08077N640BDEdair LLC · Newport, RIBuilt 1990 · S/N 4622095N646HCGraber Air LLC · Atglen, PABuilt 2007 · S/N 4636433N647SJRegistered aircraftBuilt 2013 · S/N 4636581N648TStefaniak Paul B · Richmond, TXBuilt 1995 · S/N 4636002N64TWPlane Fun LLC · Garretson, SDS/N 4636054N650KCPastor Stephen · Montgomery, TXBuilt 2014 · S/N 4636650N661MLDap Aviation LLC · Baton Rouge, LABuilt 1996 · S/N 4636060N662GMRetail Profit Systems Inc · Central Point, ORBuilt 2012 · S/N 4636569N662WPHolt Gary L · Ventura, CABuilt 2000 · S/N 4636308N664RSMalibu Inc · Dover, DEBuilt 2000 · S/N 4636313N666CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 46-8508080N667PCMattie Joseph · Ester, AKBuilt 1984 · S/N 46-8508001N66SFRed Rock Flying School LLC · Mesa, AZBuilt 1986 · S/N 46-8608042N673CAM2 Aviation LLC · Summitville, INBuilt 2013 · S/N 4636589N675CABurdg Way Air LLC · Las Vegas, NVBuilt 2010 · S/N 4636465N67CTRudd Wayne · Glenwood Springs, COBuilt 1989 · S/N 4622062
Back to AD 99-15-04 R1