OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N5994SThree Musketeers LLC · Gorham, KSBuilt 1966 · S/N MB-84N5995CBrady Michael J · Merritt Island, FLBuilt 1952 · S/N D-3347N5997CLuzier Bruce E Jr · Charleston, SCBuilt 1952 · S/N D-3349N5997SHardin Sammy R · Mckinney, TXBuilt 1966 · S/N MB-77N5998CAdams James J · San Antonio, TXS/N D-3350N599EPritchett Douglas C · Canyon, TXS/N D-5923N599VKDeland LLC · Kalispell, MTBuilt 1970 · S/N TC-1346N599WB7r Leasing LLC · Wilmington, DEBuilt 1988 · S/N CE-1272N59BETibbs Air Inc · Germantown, TNBuilt 1959 · S/N D-6118N59BQMod Flying LLC · Elkhorn, NES/N E-2273N59CMCalled To Care Residential Facility LLC · Goodyear, AZBuilt 1979 · S/N E-1377N59CTTornado Alley Turbo Inc · Ada, OKBuilt 1980 · S/N E-1719N59DCBarnhart David C II · Durham, NCBuilt 1954 · S/N D-3756N59DHMay Bernard A · Medina, OHBuilt 1968 · S/N D-8891N59DLChannel Islands Aviation Inc · Camarillo, CABuilt 1979 · S/N ME-143N59EJones Daniel S · Panama City Beach, FLBuilt 1956 · S/N BA-206N59GMBerry Frank C · Watkinsville, GABuilt 1981 · S/N CE-964N59HVBoling Kyle C · Oak Hill, FLBuilt 1966 · S/N TC-1007N59JBAero Buelo LLC · Jasper, TXBuilt 1982 · S/N E-2045N59KJSpike LLC · Cheyenne, WYBuilt 1993 · S/N EA-549N59MKTff Inc · Parma, MIBuilt 1959 · S/N D-6152N59PJTad Holdings LLC · Little Falls, MNBuilt 1987 · S/N E-2395N59TATailwinds Air Inc · Morganza, LABuilt 1997 · S/N EA-606N59TCRegistration Pending · Pembroke, GARegistration pendingBuilt 1951 · S/N D-2736N59TEDunn Craig P · Henderson, NVBuilt 1959 · S/N D-6029N5BACarlsbad Raceway Corp · Hemet, CABuilt 1962 · S/N BA-614N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315N5BSShanholtzer Richard L · Mckinney, TXBuilt 1959 · S/N D-5979N5CKPhlyx Aviation · Edgewater, MDS/N D-9693N5CWChancey Jay P · Odessa, TXBuilt 1951 · S/N D-2792N5DCSturges Jason Charles · Phoenix, AZBuilt 1976 · S/N E-887N5DLAmerson Loyd Scott · Douglas, GABuilt 1979 · S/N E-1515N5DRHaslett Bradley A · Collierville, TNBuilt 1974 · S/N TC-1653N5EHEsoteric Air Inc · Cypress, TXBuilt 1959 · S/N D-6098N5FPittsburgh Institute Of Aeronautics · Pittsburgh, PABuilt 1957 · S/N DH-131N5FWWord Forrest R · San Antonio, TXBuilt 1979 · S/N TE-1167N5GKPacific Air Investments LLC · Paso Robles, CABuilt 1975 · S/N D-9831N5GWJayne John E · Hanover, NHBuilt 1987 · S/N CE1197N5GYSeven Sierra Yankee LLC DBA · Monroeville, PABuilt 1924 · S/N JH-171N5HCPut A Lid On It Palm Beach Inc · Jupiter, FLBuilt 1972 · S/N D-9347N5HKTrboyevich Jessica · Bridport, VTS/N D-4914N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295N5JLRegistered aircraftBuilt 1968 · S/N TD-719N5KGCrossley Michael · Corona Del Mar, CABuilt 1968 · S/N TC-1068N5NBMurphy Spencer A · Rome, GABuilt 1959 · S/N D-5956N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251N5QBPayne Thomas H · Tulsa, OKBuilt 1979 · S/N D-10246N5QNGreatest Generation Naval Museum · Colorado Springs, COBuilt 1955 · S/N BG-6N5QQBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N A-223N5RYLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1960 · S/N BG-421
Back to AD 99-05-13 R1 WD