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.

N6019FFlying R LLC · Apison, TNBuilt 1965 · S/N D-7901N601BTCoats George A · The Woodlands, TXBuilt 1989 · S/N CE-1371N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71N601SGBrynildson Scott W · Rifle, COBuilt 1959 · S/N D-5949N601SWDynaero LLC · South Vineland, NJBuilt 1976 · S/N E904N601UJBurton Donald O · Mooresville, NCBuilt 1966 · S/N D-8117N6020EDominianni Michael J · Chester, NJBuilt 1959 · S/N D-5922N6020PClark Katherine A · Spring, TXBuilt 1979 · S/N MC-653N6021EMerhar Timothy J · Shoreview, MNBuilt 1959 · S/N D-5919N6021PPullman Eric B · Wurtsboro, NYBuilt 1979 · S/N MC-657N6022EWard John B · Fishers, INBuilt 1959 · S/N D-5930N6022MWolf Richard J · Apple Valley, CABuilt 1979 · S/N MC-654N6022SAhlberg Merick D · Eagle River, AKBuilt 1979 · S/N M-2156N6022WDelgado Mario J · Baldwin Park, CAS/N M-2153N6023QCr Mcdowell Construction Co Inc · Keokuk, IABuilt 1979 · S/N E-1441N6023UHigh Scott · Albuquerque, NMBuilt 1979 · S/N E-1442N6023ZSchmauderer Ivan K · Woodland, CABuilt 1979 · S/N E-1468N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130N6024AAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N D-10210N6024KNabarrette Angel · Odessa, TXBuilt 1979 · S/N TJ-187N6024QAero Equities LLC · Ventura, CABuilt 1979 · S/N TC-2209N6024SAdams Erik S · Bozeman, MTBuilt 1975 · S/N TJ-16N6024U6024u Aircraft Leasing LLC · Spanish Fork, UTBuilt 1979 · S/N TC-2210N6024XWmrm LLC · Saint Petersburg, FLBuilt 1979 · S/N CE-863N6024ZProag Services Inc · Mahnomen, MNBuilt 1979 · S/N E-1447N6025RScott James C · Akron, OHS/N E-1444N6025TVtales LLC · Urbana, ILBuilt 1979 · S/N D-10213N60264Buttram John Randal · Panama City, FLBuilt 1979 · S/N D-10219N60268Rougher Aviation LLC · Council Hill, OKBuilt 1979 · S/N E-1452N6026ERegistered aircraftBuilt 1959 · S/N D-5936N6026UJohnsson Johan C · Monterey, CABuilt 1979 · S/N D-10218N6026YWestern Flying Club Inc · Burlington, NCBuilt 1979 · S/N E-1451N6027EJava LLC · Oxford, MSBuilt 1959 · S/N D-5928N6027FPease David · Santa Cruz, CABuilt 1965 · S/N D-7895N6027GBell William F · Hartwell, GABuilt 1979 · S/N D-10220N6027UKolesar Mark A · Golden Valley, MNBuilt 1979 · S/N E-1457N6028EChiappe Glenn R · Lago Vista, TXBuilt 1979 · S/N E-1458N6028FFlying Ospreys LLC · Camas, WABuilt 1965 · S/N D-7808N6028SHazellief Joe · Okeechobee, FLBuilt 1975 · S/N P-357N60295Neufield Jim R DBA · Wasco, CABuilt 1979 · S/N TC-2217N6029FTeeple Leighton B · Plainview, TXBuilt 1965 · S/N D-7809N602BMeyer Charles H · Stratford, CABuilt 1948 · S/N D-1623N602DKGingerjet LLC · Boca Raton, FLBuilt 1967 · S/N TE-369N602FCStarr Travis W · Helotes, TXS/N TC1624N602PPayne Mark Robert Jr · Germantown, TNBuilt 1959 · S/N DH-224N60306Ibikunle Christopher S · Grayson, GABuilt 1979 · S/N TJ-195N6030RMaresco Services Inc · Alpha, NJBuilt 1979 · S/N E-1459N6030WAllen James Robert · Glasgow, KYBuilt 1979 · S/N TC-2219N6030ZBeeline Aero LLC · Scottsdale, AZBuilt 1978 · S/N CE-829N60329Beech Bumz Aviation LLC · Tarpon Springs, FLBuilt 1979 · S/N E-1473
Back to AD 99-05-13 R1 WD