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.

N66568Trapp Aviation Ltd · Lebanon, OHS/N TK-105N6656APike/Kelley LLC · Eureka Springs, ARBuilt 1983 · S/N MC-792N6656LAviation Solutions Group LLC · Royal Oak, MIBuilt 1979 · S/N CE-873N6656RHarris Walter D · Chatham, NJBuilt 1979 · S/N D-10275N6656WBonanza Partners Of Kc LLC · Shawnee, KSBuilt 1983 · S/N E-2075N6657TPilot-Ready LLC · Lime Springs, IABuilt 1979 · S/N EA-22N6657ZVas Incorporated · Reston, VABuilt 1979 · S/N CE-874N66585Haines Jay A · Summerland Key, FLBuilt 1983 · S/N EA-353N6658DThietten Gary L Trustee · Washington, UTBuilt 1979 · S/N D-10312N6658KEdelman Freddie L · Manlius, NYBuilt 1979 · S/N D-10278N6658ZClark Lloyd E · Hanover, MDBuilt 1979 · S/N TJ-222N6659GGallentine Gene W · Clayton, KSBuilt 1979 · S/N CE-876N6659LControl Data Inc · Indianapolis, INBuilt 1979 · S/N D-10279N6659RGarn Darrell L · Palmetto, GABuilt 1974 · S/N MB-743N665JTN665jt LLC · Shoreline, WABuilt 1974 · S/N TE-990N666Cahners Kyle F · Portola Valley, CABuilt 1955 · S/N G-264N6662HIrwin Dennis · San Diego, CABuilt 1979 · S/N D-10290N6662TSeipp Edwin A III · Portola Valley, CABuilt 1979 · S/N D-10284N66634Span Tech LLC · Glasgow, KYBuilt 1979 · S/N TC-2268N66648Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N D10289N6664LTt Aviation LLC · Oxnard, CABuilt 1979 · S/N EA-20N6664NN6664n Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1983 · S/N M-2386N6665WIal Corp · Lewes, DEBuilt 1979 · S/N TJ-227N6665ZDunkley Music Inc · Meridian, IDBuilt 1979 · S/N D-10291N6668QRegistered aircraftBuilt 1983 · S/N E-2077N6669DMaster Designs LLC · Gilbert, AZBuilt 1979 · S/N TC-2271N6669XEdm-Van LLC · Maple Lake, MNBuilt 1979 · S/N TK-108N666BLisa Beach Inc · La Porte, TXBuilt 1948 · S/N D-1667N666CNHamon John · Paso Robles, CABuilt 1979 · S/N E-1470N666MSSandy Bayou Planting Co · Osceola, ARBuilt 1969 · S/N D-9004N666TXJetran LLC · Horseshoe Bay, TXBuilt 1947 · S/N 6897N666WBertie William D · Independence, KSBuilt 1952 · S/N D-3170N666WAInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N TD-639N666WCAnderson Brian · Fresno, CABuilt 1977 · S/N TE-1087N666WFFehlhaber Wolfgang M · Port Orange, FLBuilt 1976 · S/N D-9885N666WLM Holdings Aero LLC · Wilmington, DES/N E-2216N666XGolden Eagle LLC · Estero, FLBuilt 1973 · S/N P-234N666ZRobertson Jared Y · Pass Christian, MSBuilt 1960 · S/N D-6317N6670GSterling Park Corp · Ashland, KYBuilt 1979 · S/N EA-26N6670JMccracken Scott D · Maysville, OKBuilt 1979 · S/N D-10295N6670ZMortan Robert F · Mckinney, TXBuilt 1979 · S/N E-1585N66710Big Bend Community College · Moses Lake, WABuilt 1983 · S/N M-2387N66719Dusch William C · Concord, NCBuilt 1983 · S/N E-2078N6671DGruber Mark W · Edmond, OKBuilt 1979 · S/N E-1613N6671LArias Aviation Inc · Wilmington, DEBuilt 1983 · S/N E-2079N66722Lumpkin Ed · Rosie, ARS/N E-2081N6672BYour World Inc · Draper, UTBuilt 1979 · S/N E-1584N6672KMaremy LLC · Ramona, CABuilt 1979 · S/N E-1564N6672XInpatient Services Association LLC · Floyds Knobs, INBuilt 1979 · S/N EA-32N6675ATool Equipment Leasing Corporation · Bethany, OKBuilt 1979 · S/N EA-30
Back to AD 99-05-13 R1 WD