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.

N18387Rizzuti Robert T · Theodosia, MOBuilt 1977 · S/N TC-2080N1838LGordon Martin A · South Amboy, NJS/N TC-2008N1838RSix Zero Zulu LLC · Kalispell, MTBuilt 1981 · S/N E-1916N18394Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1121N18396Drec 0419 LLC · Carson, CAS/N TE-1109N1839WTown & Country Auto Sales LLC · Winchester, KYBuilt 1973 · S/N TC-1514N183BWilliams John · Omaha, NES/N BG-414N183EHarkins Harrison J Trustee · Hayden, IDBuilt 1982 · S/N E-2034N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346N183QDrajesk Jeffrey F · Fish Creek, WIBuilt 1965 · S/N D-7883N183RLea Brandon Wayne Sr · Bartlett, TNBuilt 1957 · S/N D-5155N183VBRegistration Pending · Palm City, FLRegistration pendingBuilt 1977 · S/N E-1097N18400Cohen Ralph S · Marietta, GABuilt 1977 · S/N P-412N18402Ohlhauser Devin · Bismarck, NDBuilt 1977 · S/N E-1117N18403Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1120N18404Cactus Aviation Llp · Gotha, FLBuilt 1977 · S/N E-1122N1840DNewlin Thomas R · Montezuma, INBuilt 1952 · S/N D-3094N1840WPutz Aeroplanes LLC · Bryan, TXBuilt 1973 · S/N D-9431N18413Cook Brian D · La Vernia, TXBuilt 1977 · S/N CE-736N1841WN1841w LLC · Plant City, FLBuilt 1973 · S/N CE-437N18429Withers John Justin · Paris, TXS/N CE-937N1842DCoughlin Patrick J · Nashua, NHBuilt 1952 · S/N D-3098N1842WNorthwoods Aviation · Marion, IAS/N CE-438N18431Stall Benjamin A · Piedmont, OKBuilt 1977 · S/N E-1129N18433J4 Aviation LLC · Lexington Park, MDBuilt 1977 · S/N TK23N1843DSales Joe H · Seminole, TXBuilt 1952 · S/N D-3111N1843LRegistered aircraftS/N TJ-65N18446Descro Air LLC · Henderson, KYBuilt 1977 · S/N TC-2086N18448Redd Horse LLC · Wilmington, DEBuilt 1977 · S/N TC-2087N1844DSalimi Patrick · Shingle Springs, CABuilt 1952 · S/N D-3141N1844LRao Enterprises LLC · Brighton, MIBuilt 1976 · S/N D-9880N18456Hewson Robert A · Santa Barbara, CABuilt 1977 · S/N E-1131N18457Colwell Arthur R · Magnolia, TXBuilt 1977 · S/N E-1133N18459Iglesia De Cristo · Porter Ranch, CABuilt 1977 · S/N E-1134N18462Sayers James B · Edison, OHBuilt 1977 · S/N E-1140N18463Bickett James C · Central City, KYS/N E-1137N18469Bonanza 469 LLC · Visalia, CABuilt 1977 · S/N E-1141N1846WChristenson R Darren DBA · Vernal, UTBuilt 1977 · S/N E-1138N18470Entwistle Charles W · Leicester, MABuilt 1977 · S/N D-10065N18472Cherry Michael · Corolla, NCBuilt 1978 · S/N TC-2155N18474Sacandaga Air Inc · Fort Plain, NYS/N E-1309N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145N18483F33a Holdings LLC · Woodbridge, VABuilt 1977 · S/N CE-735N1848NMeserve Guy S · Sandpoint, IDBuilt 1982 · S/N WA-312N1848WLee Clarence K · Colleyville, TXBuilt 1973 · S/N TC-1534N1848XTeo Steel Inc · Ramer, TNBuilt 1981 · S/N E-1919N18496Willy P Air LLC · Fort Myers, FLBuilt 1977 · S/N E-1153N18499Austin Aviation LLC · Boise, IDBuilt 1983 · S/N EA-362N1849DBerka George · Wilmington, DEFirst renewal noticeBuilt 1952 · S/N D-3100N1849LSpillman George R Jr · Argyle, TXBuilt 1976 · S/N E-848
Back to AD 99-05-13 R1 WD