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.

N8021AEncompass Partners · Goodwell, OKBuilt 1990 · S/N CE-1520N8021WNothing Wasted Consulting LLC · Kannapolis, NCBuilt 1992 · S/N E-2700N8022RBlackwing Aviation LLC · Flower Mound, TXBuilt 1970 · S/N MC-14N8025RGaboury Michael J · Two Harbors, MNBuilt 1970 · S/N MC-17N8026TRdz Aircraft LLC · Effingham, ILBuilt 1992 · S/N E-2701N8028DHammond Mick L · Abilene, TXBuilt 1991 · S/N CE-1550N8028JVintage Aircraft Sales LLC · Radnor, OHBuilt 1990 · S/N CE-1531N8028RBorgers Thomas R · Palmyra, NJBuilt 1970 · S/N MC-24N802NHWiechmann August J · Hubbard, IABuilt 1992 · S/N E-2694N802RLa Morgia Victor J · Bullhead City, AZBuilt 1959 · S/N D-6002N802TDodson International Parts Inc · Rantoul, KSS/N TC-1548N80305Manairco Inc · Wooster, OHBuilt 1946 · S/N B-4N80306Cronin John W · Denver, COBuilt 1947 · S/N B-5N80308Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1946 · S/N B-7N80309Zachry Industrial Inc · San Antonio, TXBuilt 1946 · S/N B-8N80312Shea Francis R · Colchester, VTBuilt 1946 · S/N B-11N80315Gear Aviation LLC · Missoula, MTBuilt 1947 · S/N B-14N80316International Trading Company Of Yukon Inc · Oklahoma City, OKBuilt 1947 · S/N B-15N80321Craig Stephen J Trustee · Lawrence, KSBuilt 1946 · S/N B-20N8032RAllen Steven M · Hackett, ARBuilt 1970 · S/N MC-21N8032XCass Joseph R · Nevis, MNBuilt 1991 · S/N CE-1551N8036RBetty'S Township LLC · Gretna, LABuilt 1970 · S/N MC-53N8036TPaysse John G · Hanford, CABuilt 1980 · S/N EA-150N8036VC J Logistics LLC · Dodge City, KSS/N E-2693N80373Virgil J Tatman · Casper, WYS/N A-273N8037XJ B Aviation Inc · Charlotte, NCS/N E-2705N80388Valiair Lc Trustee · Casper, WYBuilt 1946 · S/N A-288N8038RSale Reported · Oklahoma City, OKSale reportedBuilt 1970 · S/N MC-33N8038ZBas Part Sales LLC · Greeley, COBuilt 1990 · S/N E-2568N803DLRapids Ruddervators LLC · Wisconsin Rapids, WIBuilt 1973 · S/N D-9448N803NHCoastal Helicopters Inc · Panama City, FLBuilt 1992 · S/N E-2697N8041LEgmond Aircraft LLC · Lewes, DEBuilt 1956 · S/N D-4305N8043BT & A Aviation 2 LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2618N8043RPat Brown Aviation LLC · Dodge Center, MNBuilt 1970 · S/N MC-37N8044RCobb Gerald E · Jacksonville, FLBuilt 1970 · S/N MC-38N8044UCrowe Stephen R Trustee · Lake Ozark, MOBuilt 1992 · S/N E-2708N8045UCox Clifford J · Armada, MIBuilt 1990 · S/N E-2570N8046GPoupard Chris Steven · Celina, TXBuilt 1992 · S/N CE-1646N8046JSgl Aero LLC · Alpine, WYBuilt 1990 · S/N CE-1527N8047KVan Dinter Mike · Post Falls, IDS/N CE-1648N8047PThompson Craig A · Dallas, TXBuilt 1992 · S/N CE-1660N8047RBrooks Auto Parts Inc · Douglas, GAS/N E-2709N804DJBovender Richard S · Nashville, TNBuilt 1979 · S/N TC-2239N804RRabinovitsj Alexandre D · Keene, TXS/N D-6030N8050NWillard Scott E · Mount Pleasant, SCBuilt 1992 · S/N CE-1650N8052RNwa Air LLC · Tontitown, ARBuilt 1970 · S/N MC-47N8055RPioneer Aviation LLC · Portland, ORS/N E-2711N8055UJones Kyle M · Kerrville, TXBuilt 1992 · S/N CE-1664N8055ZAir Hatzis LLC · Baton Rouge, LABuilt 1990 · S/N E-2572N8057SKnutsen Wayne R · Tioga, NDS/N D-5934
Back to AD 99-05-13 R1 WD