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.

N4586SEjh Teton Properties LLC · Petaluma, CABuilt 1975 · S/N D-9809N4587SSims Chad L · Marshall, TXBuilt 1975 · S/N E-753N4588APlane LLC · Shady Shores, TXBuilt 1970 · S/N TE-810N4589PSecurenet Financial LLC · The Villages, FLBuilt 1961 · S/N D-6798N4589STeebee Aviation LLC · Hixson, TNBuilt 1975 · S/N TC-1902N458BAAlpha Aviation Holding Group LLC · Raleigh, NCBuilt 1975 · S/N TC-1830N458CTAratow Michael · Mountain View, CABuilt 2000 · S/N EA-661N458EABeach Boyz LLC · Saint Petersburg, FLS/N E3558N458JHVliegtuig Holdings LLC · Kalispell, MTBuilt 1996 · S/N E-3037N4592DBrown Theodore A · Trivoli, ILS/N D-4760N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4593DSale Reported · Cody, WYSale reportedBuilt 1956 · S/N D-4763N4595SHurst Sheldon G IV · Smyrna, GABuilt 1975 · S/N D-9812N4596SWaters Mark N · Clovis, NMS/N CE-685N4597DEvans Robert K · Anchorage, AKBuilt 1956 · S/N D-4772N4597STopflight Air LLC · Dunkirk, INBuilt 1975 · S/N E-757N4598DMid-State Air Inc · Eaton, NYBuilt 1956 · S/N D-4766N4598MRegistered aircraftS/N D-10121N459JDWilson John K · Rosamond, CABuilt 1970 · S/N E-210N459TCN459tc LLC · Wray, COBuilt 1972 · S/N D-9328N45BLKing Air LLC · Sterling, COBuilt 1980 · S/N EA-101N45CFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1959 · S/N BA466N45CWRobertson Scott · Chappell Hill, TXBuilt 1970 · S/N TC-1319N45DHMedic Choppers LLC · Springdale, ARBuilt 1969 · S/N TE-718N45DTKaher Kevin · Groveland, CAS/N G-785N45DWLaquerre David E · Old Orchard Beach, MEBuilt 1975 · S/N D-9840N45GSLinde Aviation LLC · Payson, AZBuilt 1953 · S/N 34-76N45JFFischer Jason Edward · Rochester, MNBuilt 1954 · S/N D-3901N45LCBelle Robert M · Tampa, FLBuilt 1979 · S/N E-1600N45MSBeech Flyers Inc · Champaign, ILBuilt 2001 · S/N E-3384N45PLLep Holdings LLC · Sheridan, WYBuilt 1987 · S/N CE1167N45PSDaly Mark T · Cheyenne, WYBuilt 1953 · S/N D-3696N45TAMichalek Construction Inc · Keosauqua, IABuilt 1966 · S/N D-8252N45TBGooney Bird Group Inc · Templeton, CABuilt 1956 · S/N BG-235N45USFlight Operations LLC · Hollister, MOBuilt 1977 · S/N CE-722N45WWHolmes Bruce Arthur · Maricopa, CABuilt 1977 · S/N E-1203N45XEnglish Gary M · Clermont, FLBuilt 1952 · S/N D-3060N4600SCozzolino Aerosports II LLC · Indianapolis, INBuilt 1975 · S/N E-771N4604AThomas Douglas E · Grove City, PABuilt 1970 · S/N E-216N4605MJohnson Plane Services LLC · Greenbrier, TNBuilt 1978 · S/N E-1246N4607DLiposcak Curtis J · Madison, WIBuilt 1956 · S/N D-4800N4607NTak Air L3c · Hampshire, ILBuilt 1944 · S/N 6927N4608ATriplett Robert J · Cameron, WIBuilt 1970 · S/N E-217N4608DBraun David · Georgetown, TXBuilt 1956 · S/N D-4835N4609MShields David C · Council Bluffs, IAS/N CE-772N461Lindeman Rusty · D Hanis, TXBuilt 1952 · S/N D-3378N4612NTex-Ark Air Corp · Melissa, TXBuilt 1944 · S/N 6874N4612SWooddale Kirby LLC · Edina, MNBuilt 1958 · S/N D5517N4613MMott John H · Lafayette, INBuilt 1978 · S/N E-1245N4614DRedstar Air Shows Inc · Discovery Bay, CABuilt 1956 · S/N D-4793
Back to AD 99-05-13 R1 WD