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.

N303BMantei Mark R · Boulder, COBuilt 1956 · S/N D-4707N303BBPerry Clifton B · Lacon, ILBuilt 1964 · S/N TC-787N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303JANx Aviation LLC · Fredericksburg, VABuilt 1962 · S/N TC-385N303KCCurry Kenneth R · Cookeville, TNS/N CE-1138N303LWHoward Dan E · Hurricane, UTBuilt 1966 · S/N D-8336N303NMiles James · Memphis, TNBuilt 1981 · S/N E-1880N303RMGiesbrecht Shane · Grandview, IDBuilt 1969 · S/N TC-1219N303SASoder Christopher R · Hewitt, TXBuilt 1971 · S/N E-303N303TTCoop Aero LLC · New Albany, MSBuilt 2001 · S/N E-3377N3041CVangundy Timothy S · Camby, INBuilt 1976 · S/N D9946N3041KDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1987 · S/N CE-1112N3041WEstes Aviation LLC · Rapid City, SDBuilt 1968 · S/N D-8824N3042NRunway Aircraft LLC · Sugar Land, TXBuilt 1987 · S/N CE-1113N3042V3 Pandas LLC · Farmington, NMBuilt 1998 · S/N EA-622N3043CSelby Air LLC · Lorida, FLBuilt 1958 · S/N D-5704N3045TRegistered aircraftBuilt 1987 · S/N E-2369N3045YMassee Donald R · Riverside, CAS/N EA-623N3046CStehlik Dennis J · Wheaton, ILBuilt 1958 · S/N D-5610N3046DAldredge John F · Cornville, AZBuilt 1994 · S/N E-2866N3046KBas Part Sales LLC · Greeley, COBuilt 1987 · S/N E-2362N3047CEver Fast LLC · Kalispell, MTS/N D-5771N3048CThompson Sean R · Trabuco Canyon, CABuilt 1958 · S/N D-5710N3048VBoswell Craig A · Hernando, MSBuilt 1987 · S/N E-2363N3048WEarthbound Aviation Group LLC · Wilmington, DEBuilt 1973 · S/N E-484N3049APresidential Aviation LLC · Bakersfield, CABuilt 1987 · S/N CE-1117N304BSmith Dennis L · Thomson, GABuilt 1956 · S/N D-4647N3050KWalter Jones III Md Inc · Redlands, CABuilt 1987 · S/N E-2364N3051AHigby James E Jr · Frederick, COBuilt 1969 · S/N D-9058N3051CMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N D-5707N3052JParker Joe B · Uvalde, TXBuilt 1986 · S/N E-2346N3052XJc Flight Inc · Wilmington, DES/N CE-1120N3053WVictor Echo LLC · Knoxville, TNBuilt 1994 · S/N CE-1783N3054ANocek Aviation LLC · Skaneateles, NYBuilt 1998 · S/N E3201N3054RJamms Aviation LLC · Bedford, NHBuilt 1994 · S/N E-2879N3055WChaney George · Hazard, KYS/N P-251N3056CStorholt Wayne R Jr · Plano, TXBuilt 1958 · S/N D-5721N3056KOwens Grace P · Brunswick, GABuilt 1986 · S/N CE-1098N3056WRoss John C · Susquehanna, PABuilt 1973 · S/N CE-471N3057CClb LLC · Lewes, DEFirst renewal noticeS/N D-5713N3057WBaskins Robert H · Huntington Beach, CABuilt 1973 · S/N D-9557N3059CFellows David O · Mc Alpin, FLBuilt 1958 · S/N D-5715N305BWofford Ross · Allen, OKBuilt 1956 · S/N D-4642N305BCProp & Wing Aviation Inc · Humble, TXBuilt 1982 · S/N CE-993N305CABrinker Joe E Jr · Little Hocking, OHBuilt 1964 · S/N TC-584N305MMSegal Marshall B · Chicago, ILBuilt 1980 · S/N EA-188N305TCjn Enterprises LLC · Elbert, COBuilt 1973 · S/N TE-952N305WRKnudsvig Travis · Waterloo, IABuilt 1973 · S/N TC-1591N3060WRegistration Pending · Ojai, CARegistration pendingBuilt 1973 · S/N E-488N3061CTharp Aerospace LLC · Charleston, SCBuilt 1958 · S/N D-5757
Back to AD 99-05-13 R1 WD