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.

N2701TGray Stephen T · Lafayette, CAS/N D-8436N2703TChapman Daniel W · Soldotna, AKS/N TE-342N2705TP/T Flyers LLC · Hayes, VABuilt 1967 · S/N TD-690N270KFirst Gear Inc · Fort Wayne, INBuilt 1989 · S/N CE-1386N27117Chalfant William Paxson III · Concord, NCBuilt 1979 · S/N E-1416N2712TJames Todd E · Lebanon, PAS/N TE-349N2714TVertical Flight Leasing LLC · Wilmington, DEBuilt 1967 · S/N D-8438N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049N2717TIberlin James M · Gillette, WYBuilt 1967 · S/N TE-351N271EARichardson Cotton Inc · Wilmington, DES/N E-3486N271SBowker Mark · Bowdoinham, MEBuilt 1974 · S/N TC-1791N271WTMetz Richard Jr · New York, NYBuilt 1979 · S/N MC-710N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69N2720TMiller Mark · Bellevue, WABuilt 1967 · S/N D-8441N2721TGalvin Peter · Laytonsville, MDBuilt 1967 · S/N D-8443N2722AMontgomery Douglas Tanner · San Antonio, TXBuilt 1969 · S/N D-9050N2724TWittenbrader Jeff · Lake Ariel, PABuilt 1967 · S/N TE-354N2728TMilk Ranch LLC · Stephenville, TXBuilt 1967 · S/N D-8447N2729TWasileski David J · Auburn, NYS/N D-8451N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429N272PSNormandie Air LLC · Santa Clara, CAS/N D-4056N272QFlying Docs LLC · Tomball, TXBuilt 1966 · S/N TE-236N272SBofinger Jr John M · Hewitt, NJBuilt 1965 · S/N D-8002N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229N2730RRp Aviation Inc · Alliance, OHBuilt 1978 · S/N CE-792N2731TFocus LLC · Missoula, MTBuilt 1967 · S/N D-8454N2735TWhite Michael W · Key Largo, FLBuilt 1967 · S/N D-8455N2736TM & N Leasing Co · Marietta, GAS/N D-8458N2738TProtac Aviation LLC · Highland, CAFirst renewal noticeBuilt 1967 · S/N TD-693N2739TPickering Kevin P · Lakeland, TNBuilt 1967 · S/N D-8457N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321N273CBGause Timothy L · Georgetown, SCBuilt 1953 · S/N G-72N273EADavis Jonathon W · Charlotte, NCBuilt 2003 · S/N E3497N273PSBlack James F · Sister Bay, WIBuilt 1972 · S/N CE-379N273QTrident Aircraft Leasing LLC · Easton, MDBuilt 1966 · S/N TC-1020N2740AMcdaniel Joseph Stewart II · Henderson, TXS/N D-10113N2746TFranklin Ronald C · Las Vegas, NVBuilt 1967 · S/N D-8460N2749TCaudle Nathan · Fort Worth, TXBuilt 1967 · S/N D-8475N274AMMc Communications LLC · Conway, ARBuilt 1978 · S/N MC-567N274CTGoodwin Roger I · Palm Coast, FLBuilt 1978 · S/N M-2008N274HSWebb Alan J · Medford, ORBuilt 1976 · S/N D-9922N274SScott Joseph Brian · Sarasota, FLBuilt 1966 · S/N D-8329N274SLHowden Frederick M · Coronado, CAS/N E-2994N274VWBonanza Parts Inc · Davis, CABuilt 1960 · S/N TD-398N2753AThomas Dale A · Gooding, IDBuilt 1969 · S/N D-9052N27550Anderson Herman A · Basalt, COBuilt 1967 · S/N D-8465N2755GOnderdonk Allyn K · Mills River, NCBuilt 1957 · S/N 57-6043N2758TLinn Anthony B · Westborough, MABuilt 1967 · S/N TE-367N2759TLopas Jon D Trustee · Prescott, AZBuilt 1967 · S/N D-8468
Back to AD 99-05-13 R1 WD