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.

N745VKoritz Terence C · Ladera Ranch, CABuilt 1965 · S/N D-7953N7461NUniversal Coatings Inc · Fresno, CABuilt 1968 · S/N D-8832N7462NBartels Randall John · Wesley Chapel, FLBuilt 1968 · S/N D-8833N7463NTiger Owl Properties LLC · Centennial, COBuilt 1968 · S/N D-8834N746DDunn Jennifer D · Athol, IDBuilt 1951 · S/N D-3016N7475NN7475n LLC · Indianapolis, INBuilt 1968 · S/N D-8837N7476NGeorge Andrew N · Corvallis, ORBuilt 1968 · S/N D-8836N7476PMobley Aviation LLC · The Colony, TXBuilt 1976 · S/N CE-631N7477DDuke One LLC · Longmont, COS/N P-142N747BBallard Ralph T · Hurricane, UTBuilt 1948 · S/N D-1755N747BPRose James M · White Hall, ARBuilt 1973 · S/N D-9440N747DVUnrestricted Climb LLC · Muskego, WIBuilt 1996 · S/N E-3062N747GLoblolly Management LLC · Concord, NCBuilt 1998 · S/N E-3203N747HPK & S Aero · Wilmington, DEBuilt 1977 · S/N TC-2034N747LXQds Aviation LLC · Baton Rouge, LABuilt 1981 · S/N MC754N747SBCloud Transport Operations LLC · Kalispell, MTBuilt 1980 · S/N TJ-297N747TMTripodi Joseph J · Glendale, AZBuilt 1961 · S/N D-6796N747VVJk Aero LLC · Altenburg, MOBuilt 1967 · S/N TE-309N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360N747WTHovey Yvonne L · Attica, MIBuilt 1979 · S/N WA19N747YVGreat Among The Nations Inc · Beverly Hills, CABuilt 1999 · S/N EA-642N74894Arnold Timothy Robert · Longmont, COS/N BG-254N748BMckinney Mark L · Naperville, ILBuilt 1948 · S/N D-1756N748DAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1980 · S/N ME-341N7492NTurner Jimmy A · San Antonio, TXBuilt 1968 · S/N TC-1125N7493NBdm Air LLC · Keller, TXBuilt 1968 · S/N TE-605N749DOliver Rodney W · Houston, AKBuilt 1951 · S/N D-3019N749MRAfterburner Aerospace LLC · Belgrade, MTBuilt 1979 · S/N CE859N749WClark Jimmy Dee · Lorenzo, TXBuilt 1955 · S/N D-4278N74AZHmaair LLC · Gilbert, AZBuilt 1982 · S/N E-2017N74BAAns Electric LLC · Macon, GABuilt 1981 · S/N P-569N74BKWarner Thomas K · Monterey, CABuilt 2004 · S/N E-3532N74BPLowell Russell · Vonore, TNBuilt 1973 · S/N E-455N74BRBbj Aviators LLC · Springfield, ILBuilt 1997 · S/N E-3106N74BSSanditen Barry A · Austin, TXBuilt 1983 · S/N E-2069N74BTSta Aviation LLC · Wilmington, DEBuilt 1977 · S/N E984N74CBKendrick Paul · Atascadero, CABuilt 1974 · S/N D-9690N74DTEnjoy Life Flying LLC · Sunrise, FLBuilt 1999 · S/N EA-634N74ETThompson Howard Earle Jr · Dadeville, ALS/N TC-619N74GJSkydive Greene County · Xenia, OHBuilt 1961 · S/N BA-559N74LECarnes Eddy A · Uvalde, TXBuilt 1989 · S/N CE-1310N74MFCarl Raymond Baker LLC · Brenham, TXBuilt 1981 · S/N TJ-397N74MTKopair LLC · Saint Louis, MOBuilt 2000 · S/N EA-659N74RHCirrus Management LLC · Suwanee, GABuilt 1955 · S/N D-4153N74SKKoontz Construction Inc · Livingston, MTBuilt 1966 · S/N D-8148N74USTwo Three Air LLC · Orlando, FLBuilt 1974 · S/N E-574N74WJVicari Aviation LLC · Harvey, LABuilt 1988 · S/N E-2458N7501SPressley Aviation LLC · New London, NCBuilt 1963 · S/N TC-413N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391N750JFHamontree Gerry · Ellsworth, KSBuilt 1991 · S/N CE-1633
Back to AD 99-05-13 R1 WD