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.

N5480UGwb Air LLC · Waterford, MIS/N D-8553N5483DMclenaghan Alvin N · Phoenix, AZBuilt 1957 · S/N D-5024N5485MN446rh LLC · Helena, MTBuilt 1978 · S/N ME-32N5487DSims Daniel E · Salem, ORBuilt 1957 · S/N D-5011N5487USuss Charles H Trustee · Woodford, VTBuilt 1967 · S/N D-8559N5489DJrh Wings LLC · Alva, OKBuilt 1957 · S/N D-5012N548BCopass Benjamin Jay · Fountain Run, KYBuilt 1948 · S/N D-1566N548TFrasier Samuel R · Gainesville, FLBuilt 1961 · S/N TD-455N5491UAarestad Potato Co Ltd · Halstad, MNBuilt 1967 · S/N D-8584N5492DCekinovich Ted M · Machesney Park, ILBuilt 1956 · S/N D-5018N5493DAcres Aviation LLC · Fremont, NEBuilt 1957 · S/N D-5022N5494DGulp LLC · Ardmore, OKBuilt 1957 · S/N D-5026N5496DYuhr Keith D · Miami, FLBuilt 1957 · S/N D-5263N549TSayers James B · Edison, OHBuilt 1961 · S/N TC-91N54CXIsland City Seaplanes Inc · Cordova, AKBuilt 1956 · S/N BA-175N54DGSaffron Aviation LLC · Carrollton, GABuilt 1979 · S/N E-1562N54FPPlatinum Aero Enterprise LLC · Henderson, NVBuilt 1955 · S/N D-4093N54HThb34 LLC · Kalispell, MTBuilt 1953 · S/N 34-80N54HLOverbey Michael B · Houston, TXBuilt 1972 · S/N CE-376N54JNDlz Aviation LLC · Ostrander, OHBuilt 1991 · S/N E-2684N54KLumley William B · Delray Beach, FLBuilt 1957 · S/N BA-235N54PFSilverado Land Management LLC · Sparks, NVS/N E-2941N54RFFrasca Lucille A · Urbana, ILBuilt 1957 · S/N G-140N54RHWhite Parker K · Grass Valley, CABuilt 1959 · S/N D-6275N54TCK K Stevens Publishing Co · Astoria, ILBuilt 1976 · S/N CE-661N54VBas Part Sales LLC · Greeley, COBuilt 1980 · S/N ME-313N54VKPain Management And Aesthetics LLC · Celina, OHBuilt 1966 · S/N D-8066N54WMNemensky Jack · Southborough, MABuilt 1976 · S/N CE-657N5500DSmoky Mountain Vertical Services LLC · Kodak, TNBuilt 1957 · S/N D-5037N5500FVernon Walter Benson · Denver, COBuilt 1989 · S/N CE-1400N5503DDodge Michael T · Wausau, WIBuilt 1957 · S/N D-5029N5505DMolloy Mark E · Waxahachie, TXFirst renewal noticeBuilt 1957 · S/N D-5045N5506DGarrison John P · Temple, TXBuilt 1957 · S/N D-5046N550AFAtm One Inc · Tulsa, OKBuilt 1979 · S/N EA-6N550BZRoswell James M · Stuart, FLBuilt 1981 · S/N TC-2352N550CBCarnevale Philip A · Lake City, FLBuilt 1978 · S/N TE-1135N550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMBuilt 1973 · S/N D-9505N550DFArrow Aircraft Leasing LLC · Tucson, AZBuilt 1978 · S/N TC-2197N550JAAlves Gerald T · Alamo, CABuilt 1962 · S/N TC-302N550JEEssert Joe · Windsor, CORegistration expired, pending cancellationBuilt 1960 · S/N D-6356N550JRUrban Cowboy Aviation LLC · Richland, NEBuilt 1990 · S/N CE-1449N550LThompson John S · Dallas, TXS/N CE-1190N550LEFlycarolina LLC · Concord, NCBuilt 1963 · S/N TC-400N550LMAdventure Day Aviation LLC · Greensboro, NCBuilt 1990 · S/N CE-1472N550MBRegistered aircraftBuilt 1964 · S/N D-7610N550NCTri-State Communications Inc · South Sioux City, NEBuilt 1988 · S/N CE-1241N550RNovember Sierra Aviation LLC · Oneill, NES/N TC-391N550RJHovermale Ken · Portland, MEBuilt 1989 · S/N E-2516N550X550x LLC · Tucson, AZS/N D-9255N550YRFriedman Michael S · Chantilly, VABuilt 1981 · S/N TE-1196
Back to AD 99-05-13 R1 WD