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.

N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241N177FMeek Harvey K · Poplar Grove, ILBuilt 1964 · S/N TC-587N177SWGruslin Jean Pol G · Kingwood, TXBuilt 1975 · S/N E-731N177WTBucey Barry E · Visalia, CAS/N D-6300N177WWWallace William R · Fredericksburg, TXBuilt 1980 · S/N TC-2295N17802Asxo · Dallas, TXBuilt 1977 · S/N CE-709N17814Sellers Scott · Solsberry, INBuilt 1978 · S/N D-10144N17816Legal Flying Service Inc · Pembroke Pines, FLBuilt 1977 · S/N D-10011N17817Dye Barrett · Abilene, TXBuilt 1977 · S/N E-1034N17818Batie Gregory T · Rogers, ARBuilt 1977 · S/N CE-710N17819Mclendon Brian · Hawkins, TXBuilt 1977 · S/N E-1035N1781GPinegar Aviation Services LLC · Ridgeland, SCBuilt 1962 · S/N D-6932N17820Evergreen Flying Service Inc · Rayville, LABuilt 1977 · S/N TE-1101N17826Three Six Bonita LLC · Georgetown, TXBuilt 1977 · S/N E-1036N17827Cumins Douglas · Mechanicsville, VABuilt 1977 · S/N D-10015N17829Slayden Wesley B · White Bluff, TNBuilt 1977 · S/N CE-712N17832Arrow Inc · Mount Sterling, KYBuilt 1977 · S/N E-1039N17836Bear Dorvin L · Elida, OHBuilt 1977 · S/N E-1041N17838N17838 LLC · Scottsdale, AZBuilt 1977 · S/N E-1046N17840Es Investments LLC · Chandler, AZS/N D-10017N17846Stalford Tom G · Nicholson, PABuilt 1977 · S/N CE-714N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58N17852Flores Gustavo · Dallas, TXBuilt 1977 · S/N CE-715N17863Loon Song Flyers LLC · Brookside, NJBuilt 1977 · S/N E-1055N17865Wcs Inc · Troy, ALBuilt 1977 · S/N D-10021N1787ZWashington Arron M · Mobile, ALS/N D6464N1788GTolbert Morgan Leslie · Bernardsville, NJBuilt 1962 · S/N D-6978N178BGSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1978 · S/N P-459N178JSTidd Scott · Reading, MIBuilt 1981 · S/N WA-230N178QRega Consulting Inc · Port Orange, FLBuilt 1964 · S/N D-7560N178WDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N TC-2096N1790UHarris M A · Hartford, KSBuilt 1970 · S/N MB-486N1792GHelminiak Jon · Milwaukee, WIBuilt 1962 · S/N D-6976N17931Unlimited Sky LLC · Swansboro, NCBuilt 1977 · S/N E-1022N1794WSkyhawk Flying Club Inc · Omaha, NEBuilt 1972 · S/N E-380N1795GProps2jets LLC · Bolingbrook, ILBuilt 1962 · S/N D-6977N1797GTabor Tobey R · Ventura, CABuilt 1962 · S/N D-6975N17985Black Cat Aviation LLC · Indianapolis, INBuilt 1943 · S/N 4807N17988Gonneville Donald E Jr · Durango, COBuilt 1977 · S/N D-10026N179KDTblc LLC · Princeton, NJBuilt 1967 · S/N D-8519N179MCFulton Rick D · Marble Falls, TXBuilt 1990 · S/N CE-1530N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179N17BPTeam Yak Attack Inc · Poplar Grove, ILBuilt 1974 · S/N TC-1650N17BWLoeffler Helmut Guenter · Prattsburgh, NYBuilt 1968 · S/N MB-344N17CBCygnet Aerospace Corp · Los Osos, CABuilt 1966 · S/N D-8232N17CCReinhart Alan · Ventura, CABuilt 1969 · S/N D-9087N17CDDroddy Charles V · Bryan, TXBuilt 1976 · S/N E-931N17DCShaw Richard A · Redondo Beach, CABuilt 1950 · S/N D-2669N17EARegistration Pending · Melbourne, FLRegistration pendingBuilt 1997 · S/N E-3092N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488
Back to AD 99-05-13 R1 WD