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.

N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812N35TWRice Timothy J · Anchorage, AKBuilt 1955 · S/N D-4339N35UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N D-6795N35UPBarker Terry · Purvis, MSBuilt 1965 · S/N D-7998N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000N35VEMckibben Howard Stephens · Elk Grove, CABuilt 1961 · S/N D-6694N35VSRcp3 Enterprises LLC · Chesterfield, MOBuilt 1966 · S/N D-8247N35WFWashburn Robert D · Newbury Park, CABuilt 1959 · S/N D-4223N35WKSchnell Thomas · Iowa City, IABuilt 1955 · S/N D-4366N35WVN35wv LLC · Charleston, WVBuilt 1955 · S/N D-4273N35XFCaudle David William · Arlington, TXBuilt 1958 · S/N D-5674N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397N35YTArmstrong Samuel V · Lovelock, NVBuilt 1955 · S/N D4058N3601BMiller William M · Albuquerque, NMBuilt 1954 · S/N D-3831N3601QWard Harry W Trustee · Williamsburg, VABuilt 1967 · S/N MA-226N3603QWray Development Inc · Menifee, CABuilt 1967 · S/N MA-203N3607QToole William Barry · Goochland, VABuilt 1967 · S/N MA-207N360AStrong LLC · Norcross, GABuilt 1981 · S/N E-1904N360BGregs Inc · Tiburon, CABuilt 1957 · S/N D-4910N360HS Dacy Enterprises Inc · Harvard, ILBuilt 1962 · S/N BA-621N360KRRyans Float Flying LLC · Oregon City, ORBuilt 1961 · S/N DH-320N360NEGoldrivet · Stateline, NVBuilt 1980 · S/N EA-128N360PMBon Aire Inc · Middlesboro, KYBuilt 1978 · S/N E-1253N360TThroop Greg J · Spokane, WABuilt 1967 · S/N D-8427N361Anderson G Drew · Kent, WABuilt 1952 · S/N D-3202N3611ASgmbb LLC · Seneca, SCBuilt 1979 · S/N E-1472N3613QNiec Steven M · Clio, MIBuilt 1967 · S/N M-1048N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237N361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308N361CMMesser-Bowers Co · Enid, OKBuilt 1986 · S/N E-2312N361CWCk Aviation LLC · Brookhaven, MSBuilt 1980 · S/N E-1755N361DMLeibstein Guy · Babylon, NYBuilt 1975 · S/N E-670N361KWFliteco Holdings LLC · Lewes, DEBuilt 1981 · S/N EA-264N361SCShelton Jaime David · Hurricane, UTBuilt 1969 · S/N TE-696N361WHubbard Kenneth Scott · Decatur, ALBuilt 2002 · S/N E-3438N3621RBateman Randy · Lindale, TXBuilt 1977 · S/N E-1095N3622AWing Bird Aviation LLC · Garland, TXBuilt 1969 · S/N TE-777N3624QEkholm Bryan K · Annandale, MNBuilt 1967 · S/N MB-242N3627AHint Mart H · Peachtree City, GABuilt 1969 · S/N D-9079N3628QJ&B Toys Inc · Wilmington, DEBuilt 1967 · S/N MA-213N3629ADarrow Mark A Trustee · Mukilteo, WABuilt 1969 · S/N D-9080N362ARegistered aircraftBuilt 1980 · S/N E-1745N362HPCaporale Ronald L · Dillon, MTS/N TC-2362N362RMAmerican Aviation Inc · Brooksville, FLBuilt 1984 · S/N E-2194N362SAScapha Air LLC · Boone, NCS/N E-3517N362SBNilco Enterprises Inc · Irving, TXBuilt 1981 · S/N E-1848
Back to AD 99-05-13 R1 WD