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.

N82BFMorrison James M III · Terry, MSBuilt 1981 · S/N E-1937N82CFKehler Kelly · Saint Xavier, MTBuilt 1975 · S/N TE-1061N82CKBloxham Thomas L · Pleasant Hill, CABuilt 1997 · S/N E3096N82ECInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N P-376N82HCVan Buskirk Steven · Denver, COBuilt 1974 · S/N D-9584N82JGTotal Aircraft Management Inc · Acworth, GABuilt 1968 · S/N TE-626N82JTRegistered aircraftBuilt 1964 · S/N D-7581N82MJTravelair 82mj LLC · Watauga, TXS/N TD-412N82MSShifflett Kenneth · Olive Branch, MSBuilt 1966 · S/N D-8108N82SPMaiden Robert · Williamson, GABuilt 1958 · S/N DH-174N83000Gehrer Aviation LLC · Wichita, KSBuilt 1993 · S/N E-2829N8300DAltitude Adjustment LLC · Solvang, CABuilt 1957 · S/N D-5394N8300NErect A Tube Inc · Harvard, ILBuilt 1968 · S/N D-8719N8300ZWillowridge Farm · Winchester, KYBuilt 1993 · S/N EA-551N8302DSmith Luke Allbee · Houston, TXBuilt 1957 · S/N D-5396N8309DBrown Willard Ferrell · Fayetteville, GABuilt 1958 · S/N D-5428N8309NNewman Michael Jay · Sherborn, MABuilt 1968 · S/N D-8720N830ADb-Gbr LLC · Sarasota, FLBuilt 1962 · S/N M-36N830CBPatterson Ryan R Trustee · Lebanon, OHS/N BG-369N830NRegistration Pending · Boring, ORRegistration pendingS/N D-6169N830SUJames John S · Perkins, OKBuilt 1978 · S/N TE-1126N830TDWhite And Blue LLC · Auburn, CABuilt 1987 · S/N E-2397N8311DCunningham James J · Midlothian, TXBuilt 1957 · S/N D-5414N8311FGregoire Brandon James Ernst · Orlando, FLBuilt 1969 · S/N M1280N8313DMclenaghan Alvin N · Phoenix, AZBuilt 1957 · S/N D-5417N8313NSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1968 · S/N TC-1070N8314DMclean Angus L · Bradenton, FLBuilt 1958 · S/N D-5439N8315DBurnd C R · Town Creek, ALBuilt 1958 · S/N D-5462N8318DHice Robert L · Panama City Beach, FLBuilt 1958 · S/N D-5427N8318MChristian Ralph B III · Fort Worth, TXS/N D-3944N8318NAir Power Associates LLC · O Fallon, MOBuilt 1968 · S/N D-8723N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293N831JBDjd Properties LLC · Victoria, TXBuilt 1980 · S/N TJ-279N831KTPilot Network Flyers LLC · Bastrop, TXBuilt 1974 · S/N M-1548N831RMBarber John R Trustee · Port Orange, FLS/N E-1685N8320DMiller Mark A · Hutchinson, MNBuilt 1958 · S/N D-5437N8321NAstle John K · Brighton, MIBuilt 1968 · S/N D-8722N8322DTupelo Aeronautics Inc · Tupelo, MSS/N D-5459N8323DRegistered aircraftBuilt 1957 · S/N D-5405N8324DLacour Erik · Clovis, CABuilt 1958 · S/N D-5426N8325NKontour Shawn K · Wheatland, WYBuilt 1968 · S/N D-8730N8326DSchulte Allison R · Trappe, MDBuilt 1958 · S/N D-5442N8326NLimitless Experience Inc · Middletown, DEBuilt 1968 · S/N D-8728N8327DLeavitt John C · Titusville, FLBuilt 1957 · S/N D-5411N8328N789 Aviation LLC · Medina, OHBuilt 1968 · S/N D-8735N832HFalkenthal Robert J · Beaumont, CABuilt 1977 · S/N E-1047N832RSHaps Shack Express LLC · Asheville, NCBuilt 1978 · S/N E-1345N833Dick David W · Roseburg, ORBuilt 1988 · S/N CE-1217N8330DV-Tail Flyers Inc · Chanhassen, MNBuilt 1958 · S/N D-5483N8331DLee John M · Lakebay, WABuilt 1958 · S/N D-5537
Back to AD 99-05-13 R1 WD