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.

N2862WBonanza 62w LLC · Richmond, INBuilt 1973 · S/N D-9504N2863WWarrick Motors LLC · Newton, IABuilt 1973 · S/N CE-451N286WSchlutz Greg F · Longmont, COBuilt 1966 · S/N D-8042N2870WRobinson John D · Peachtree City, GABuilt 1973 · S/N D-9501N2873WHolland Edgar S · Fletcher, NCBuilt 1973 · S/N TC-1580N2875WTreadway Ag Delaware LLC · Lewes, DES/N D-9508N287HHaught Herbie B Jr · Mountain View, ARBuilt 1965 · S/N D-7763N287JTA W Aviation · Sevierville, TNBuilt 1953 · S/N G-287N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330N287LMDjc Bonanza LLC · Stuart, FLBuilt 1994 · S/N E-2859N2882WWholey James · Saratoga, CABuilt 1973 · S/N E-452N2883WAustin Richard K · Ludington, MIBuilt 1973 · S/N P-238N2886WBushong Chistopher L · Gulf Shores, ALS/N D-9512N2889WAviation Institute Of Maintenance · Virginia Beach, VABuilt 1973 · S/N P-249N288FGroove LLC · Afton, VABuilt 1965 · S/N D-7970N288MTgc Aviation LLC · Watkinsville, GABuilt 2002 · S/N E-3460N288TBCejka Robert K · Cudahy, CABuilt 1975 · S/N TC-1880N2890WAlbatross Aviation LLC · Lakeville, OHBuilt 1973 · S/N D-9510N28920Wakeman Henry K III · Etna, NHBuilt 1986 · S/N E-2330N2894WDavenport Skyler R · Granbury, TXBuilt 1973 · S/N D-9514N2895WN2895w LLC · Mount Airy, MDBuilt 1973 · S/N E-457N289MCCrowell J Frank III · Nashville, TNS/N E-3556N28BWJv Aviation Group Inc · La Puente, CABuilt 1965 · S/N TC-957N28CNRoman Stephen B · Minnetrista, MNBuilt 1976 · S/N CN-1N28CPArk Investments Inc · Ridgeland, MSBuilt 1971 · S/N D-9213N28DBEdson Franz R · Waterford, CTBuilt 1970 · S/N D-9139N28DJMccrorie David M · Port Angeles, WABuilt 1964 · S/N D-7320N28ECZefting Aviation LLC · Bellingham, WABuilt 1960 · S/N DH-285N28FCFlight Club · Middle River, MDBuilt 1981 · S/N WA-266N28LDDancing Bear LLC · Polson, MTBuilt 1970 · S/N D-9205N28SGMarshall Robert W · Hemet, CABuilt 1956 · S/N D-4540N28SRM & M Aero LLC · Wilmington, DEBuilt 1962 · S/N TD-524N28TJNational Marketing And Management Services LLC · Clyde Park, MTBuilt 1979 · S/N TC-2218N28VTOwens Curtis R Jr · Jourdanton, TXBuilt 1978 · S/N TC-2184N28WBMulder Air Inc · Renville, MNBuilt 1968 · S/N D-8729N28WKNurge Richard J · Gilroy, CAS/N 4872N28WVOrth Duane C · San Antonio, TXBuilt 1978 · S/N TJ124N2904BPricer J Richard · Arlington, TXBuilt 1953 · S/N D-3549N2907BPowell Gregory S · Paso Robles, CAS/N D-3552N290SGinter Aviation LLC · Oakland, MDBuilt 1971 · S/N E-292N2910BShively Aurora J · Anchorage, AKS/N D-3554N2913BW Air Collection Inc Trustee · Wilmington, DEBuilt 1953 · S/N A-963N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314N2917BPyle Dana · Naples, FLBuilt 1953 · S/N D-3558N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119N291BPJackson Jeffrey L · Manchester, TNBuilt 1966 · S/N TC-979N291TPlane Fun Inc Tr Trustee · Snellville, GAS/N TG-13N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372N2924BBonanza N2924b LLC · Hermann, MOBuilt 1953 · S/N D-3565N2929BRegistered aircraftBuilt 1953 · S/N D-3570
Back to AD 99-05-13 R1 WD